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
java.sql.SQLException: Table not found: CUSTOMER in statement [SELECT * FROM CUSTOMER] at org.hsqldb.Trace.getError(Unknown Source)
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..!!!