java.sql.SQLSyntaxErrorException: Syntax error: Encountered "<EOF>" at line 1, column 31., took 0.032 sec

GitHub | tminglei | 5 months ago
  1. 0

    GitHub comment 966#230934056

    GitHub | 5 months ago | tminglei
    java.sql.SQLSyntaxErrorException: Syntax error: Encountered "<EOF>" at line 1, column 31., took 0.032 sec
  2. 0

    Invalid SQL generated for inner join with limit.

    GitHub | 3 years ago | thesamet
    java.sql.SQLSyntaxErrorException: Column 'X2.title' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or ap pears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'X2.title' is not a column in the target table.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  1. davidvanlaatum 2 times, last 4 weeks ago
  2. davidvanlaatum 1 times, last 1 month ago
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

    Syntax error: Encountered "<EOF>" at line 1, column 31.

    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException()
  2. Derby
    EmbedConnection.prepareStatement
    1. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    2. org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
    3. org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
    4. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    5. org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
    6. org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
    7. org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
    8. org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
    9. org.apache.derby.impl.jdbc.EmbedPreparedStatement.this(Unknown Source)
    10. org.apache.derby.impl.jdbc.EmbedPreparedStatement20.this(Unknown Source)
    11. org.apache.derby.impl.jdbc.EmbedPreparedStatement30.this(Unknown Source)
    12. org.apache.derby.impl.jdbc.EmbedPreparedStatement40.this(Unknown Source)
    13. org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
    14. org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    15. org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    15 frames
  3. slick.jdbc
    JdbcActionComponent$SimpleJdbcProfileAction.run
    1. slick.jdbc.JdbcBackend$SessionDef$class.prepareStatement(JdbcBackend.scala:302)
    2. slick.jdbc.JdbcBackend$BaseSession.prepareStatement(JdbcBackend.scala:414)
    3. slick.jdbc.JdbcBackend$SessionDef$class.withPreparedStatement(JdbcBackend.scala:351)
    4. slick.jdbc.JdbcBackend$BaseSession.withPreparedStatement(JdbcBackend.scala:414)
    5. slick.jdbc.JdbcActionComponent$InsertActionComposerImpl.preparedOther(JdbcActionComponent.scala:500)
    6. slick.jdbc.JdbcActionComponent$InsertActionComposerImpl$InsertOrUpdateAction.emulate(JdbcActionComponent.scala:564)
    7. slick.jdbc.JdbcActionComponent$InsertActionComposerImpl$InsertOrUpdateAction.f$1(JdbcActionComponent.scala:539)
    8. slick.jdbc.JdbcActionComponent$InsertActionComposerImpl$InsertOrUpdateAction.run(JdbcActionComponent.scala:544)
    9. slick.jdbc.JdbcActionComponent$SimpleJdbcProfileAction.run(JdbcActionComponent.scala:31)
    10. slick.jdbc.JdbcActionComponent$SimpleJdbcProfileAction.run(JdbcActionComponent.scala:28)
    10 frames
  4. slick.basic
    BasicBackend$DatabaseDef$$anon$2.run
    1. slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
    2. slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
    2 frames
  5. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames