DB2 ActiveRecord::JDBCError: [SQL5016]

[queuebit]

I receive this error from rails 3.2, jruby-1.7.16 when I try to perform a .save on a new ActiveRecord::Base model.

ActiveRecord::JDBCError: [SQL5016] Qualified object name SQLPRIMARYKEYS not valid.: SELECT 1 FROM SYSIBM.SQLPRIMARYKEYS WHERE TABLE_NAME = 'MONTHLY_FINANCIAL_INFORMATION'

This query seems to come from lib / arjdbc / db2 / as400.rb.

When I look at the error code in DB2 documentation, it makes it sound like an error with naming. It recommends changing the jdbc driver connection to use system naming, but that causes a different set of errors.

Any ideas? Things I should try? Thanks!

I have been able to get around this error in the past by making a raw SQL insert query against DB2 directly for the initial save action (new record).

[kares]

not really since we do not have anything to test this against, we rely on "outside" commiters ... we're also planning to deprecate the AS400 parts in favor of https://github.com/pierrickrouxel/activerecord-jdbcas400-adapter since we're pretty much playing a dump merger here, maybe ask around @pierrickrouxel

[pierrickrouxel]

As said @kares you can try with the new adapter. If the bug is always present please create a new issue in my repository.

[queuebit]

I wasn't able to get activerecord-jdbcas400-adapter working with our database. I was getting [SQL0804] SQLDA or descriptor area not valid. error. I will just use the SQL insert query for the time being.

Thanks.

[pierrickrouxel]

What is your IBM i version ?

[queuebit]

What is your IBM i version ?

6.1