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.
The moose likes JDBC and Relational Databases and the fly likes DB2 Type 2 Vs Type 4 Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "DB2 Type 2 Vs Type 4 Driver" Watch "DB2 Type 2 Vs Type 4 Driver" New topic
Author

DB2 Type 2 Vs Type 4 Driver

amod gole
Ranch Hand

Joined: Dec 07, 2005
Posts: 83
Hello All,

I have one application in which I am calling one procedure from DB2 database and I am entering some record into one of my table.

Now Problem is what when I am using DB2 Type 4 driver with driver manager it work fine but when same code I am using along with Type 2 driver and datasource it throws an exception saying

SQLExceptionCOM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][AS] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001

Please let me know If any one is having any idea or solution regarding this.

Thanks In Advance,
AMod
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB2 Type 2 Vs Type 4 Driver
 
It's not a secret anymore!