Any success stories using rails against a DB2 database on an as400? If so, how? Thanks Ed Schechter -- Posted via http://www.ruby-forum.com/.
I had a similar problem domain where I needed to interface with an iSeries/400. I found that the iSeries was not a great backend for an OLTP, and experienced all sorts of performance and availablility issues. In the end, I eventually decided that the best solution was to have a separate DB to handle OLTP and then sync offline with the iSeries using some sort of messaging system. For my environment, this makes it much easier to introduce rails to my employer. It allows me to say "you can issolate your side from our ''non-standard'' webapp"; of course, I''m more happy that I''m issolated from them :) HTH. On Tuesday, March 21, 2006, at 3:18 AM, Ed Schechter wrote:>Any success stories using rails against a DB2 database on an as400? > >If so, how? > >Thanks >Ed Schechter > >-- >Posted via http://www.ruby-forum.com/. >_______________________________________________ >Rails mailing list >Rails@lists.rubyonrails.org >http://lists.rubyonrails.org/mailman/listinfo/railsCheers! --Dave Teare http://devlists.com - Email list management http://palmsphere.com - Apps for your hand-held -- Posted with http://DevLists.com. Sign up and save your time!
DB2/400 does not use the same drivers as DB2/UDB from client platforms that I am familiar with. Actually there is very little support for this platform even among mainstream DB tool providers such as Embarcadero, good luck with RoR :( On 21 Mar 2006 02:48:02 -0000, Dave Teare <devlists-rubyonrails@devlists.com> wrote:> I had a similar problem domain where I needed to interface with an > iSeries/400. I found that the iSeries was not a great backend for an > OLTP, and experienced all sorts of performance and availablility issues. > > In the end, I eventually decided that the best solution was to have a > separate DB to handle OLTP and then sync offline with the iSeries using > some sort of messaging system. > > For my environment, this makes it much easier to introduce rails to my > employer. It allows me to say "you can issolate your side from our > ''non-standard'' webapp"; of course, I''m more happy that I''m issolated > from them :) > > HTH. > > On Tuesday, March 21, 2006, at 3:18 AM, Ed Schechter wrote: > >Any success stories using rails against a DB2 database on an as400? > > > >If so, how? > > > >Thanks > >Ed Schechter > > > >-- > >Posted via http://www.ruby-forum.com/. > >_______________________________________________ > >Rails mailing list > >Rails@lists.rubyonrails.org > >http://lists.rubyonrails.org/mailman/listinfo/rails > > > Cheers! > --Dave Teare > http://devlists.com - Email list management > http://palmsphere.com - Apps for your hand-held > > > -- > Posted with http://DevLists.com. Sign up and save your time! > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- Jeremy Huffman http://www.jeremyhuffman.com
I''m in a similar situation. I have to have access to information residing on an AS/400 (iSeries, whatever they call it nowadays). I created a module I for accessing the AS/400 using dbi/ODBC. where I need access (syncing, stored procedure calls, etc), I just require the module. I use a local MySQL database for storing/managing application data. Chris On 3/20/06, Jeremy Huffman <jeremy@jeremyhuffman.com> wrote:> > DB2/400 does not use the same drivers as DB2/UDB from client platforms > that I am familiar with. Actually there is very little support for > this platform even among mainstream DB tool providers such as > Embarcadero, good luck with RoR :( > > > On 21 Mar 2006 02:48:02 -0000, Dave Teare > <devlists-rubyonrails@devlists.com> wrote: > > I had a similar problem domain where I needed to interface with an > > iSeries/400. I found that the iSeries was not a great backend for an > > OLTP, and experienced all sorts of performance and availablility issues. > > > > In the end, I eventually decided that the best solution was to have a > > separate DB to handle OLTP and then sync offline with the iSeries using > > some sort of messaging system. > > > > For my environment, this makes it much easier to introduce rails to my > > employer. It allows me to say "you can issolate your side from our > > ''non-standard'' webapp"; of course, I''m more happy that I''m issolated > > from them :) > > > > HTH. > > > > On Tuesday, March 21, 2006, at 3:18 AM, Ed Schechter wrote: > > >Any success stories using rails against a DB2 database on an as400? > > > > > >If so, how? > > > > > >Thanks > > >Ed Schechter > > > > > >-- > > >Posted via http://www.ruby-forum.com/. > > >_______________________________________________ > > >Rails mailing list > > >Rails@lists.rubyonrails.org > > >http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > > Cheers! > > --Dave Teare > > http://devlists.com - Email list management > > http://palmsphere.com - Apps for your hand-held > > > > > > -- > > Posted with http://DevLists.com. Sign up and save your time! > > _______________________________________________ > > Rails mailing list > > Rails@lists.rubyonrails.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > -- > Jeremy Huffman > http://www.jeremyhuffman.com > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060321/7f0c0651/attachment.html
so is the issue of connecting RoR to db2 on iseries going to be impossible? my workplace is 100% ibm, and i''d love to redo our customer load-tracking application in rails, but all our data is on as400 db2, and it''s such a massive amount of data that replicating to a separate standalone db box would be cost-prohibitive.
You will not be able to use active record unless/until someone codes an adapter for it. You can use dbi/odbc and use the rest of the rails framework. On 3/30/06, Anonymous <list@freeonrails.com> wrote:> > > so is the issue of connecting RoR to db2 on iseries going to be > impossible? my workplace is 100% ibm, and i''d love to redo our customer > load-tracking application in rails, but all our data is on as400 db2, and > it''s such a massive amount of data that replicating to a separate standalone > db box would be cost-prohibitive. > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- Jeremy Huffman http://www.jeremyhuffman.com -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060330/123a5565/attachment.html
Great to hear! I am starting a project and the plan is to replicate once a day to Postgresql from our iSeries. It is good to know it will be smooth sailing. On 3/30/06, Jeremy Huffman <jeremy@jeremyhuffman.com> wrote:> > You will not be able to use active record unless/until someone codes an > adapter for it. You can use dbi/odbc and use the rest of the rails > framework. > > > On 3/30/06, Anonymous <list@freeonrails.com> wrote: > > > > > > so is the issue of connecting RoR to db2 on iseries going to be > > impossible? my workplace is 100% ibm, and i''d love to redo our customer > > load-tracking application in rails, but all our data is on as400 db2, and > > it''s such a massive amount of data that replicating to a separate standalone > > db box would be cost-prohibitive. > > _______________________________________________ > > Rails mailing list > > Rails@lists.rubyonrails.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > > > > > > -- > > Jeremy Huffman > http://www.jeremyhuffman.com > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060414/17388615/attachment.html
Anonymous wrote in post #55831:> so is the issue of connecting RoR to db2 on iseries going to be > impossible? my workplace is 100% ibm, and i''d love to redo our customer > load-tracking application in rails, but all our data is on as400 db2, > and it''s such a massive amount of data that replicating to a separate > standalone db box would be cost-prohibitive.Here is IBM''s formal project on rubyforge for connecting to their databases including DB2 on IBMi (aka AS400, iSeries, System i, i5) http://rubyforge.org/projects/rubyibm AaronBartell.com -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
On Wed, Aug 1, 2012 at 8:52 AM, Aaron Bartell <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> Anonymous wrote in post #55831: >> so is the issue of connecting RoR to db2 on iseries going to be >> impossible? my workplace is 100% ibm, and i''d love to redo our customer >> load-tracking application in rails, but all our data is on as400 db2, >> and it''s such a massive amount of data that replicating to a separate >> standalone db box would be cost-prohibitive. > > Here is IBM''s formal project on rubyforge for connecting to their > databases including DB2 on IBMi (aka AS400, iSeries, System i, i5) > > http://rubyforge.org/projects/rubyibm >Another alternative, if I''m allowed to mention it here, is JRuby.. then you''d just need DB2 JDBC drivers. -- Greg Akins http://twitter.com/akinsgre -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.