org.hsqldb.cmdline.SqlToolError

Failed to get metadata for query by using: "SELECT field1, field2, field, field4 FROM temp_tbl WHERE 1 = 2"

Samebug tips0

We couldn't find tips for this exception.

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

Solutions on the web408

  • via hsqldb by tokajac
    ,
  • via Unknown by Unknown author,
  • Stack trace

    • org.hsqldb.cmdline.SqlToolError: Failed to get metadata for query by using: "SELECT field1, field2, field, field4 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: FIELD 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: FIELD 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 visitor
    Unknown visitorOnce,
    Unknown UserUnknown User
    4 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    92 more bugmates