Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Table Not Found in hsqldb

 
Huzefa Zohaib
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello,

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

thanks,
nivas.
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
does your web app's login connection the same as the schema owner?
 
Jan Cumps
Bartender
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm trying to help someone in this thread who has the same symptoms. Unsuccessful until now.
 
Jan Cumps
Bartender
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
They found a solution in the other thread.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic