Re: Using multiple Db connections to single Database

2017-01-26 Thread Michael Gentry
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 th

Re: Using multiple Db connections to single Database

2017-01-26 Thread John Huss
Are you creating a new ObjectContext for each request? You should be. On Thu, Jan 26, 2017 at 12:11 PM Alexander Uherek 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

Using multiple Db connections to single Database

2017-01-26 Thread Alexander Uherek
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-S