Forums Register Login

jdbc hsqldb issue - table not found

+Pie Number of slices to send: Send
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




java.sql.SQLException: Table not found: CUSTOMER in statement [SELECT * FROM CUSTOMER]
at org.hsqldb.Trace.getError(Unknown Source)
+Pie Number of slices to send: Send
"indian scorpio", please check your private messages.
+Pie Number of slices to send: Send
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?

  • +Pie Number of slices to send: Send
    "shubham",
    Please read Paul's message again. A display name must be two names.
    +Pie Number of slices to send: Send
    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..!!!
    I didn't do it. You can't prove it. Nobody saw me. The sheep are lying! This tiny ad is my witness!
    a bit of art, as a gift, the permaculture playing cards
    https://gardener-gift.com


    reply
    reply
    This thread has been viewed 2121 times.
    Similar Threads
    Unable to execute jar file....got following stack trace.
    Unable to execute jar file....got following stack trace.
    tomcat connection
    Problem with Jasper report
    org.xml.saxSAXNotRecognEx
    More...

    All times above are in ranch (not your local) time.
    The current ranch time is
    Mar 28, 2024 07:01:00.