This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes jdbc hsqldb issue - table not found   Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc hsqldb issue - table not found   " Watch "jdbc hsqldb issue - table not found   " New topic
Author

jdbc hsqldb issue - table not found

shubham lahoti
Greenhorn

Joined: Nov 26, 2008
Posts: 3
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

Joined: Apr 14, 2004
Posts: 10336

"indian scorpio", please check your private messages.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

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
    internet detective
    Marshal

    Joined: May 26, 2003
    Posts: 30076
        
    149

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


    [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
    Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
    shubham lahoti
    Greenhorn

    Joined: Nov 26, 2008
    Posts: 3
    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..!!!
     
    With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
     
    subject: jdbc hsqldb issue - table not found
     
    Similar Threads
    Unable to execute jar file....got following stack trace.
    tomcat connection
    Problem with Jasper report
    org.xml.saxSAXNotRecognEx
    Unable to execute jar file....got following stack trace.