Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    77

    Unanswered: 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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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).
    ...........................

  3. #3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •