Bugs item #12977, was opened at 2007-08-10 12:08
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=12977&group_id=2014
Category: AR-JDBC
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: DB2 issue using AR-jdbc: DB2 DB2 SQL error: SQLCODE: -401, SQLSTATE:
42818, SQLERRMC: =: SELECT * FROM widgets WHERE (widgets.id = '42')
Initial Comment:
Using DB2 8.1
DB2 Universal JDBC Type 4 driver 8.1
The typing for DB2 BIGINT, SMALLINT, INTEGER an defaults to string type in
AR-jdbc and when you do a list, destroy, show it tries to query using the
following SQL and DB2 cannot do the implicit type conversion from string to int.
widgets.id = '42'
SELECT * FROM widgets WHERE (widgets.id = '42')
----------------------------------------------------------------------
Comment By: Richard Finegan (ruuzo)
Date: 2007-10-11 17:10
Message:
i thought i'd "me too" here in the comments...i'm having the same problem...
i also had another problem, which i got around by editing environment.rb with:
ActiveRecord::Base.connection.execute('set schema myschemaname')
...for whatever reason "schema: myschemaname" from database.yml isn't being
picked up.
----------------------------------------------------------------------
Comment By: Ola Bini (olabini)
Date: 2007-08-11 06:42
Message:
DB2 support isn't as good as it should be. Right now noone actively maintains
it.
----------------------------------------------------------------------
You can respond by visiting:
http://rubyforge.org/tracker/?func=detail&atid=7857&aid=12977&group_id=2014
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
