If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > CLI0613E error in setObject for Blob

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-16-04, 15:14
preetim preetim is offline
Registered User
 
Join Date: Jun 2003
Posts: 77
CLI0613E error in setObject for Blob

Hi,

I dont know if its the right forum to post this problem.
Its a java + db2 problem.

My application is giving a CLI0613 error in setObject for a BLOB type object.
Environment is - DB2v 7.2, Java2, windows 2000 server.
The error log is -

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0613E Program type out of range. SQLSTATE=S1003
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.pstmtEx ception(SQLExceptionGenerator.java:612)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.setNull( DB2PreparedStatement.java:1297)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.setObjec t(DB2PreparedStatement.java:2133)
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.setObjec t(DB2PreparedStatement.java:2095)

The object type in setObject is java Blob.

Thanks a lot ,
-Preeti
Reply With Quote
  #2 (permalink)  
Old 12-16-04, 16:51
n_i n_i is online now
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
CLI0613E Program type out of range.

Explanation:

The object given in the PreparedStatement/CallableStatement
setObject is not a valid object type.

User Response:

Make sure the object to be set is one of the object types allowed
in setObject (see JDBC specification).
...........................
Reply With Quote
  #3 (permalink)  
Old 12-20-04, 13:42
preetim preetim is offline
Registered User
 
Join Date: Jun 2003
Posts: 77
Thanks for your response. I'm still trying to fix it.

I found that the same code runs fine on other servers. Even on the same database(when transferred to other server). This problem is coming only on one server.

So, it looks like there is some problem with that one server's JDBC driver or some other configuration settings due to which it is failing in setObject for an object of type java.sql.Blob.

All servers are using JDBC 2 drivers.

Please let me know if you've any idea on what may be wrong.

-Preeti
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On