This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi, There is a stored procedure in DB2 which expects Date as its input parameter. The code is deployed in weblogic 8.0 and the driver used is COM.ibm.db2.jdbc.app.DB2Driver (Type 2 ) . Code snippet is as follows
When i run the same piece of code in my local IDE (WSAD) , i get the following error DB2 SQL error: SQLCODE: -301, SQLSTATE: 42895, SQLERRMC: 005;
SQLState 42895 is due to "For static SQL, an input host variable cannot be used, because its data type is not compatible with"
Hence I changed the statement from CS.setString(1, strdate) to CS.setDate(1, java.sql.Date()) and it worked fine. The only difference I could see is that my IDE uses com.ibm.db2.jcc.DB2Driver (Type 4) to connect to the database. Can someone tell me if the problem is due to driver?