2439651 - JAVA Arithmetic overflow using cursor and streamlined dynamic sql - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

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(Tds.java:4119)
       at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3235)
       at com.sybase.jdbc4.tds.Tds.getResultSetResult(Tds.java:3981)
       at com.sybase.jdbc4.tds.TdsCursor.open(TdsCursor.java:333)
       at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2605)
       at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:274)
       at Test.main(Test.java:35)


Read more...

Environment

  • 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

Product

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

Keywords

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.