SAP Knowledge Base Article - Preview

2439651 - JAVA Arithmetic overflow using cursor and streamlined dynamic sql - SAP ASE


Using a cursor, streamlined dynamic sql, and statement cache query gives error:
com.sybase.jdbc4.jdbc.SybSQLException: Arithmetic overflow during implicit conversion of NUMERIC value '10' to a NUMERIC field .
       at com.sybase.jdbc4.tds.Tds.processEed(
       at com.sybase.jdbc4.tds.Tds.nextResult(
       at com.sybase.jdbc4.tds.Tds.getResultSetResult(
       at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(
       at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(
       at Test.main(



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


SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7


java, jdbc, jconn4.jar,jdbc, jconn4, cursor, error, break, fail, prepared statement, dynamic prepare, big decimal, double, float, literal params, performance, lwp, 806224, CR#806224, CR 806224 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.