Bugs item #12977, was opened at 2007-08-10 15: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') ---------------------------------------------------------------------- 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
