[ANN] activerecord-jdbc-adapter 0.8.1 Released

Ruby JRuby
1

Everyone,

The long-delayed and much-awaited 0.8.1 release is here. It fixes
quite a few reported bugs (but not quite all). See the full changelog
below for details.

Please help me make more frequent releases of ar-jdbc by submitting
“svn diff” or “git format-patch” patches against the trunk of
activerecord-jdbc. Test cases appreciated also.

File bugs here:

http://jira.codehaus.org/browse/JRUBY

Use the “ActiveRecord-JDBC” component when filing them.

You can check out the source here:

SVN: http://jruby-extras.rubyforge.org/svn/trunk/activerecord-jdbc
GIT: git://github.com/nicksieger/activerecord-jdbc-adapter

Cheers,
/Nick

Changes:

0.8.1

  • Now sporting a JDBC sqlite3 adapter! Thanks Joseph A…
  • Added support for InterSystems Cache database (Ryan B.)
  • Fix for JRUBY-2256
  • JRUBY-1638, JRUBY-2404, JRUBY-2463: schema.table handling and Oracle
    NUMBER fixes (Darcy S. & Jesse Hu)
  • Add structure dump and other DDL-ish for DB2 (courtesy abedra and
    stuarthalloway)
  • Fix missing quote_table_name function under Rails 1.2.6 and earlier
  • Small tweaks to jdbc.rake to select proper config
  • JRUBY-2011: Fix MSSQL string un-quoting issue (Silvio Fonseca)
  • JRUBY-1977, 17427: Fix information_schema select issue with MSSQL
    (Matt B.)
  • 20479: Improve get_table_name for MSSQL (Aslak
    Hellesøy)- 20243: numerics improvements for MSSQL (Aslak
    Hellesøy)- 20172: don’t quote table names for MSSQL (Thor Marius Henrichsen)
  • 19729: check for primary key existence in postgres during insert
    (Martin Luder)
  • JRUBY-2297, 18846: retrying failing SQL statements is harmful when
    not autocommitting (Craig McMillan)
  • 10021: very preliminary sybase support. (Mark Atkinson) Not usable
    until collision w/ sqlserver driver is resolved.
  • JRUBY-2312, JRUBY-2319, JRUBY-2322: Oracle timestamping issues
    (Jesse Hu & Michael König)
  • JRUBY-2422: Fix MySQL referential integrity and rollback issues
  • JRUBY-2382: mysql string quoting fails with
    ArrayIndexOutofBoundsException

To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
2

Thanks Nick.

2008/6/5 Nick S. [email protected]:

3

Great work…

FYI the RubyForge download links for 0.8.1 give me a 404, just in case
something is amiss

http://rubyforge.org/frs/?group_id=2014&release_id=22680

Nev

below for details.

0.8.1

  • JRUBY-2011: Fix MSSQL string un-quoting issue (Silvio Fonseca)
    (Jesse Hu & Michael König)
  • JRUBY-2422: Fix MySQL referential integrity and rollback issues
  • JRUBY-2382: mysql string quoting fails with
    ArrayIndexOutofBoundsException

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
4

I would like to get the SQLite3 adapter working a little better than it
currently is. My biggest question right now is around how we get to and
from a DB column type to something expected by rails. I see in several
adapters the type_cast method which looks like its involved in this
somehow,
but I can’t see any place it’s actually used.
For example, say I want to store booleans as a “t” and an “f” (right now
the
adapter is doing 1 and 0 which is inconsistent with the normal rails
adapter). Where do I take a true/false value from rails and convert it
to
the t/f value, and where do I take a t/f value from the DB and convert
it to
true/false?

Thanks for the help and the mention in the release notes.

Joe

On Wed, Jun 4, 2008 at 9:13 PM, Neville B. <

5

I just upgraded to 0.8.1 and I noticed that every time I run any tests
using rake, all the tables in my dev db get dropped.

When I downgraded to 0.8, the problem went away.

I’m using rails 2.0.2, jruby 1.1.2 and mysql5.

Anyone else noticed the same issue?

/i

On Jun 4, 2008, at 2:34 PM, Nick S. wrote:

File bugs here:
Cheers,
NUMBER fixes (Darcy S. & Jesse Hu)

To unsubscribe from this list, please visit:

http://xircles.codehaus.org/manage_email
6

Great job to both Nick and Joseph. What a coincident, I was just
searching
for sqlite3 support exactly 2 days ago, and now here it is.

I had updated the ActiveRecord-JDBC wiki page to reflect the the support
for
sqlite3 and sample of database.yml.

-DJ

7

Patch now available: http://jira.codehaus.org/browse/JRUBY-2619

/i

On Jun 6, 2008, at 12:59 PM, Igor M. wrote:

“svn diff” or “git format-patch” patches against the trunk of
SVN: http://jruby-extras.rubyforge.org/svn/trunk/activerecord-jdbc

  • Added support for InterSystems Cache database (Ryan B.)
    (Matt B.)
  • JRUBY-2382: mysql string quoting fails with
    ArrayIndexOutofBoundsException

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