File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Type 2 and Type 4 Drivers for DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Type 2 and Type 4 Drivers for DB2" Watch "Type 2 and Type 4 Drivers for DB2" New topic
Author

Type 2 and Type 4 Drivers for DB2

Vinu krish
Greenhorn

Joined: Nov 20, 2003
Posts: 16
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

CallableStatement CS = conn.prepareCall(SQL(?));
String strdate = "2005-01-01";
CS.setString(1, strdate)
CS.execute();

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?

Thanks,
Vinu
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30123
    
150

Vinu,
The format of dates is very database and driver specific. So it is perfectly believe that the driver is the difference. Note that it is better practice to use setDate() anyway.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Type 2 and Type 4 Drivers for DB2
 
Similar Threads
2 phase commit
CLI0112E Error in assignment. SQLSTATE=22005
Oracle wrong number or types of arguments...
DB2 StaleConnectionException
Passing parameter to date function in DB2