Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002

    Arrow Unanswered: Help - CLI0125E Function sequence error

    Hi Experts,

    I encountered this error in my Java application 3 times over a period
    of 3 days of a performance benchmarking test run. How do I go about
    solving it ? The DB2 documentation is not very helpful in this matter.

    System: IBM Classic 1.3.0 JVM, AIX, DB2 7.1 with FP3.

    SQLState: HY010; Vendor: -99999; Message: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
    at java.sql.SQLException.<init>(
    at<init>(DB2Exception. java:71)
    at QLException(
    at eturn_code( Code))
    at eturn_code( Code))
    at Code))
    ....... (remaining stack trace snipped).......

    The piece of code that caused the problem is approximated below. This
    code is called thousands of times, but failed only 3 times. The stack
    trace indicates that the part of the code threw the error.

    ------begin code snippet------

    PreparedStatement pstmtClick = null;
    ResultSet rs = null;
    try {
    pstmtClick = PSPool.getInstance().getPSFC(); // get from pool
    pstmtClick.setLong(..... // some set statements

    rs = pstmtClick.executeQuery();
    return( && rs.getInt(1) == 0);
    } finally {
    if (pstmtClick != null)
    PSPool.getInstance().releasePSFC(pstmtClick); // release into pool

    ------------end of code snippet------

    Comments appreciated. Let me know if you need more info about the DB2 server parameters, etc.


    - Silver

  2. #2
    Join Date
    Apr 2003


    As far as i see this Problem

    This is a ResultSet Problem. When the coming data type does not match with the accessing data type .
    For e.g.

    Table :
    Name String
    when u r accessing this may be using rs.getInt()

Posting Permissions

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