Bugs item #12977, was opened at 2007-08-10 21: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: Ola Bini (olabini)
Date: 2007-08-11 15: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

Reply via email to