permaculture playing cards*
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
Similar Threads
how to connect to db2 using type4 drivers
how to connect to db2 using type4 drivers
Db2 invalid column name error
Exceptions while working with Type 4; No exception with working with Type 2 driver
Connection pool problem in WLS81SP4