Ah, ok. Like the other person who posted on this, had tried both pool and 
pool.jdbc to no avail. That seems to be what the documentation indicates.

Thanks for the update.

From: Christian Schneider [mailto:cschneider...@gmail.com] On Behalf Of 
Christian Schneider
Sent: Monday, March 06, 2017 9:18 AM
To: user@karaf.apache.org
Subject: Re: PAX JDBC 1.0.1 pools

Hi Scott,

sorry for the late response. Took a while until I found time to look into the 
hikari pool code.

You need to prefix the hikari properties with "hikari.".
All these properties will be stripped of the prefix and given to Hikari as the 
config map.

Christian

On 24.02.2017 18:35, Leschke, Scott wrote:
That much I have. I was talking about the configuration that might be more pool 
specific, like:

poolName          =
maximumPoolSize   =
minimumIdle       =
idleTimeout       =
maxLifetime       =

From: Christian Schneider [mailto:cschneider...@gmail.com] On Behalf Of 
Christian Schneider
Sent: Friday, February 24, 2017 11:30 AM
To: user@karaf.apache.org<mailto:user@karaf.apache.org>
Subject: Re: PAX JDBC 1.0.1 pools

See https://ops4j1.jira.com/wiki/display/PAXJDBC/Pooling+and+XA+support+in+1.0.0

For H2 and hikari you could use:
osgi.jdbc.driver.name=H2
pool=hikari
databaseName=test
user=sa
password=
dataSourceName=test2

To install in karaf:
feature:repo-add pax-jdbc 1.0.1
feature:install pax-jdbc-config pax-jdbc-pool-hikaricp pax-jdbc-h2

You should see a DataSource

service:list DataSource

[javax.sql.DataSource]
----------------------
 databaseName = test
 dataSourceName = test2
 felix.fileinstall.filename = 
file:/home/cschneider/java/apache-karaf-4.1.0/etc/org.ops4j.datasource-local.cfg<file:///\\%5C%5Chome%5Ccschneider%5Cjava%5Capache-karaf-4.1.0%5Cetc%5Corg.ops4j.datasource-local.cfg>
 osgi.jdbc.driver.name = H2
 osgi.jndi.service.name = test2
 password =
 service.bundleid = 55
 service.factoryPid = org.ops4j.datasource
 service.id = 120
 service.pid = org.ops4j.datasource.78e4961e-be81-4328-9d2e-6e6af73bebd1
 service.scope = singleton
 user = sa
Provided by :
 OPS4J Pax JDBC Config (55)


As far as I know hikari has no XA support or at least we do not support it.

Christian



On 24.02.2017 17:12, Leschke, Scott wrote:
I'm a bit confused on how to configure the underlying connection pool. I'll be 
using the Hikari pool service.pax-jdbc-pool-hikaricp. Could someone point me to 
the docs or something? The only example I see is for DBCP and all my 
experiments thus far have failed.

Thx, Scott




--

Christian Schneider

http://www.liquid-reality.de



Open Source Architect

http://www.talend.com




--

Christian Schneider

http://www.liquid-reality.de



Open Source Architect

http://www.talend.com

Reply via email to