You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@karaf.apache.org by dpravin <pr...@gmail.com> on 2017/01/17 19:24:32 UTC
Re: pax-jdbc-dbcp2 and connection pooling
Hello Christian,
I started testing the new pax-jdbc today and found following issues during
my testing with dbcp2,
Environment details are
Jboss Fuse 6.2.1
pax-jdbc 0.10.0- SNAPSHOT
Oracle - 11.2.0.4.0
Installed following features from pax-jdbc,
>features:install transaction jndi pax-jdbc-oracle pax-jdbc-pool-dbcp2
pax-jdbc-config
dataSourceName = dsn
osgi.jndi.service.name = dsn
osgi.jdbc.driver.name = oracle
url = jdbc:oracle:thin:@//<<servername>>:port/databasename
user = user
password = password
pool.initalSize = 1
pool.maxTotal = 2
pool.minIdle = 2
Issues,
1) If xa property is not added to config file or set to false - Registers
datasource with same name twice and get following runtime error,
Error executing command: Multiple JDBC datasource found for dsn
2) if xa=true, then it registers the datasource and able to use connections
from pool.
3) pool.initalSize = 1 - The property gives error in this version, however
worked fine with earlier version.
I will continue to test and share my findings.
Thankws,
Pravin
--
View this message in context: http://karaf.922171.n3.nabble.com/pax-jdbc-dbcp2-and-connection-pooling-tp4048791p4049266.html
Sent from the Karaf - User mailing list archive at Nabble.com.
Re: pax-jdbc-dbcp2 and connection pooling
Posted by Erwin Hogeweg <er...@me.com>.
Hi Pravin,
FWIW, I noticed that I (now) need:
jdbc.pool.maxTotal=2
jdbc.pool.maxIdle=2
Regards,
Erwin
> On Jan 17, 2017, at 2:24 PM, dpravin <pr...@gmail.com> wrote:
>
> Hello Christian,
>
> I started testing the new pax-jdbc today and found following issues during
> my testing with dbcp2,
>
> Environment details are
>
> Jboss Fuse 6.2.1
> pax-jdbc 0.10.0- SNAPSHOT
> Oracle - 11.2.0.4.0
>
> Installed following features from pax-jdbc,
>
>> features:install transaction jndi pax-jdbc-oracle pax-jdbc-pool-dbcp2
> pax-jdbc-config
>
> dataSourceName = dsn
> osgi.jndi.service.name = dsn
> osgi.jdbc.driver.name = oracle
> url = jdbc:oracle:thin:@//<<servername>>:port/databasename
> user = user
> password = password
> pool.initalSize = 1
> pool.maxTotal = 2
> pool.minIdle = 2
>
>
> Issues,
>
> 1) If xa property is not added to config file or set to false - Registers
> datasource with same name twice and get following runtime error,
>
> Error executing command: Multiple JDBC datasource found for dsn
>
> 2) if xa=true, then it registers the datasource and able to use connections
> from pool.
>
> 3) pool.initalSize = 1 - The property gives error in this version, however
> worked fine with earlier version.
>
>
> I will continue to test and share my findings.
>
>
> Thankws,
> Pravin
>
>
>
>
>
>
> --
> View this message in context: http://karaf.922171.n3.nabble.com/pax-jdbc-dbcp2-and-connection-pooling-tp4048791p4049266.html
> Sent from the Karaf - User mailing list archive at Nabble.com.