Not directly on topic, but I'd suggest using jruby and jtopen (jt400.jar) regards, Simon
On Thu, Sep 19, 2013 at 3:31 PM, Wesley Staples <[email protected]> wrote: > I’m attempting to connect to an iSeries database with Sequel / ODBC. > Everything works fine on the 32-bit version of Ubuntu and on windows > however for some reason using the same code on a 64-bit system I’m getting > the error: > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:109:in > `fetch_all': failed to allocate memory (NoMemoryError) > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:109:in > `block in fetch_rows' > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:42:in > `block in execute' > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/database/connecting.rb:229:in > `block in synchronize' > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/connection_pool/threaded.rb:104:in > `hold' > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/database/connecting.rb:229:in > `synchronize' > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:39:in > `execute' > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/dataset/actions.rb:793:in > `execute' > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/adapters/odbc.rb:104:in > `fetch_rows' > from > /home/helpdesk/.rvm/gems/ruby-2.0.0-p247/gems/sequel-4.2.0/lib/sequel/dataset/actions.rb:143:in > `each' > from odbc_test.rb:7:in `<main>' > > I started with ruby 1.9.3 but upgraded to 2.0 with the same result. Any > thoughts on what I can check? > > I can connect with isql fine: > > isql -v GBAS400 > +---------------------------------------+ > | Connected! | > | | > | sql-statement | > | help [tablename] | > | quit | > | | > +---------------------------------------+ > SQL> SELECT TABLE_NAME FROM QSYS2.SYSTABLES WHERE TABLE_NAME = 'SYSTABLES' > > +---------------------------------------------------------------------------------------------------------------------------------+ > | > TABLE_NAME > | > > +---------------------------------------------------------------------------------------------------------------------------------+ > | > SYSTABLES > | > | > SYSTABLES > | > | > SYSTABLES > | > | > SYSTABLES > | > | > SYSTABLES > | > | > SYSTABLES > | > > +---------------------------------------------------------------------------------------------------------------------------------+ > SQLRowCount returns -1 > 6 rows fetched > SQL> > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sequel-talk. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/groups/opt_out.
