[ANN] activerecord-jdbc-adapter 0.9.1 Released

Hi all, we released activerecord-jdbc-adapter 0.9.1 today. This
release contains a lot of updates over the previous release, and an
upgrade is recommended. In particular, we started to pay renewed
attention to running ActiveRecord’s own tests using the jdbc adapter
this release.

Please install the usual way, with “jruby -S gem install
activerecord-jdbc-adapter”, “jruby -S gem install
activerecord-jdbcmysql-adapter”, etc. Give us feedback on the new
activerecord-jdbc JIRA instance located at
http://kenai.com/jira/browse/ACTIVERECORD_JDBC.

Release contents follow.

Cheers,
/Nick

activerecord-jdbc-adapter is a database adapter for Rails’ ActiveRecord
component that can be used with JRuby[http://www.jruby.org/]. It allows
use of
virtually any JDBC-compliant database with your JRuby on Rails
application.

Changes:

0.9.1

  • We did a lot of internal cleanup this release in the hopes of
    simplifying the code and increasing performance.
  • Many SQLite updates (thanks Nils Christian Haugen)
  • JRUBY-2912: Fix MSSQL create/drop database (Joern Hartmann)
  • JRUBY-2767: Mistake in selecting identity with H2/HSQLDB
  • JRUBY-2884: jdbc_postgre.rb issue handling nil booleans (also a fix
    for hsqldb/h2) + tests
  • JRUBY-2995: activerecord jdbc derby adapter should quote columns
    called ‘year’
  • JRUBY-2897: jdbc_postgre.rb needs microsecond support
  • JRUBY-3282: Upgrade to derby 10.4.2.0 to allow unique constraints
    with nullable columns
  • Update h2 from 1.0.63 to 1.1.107 in driver
  • JRUBY-3026: [Derby] Allow select/delete/update conditions with
    comparison to NULL using ‘=’
  • JRUBY-2996: …(actually this fixes only remaining issue of this bug
    which was symbols making into quote were exploding
  • JRUBY-2691: Update sybase driver to pass simple unit tests with jtds
    and verify it works with the new dialect keyword. patch by Leigh
    Kennedy
  • Make :float type work on h2,hsql [returned as string]. Make :float
    work on hsqldb (no paren value supported). Make REAL_TYPE just
    return RubyFloat
  • JRUBY-3222: Upgrade #type_to_sql to variation of AR 2.1.2 version
  • Add patch supplied in JRUBY-3489 (patch by Jean-Dominique Morani)
  • Various Oracle fixes by edsono
  • JRUBY-2688: Don’t hard-code MySQL connection character encoding to
    utf8

To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

This is really great! Do you have any numbers on how many Rails tests
are
not passing for each adapter? I know Tom sent off some numbers a while
back.

Joe

Is connection pooling still happening at the AR level as well as JNDI?

On Tue, Mar 17, 2009 at 1:24 PM, Nick S. [email protected]
wrote:

http://kenai.com/jira/browse/ACTIVERECORD_JDBC.
virtually any JDBC-compliant database with your JRuby on Rails application.

  • JRUBY-2884: jdbc_postgre.rb issue handling nil booleans (also a fix
    which was symbols making into quote were exploding
    utf8

To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email


CONFIDENTIALITY NOTICE: This email is for sole use of intended
recipient(s). Unauthorized use is prohibited.


To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

Yes it is, unfortunately. I haven’t been able to crack that nut yet.
I’d like to see whether it’s possible to measure what the cost of the
extra overhead is – certainly there are synchronization and memory
costs, but compared to the database activity itself, is it worth the
effort?

/Nick

On Tue, Mar 17, 2009 at 2:55 PM, Todd W. [email protected] wrote:

activerecord-jdbc-adapter", "jruby -S gem install

  • Many SQLite updates (thanks Nils Christian Haugen)
  • JRUBY-3026: [Derby] Allow select/delete/update conditions with
  • Add patch supplied in JRUBY-3489 (patch by Jean-Dominique Morani)

To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email


To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email

I just ran the tests with 0.9.1 + Rails 2.3.2:

MySQL: 2013 tests, 6507 assertions, 19 failures, 1 errors
PostgreSQL: 2024 tests, 6314 assertions, 54 failures, 83 errors
SQLite3: 2013 tests, 5814 assertions, 69 failures, 42 errors (!)
Derby: 2018 tests, 6002 assertions, 67 failures, 168 errors

We’d obviously love to be completely green, but that said, this
probably represents the best those numbers have ever been for the jdbc
adapter.

/Nick

On Tue, Mar 17, 2009 at 12:58 PM, Joseph A. [email protected]
wrote:

upgrade is recommended. In particular, we started to pay renewed

for hsqldb/h2) + tests

  • JRUBY-2691: Update sybase driver to pass simple unit tests with jtds

To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email


To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email