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

    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 4.3.3.10, DB2 7.1 with FP3.

    SQLState: HY010; Vendor: -99999; Message: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
    at java.sql.SQLException.<init>(SQLException.java:45)
    at COM.ibm.db2.jdbc.DB2Exception.<init>(DB2Exception. java:71)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java:260)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java(Compiled Code))
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java(Compiled Code))
    at COM.ibm.db2.jdbc.app.DB2ResultSet.next(DB2ResultSe t.java(Compiled 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 rs.next() 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.next() && rs.getInt(1) == 0);
    } finally {
    if (pstmtClick != null)
    PSPool.getInstance().releasePSFC(pstmtClick); // release into pool
    rs.close();
    }

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

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

    Thanks.

    - Silver

  2. #2
    Join Date
    Apr 2003
    Posts
    3

    Lightbulb

    Hi
    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
  •