HSQLDB: Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found:

[chouhan pankaj]

Dear Experts,

I am using HSQLDB in my POC. Following are the details:
Type: HSQL Database Engine Server
Driver: org.hsqldb.jdbcDriver
URL:jdbc:hsqldb:file:ruledb
User:sa
Password:
OS: Windows7
HSQLDB version: 1.7.1
JDK Version: 7

Following is the code snippet, I am using:

private static Connection getConnection(){
		try {
		     Class.forName("org.hsqldb.jdbcDriver" );
		 } catch (Exception e) {
		     System.err.println("ERROR: failed to load HSQLDB JDBC driver.");
		     e.printStackTrace();
		     return null;
		 }

		 try {
			Connection c = DriverManager.getConnection("jdbc:hsqldb:file:ruledb", "sa", "");
			return c;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		 return null;
	}
	
	private static List fetchData(){
		Connection con = DroolsTest.getConnection();
		PreparedStatement stmt;
		String sql = "Select * from public.customer";
		List list = new ArrayList();
		try {
			stmt = con.prepareStatement(sql);
			ResultSet rs = stmt.executeQuery();
			
			list.add(new customer(rs.getString("ID"), rs.getInt("AGE"), rs.getFloat("INCOME"), rs.getString("PROFESSION")));
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}

I am getting following error on statement: stmt = con.prepareStatement(sql);

java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CUSTOMER
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)[]
Press enter in order to run the test again....

	at com.sample.DroolsTest.fetchData(DroolsTest.java:131)
	at com.sample.DroolsTest.runRule(DroolsTest.java:99)
	at com.sample.DroolsTest.main(DroolsTest.java:64)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: CUSTOMER
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SchemaManager.getTable(Unknown Source)
	at org.hsqldb.ParserDQL.readTableName(Unknown Source)
	at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
	at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
	at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
	at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
	at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
	at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
	at org.hsqldb.Session.compileStatement(Unknown Source)
	at org.hsqldb.StatementManager.compile(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 5 more

I request experts to please correct me, where I am going wrong?
Thanks in advance!!!

[Ranchhor Das]

Today I encountered with the same issue.

In my case, I had a catalog attribute defined with @Table in my DB entity class. After removing the catalog it worked perfectly.