SOLVED.
After looking through the dbcp2 source code I discovered that the pool
properties need to be prepended by 'jdbc.' So:
jdbc.pool.maxTotal=23
jdbc.pool.maxIdle=-1
Even now that I know this I am unable to find any documentation describing
these properties.
Cheers,
Erwin
On Tuesday, December 20, 2016 at 9:34:04 PM UTC-5, Dutch Dude wrote:
>
> Hi,
>
> I am sure I am doing something wrong, but I feel I am chasing my tail.
>
> Christian helped me out a while ago setting up a DataSource with mysql,
> and that works perfectly. However, now I need to increase the connection
> pool size but I can't figure it out. I tried a bunch of things, following
> the instructions on the wiki, but to no avail. I always see max. 8
> connections in mysql workbench, no matter how many I have configured.
>
> I this in my datasource config:
>
> pool.initialSize=11
> pool.maxTotal=23
>
> and this in my persistence.xml:
>
> <!-- Configure connection pool. -->
>
> <property name="eclipselink.target-database" value="MYSQL" />
>
> <property name="eclipselink.connection-pool.default.initial" value="1" />
>
> <property name="eclipselink.connection-pool.default.min" value="64" />
>
> <property name="eclipselink.connection-pool.default.max" value="64" />
>
> These are the jdbc bundles:
> id State Bundle
> 57 ACTIVE org.ops4j.pax.jdbc_0.9.0
> 58 ACTIVE org.ops4j.pax.jdbc.pool.dbcp2_0.9.0
> 59 ACTIVE org.ops4j.pax.jdbc.config_0.9.0
> 60 ACTIVE org.ops4j.pax.jdbc.pool.common_0.9.0
> 63 ACTIVE com.mysql.jdbc_5.1.40
> g!
>
> Just FYI - It doesn't make a difference when I include the pax-jdbc-mysql
> bundle because the com.mysql.jdbc also registers the DSFactories.
>
> And this is the DataSource service:
> g! services javax.sql.DataSource
> {javax.sql.DataSource}={user=user, osgi.jndi.service.name=jdbc/mynonjta,
> dataSourceName=jdbc/mynonjta, databaseName=database,
> url=jdbc:mysql://my_db_server:3306/database,
> service.pid=org.ops4j.datasource.81aed1e6-e5e3-4398-a67b-2e23b22e96b2,
> service.factoryPid=org.ops4j.datasource, password=password,
> pool.maxTotal=23, osgi.jdbc.driver.class=com.mysql.jdbc.Driver-pool,
> felix.fileinstall.filename=file:/Users/erwin/work/.../org.ops4j.datasource-my.cfg,
>
> pool.initialSize=11, service.id=139, service.bundleid=59,
> service.scope=singleton}
> "Registered by bundle:" org.ops4j.pax.jdbc.config_0.9.0 [59]
> "Bundles using service"
> org.apache.aries.jpa.container_2.3.0 [51]
>
> Does anyone see what I am missing?
>
> As always, your help is greatly appreciated.
>
> BTW... I am using RESOURCE-LOCAL transaction-type.
>
> EL-2.6.2
> Equinox-3.10
> Java-8
> MacOS Sierra
>
>
> Thanks,
>
> Erwin
>
>
--
--
------------------
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.
