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.