SAP Knowledge Base Article - Preview

3155979 - jConnect - ENABLE_BULK_LOAD causes "Incorrect syntax near ':' " SDK for ASE

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

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0

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.