Code example for DatabaseMetaData

Methods: getTables

0
            stmt.execute("set property \"hsqldb.cache_size_scale\" 10");
            stmt.execute("set write_delay 0");
            stmt.execute("set logsize " + 100);
 
            DatabaseMetaData metaData = con.getMetaData();
            ResultSet        rs = metaData.getTables(null, null, "A", null);
            boolean          schemaExists;
 
            try { 
                schemaExists = rs.next();
            } finally { 
                rs.close();
            } 
 
            if (!schemaExists) {
                stmt.execute(
                    "create cached table A (ID binary(16) PRIMARY KEY, DATA varbinary not null)"); 
            } 
 
            stmt.execute("checkpoint");
        } finally {