This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Large Binary Objects

 
Praveen Dharmavaram
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I was using the following code to call the stored procedure. one of the parameters of the stored procedures accepts BINARY data. The BINARY data could go upto 145290 Bytes. This was working fine in WAS 3.5.7 where i was using the JDBC 1.0 Connection pooling. But as i migrated to WAS 5.0.2 I have been forced to use JDBC 2.0 and port my application to J2EE 1.3. I can no longer pass the BINARY data. I tried registering the parameters as VARBINARY, LONGVARBINARY, BLOB and CLOB to acheive the desired result.
When i use VARBINARY or LONGVARBINARY, i get a CLI0102E Invalid Conversion.SQLSTATE=07006 .
When i use BLOB or CLOB, i get an CLI0613E Program Type out of range.SQLSTATE=S1003.
Can some one please help me out.
Thanks
Praveen
 
Joe Ess
Bartender
Pie
Posts: 9258
10
Linux Mac OS X Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Other relevant information regarding Praveen's problem can be found in this thread
 
Praveen Dharmavaram
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Joe..That was me who posted the same question earlier. As was in the post i did not get it resolved with the IBM support. I am curious to know if anyone else is facing the same problem.
Thanks
Praveen
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic