1   package org.riverock.dbrevision.utils;
2   
3   import org.riverock.dbrevision.db.Database;
4   import org.riverock.dbrevision.db.DatabaseFactory;
5   import org.riverock.dbrevision.db.DatabaseStructureManager;
6   import org.riverock.dbrevision.annotation.schema.db.DbTable;
7   import org.riverock.dbrevision.Constants;
8   
9   import java.sql.*;
10  import java.util.List;
11  
12  /**
13   * User: SergeMaslyukov
14   * Date: 29.08.2007
15   * Time: 23:55:28
16   */
17  public class TestConnectionProvider {
18      public static void main(String[] args) throws ClassNotFoundException, SQLException {
19          String url = "jdbc:hsqldb:hsql://localhost:9001";
20  
21          Class.forName("org.hsqldb.jdbcDriver");
22  
23          Connection conn = DriverManager.getConnection(url, "sa", null);
24  
25          Database database = DatabaseFactory.getInstance(conn, Database.Family.HYPERSONIC);
26  
27          DatabaseMetaData metaData = database.getConnection().getMetaData();
28  //        String dbSchema = metaData.getUserName();
29          String dbSchema = "";
30          List<DbTable> list = DatabaseStructureManager.getTableList(database.getConnection(), dbSchema, Constants.DB_REVISION_TABLE_NAME);
31  
32          System.out.println("list = " + list);
33      }
34  }