Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
MIME-Version: 1.0
In-Reply-To: <83D249F1-A12C-4F89-8DA3-E1FC681747DB@mackoy.de>
References: <83D249F1-A12C-4F89-8DA3-E1FC681747DB@mackoy.de>
From: Michael Gentry <mgentry@masslight.net>
Date: Thu, 26 Jan 2017 13:28:16 -0500
Message-ID: <CAA-upzrqR0Dzukq2CN3wWVC_uvpaPPCQsAcy9XL_2m2w70deDQ@mail.gmail.com>
Subject: Re: Using multiple Db connections to single Database
To: Cayenne Users <user@cayenne.apache.org>
Content-Type: multipart/alternative; boundary=94eb2c1b4fd076702a0547038429
archived-at: Thu, 26 Jan 2017 18:28:45 -0000

--94eb2c1b4fd076702a0547038429
Content-Type: text/plain; charset=UTF-8

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 <auherek@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
>
> auherek@mackoy.de
> www.mackoy.de <http://www.mackoy.de/>
>

--94eb2c1b4fd076702a0547038429--