wood burning stoves 2.0*
The moose likes Websphere and the fly likes WAS 4.0.5 DB2 7.2 (NT) connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "WAS 4.0.5 DB2 7.2 (NT) connection" Watch "WAS 4.0.5 DB2 7.2 (NT) connection" New topic

WAS 4.0.5 DB2 7.2 (NT) connection

Nishu Saim

Joined: Oct 26, 2004
Posts: 2

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!

I agree. Here's the link: http://aspose.com/file-tools
subject: WAS 4.0.5 DB2 7.2 (NT) connection