java.io.IOException: org.hsqldb.HsqlException: user lacks privilege or object not found: MY\_TABLE

hsqldb | jcpalmer | 6 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

    Privledge problems after crash

    hsqldb | 6 years ago | jcpalmer
    java.io.IOException: org.hsqldb.HsqlException: user lacks privilege or object not found: MY\_TABLE
  2. 0

    Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

    apache.org | 1 year ago
    java.io.IOException: Invalid metadata version. >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) >> >> at >> org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) >> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> >> 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: >> Exception in thread "main" java.lang.NoSuchMethodError: >> org/hsqldb/DatabaseURL. >> parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; >> at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) >> at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) >> at java.sql.DriverManager.getConnection(DriverManager.java:419) >> at java.sql.DriverManager.getConnection(DriverManager.java:467) >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) >> at >> org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) >> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> >> >> 2013/11/19 sam liu <liuqiyun2011@gmail.com> >> Hi Experts, My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) agains hadoop-2.1.0-beta: 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: Exception in thread "main" java.lang.NoSuchMethodError: org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
  3. 0

    Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

    sqoop-user | 3 years ago | sam liu
    java.io.IOException: Invalid metadata version. > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) > > at > org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) > at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: > Exception in thread "main" java.lang.NoSuchMethodError: > org/hsqldb/DatabaseURL. > parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) > at java.sql.DriverManager.getConnection(DriverManager.java:419) > at java.sql.DriverManager.getConnection(DriverManager.java:467) > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) > at > org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) > at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > > 2013/11/19 sam liu <liuqiyun2011@gmail.com> > Hi Experts, My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) agains hadoop-2.1.0-beta: 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: Exception in thread "main" java.lang.NoSuchMethodError: org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

    sqoop-user | 3 years ago | sam liu
    java.io.IOException: Invalid metadata version. >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) >> >> at >> org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) >> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> >> 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: >> Exception in thread "main" java.lang.NoSuchMethodError: >> org/hsqldb/DatabaseURL. >> parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; >> at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) >> at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) >> at java.sql.DriverManager.getConnection(DriverManager.java:419) >> at java.sql.DriverManager.getConnection(DriverManager.java:467) >> at >> org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) >> at >> org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) >> at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> >> >> 2013/11/19 sam liu <liuqiyun2011@gmail.com> >> Hi Experts, My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) agains hadoop-2.1.0-beta: 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: Exception in thread "main" java.lang.NoSuchMethodError: org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
  6. 0

    Re: Failed to use sqoop-1.4.3 job tool on hadoop-2.1.0-beta

    sqoop-user | 3 years ago | sam liu
    java.io.IOException: Invalid metadata version. > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:202) > > at > org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) > at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > 2) If I use hsqldb-1.8.0.10.jar in my env, the exception will be: > Exception in thread "main" java.lang.NoSuchMethodError: > org/hsqldb/DatabaseURL. > parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties; > at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source) > at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source) > at java.sql.DriverManager.getConnection(DriverManager.java:419) > at java.sql.DriverManager.getConnection(DriverManager.java:467) > at > org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:176) > at > org.apache.sqoop.metastore.hsqldb.AutoHsqldbStorage.open(AutoHsqldbStorage.java:112) > at org.apache.sqoop.tool.JobTool.run(JobTool.java:274) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > > > > 2013/11/19 sam liu <liuqiyun2011@gmail.com> > Hi Experts, My cluster is hadoop-2.1.0-beta and it requires hsqldb-2.0.0.jar. At the same time, my sqoop is 1.4.3, and it requires hsqldb-1.8.0.10.jar. Now I failed to run sqoop-1.4.3 job tool($SQOOP_HOME/bin/sqoop job --list) agains hadoop-2.1.0-beta: 1) If I use hsqldb-2.0.0.jar in my env, the exception will be: Exception in thread "main" java.lang.NoSuchMethodError: org/hsqldb/DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;

    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. java.io.IOException

      org.hsqldb.HsqlException: user lacks privilege or object not found: MY\_TABLE

      at org.hsqldb.lib.java.JavaSystem.toIOException()
    2. HSQLDB
      JDBCDriver.connect
      1. org.hsqldb.lib.java.JavaSystem.toIOException(JavaSystem.java:77)
      2. org.hsqldb.scriptio.ScriptReaderText.processStatement(ScriptReaderText.java:295)
      3. org.hsqldb.scriptio.ScriptReaderText.readLoggedStatement(ScriptReaderText.java:225)
      4. org.hsqldb.persist.ScriptRunner.runScript(ScriptRunner.java:137)
      5. org.hsqldb.persist.ScriptRunner.runScript(ScriptRunner.java:118)
      6. org.hsqldb.persist.Log.processLog(Log.java:792)
      7. org.hsqldb.persist.Log.open(Log.java:133)
      8. org.hsqldb.persist.Logger.openPersistence(Logger.java:289)
      9. org.hsqldb.Database.reopen(Database.java:220)
      10. org.hsqldb.Database.open(Database.java:186)
      11. org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:240)
      12. org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:157)
      13. org.hsqldb.jdbc.JDBCConnection.<init>(JDBCConnection.java:3281)
      14. org.hsqldb.jdbc.JDBCDriver.getConnection(JDBCDriver.java:321)
      15. org.hsqldb.jdbc.JDBCDriver.connect(JDBCDriver.java:259)
      15 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(Unknown Source)
      2. java.sql.DriverManager.getConnection(Unknown Source)
      2 frames