Hello,
When I try to execute queries against HSQLDB within my webapp (using a JDBC
statement), it throws the following SQLException:
java.sql.SQLException: Table not found: USERS in statement [select * from
users]
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.jdbcResultSet.<init>(Unknown Source)
at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.execute(Unknown Source)
at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
(where USERS is whatever table I'm trying to query against)
I am able to connect to the database - I don't get this exception until I
try to execute query. I am running HSQLDB (as standalone) inside of my
webapp on Tomcat.
When I take the same "tapmeta.script" and "tapmeta.properties", and point to
it with runManager.bat (same connection string, standalone mode), all the
tables show up, and I'm able to query against them. So, it works with
runManager.bat and doesn't work from webapp. Here is the connection string:
jdbc:hsqldb:V:\ab210009.tapwork26\tap\tap_rel\dev\web\config\hsql-data\tapme
ta
I tried executing the following code to determine what tabes were present
(since none of mine appeared), and got back nothing:
-----------
Results:
getCatalog: null
All tables in all schemas:
[]
------------
Code:
String dbName = conn.getCatalog(); // conn is instance of Connection
System.out.println("getCatalog: " + dbName);
DatabaseMetaData md = conn.getMetaData();
String[] types = {
"TABLE"
};
ResultSet rsTables = md.getTables(null, null/*"APP"*/, null, types);
Vector v = new Vector();
while (rsTables.next()) {
String name = rsTables.getString("TABLE_NAME") + " : " +
rsTables.getString("TABLE_CAT") + " : "
+ rsTables.getString("TABLE_SCHEM");
v.add(name);
}
Collections.sort(v);
System.out.println("All tables in all schemas:");
System.out.println(v.toString() + "\n\n");
-----------
Q: Why isn't it finding the tables when querying from a webapp via JDBC?
Thanks in advance for any help,
Alex
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
