jdbc hsqldb issue - table not found

Hi

When I try to connect using hsqldb DB Manager same link shows me the table and all queries work fine. Went through a couple of forums... but no solutions seems to work. Have also tried dbUrl/ dbName as jdbc:hsqldb:file:/home/shlahoti/DB/;default_schema=true" (mentioned at a few places... Any other suggestions. One of the topics in the forum says running hsql in server mode which I havn't tried/ don't want to do. I want to run with absolute path

Facing following exception for code

public static Connection connectDB(String databaseName, String userName, String password) {
      Connection jdbcConnection = null;
      try{
         Class.forName("org.hsqldb.jdbcDriver").newInstance();
         jdbcConnection = DriverManager.getConnection(databaseName,userName,password);
      }catch(Exception ex) {
         String connectMsg = "Could not connect to the database: " + ex.getMessage() + " " + ex.getLocalizedMessage();
         System.out.println(connectMsg);
      }
      return jdbcConnection;
   }
    public static void main(String[] args) {
       try{
          String databaseName = "jdbc:hsqldb:file:/home/indscorp/DB/";
          String userName = "sa";
          String password = "";
         Connection jdbcConnection = connectDB(databaseName, userName, password);
         System.out.println(jdbcConnection);
         String query = "SELECT * FROM CUSTOMER"; 
         Statement statmnt = jdbcConnection.createStatement();
         ResultSet rs = statmnt.executeQuery(query);      
    }catch(Exception e){
        e.printStackTrace();
    }

java.sql.SQLException: Table not found: CUSTOMER in statement [SELECT * FROM CUSTOMER]
at org.hsqldb.Trace.getError(Unknown Source)

"indian scorpio", please check your private messages.

As far as I understand, server mode shouldn't be an issue. If the server mode were the problem, you should have an issue gettign the connection, not seeing the table.

The likely issues could be:

Does your user have access to the schema this table exists in?

Does your user have select permissions for this table?

Does the table exist?

When you connecti to HSQL, do you connect to the database this table exists in, or do you connect to another?

"shubham",
Please read Paul's message again. A display name must be two names.

finally updated my name..

Anyways regrding the suggestions
Does your user have access to the schema this table exists in?
- I am using hsql DB MAnager with same username & pw and it connects then

Does your user have select permissions for this table?
- same as above
Does the table exist?
- shows table in DB manager
When you connecti to HSQL, do you connect to the database this table exists in, or do you connect to another?
- i believe i am connecting to same DB but obviously I am not as it doesn't shows table - probably while connecting through JAVA some modifications in DBURL required.. which I am missing out on..!!!