java.sql.SQLException: Incorrect syntax near the keyword 'function'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150) at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:687) at net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:849) at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1062) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:520) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:396) at com.loudeye.tools.ant.tasks.sql.SQLStatement.exec(SQLStatement.java:137) at com.loudeye.tools.ant.tasks.UpdateSchemaTask.execute(UpdateSchemaTask.java:116) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)

jtds | jdidion | 1 decade ago
  1. 0

    Error parsing CREATE FUNCTION statement

    jtds | 1 decade ago | jdidion
    java.sql.SQLException: Incorrect syntax near the keyword 'function'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150) at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:687) at net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:849) at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1062) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:520) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:396) at com.loudeye.tools.ant.tasks.sql.SQLStatement.exec(SQLStatement.java:137) at com.loudeye.tools.ant.tasks.UpdateSchemaTask.execute(UpdateSchemaTask.java:116) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
  2. 0

    Ant tasks

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: No suitable driver [schematool] at java.sql.DriverManager.getConnection(DriverManager.java:532) [schematool] at java.sql.DriverManager.getConnection(DriverManager.java:171) [schematool] at com.solarmetric.kodo.impl.jdbc.datasource.ConnectionImpl.connect(ConnectionI mpl.java:222) [schematool] at com.solarmetric.kodo.impl.jdbc.datasource.ConnectionImpl.<init>(ConnectionIm pl.java:56) [schematool] at com.solarmetric.kodo.impl.jdbc.datasource.ConnectionImpl.<init>(ConnectionIm pl.java:45) [schematool] at com.solarmetric.kodo.impl.jdbc.schema.SchemaTool.<init>(SchemaTool.java:68) [schematool] at com.solarmetric.kodo.impl.jdbc.schema.SchemaTool.main(SchemaTool.java:1234) [schematool] at com.solarmetric.modules.integration.ant.SchemaToolTask.executeOn(SchemaToolT ask.java:46) [schematool] at com.solarmetric.modules.integration.ant.TaskBase.execute(TaskBase.java:115) [schematool] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:166) [schematool]
  3. 0

    Connection.close() can take a long time when Sybase down

    jtds | 1 decade ago | gward
    java.sql.SQLException: Invalid state, the Connection object is closed. at net.sourceforge.jtds.jdbc.TdsCore.checkOpen(TdsCore.java:424) at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:685) at net.sourceforge.jtds.jdbc.TdsCore.close(TdsCore.java:808) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.close(ConnectionJDBC2.java:1467)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can't use Content or Row Count tab (with MSSQL 2000 SP1)

    squirrel-sql | 1 decade ago | jimisola
    java.sql.SQLException: Line 1: Incorrect syntax near '-'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2217) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:1696) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:522) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:274) at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:940) at net.sourceforge.squirrel\_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab.createDataSet(ContentsTab.java:301) at net.sourceforge.squirrel\_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:123) at net.sourceforge.squirrel\_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
  6. 0

    SQuirreL SQL Client / Mailing Lists

    sourceforge.net | 1 year ago
    java.sql.SQLException: Line 1: Incorrect syntax near '-'. at = net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:= 365) at = net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at = net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at = net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at = net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.jav= a:418) at = net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1= 258) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.tab= le.ContentsTab.createDataSet(ContentsTab.java:325) at = net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.Bas= eDataSetTab$1.run(BaseDataSetTab.java:123) at = net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:8= 2)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Incorrect syntax near the keyword 'function'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2708) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2150) at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:687) at net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:849) at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1062) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:520) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:396) at com.loudeye.tools.ant.tasks.sql.SQLStatement.exec(SQLStatement.java:137) at com.loudeye.tools.ant.tasks.UpdateSchemaTask.execute(UpdateSchemaTask.java:116) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)

      at org.apache.tools.ant.Task.perform()
    2. Ant
      Task.perform
      1. org.apache.tools.ant.Task.perform(Task.java:364)
      1 frame