KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > h2 > test > cases > TestRemoteMetaData


1 /*
2  * Copyright 2004-2006 H2 Group. Licensed under the H2 License, Version 1.0 (http://h2database.com/html/license.html).
3  * Initial Developer: H2 Group
4  */
5 package org.h2.test.cases;
6
7 import java.sql.*;
8
9 import org.h2.tools.Server;
10
11 public class TestRemoteMetaData {
12
13     public static void main(String JavaDoc[] args) throws Exception JavaDoc {
14         Class.forName("org.h2.Driver");
15         Server server = org.h2.tools.Server.createTcpServer(new String JavaDoc[0]);
16         server.start();
17         
18         String JavaDoc url = "jdbc:h2:tcp://localhost/test;TRACE_LEVEL_FILE=3";
19         Connection conn = DriverManager.getConnection(url, "sa", "sa");
20         DatabaseMetaData meta = conn.getMetaData();
21     
22         ResultSet rsTables = meta.getTables(null, null, null, null);
23         while(rsTables.next()) {
24             if (rsTables.getString(4).equals("TABLE")) {
25                 String JavaDoc name = rsTables.getString("TABLE_NAME");
26                 meta.getExportedKeys(null, null, name);
27                 meta.getImportedKeys(null, null, name);
28             }
29         }
30         server.stop();
31     }
32 }
33
Popular Tags