java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: EMPLOYEE

[Vinod Vijay]

Hi, I'm trying to connect my java program with HSQLDB. I'm getting following error:-

Connection established!!!
111
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: EMPLOYEE
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
	at dbConnect.HSQLDbConnect.DbConnect(HSQLDbConnect.java:61)
	at dbConnect.HSQLDbConnect.main(HSQLDbConnect.java:41)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: EMPLOYEE
	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.readSimpleRangeVariable(Unknown Source)
	at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source)
	at org.hsqldb.ParserCommand.compilePart(Unknown Source)
	at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 4 more

I can easily access my HSQL db with HSQL DB manager and can insert data directly into that. Even I have inserted one record using HSQL db manager directly but not through java program.
Any suggestion

[Sumit Patil]

What is the sql you are running in your java program?
Have you tried running the same query directly in HSQL db manager?
Please try that.

Thanks.

[Vinod Vijay]

Sumit Patil wrote:What is the sql you are running in your java program?
Have you tried running the same query directly in HSQL db manager?
Please try that.

Thanks.

Here is my code:-

/**
 * 
 */
package dbConnect;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;



/**
 * @author vk185052
 *
 */

public class HSQLDbConnect {

	Connection con = null;
    Statement stmt = null;
	ResultSet rs = null;

	String url = "jdbc:hsqldb:file:vijay827";

	String username = "SA";

	String password = "password";

//	String port = "";
//
//	String sid = "";

	/**
	 * @author vk185052
	 */
	public static void main(String[] args) {
		HSQLDbConnect connect = new HSQLDbConnect();
		connect.DbConnect();

	}

	/**
	 * @author vk185052
	 */
	public void DbConnect(){

		try {

			Class.forName("org.hsqldb.jdbcDriver");
			con = DriverManager.getConnection(url, username, password);
			System.out.println("Connection established!!!");
			String sql;
			//sql = "insert into employee values('2','Vijay Kumar')";
			sql = "Select * from employee";
			
			stmt = con.createStatement();
            rs = stmt.executeQuery(sql);

            while(rs.next()){
            	System.out.println("Emp_Id "+rs.getInt(1));
            	System.out.println("Emp_Name "+rs.getInt(2));
            }
            
           
		} catch (ClassNotFoundException ce) {
			ce.printStackTrace();

		} catch(SQLException se){
			se.printStackTrace();
		} 
	}
}

Yes! I tried the same sql in HSQL DB manager directly and it worked.

[Wendy Gibbons]

and you connected as the same user? as in the hibernate config files

[Vinod Vijay]

Wendy Gibbons wrote:and you connected as the same user? as in the hibernate config files

I'm not using hibernate here. I'm trying to access with username 'SA'.

[Wendy Gibbons]

Vinod Vijay wrote:

Wendy Gibbons wrote:and you connected as the same user? as in the hibernate config files

I'm not using hibernate here. I'm trying to access with username 'SA'.

sorry you mentioned HSQL i thought that was hibernate