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:
|
Causedby:java.sql.SQLException:cannot setproperties [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│OracleDatabase11gRelease11.2.0.4.0-64bitProduction│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
Providedby:
OPS4J PaxJDBC 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
Providedby:
OPS4J PaxJDBC PoolingDBCP2 (77)
Usedby:
OPS4J PaxJDBC Config(74)
[org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory]
--------------------------------------------------------
pool =dbcp2
service.bundleid =77
service.id =147
service.scope =singleton
xa =true
Providedby:
OPS4J PaxJDBC PoolingDBCP2 (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]
<mailto:[email protected]>.
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.
