Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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: 2618
14
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: 2618
14
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
They found a solution in the other thread.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!