• Post Reply Bookmark Topic Watch Topic
  • New Topic

WAS 4.0.5 DB2 7.2 (NT) connection  RSS feed

Nishu Saim
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I have successfully connected WAS 4.0.5 / WSAD 5.0 with DB 7.2 NT(Fix Pack 9). But after starting the server, I get DB2 error :

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0405N The numeric literal "0" is not valid because its value is out of range. SQLSTATE=42820

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:260)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:197)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:448)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java:1247)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java:786)
at com.ibm.ejs.cm.cache.CachedStatement.executeQuery(CachedStatement.java:301)
at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java:274)
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:47)

This error has started appearing only when i upgraded WAS from 4.0.3 to 4.0.5 and WSAD from 4.0.3 to 5.0

Would appreciate if somebody can help!

It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!