I''m trying to get rails working with DB2 V9. I''ve built two DB2 drivers and cannot get them to work. I''ve tried to use the ruby-db2-0.4.4 package to build the driver. When I use this adapter (db2), Rails queries the database and puts the ID column value (which is of type integer) in single quotes (select * from TEST where ID = ''1''), and the database rejects the SQL. I''ve also tried to use the IBM''s DB2forRails starter package. When I build and use this adapter (ibm_db2), I get the following error when I try to access the database: dependencies.rb:123:in `const_missing`: unitialized constant CASE_LOWER (NameError). I would appreciate any help from someone who has successfully installed the DB2 driver and maybe experienced these errors and fixed them along the way. Thanks! -Joe --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Joe, I''ve got the ibm_db2 driver running successfully here. I''ve started writing a presentation on this for IDUG in May, and the installation is documented in it. You can pick up the latest version from here - http://www.scotdb.com/downloads/railsdb2.odp (that''s a OpenOffice Presentation). If that doesn''t help, if you let me know your environment (operating system, Ruby and Rails versions etc.) then I''ll try to help further. Thanks Phil --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Philip Nelson wrote:> Joe, > > I''ve got the ibm_db2 driver running successfully here. > > I''ve started writing a presentation on this for IDUG in May, and the > installation is documented in it. You can pick up the latest version from > here - > > http://www.scotdb.com/downloads/railsdb2.odp > > (that''s a OpenOffice Presentation). > > If that doesn''t help, if you let me know your environment (operating system, > Ruby and Rails versions etc.) then I''ll try to help further. > > Thanks > > PhilThanks, Phil, I''ll give that a try. I have managed to figure out when using the db2.0.4.4 driver, that by using the "to_i" method to convert the argument "params(:id)", which is implicitly a string, into an integer wherever the argument is used within a find() method call, I can get Rails to work. I still don''t know why it treats "params(:id)" as a string but when MySQL is used, there is no such problem. thanks, Joe --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---