This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc hsqldb issue - table not found

 
shubham lahoti
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"indian scorpio", please check your private messages.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

  •  
    Jeanne Boyarsky
    author & internet detective
    Marshal
    Posts: 34973
    379
    Eclipse IDE Java VI Editor
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    "shubham",
    Please read Paul's message again. A display name must be two names.
     
    shubham lahoti
    Greenhorn
    Posts: 3
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    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..!!!
     
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic