activejdbc.DBException: java.sql.SQLException: user lacks privilege or object not found: id, Query: INSERT INTO roles (name) VALUES (?), params: USER

hsqldb | evanleonard | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    One prepareStatement method does not support generated keys

    hsqldb | 7 years ago | evanleonard
    activejdbc.DBException: java.sql.SQLException: user lacks privilege or object not found: id, Query: INSERT INTO roles (name) VALUES (?), params: USER

    Root Cause Analysis

    1. activejdbc.DBException

      java.sql.SQLException: user lacks privilege or object not found: id, Query: INSERT INTO roles (name) VALUES (?), params: USER

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      JDBCConnection.prepareStatement
      1. org.hsqldb.jdbc.Util.sqlException(Util.java:215)
      2. org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3945)
      3. org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:2680)
      3 frames