java.sql.SQLException: \[1\] Unexpected token: 15 in statement \[SELECT LIMIT 15 20 \* FROM testtable\]

hsqldb | nobody | 1 decade ago
  1. 0

    i got problems with LIMIT function

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: \[1\] Unexpected token: 15 in statement \[SELECT LIMIT 15 20 \* FROM testtable\]
  2. 0

    RE: Domain.xml

    jakarta-slide-user | 2 decades ago | Pan, Jiantao
    java.sql.SQLException: Violation of unique index in statement [insert into objects values('/', 0)]
  3. 0

    RE: Domain.xml

    jakarta-slide-user | 2 decades ago | Pan, Jiantao
    java.sql.SQLException: Violation of unique index in statement [insert into objects values('/', 0)]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Fail to restore backup into internal database: Cannot create PoolableConnectionFactory (Unexpected token , requires FROM in statement [select 1])

    YouTrack | 7 years ago
    org.springframework.jdbc.UncategorizedSQLException: Retrieving schema table names; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Cann ot create PoolableConnectionFactory (Unexpected token , requires FROM in statement [select 1]); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unexpected token , requires FROM in statement [select 1])
  6. 0

    Fail to restore backup into internal database: Cannot create PoolableConnectionFactory (Unexpected token , requires FROM in statement [select 1])

    YouTrack | 7 years ago
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unexpected token , requires FROM in statement [select 1])

    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

      \[1\] Unexpected token: 15 in statement \[SELECT LIMIT 15 20 \* FROM testtable\]

      at org.hsql.jdbcResultSet.<init>()
    2. org.hsql
      jdbcStatement.execute
      1. org.hsql.jdbcResultSet.<init>(jdbcResultSet.java:1790)
      2. org.hsql.jdbcConnection.executeStandalone(jdbcConnection.java:617)
      3. org.hsql.jdbcConnection.execute(jdbcConnection.java:527)
      4. org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
      5. org.hsql.jdbcStatement.execute(jdbcStatement.java:267)
      5 frames
    3. classes
      DB.query
      1. classes.DB.query(DB.java:56)
      1 frame
    4. Unknown
      TestDBClass.main
      1. TestDBClass.test(TestDBClass.java:28)
      2. TestDBClass.main(TestDBClass.java:23)
      2 frames