Hi,
I've started with Activerecord-jdbc for AS400 / System i, using the remote
JDBC driver from "AS400 Java Toolbox" (jdbc:as400:...).
I started the project based upon jdbc:DB2, and my focus is to run Rails
with ActiveScaffold. I now have a working column sorting with
"LIMIT/Paging" support, and also support for live search.
I'm inspired by the implementation done in DB2OnRails done by IBM.
(http://www.alphaworks.ibm.com/tech/db2onrails)
What's the procedure for committing this to the Activerecord-jdbc project?
My next issues is handling of:
- Adding automated tests to prove and enhance support
- More types like Boolean, Float, Date etc.
Inside scope:
- Support for current i5/OS versions. V5R3M0 and later
Out of my scope:
- Migrations (since we're coding against a standard product which already
controls the database scheme)
Right now my implementation requires a small SQL UDF (ILE RPG) to
correctly support paging, since DB2 has no direct support for LIMITS. The
IBM implementation will not support ORDER BY since it uses a OLAP function
row_number(), which I didn't succeed with when having column sorting
active.
Regards
Multi-Support A/S
Henrik Fjorback
--------------------------------------------------------------------
Phone +45 96 600 600, Fax +45 96 600 601
E-mail: [EMAIL PROTECTED]
http://www.multi-support.com
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
