Yup, I think you are right. Thanks,
Eewin > On Sep 10, 2018, at 10:54, Jean-Baptiste Onofré <[email protected]> wrote: > > Hi Erwin, > > there a "config" properties of the PooledDataSourceFactory (acting as a > ManagedService), not "service" properties. I think that where you > confusion comes from. > > Regards > JB > > On 10/09/2018 16:12, Erwin Hogeweg wrote: >> JB and François, >> >> Thanks, I am familiar with the PaxJDBC wiki. I guess I expected to see those >> pool properties in the PooledDataSourceFactory. >> >> I DO see multiple DB connections, so I assume everything is working as >> expected. >> >> Thanks for the clarification. >> >> Erwin >> >>> On Sep 10, 2018, at 10:02, Francois Papon <[email protected]> >>> wrote: >>> >>> Hi, >>> >>> There is some examples on the PaxJDBC wiki where they mentioned a >>> "jdbc.pool" prefix : >>> >>> https://ops4j1.jira.com/wiki/spaces/PAXJDBC/pages/119078914/Pooling+and+XA+support+in+1.0.0 >>> >>> regards, >>> >>> François Papon >>> [email protected] >>> >>> Le 10/09/2018 à 17:46, Jean-Baptiste Onofré a écrit : >>>> It looks good to me as you should have a configuration with the pool >>>> configuration right (ManagedServiceFactory) ? >>>> >>>> Regards >>>> JB >>>> >>>> On 10/09/2018 15:37, Erwin Hogeweg wrote: >>>>> >>>>>> On Sep 10, 2018, at 09:33, Jean-Baptiste Onofré <[email protected] >>>>>> <mailto:[email protected]>> wrote: >>>>>> >>>>>> What's the output of bundle:services -p 86 ? >>>>> *karaf*@root()> bundle:services-p 86 >>>>> >>>>> >>>>> >>>>> OPS4J Pax JDBC Pooling DBCP2 (86) provides: >>>>> ------------------------------------------- >>>>> objectClass = [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory] >>>>> pool = dbcp2 >>>>> service.bundleid = 86 >>>>> service.id <http://service.id> = 267 >>>>> service.scope = singleton >>>>> xa = false >>>>> ---- >>>>> objectClass = [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory] >>>>> pool = dbcp2 >>>>> service.bundleid = 86 >>>>> service.id <http://service.id> = 310 >>>>> service.scope = singleton >>>>> xa = true >>>>> *karaf*@root()> >>>>> >>>>> >>>>> >>>>>> All pool properties are not as service properties, they are only config >>>>>> properties. >>>>>> >>>>>> Regards >>>>>> JB >>>>>> >>>>>> On 10/09/2018 15:23, Erwin Hogeweg wrote: >>>>>>> Thanks JB, >>>>>>> >>>>>>>> The pool uses "pool." prefix in the config. >>>>>>>> >>>>>>>> So pool.maxTotal is a valid configuration in DBCP, pool.dummy is >>>>>>>> another one. >>>>>>> That is what I thought, but those properties don’t show up in the >>>>>>> PooledDataSourceFactory (see below). Is that expected? >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> Erwin >>>>>>> >>>>>>> >>>>>>>>> [javax.sql.DataSource] >>>>>>>>> ——————————— >>>>>>>>> … >>>>>>>>> *pool.maxIdle = 25 >>>>>>>>> pool.maxTotal = 8 >>>>>>>>> * >>>>>>> >>>>>>>>> [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory] >>>>>>>>> -------------------------------------------------------- >>>>>>>>> pool = dbcp2 >>>>>>>>> service.bundleid = 86 >>>>>>>>> service.id <http://service.id/> <http://service.id >>>>>>>>> <http://service.id/>> <http://service.id/> = 113 >>>>>>>>> service.scope = singleton >>>>>>>>> xa = false >>>>>>>>> Provided by : >>>>>>>>> OPS4J Pax JDBC Pooling DBCP2 (86) >>>>>>>>> Used by: >>>>>>>>> OPS4J Pax JDBC Config (16) >>>>>>>>> >>>>>>>>> [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory] >>>>>>>>> -------------------------------------------------------- >>>>>>>>> pool = dbcp2 >>>>>>>>> service.bundleid = 86 >>>>>>>>> service.id <http://service.id/> <http://service.id >>>>>>>>> <http://service.id/>> <http://service.id/> = 116 >>>>>>>>> service.scope = singleton >>>>>>>>> xa = true >>>>>>>>> Provided by : >>>>>>>>> OPS4J Pax JDBC Pooling DBCP2 (86) >>>>>>> >>>>>>> >>>>>>>> You can use any DBCP configuration as soon as you prefix with "pool.": >>>>>>>> >>>>>>>> maxIdle >>>>>>>> maxTotal >>>>>>>> maxWaitMillis >>>>>>>> testOnBorrow >>>>>>>> validationQuery >>>>>>>> validationQueryTimeout >>>>>>>> >>>>>>>> Regards >>>>>>>> JB >>>>>>>> >>>>>>>> On 10/09/2018 14:10, Erwin Hogeweg wrote: >>>>>>>>> All - >>>>>>>>> >>>>>>>>> Is anyone aware of changes in the DB pool configuration parameters in >>>>>>>>> 4.2.1? I can’t find any documentation re. that. >>>>>>>>> >>>>>>>>> The error I received in 4.2.0 is gone, but I can’t figure out how to >>>>>>>>> configure the pool. I tried all possible combination of pool. factory. >>>>>>>>> and property but none seem to work. >>>>>>>>> >>>>>>>>> Any pointer to an example or a document would be very much >>>>>>>>> appreciated. >>>>>>>>> >>>>>>>>> FWIW, This is my datasource .cfg >>>>>>>>> >>>>>>>>> osgi.jdbc.driver.class=com.mysql.jdbc.Driver >>>>>>>>> url=jdbc:mysql://my_db_server:3306/xyz?useSSL=false >>>>>>>>> dataSourceName=jdbc/_xyz_ >>>>>>>>> user=_user_ >>>>>>>>> password=_password_ >>>>>>>>> pool=dbcp2 >>>>>>>>> xa=false >>>>>>>>> >>>>>>>>> pool.maxTotal=8 >>>>>>>>> pool.maxIdle=25 >>>>>>>>> >>>>>>>>> And these are the generated services: >>>>>>>>> >>>>>>>>> *karaf*@root()> service:listDataSource >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> [javax.sql.DataSource] >>>>>>>>> ---------------------- >>>>>>>>> dataSourceName = jdbc/xyz >>>>>>>>> felix.fileinstall.filename = >>>>>>>>> file:/Users/erwin/work/Xyz/trunk/src/server/karaf.distro/target/assembly/etc/org.ops4j.datasource-xyz.cfg >>>>>>>>> osgi.jdbc.driver.class = com.mysql.jdbc.Driver >>>>>>>>> osgi.jndi.service.name = jdbc/xyz >>>>>>>>> password = password >>>>>>>>> pax.jdbc.managed = true >>>>>>>>> pool.maxIdle = 25 >>>>>>>>> pool.maxTotal = 8 >>>>>>>>> service.bundleid = 16 >>>>>>>>> service.factoryPid = org.ops4j.datasource >>>>>>>>> service.id <http://service.id/> <http://service.id >>>>>>>>> <http://service.id/>> <http://service.id/> = 274 >>>>>>>>> service.pid = >>>>>>>>> org.ops4j.datasource.7b57f2dc-2d66-40c1-8e0a-4e6b8e4f23da >>>>>>>>> service.scope = singleton >>>>>>>>> url = jdbc:mysql://my_db_server:3306/xyz?useSSL=false >>>>>>>>> user = user >>>>>>>>> Provided by : >>>>>>>>> OPS4J Pax JDBC Config (16) >>>>>>>>> Used by: >>>>>>>>> Xyz :: Data Model (190) >>>>>>>>> Xyz :: Repository Services Impl. (200) >>>>>>>>> >>>>>>>>> *karaf*@root()> service:listPooledDataSourceFactory >>>>>>>>> [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory] >>>>>>>>> -------------------------------------------------------- >>>>>>>>> pool = dbcp2 >>>>>>>>> service.bundleid = 86 >>>>>>>>> service.id <http://service.id/> <http://service.id >>>>>>>>> <http://service.id/>> <http://service.id/> = 113 >>>>>>>>> service.scope = singleton >>>>>>>>> xa = false >>>>>>>>> Provided by : >>>>>>>>> OPS4J Pax JDBC Pooling DBCP2 (86) >>>>>>>>> Used by: >>>>>>>>> OPS4J Pax JDBC Config (16) >>>>>>>>> >>>>>>>>> [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory] >>>>>>>>> -------------------------------------------------------- >>>>>>>>> pool = dbcp2 >>>>>>>>> service.bundleid = 86 >>>>>>>>> service.id <http://service.id/> <http://service.id >>>>>>>>> <http://service.id/>> <http://service.id/> = 116 >>>>>>>>> service.scope = singleton >>>>>>>>> xa = true >>>>>>>>> Provided by : >>>>>>>>> OPS4J Pax JDBC Pooling DBCP2 (86) >>>>>>>>> >>>>>>>>> *karaf*@root()> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> -- >>>>>>>> Jean-Baptiste Onofré >>>>>>>> [email protected] >>>>>>>> <mailto:[email protected]> <mailto:[email protected]> >>>>>>>> http://blog.nanthrax.net <http://blog.nanthrax.net/> >>>>>>>> Talend - http://www.talend.com <http://www.talend.com/> >>>>>> -- >>>>>> Jean-Baptiste Onofré >>>>>> [email protected] <mailto:[email protected]> >>>>>> http://blog.nanthrax.net <http://blog.nanthrax.net/> >>>>>> Talend - http://www.talend.com <http://www.talend.com/> >>> >> > > -- > Jean-Baptiste Onofré > [email protected] > http://blog.nanthrax.net > Talend - http://www.talend.com
