java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Re: CreateIfNoSchemaStrategy not as I expected
    via by Tomas Stenlund,
  • Re: CreateIfNoSchemaStrategy not as I expected
    via by Andrus Adamchik,
  • WARN 2009-06-04 12:05:04,804 (net.sf.taverna.t2.provenance.lineageservice.EventProcessor:678) - Patch top level inputs problem for provenance: java.sql.SQLException: Syntax error: Encountered "order" at line 1, column 276. java.sql.SQLException: Syntax error: Encountered "order" at line 1, column 216. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at net.sf.taverna.t2.provenance.lineageservice.ProvenanceQuery.getVars(ProvenanceQuery.java:152) at net.sf.taverna.t2.provenance.lineageservice.ProvenanceQuery.getOutputVars(ProvenanceQuery.java:322) at net.sf.taverna.t2.provenance.lineageservice.EventProcessor.reconcileTopLevelOutputs(EventProcessor.java:722) at net.sf.taverna.t2.provenance.lineageservice.EventProcessor.processProcessEvent(EventProcessor.java:599) at net.sf.taverna.t2.provenance.lineageservice.Provenance.processEvent(Provenance.java:192) at net.sf.taverna.t2.provenance.lineageservice.Provenance.acceptRawProvenanceEvent(Provenance.java:133) at net.sf.taverna.t2.provenance.connector.DerbyProvenanceConnector$1.run(DerbyProvenanceConnector.java:292) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:613) Caused by: ERROR 42X01: Syntax error: Encountered "order" at line 1, column 216. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 12 more
    via by Alan Williams,
  • Given the attached workflow and the input my_id, the following exception is shown to the user when clicking on iANautoSNP Could not retrieve intermediate results: java.sql.SQLException: SQL text pointer is null The stack trace: java.sql.SQLException: Syntax error: Encountered "order" at line 1, column 236. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at net.sf.taverna.t2.provenance.lineageservice.ProvenanceQuery.getVars(ProvenanceQuery.java:152) at net.sf.taverna.t2.provenance.lineageservice.EventProcessor.processInput(EventProcessor.java:1022) at net.sf.taverna.t2.provenance.lineageservice.EventProcessor.processProcessEvent(EventProcessor.java:576) at net.sf.taverna.t2.provenance.lineageservice.Provenance.processEvent(Provenance.java:192) at net.sf.taverna.t2.provenance.lineageservice.Provenance.acceptRawProvenanceEvent(Provenance.java:133) at net.sf.taverna.t2.provenance.connector.DerbyProvenanceConnector$1.run(DerbyProvenanceConnector.java:292) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675) at java.lang.Thread.run(Thread.java:613) Caused by: ERROR 42X01: Syntax error: Encountered "order" at line 1, column 236. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ... 11 more
    via by Alan Williams,
  • CreateIfNoSchemaStrategy not as I expected
    via by Tomas Stenlund,
    • java.sql.SQLException: Java exception: 'ASSERT FAILED transaction table has null entry: org.apache.derby.shared.common.sanity.AssertFailure'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45) at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87) at org.apache.derby.impl.jdbc.Util.javaException(Util.java:244) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:403) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2183) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1325) at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:625)

    Users with the same issue

    jf-astjf-ast
    1 times, last one,
    stigkjstigkj
    1 times, last one,
    andyglickandyglick
    1 times, last one,
    davidvanlaatumdavidvanlaatum
    1 times, last one,
    muffinmannenmuffinmannen
    81 times, last one,
    1 more bugmates