On Mon, Dec 22, 2008 at 2:52 PM, AD email@example.com wrote:
is there a cohesive doc on using Rails 2.2 with JNDI connection pooling and
how it is used in conjunction with the new activereord-jdbc gem ?
From the changelog it seems you can simply use jndi line in the
database.yml, set pool > JNDI pool and you should be good, but not sure if
that is all that is needed.
Nick any advice here? We are looking to use JNDI (since other apps will
need the connection pool that are non-rails) so we want to make sure we set
this up correctly.
That’s pretty much it, set the “jndi:” setting to point to your data
source. Although currently I haven’t found a good way to completely
route around Rails’ connection pool, so you’ll want to make sure that
the Rails connection pool (“pool:” setting in database.yml) is sized
at least as big as your JNDI pool. (I should have thought through it a
little more since I wrote it, but it needed to get out the door :). So
what’s happening is there’s an extra, somewhat unnecessary layer of
pooling of the Rails adapters. But activerecord-jdbc 0.9 should be set
up to properly release the JNDI connection pool when the Rails
connection adapter is checked in.
To unsubscribe from this list, please visit: