Forum: JRuby [ANN] activerecord-jdbc-adapter 0.9 released

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
526d60de6472502bb570a9df2842b33b?d=identicon&s=25 Nick Sieger (Guest)
on 2008-11-27 05:27
(Received via mailing list)
Hi everyone,

I'm pleased to announce the release of activerecord-jdbc-adapter 0.9.
This release should be fully compatible with Rails 2.2. In particular,
I've added code in the adapter to detect when you use a JNDI
connection and automatically add a checkin hook for the Rails
connection pool to ensure that the connection is returned to the JNDI
pool at the end of each request. This is a little suboptimal in that
there are two levels of pooling; you still need to make sure your AR
pool size is >= your JNDI pool size. I'm thinking about how to
circumvent the AR pool in a future release. As a fallback, you can
also use the pre-2.2 technique described in [1] to completely close
the connection after every request.

Also, if you're interested in specifics of activerecord-jdbc
development, please join the mailing lists over at
http://kenai.com/projects/activerecord-jdbc/lists.

Looking forward to your feedback!

/Nick

[1]:
http://blog.linkedin.com/2008/08/19/jdbc-connectio...

Full 0.9 changelog follows.

## 0.9

- Now updated to support ActiveRecord 2.2. JNDI-based connections will
  automatically connect/disconnect for every AR connection pool
  checkout/checkin. For best results, set your pool: parameter >= the
  actual maximum size of the JNDI connection pool. (We'll look at how
  to eliminate the need to configure AR's pool in the future.)
- NEW! Informix support courtesy of Javier Fernandez-Ivern.
- Backport another Oracle CLOB issue, thanks Edson C├ęsar.
- Rubyforge #22018: chomp final trailing semicolon for oracle
- JRUBY-2848: Fix NPE error in set_native_database_types
- Rework oracle lob saving callback to be Rails 2.1 friendly (assist
  from court3nay)
- JRUBY-2715: Add create/drop database methods to Postgres (Peter
Williams)
- JRUBY-3183: Fix structure dump for Postgres (Ryan Bell)
- JRUBY-3184: recreate_database for test database working for PG (Ryan
Bell)
- JRUBY-3186: disable referential integrity for PG (Ryan Bell)
- Authoritative repository now hosted at
  git://github.com/nicksieger/activerecord-jdbc-adapter.git; rubyforge
  svn trunk cleaned out.

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email
Bcf23fd7e4ca8b75df30109fbe616b02?d=identicon&s=25 James Norton (Guest)
on 2009-05-12 16:42
(Received via mailing list)
I know this is an old announcement, but I have a question regarding your
statement that the AR pool size should be >= the size of the JNDI pool.
How
can setting the size of the AR pool > the size of the JNDI pool ever
work?
Doesn't the AR pool keep its connections open?  Won't it exceed the
number
of available connections from the JNDI pool leading to a connection
timeout?

Thanks,

James
This topic is locked and can not be replied to.