Database Software

Hi,

We have been getting a Function Sequence error within Application code which is intermittent. Issue has been observed when at scale test which results in frequent reads into TimesTen

Stack Trace:
java.sql.SQLException: [TimesTen][TimesTen 7.0.5.0.0 ODBC Driver]Function sequence error
com.timesten.jdbc.JdbcOdbc.createSQLException(JdbcOdbc.java:3184)
com.timesten.jdbc.JdbcOdbc.standardError(JdbcOdbc.java:3318)
com.timesten.jdbc.JdbcOdbc.SQLFetch(JdbcOdbc.java:844)
com.timesten.jdbc.JdbcOdbcResultSet.next(JdbcOdbcResultSet.java:372)

The application is a multithreaded service.

All over the application code, Connection is retrieved from a singleton class

ttConn = Utils.INSTANCE.getTTConn();

----------------------

........
import com.timesten.jdbc.TimesTenDataSource;
........
private final TimesTenDataSource ds = new TimesTenDataSource();
........
     public Connection getTTConn() {
        try {
            if ((ttConn == null) || (ttConn.isClosed()))  {
            
                ttConn = ds.getConnection();
            }

        } catch (SQLException ex) {
                SoapServiceLogger.severe("Failed to get TT Connection");
                SoapServiceLogger.severe(ex);
        }

        return ttConn;
    }
........

Whats the likely cause of the issue & is there any best practices suggested to avoid the occurrence of the issue?

Thanks,
Jose

Edited by: 878519 on Aug 10, 2011 4:09 AM