Advertisement
Guest User

Untitled

a guest
Mar 21st, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. public class T20905JD
  2. {
  3. public static String sUser = "guest";
  4. public static String sPassword = "please";
  5.  
  6. public static void main(String args[])
  7.  
  8. {
  9. // Creation of URL to be passed to the JDBC driver
  10. String url = "jdbc:teradata://whomooz/TMODE=ANSI,CHARSET=UTF8";
  11.  
  12.  
  13.  
  14.  
  15. // Creating a connection object
  16. Connection con = DriverManager.getConnection(url, sUser, sPassword);
  17. System.out.println(" User " + sUser + " connected.");
  18. System.out.println(" Connection to Teradata established. n");
  19.  
  20.  
  21. DatabaseMetaData dbmd = con.getMetaData();
  22. System.out.println(" DatabaseMetaData object created. n");
  23. .
  24. ResultSet rs = dbmd.getSchemas();
  25.  
  26. // Display the database names
  27.  
  28. System.out.println(" DISPLAYING ALL DATABASE NAMES:n");
  29.  
  30. while(rs.next())
  31.  
  32. {
  33. System.out.println(" " + rs.getString("TABLE_SCHEM"));
  34. }
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement