Symptom
Insert datetime value into an ASE column that has DEFAULT fails with:
com.sybase.jdbc4.jdbc.SybSQLException: Incorrect syntax near ':'.
at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:3507)
at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2938)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:308)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:285)
at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2681)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2667)
at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:565)
at com.sybase.jdbc4.jdbc.SybBCP.getDefaultFunctionValue(SybBCP.java:367)
at com.sybase.jdbc4.jdbc.SybBCP.addResults(SybBCP.java:584)
at com.sybase.jdbc4.jdbc.SybBCP.<init>(SybBCP.java:183)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.prepareBCP(SybPreparedStatement.java:3783)
at com.sybase.jdbc4.jdbc.SybPreparedStatement.<init>(SybPreparedStatement.java:220)
at com.sybase.jdbc4.jdbc.SybConnection.createSybPreparedStatement(SybConnection.java:1821)
at com.sybase.jdbc4.jdbc.SybConnection.prepareStatement(SybConnection.java:1779)
at com.sybase.jdbc4.jdbc.SybConnection.prepareStatement(SybConnection.java:1653)
at com.sybase.jdbc4.jdbc.SybConnection.prepareStatement(SybConnection.java:1613)
at Test.main(Test.java:40)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
- jConnect
- JDBC 7.07
- JDBC 16 ( is version JDBC 7.07 )
- java
Product
Keywords
KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.