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.
