3724152 - jConnect: Temporary tables may not be accessible between separate PreparedStatement objects, leading to Error 208 - SDK for SAP ASE

• In a Java program, the following exception may occur when a temporary table is created and accessed across separate java.sql.PreparedStatement objects.

com.sybase.jdbc42.jdbc.SybSQLException: #test1 not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
        at com.sybase.jdbc42.tds.Tds.processEed(Tds.java:4230)
        at com.sybase.jdbc42.tds.Tds.nextResult(Tds.java:3347)
        at com.sybase.jdbc42.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
        at com.sybase.jdbc42.jdbc.SybStatement.nextResult(SybStatement.java:308)
        at com.sybase.jdbc42.jdbc.SybStatement.nextResult(SybStatement.java:290)
        at com.sybase.jdbc42.jdbc.SybStatement.updateLoop(SybStatement.java:2793)
        at com.sybase.jdbc42.jdbc.SybStatement.executeUpdate(SybStatement.java:2777)
        at com.sybase.jdbc42.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:335)

• SAP Sybase Software Developer Kit (SDK) 15.7
• SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
• jConnect
  • JDBC 7.0
  • JDBC 7.07
  • JDBC 16 ( is version JDBC 7.07 )

Error 208, #208 , KBA , BC-SYB-SDK , SDK , Known Error