/tst/org/diffkit/db/tst/TestDBConnection.java

http://diffkit.googlecode.com/ · Java · 39 lines · 31 code · 5 blank · 3 comment · 0 complexity · 41b5deb623ed9e95ab5267cd6b417e4d MD5 · raw file

  1. package org.diffkit.db.tst;
  2. import java.sql.Connection;
  3. import java.sql.DatabaseMetaData;
  4. import org.diffkit.db.DKDBConnectionInfo;
  5. import org.diffkit.db.DKDatabase;
  6. import org.diffkit.db.DKDBFlavor;
  7. public class TestDBConnection {
  8. public static void main(String[] args_) {
  9. try {
  10. // DKDBConnectionInfo connectionInfo = new DKDBConnectionInfo("test",
  11. // DKDBConnectionInfo.Kind.H2, "mem:test", null, null, "test", "test");
  12. DKDBConnectionInfo connectionInfo = new DKDBConnectionInfo("db204",
  13. DKDBFlavor.DB2, "LRMDB", "db204.95g.jec.us.ml.com",
  14. (Long) 50000L, "analytic", "merrill");
  15. // 'jdbc:db2://unit_host:unit_port/unit_server'
  16. testConnectionInfo(connectionInfo);
  17. }
  18. catch (Exception e) {
  19. e.printStackTrace();
  20. }
  21. }
  22. private static void testConnectionInfo(DKDBConnectionInfo connectionInfo_)
  23. throws Exception {
  24. System.out.println("connectionInfo->" + connectionInfo_);
  25. System.out.println("JDBCUrl->" + connectionInfo_.getJDBCUrl());
  26. System.out.println("driverName->" + connectionInfo_.getDriverName());
  27. System.out.println("connectionInfo->" + connectionInfo_);
  28. DKDatabase connectionSource = new DKDatabase(connectionInfo_);
  29. Connection connection = connectionSource.getConnection();
  30. System.out.println("connection->" + connection);
  31. DatabaseMetaData meta = connection.getMetaData();
  32. System.out.println("meta->" + meta);
  33. }
  34. }