1   package org.riverock.dbrevision.trash;
2   
3   import java.sql.Connection;
4   import java.sql.DatabaseMetaData;
5   import java.sql.DriverManager;
6   import java.sql.ResultSet;
7   import java.sql.ResultSetMetaData;
8   import java.sql.SQLException;
9   
10  /**
11   * User: SMaslyukov
12   * Date: 30.08.2007
13   * Time: 12:59:28
14   */
15  public class HypersonicSchemaTest {
16      public static void main(String[] args) throws SQLException, ClassNotFoundException {
17  
18          Class.forName("org.hsqldb.jdbcDriver");
19          String url = "jdbc:hsqldb:hsql://localhost";
20  
21          Connection conn = DriverManager.getConnection(url, "sa", null);
22  
23  
24          DatabaseMetaData metaData = conn.getMetaData();
25          String dbSchema = metaData.getUserName();
26  
27          System.out.println("dbSchema = " + dbSchema);
28          
29          ResultSet rs = metaData.getSchemas();
30          while(rs.next()) {
31              String schema = rs.getString("TABLE_SCHEM");
32              String catalog = rs.getString("TABLE_CATALOG");
33              System.out.println("schema = " + schema+", catalog = " + catalog);
34  /*
35              ResultSetMetaData meta = rs.getMetaData();
36              int count = meta.getColumnCount();
37              for (int i=0; i<count; i++) {
38                  Object obj = rs.getObject(i);
39                  System.out.println("obj = " + obj);
40              }
41  */
42          }
43          String term = metaData.getSchemaTerm();
44          System.out.println("term = " + term);
45  
46      }
47  }