aspose file tools*
The moose likes JDBC 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
Bookmark "Table Not Found in hsqldb" Watch "Table Not Found in hsqldb" New topic
Author

Table Not Found in hsqldb

Huzefa Zohaib
Ranch Hand

Joined: Nov 21, 2001
Posts: 40
Hello!

hsqldb_1_8_0_1
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
Class.forName("org.hsqldb.jdbcDriver");
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
Greenhorn

Joined: Nov 01, 2007
Posts: 12
hello,

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

thanks,
nivas.
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
Bartender

Joined: Dec 20, 2006
Posts: 2500
    
    8

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


OCUP UML fundamental and ITIL foundation
youtube channel
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2500
    
    8

They found a solution in the other thread.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Table Not Found in hsqldb