Forum: Ruby on Rails Legacy database support (iSeries / as/400)

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.
2ce82d5751d315dc12d31759d165b160?d=identicon&s=25 shawn (Guest)
on 2007-03-15 17:46
(Received via mailing list)
I would really like to incorporate Ruby in my organization, but I have
been mostly limited to Java (for the past 10 years or so) due to the
availability of mature JDBC drivers (particularly for as/400 aka i5
aka iSeries).  While Java works fine, a full J2EE implementation if
often overkill for many smaller applications.  My current web
development framework of choice is Tapestry along with Spring and
Hibernate.

I've played with Ruby and RoR for a while now, but as far as I know
there is no real support yet for DB2/400.  I don't want to run Ruby on
the iSeries, but I do need database support.  Does RoR need to be
explicitly support DB2/400, or is it possible to use a generic ODBC
connection?  I have read for the past year or so that iSeries support
is on the way, but I haven't seen any real progress yet.  I would
appreciate any information or suggestions.
4e69f7adb2b29a7778da7a52aabe74a0?d=identicon&s=25 Philip Nelson (Guest)
on 2007-03-15 22:55
(Received via mailing list)
Shawn,

As you are no doubt aware, there are two ways to talk to DB2/400 from
client/server applications : via a proprietary driver (iSeries Access)
and
using the standard DB2 client via DB2 Connect.

If you have DB2 Connect, then you should be able to use the ibm_db2
client
from IBM Alphaworks.    

Phil
2ce82d5751d315dc12d31759d165b160?d=identicon&s=25 shawn (Guest)
on 2007-03-16 16:55
(Received via mailing list)
Philip,

Yes, I'm aware of those, but comments such as this:
http://wiki.rubyonrails.com/rails/pages/IBM+DB2 and this:
http://www-128.ibm.com/developerworks/forums/dw_th...

tell me that IBM is working to unify DB2 Connect support across all of
the db2 products.  It appears full support is coming in the future,
but I was curious to know if anyone in the rails community is having
success with this at the moment.

Thanks,
Shawn
A2c85dc5ee81b12e3cc0a6522e8d079d?d=identicon&s=25 Chris Hall (au5lander)
on 2007-03-16 18:07
(Received via mailing list)
we're using iSeries Access and the Rails ODBC Adapter from Openlink at

http://odbc-rails.rubyforge.org/

it seems to work for our purposes.
883e87b366e7e5364f2514c2f35174ca?d=identicon&s=25 John Land (johnland)
on 2014-11-06 09:55
It is helpful. Thanks for sharing.
This topic is locked and can not be replied to.