java.lang.Error: java.sql.SQLException: error in script file line: 102 C:\data\hsqldb\test.db user lacks privilege or object not found: C1

hsqldb | lukaseder | 1 year ago
  1. 0

    Illegal SQL is persisted for table valued function

    hsqldb | 1 year ago | lukaseder
    java.lang.Error: java.sql.SQLException: error in script file line: 102 C:\data\hsqldb\test.db user lacks privilege or object not found: C1
  2. 0

    HSQLDB problem

    java-forums.org | 4 months ago
    java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@a4d71f6d[file =C:\Users\Jansu\workspace\poker\db\db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2010-12-22 14:57:53 heartbeat - read: -2700 ms.
  3. 0

    Database lock acquisition failure and hsqldb

    Stack Overflow | 6 years ago | markjason72
    java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@f3811c1a[file =C:\myhsql\db\sjdb.lc k, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2010-10-19 12:46:09 heartbeat - read: -6750 ms.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    iText - Invalid schema name executing filmfestival.script

    nabble.com | 1 year ago
    java.sql.SQLException: error in script file line: 2 invalid schema name: SYSTEM_SCHEMA in statement [CREATE MEMORY TABLE FILM_MOVIETITLE(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR_IGNORECASE(120) NOT NULL,ORIGINAL_TITLE VARCHAR_IGNORECASE(120) DEFAULT NULL,IMDB VARCHAR_IGNORECASE(7) NOT NULL,YEAR INTEGER NOT NULL,DURATION INTEGER NOT NULL)]
  6. 0

    iText - problem in Chapter 2:DatabaseTest.java

    nabble.com | 1 year ago
    java.sql.SQLException: error in script file line: 2 invalid schema name: SYSTEM_SCHEMA in statement [CREATE MEMORY TABLE FILM_MOVIETITLE(ID INTEGER NOT NULL PRIMARY KEY,TITLE VARCHAR_IGNORECASE(120) NOT NULL,ORIGINAL_TITLE VARCHAR_IGNORECASE(120) DEFAULT NULL,IMDB VARCHAR_IGNORECASE(7) NOT NULL,YEAR INTEGER NOT NULL,DURATION INTEGER NOT NULL)]

  1. andyglick 2 times, last 4 weeks ago
  2. kjhdofjosvs 1 times, last 1 week ago
  3. marcbouvierdav 1 times, last 2 months 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: C1

    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
    JDBCDriver.connect
    1. org.hsqldb.ExpressionColumn.checkColumnsResolved(Unknown Source)
    2. org.hsqldb.ParserRoutine.resolveOuterReferencesAndTypes(Unknown Source)
    3. org.hsqldb.ParserRoutine.resolveOuterReferencesAndTypes(Unknown Source)
    4. org.hsqldb.ParserRoutine.compileReturnValue(Unknown Source)
    5. org.hsqldb.ParserRoutine.compileSQLProcedureStatementOrNull(Unknown Source)
    6. org.hsqldb.ParserRoutine.compileSQLProcedureStatementList(Unknown Source)
    7. org.hsqldb.ParserRoutine.compileCompoundStatement(Unknown Source)
    8. org.hsqldb.ParserRoutine.compileSQLProcedureStatementOrNull(Unknown Source)
    9. org.hsqldb.ParserRoutine.readRoutineSQLBody(Unknown Source)
    10. org.hsqldb.ParserRoutine.readRoutineBody(Unknown Source)
    11. org.hsqldb.ParserRoutine.readCreateProcedureOrFunction(Unknown Source)
    12. org.hsqldb.ParserRoutine.compileCreateProcedureOrFunction(Unknown Source)
    13. org.hsqldb.ParserDDL.compileCreate(Unknown Source)
    14. org.hsqldb.ParserCommand.compilePart(Unknown Source)
    15. org.hsqldb.ParserCommand.compileStatement(Unknown Source)
    16. org.hsqldb.Session.compileStatement(Unknown Source)
    17. org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source)
    18. org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
    19. org.hsqldb.persist.Log.processScript(Unknown Source)
    20. org.hsqldb.persist.Log.open(Unknown Source)
    21. org.hsqldb.persist.Logger.open(Unknown Source)
    22. org.hsqldb.Database.reopen(Unknown Source)
    23. org.hsqldb.Database.open(Unknown Source)
    24. org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
    25. org.hsqldb.DatabaseManager.newSession(Unknown Source)
    26. org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
    27. org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
    28. org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
    28 frames
  4. org.jooq.test
    jOOQAbstractTest.setUp
    1. org.jooq.test.jOOQAbstractTest.getConnection1(jOOQAbstractTest.java:1026)
    2. org.jooq.test.jOOQAbstractTest.getConnection0(jOOQAbstractTest.java:969)
    3. org.jooq.test.jOOQAbstractTest.getConnection(jOOQAbstractTest.java:754)
    4. org.jooq.test.jOOQAbstractTest.setUp(jOOQAbstractTest.java:578)
    4 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:497)
    4 frames
  6. JUnit
    ParentRunner.run
    1. org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
    2. org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    3. org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
    4. org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
    5. org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    6. org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
    7. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
    8. org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
    9. org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
    10. org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
    11. org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
    12. org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
    13. org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
    14. org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    15. org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    16. org.junit.runners.ParentRunner.run(ParentRunner.java:309)
    16 frames
  7. JUnit4 Runner
    JUnit4TestReference.run
    1. org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
    1 frame
  8. JUnit3 Runner
    RemoteTestRunner.main
    1. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    2. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)
    3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)
    4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)
    5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)
    5 frames