Hi Alexander, I'm not sure which connection feature (DataSource Factory) you are using to connect to the DB (Driver, JNDI, or DBCP), but all three of those use a connection pooling mechanism. When you ask an Object/Data Context to perform a query or commit changes, it borrows a connection from the connection pool, does some SQL, then returns the connection back to the pool where it can be re-used later. If you don't have multiple simultaneous query/commit changes occurring across multiple Object/Data Contexts, it makes perfect sense to see one connection get used a lot (really depends on the connection pooling mechanism, though) and the others to be idle. This is working as-designed. If you starting doing more things in parallel, you'll see more connections get used.
mrg On Thu, Jan 26, 2017 at 11:05 AM, Alexander Uherek <auhe...@mackoy.de> wrote: > Hello, > > I am using Cayenne 3.0.2 together with the play Framework (1.2.7). > I configured the framework to use a pool of 10 DB-connections, which > according to pg_stats are opened and idle. > Unfortunatly only one connection is used for my Cayenne Queries. > Do you have any hints? > > > Alexander Uherek > IT-Services > > mackoyCONSULTING > Schloss Seefeld | Hochschloss > 82229 Seefeld > Tel. +49 8152/92989-82 > Fax +49 8152/92989-89 > > auhe...@mackoy.de > www.mackoy.de <http://www.mackoy.de/> >
