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.
