java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USERS in statement [insert into Users (id, avatar, email, login, password) values (default, ?, ?, ?, ?)]

Stack Overflow | jodekpotasu | 9 months 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

    Hibernate HSQLDB - could not prepare statement

    Stack Overflow | 9 months ago | jodekpotasu
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USERS in statement [insert into Users (id, avatar, email, login, password) values (default, ?, ?, ?, ?)]
  2. 0

    HA-JDBC / Discussion / Open Discussion:Configure HA-JDBC to use/replace Tomcat 7.0.35 JDBC pooling

    sourceforge.net | 2 years ago
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USERS Error Code: -5501 Call: UPDATE USERS SET LAST_LOGIN_DT = ?, LAST_LOGOUT_DT = ? WHERE (USER_NAME = ?) bind => Query: UpdateObjectQuery(jpa.entities.Users )
  3. 0

    Configure HA-JDBC to use/replace Tomcat 7.0.35 JDBC pooling

    ha-jdbc | 4 years ago | smithh032772
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USERS Error Code: -5501 Call: UPDATE USERS SET LAST_LOGIN_DT = ?, LAST_LOGOUT_DT = ? WHERE (USER_NAME = ?) bind => [3 parameters bound] Query: UpdateObjectQuery(jpa.entities.Users[ userName=administrator ])
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HA-JDBC / Discussion / Open Discussion:Configure HA-JDBC to use/replace Tomcat 7.0.35 JDBC pooling

    sourceforge.net | 11 months ago
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USERS Error Code: -5501 Call: UPDATE USERS SET LAST_LOGIN_DT = ?, LAST_LOGOUT_DT = ? WHERE (USER_NAME = ?) bind => Query: UpdateObjectQuery(jpa.entities.Users )
  6. 0

    JDBC sink: can't insert data

    GitHub | 12 months ago | nurgasemetey
    org.springframework.messaging.MessageHandlingException: error occurred in message handler [jdbcMessageHandler]; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO names(name) VALUES (?)]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: NAMES

  1. Axelo 12 times, last 4 weeks ago
  2. kjhdofjosvs 2 times, last 5 months ago
  3. marcbouvierdav 1 times, last 6 months ago
  4. jpvee 4 times, last 4 months ago
  5. andyglick 2 times, last 5 months ago
1 more registered users
87 unregistered visitors
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. org.hsqldb.HsqlException

    user lacks privilege or object not found: USERS

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)
    2. org.hsqldb.error.Error.error(Unknown Source)
    2 frames
  3. HSQLDB
    JDBCConnection.prepareStatement
    1. org.hsqldb.ParserDQL.readTableName(Unknown Source)
    2. org.hsqldb.ParserDQL.readRangeVariableForDataChange(Unknown Source)
    3. org.hsqldb.ParserDML.compileInsertStatement(Unknown Source)
    4. org.hsqldb.ParserCommand.compilePart(Unknown Source)
    5. org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    6. org.hsqldb.Session.compileStatement(Unknown Source)
    7. org.hsqldb.StatementManager.compile(Unknown Source)
    8. org.hsqldb.Session.execute(Unknown Source)
    9. org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
    10. org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    10 frames
  4. Hibernate
    SessionImpl.save
    1. org.hibernate.engine.jdbc.internal.StatementPreparerImpl$2.doPrepare(StatementPreparerImpl.java:124)
    2. org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186)
    3. org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:122)
    4. org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.prepare(IdentityGenerator.java:89)
    5. org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:55)
    6. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)
    7. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)
    8. org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)
    9. org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:492)
    10. org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:197)
    11. org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:181)
    12. org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:216)
    13. org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:334)
    14. org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:289)
    15. org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195)
    16. org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
    17. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:209)
    18. org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
    19. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:194)
    20. org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
    21. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
    22. org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:715)
    23. org.hibernate.internal.SessionImpl.save(SessionImpl.java:707)
    24. org.hibernate.internal.SessionImpl.save(SessionImpl.java:702)
    24 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  6. Hibernate
    ThreadLocalSessionContext$TransactionProtectionWrapper.invoke
    1. org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:356)
    1 frame
  7. com.sun.proxy
    $Proxy8.save
    1. com.sun.proxy.$Proxy8.save(Unknown Source)
    1 frame
  8. com.serwis
    TEST.main
    1. com.serwis.TEST.main(TEST.java:33)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  10. IDEA
    AppMain.main
    1. com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
    1 frame