org.hsqldb.cmdline.SqlToolError

Failed to get metadata for query by using: "SELECT field1field2field3field4 FROM temp_tbl WHERE 1 = 2"

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web4

  • via hsqldb by tokajac
    , 1 year ago
    Failed to get metadata for query by using: "SELECT field1field2field3field4 FROM temp_tbl WHERE 1 = 2"
  • Failed to get metadata for query by using: "SELECT field1field2field3field4 FROM temp_tbl WHERE 1 = 2"
  • Stack trace

    • org.hsqldb.cmdline.SqlToolError: Failed to get metadata for query by using: "SELECT field1field2field3field4 FROM temp_tbl WHERE 1 = 2" at org.hsqldb.cmdline.SqlFile.importDsv(Unknown Source) at org.hsqldb.cmdline.SqlFile.processSpecial(Unknown Source) at org.hsqldb.cmdline.SqlFile.scanpass(Unknown Source) at org.hsqldb.cmdline.SqlFile.execute(Unknown Source) at test.features.DSVImportSample.main(DSVImportSample.java:29) Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: FIELD1FIELD2FIELD3FIELD4 at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source) ... 5 more Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: FIELD1FIELD2FIELD3FIELD4 at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source) at org.hsqldb.QueryExpression.resolve(Unknown Source) at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source) at org.hsqldb.ParserCommand.compilePart(Unknown Source) at org.hsqldb.ParserCommand.compileStatements(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 7 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 11 months ago
    4 times, 1 month ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    92 more bugmates