Sunday, November 29, 2009

data type out of range. JDBC error

data type out of range

You may receive the following error when doing database programming in JAVA


[IBM ][CLI Driver ] CLI0123E SQL data type out of range.
SQLSTATE=HY004

Reason
The JDBC version is back-level (Version 1).

Action to be done
Run usejdbc2.bat to ensure the JDBC upgraded from Version 1 to 2:

Stop the DB2 JDBC Applet Server service.
Run usejdbc2.bat located in SQLLIB\java12 directory (for example, c:\Program Files \sqllib \java12 ).
Restart the DB2 JDBC Applet Server service.

No comments:

Post a Comment