Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: SQLJ data exception

    We use named iterator to retrieve data from the result set. One of our test case is to run the same set of SQLJ statements to add, delete or get data from our database repeatedly for 7 days. When we run this case, we are able to run that same set of SQLJ statements successfully for 34 times. But it always failed on the 35th run of this test case and at the same place, i.e. in looping through the result set. The exception we got is shown below. We examine our database and see no such data in the database. Any idea or suggestion of why we are getting this error?

    Thanks,
    Ling



    [IBM][CLI Driver][DB2/NT] SQL0433N Value "k2Y*+Z ز1h; Y W& 56Ѥ/Oز1h; Y" is too long. SQLSTATE=22001

    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown Source)(Inlined Compiled Code)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(Unknown Source)(Compiled Code)
    at COM.ibm.db2.jdbc.app.DB2ResultSet.next(Unknown Source)(Compiled Code)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJ dbcResultSet.java(Compiled Code))

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by Ling Tai
    We use named iterator to retrieve data from the result set. One of our test case is to run the same set of SQLJ statements to add, delete or get data from our database repeatedly for 7 days. When we run this case, we are able to run that same set of SQLJ statements successfully for 34 times. But it always failed on the 35th run of this test case and at the same place, i.e. in looping through the result set. The exception we got is shown below. We examine our database and see no such data in the database. Any idea or suggestion of why we are getting this error?

    Thanks,
    Ling



    [IBM][CLI Driver][DB2/NT] SQL0433N Value "k2Y*+Z ز1h; Y W& 56Ѥ/Oز1h; Y" is too long. SQLSTATE=22001

    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown Source)(Inlined Compiled Code)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(Unknown Source)(Compiled Code)
    at COM.ibm.db2.jdbc.app.DB2ResultSet.next(Unknown Source)(Compiled Code)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.next(WSJ dbcResultSet.java(Compiled Code))
    What's the statement? Need more info. Calling any functions, built-in or otherwise?
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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