my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes Table Not Found in hsqldb Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Table Not Found in hsqldb" Watch "Table Not Found in hsqldb" New topic

Table Not Found in hsqldb

Huzefa Zohaib
Ranch Hand

Joined: Nov 21, 2001
Posts: 40

I have created table using runManager.bat via
"create cached table"
and tables are created successfully.

Now when I try to access the database via JDBC using the following code
String url = "jdbc:hsqldb:mydb/mydb";
con= DriverManager.getConnection(url, usrName, pas);
System.out.println ("Connection is created successfully");

and try to insert the data it throwing an exception
java.sql.SQLException: Table not found in statement [SELECT * FROM Users]

After then i tried to recreate the using JDBC, even in that case tables being created successfully, but the error is there.
Vijay Nivas

Joined: Nov 01, 2007
Posts: 12

I am also having same problem.How did you get rid of this exception?

Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
does your web app's login connection the same as the schema owner?
Jan Cumps

Joined: Dec 20, 2006
Posts: 2549

I'm trying to help someone in this thread who has the same symptoms. Unsuccessful until now.

OCUP UML fundamental and ITIL foundation
Jan Cumps

Joined: Dec 20, 2006
Posts: 2549

They found a solution in the other thread.
I agree. Here's the link:
subject: Table Not Found in hsqldb
It's not a secret anymore!