How to detect existing text tables in a hsql db?



I have a Java-Application that creates several text-tables at the first
start. When I start the application again I just want to check, if the
text tables exist. But the application always returns a "false, table
does not exist" and the localdb.properties and localdb.script files are
written new. After that, the tables can be detected, but only until the
next start of the application.

dbcon.connect(LOCALDRIVER, LOCALPROTOCOL, LOCALDATABASE, LOCALUSER,
LOCALPASS);

DatabaseMetaData metadata = dbcon.con.getMetaData();
String[] aTyps = new String[]{"TABLE"};

ResultSet result = metadata.getTables(null, null, "%", aTyps);
while (result.next()) {
System.out.println(result.getString("TABLE_NAME"));
}
result.close();


Susanne

.