File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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: 2562

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: 2562

They found a solution in the other thread.
I agree. Here's the link:
subject: Table Not Found in hsqldb
jQuery in Action, 3rd edition