> > Due to increased SPAM and fake accounts, the self-registration has been > disabled. Sorry for the inconvenience. Contact the OPS4J General list to > have an account created. >
Who can help here? Am Dienstag, 19. September 2017 11:13:18 UTC+2 schrieb Jean-Baptiste Onofré: > > Hi > > it sounds like a bug, can you create a Jira about that ? > > Thanks, > Regards > > JB > > On 09/19/2017 11:03 AM, Maurice Betzel wrote: > > Dear community, > > i am trying to setup a database connection pool for Oracle using the > ojdbc8 12.2.0.1 Driver, but if i add: > > jdbc.pool.maxTotal=16 > > i get a SQLException: > > Caused by: java.sql.SQLException: cannot set properties [pool.maxTotal] > at org.ops4j.pax.jdbc.oracle.impl.OracleDataSourceFactory. > setProperties(OracleDataSourceFactory.java:97) ~[?:?] > at org.ops4j.pax.jdbc.oracle.impl.OracleDataSourceFactory. > createDataSource(OracleDataSourceFactory.java:53) ~[?:?] > > I have tested this with PAX-JDBC 0.9.0 where all was up and running > perfectly. It seems the pool parameters are not forwarded to the pool and > filtered out before the data-source creation. > > Config details for PAX-JDBC 1.2.0: > > osgi.jdbc.driver.name=oracle > pool=dbcp2 > xa=true > dataSourceName=oramult > .user=testUser > .password=testPassword > url=jdbc:oracle:thin:@//test-01:1521/oramult > jdbc.pool.maxTotal=16 > > Karaf details: > > karaf@root()> jdbc:ds-list > Name │ Product │ Version > │ URL │ Status > > ────────┼─────────┼───────────────────────────────────────────────────────────┼─────────────────────────────────────────────┼─────── > oramult │ Oracle │ Oracle Database 11g Release 11.2.0.4.0 - 64bit > Production │ jdbc:oracle:thin:@//test-01:1521/oramult │ OK > karaf@root()> service:list javax.sql.DataSource > [javax.sql.DataSource] > ---------------------- > dataSourceName = oramult > felix.fileinstall.filename = file:/C:/Users/betzm/Development/intellij/eu > .abeel.platform/assemblies/platform/target/platform-1.0.0/etc/org.ops4j. > datasource-oracle.test.persistence.cfg > osgi.jdbc.driver.name = oracle > osgi.jndi.service.name = oramult > service.bundleid = 74 > service.factoryPid = org.ops4j.datasource > service.id = 160 > service.pid = org.ops4j.datasource.f33bc71b-6efd-4759-b102-0a9889f2a2fd > service.scope = singleton > url = jdbc:oracle:thin:@//vlo-ora-02:1521/oramult > Provided by : > OPS4J Pax JDBC Config (74) > > karaf@root()> service:list PooledDataSourceFactory > [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory] > -------------------------------------------------------- > pool = dbcp2 > service.bundleid = 77 > service.id = 146 > service.scope = singleton > xa = false > Provided by : > OPS4J Pax JDBC Pooling DBCP2 (77) > Used by: > OPS4J Pax JDBC Config (74) > > [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory] > -------------------------------------------------------- > pool = dbcp2 > service.bundleid = 77 > service.id = 147 > service.scope = singleton > xa = true > Provided by : > OPS4J Pax JDBC Pooling DBCP2 (77) > > Any idea how to configure the connection pool? > > -- > -- > ------------------ > OPS4J - http://www.ops4j.org - [email protected] <javascript:> > > --- > You received this message because you are subscribed to the Google Groups > "OPS4J" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > > > -- -- ------------------ OPS4J - http://www.ops4j.org - [email protected] --- You received this message because you are subscribed to the Google Groups "OPS4J" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
