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 | 5 months ago
  1. 0

    Hibernate HSQLDB - could not prepare statement

    Stack Overflow | 5 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 | 1 year 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 | 7 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 | 7 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. kjhdofjosvs 2 times, last 7 days ago
  2. marcbouvierdav 1 times, last 2 months ago
  3. andyglick 2 times, last 3 weeks ago
  4. WoodenDoors 67 times, last 8 months ago
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