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 Problem with the JDBC driver. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem with the JDBC driver." Watch "Problem with the JDBC driver." New topic
Author

Problem with the JDBC driver.

Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
Has anyone ever tried sending a BINARY data of about 145k to the database and succeed. I am using JDBC 2.0 Connection pooling and when i try to send a data bigger than 32K i get an CLI0102E Invalid conversion SQLSTATE-07006.
Here is the code i used.Any thoughts.
I register the parameter as
callStmt.registerOutParameter(2, Types.LONGVARBINARY);
//where b is bytes of length 145K
callStmt.setObject(2, b, Types.LONGVARBINARY);

Thanks
Praveen
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8836
    
    7

When you say "the database", what brand database in particular are you speaking of? I've used BLOB's on MySql just fine. What JDBC driver are you using?


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
I use a db2(7.2.10) DB and client. and i get a connection using DB2 Connection pooling (COM.ibm.db2.jdbc.*).
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8836
    
    7

I don't have any experience with db2. What are you declaring the database column as? In MySql there's several TEXT and BLOB fields of differing storage capacity.
Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
well..i declare it as a BLOB. This was working when i was using JDBC 1.0 Driver. But when we upgraded to DB2(FP10) and started using the JDBC 2.0 it stopped working and gives the error mentioned earlier.
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8836
    
    7

Well, browsing around the DB2 support site I see that this is indeed a defect with DB2, but it looks like there is a fix:
HERE
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8836
    
    7

I lied. That link just had all the keywords on it. It does not appear to be the error you are reporting. I can't think of anything else. Check out that DB2 support site. Hopefully someone with DB2 experience will see this thread.
Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
thanks for the info. I already have a PMR open with IBM in this regard and was wondering if I was the only one facing this problem.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem with the JDBC driver.
 
Similar Threads
Hibernate and Jdbc
why we need javabeans?
MS SQL Server 7 driver
JDBC book suggestions
Microsoft Access Craziness