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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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

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 [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,
I agree. Here's the link:
subject: DB2 Type 2 Vs Type 4 Driver
jQuery in Action, 3rd edition