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]
---
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.
