DatabaseMetaData: getDriverVersion()
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class Main {
public static void main(String[] args) throws Exception {
String url = "jdbc:odbc:databaseName";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String user = "guest";
String password = "guest";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
// Get the MetaData
DatabaseMetaData metaData = conn.getMetaData();
// Get driver information
System.out.println("Driver Informaion");
System.out.println(metaData.getDriverName());
System.out.println(metaData.getDriverVersion());
// Get schema information
System.out.println("Schemas");
ResultSet schemas = metaData.getSchemas();
while (schemas.next()) {
System.out.println(schemas.getString(1));
}
// Get table information
System.out.println("Tables");
ResultSet tables = metaData.getTables("", "", "", null);
while (tables.next()) {
System.out.println(tables.getString(3));
}
conn.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
Related examples in the same category
1. | DatabaseMetaData.columnNullable | | |
2. | DatabaseMetaData: getCatalogs() | | |
3. | DatabaseMetaData: getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | | |
4. | DatabaseMetaData: getDatabaseMajorVersion() | | |
5. | DatabaseMetaData: getDatabaseMinorVersion() | | |
6. | DatabaseMetaData: getDatabaseProductName() | | |
7. | DatabaseMetaData: getDatabaseProductVersion() | | |
8. | DatabaseMetaData: getDefaultTransactionIsolation() | | |
9. | DatabaseMetaData: getDriverName() | | |
10. | DatabaseMetaData: getExportedKeys(String catalog, String schema, String table) | | |
11. | DatabaseMetaData: getImportedKeys(String catalog, String schema, String table) | | |
12. | DatabaseMetaData: getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) | | |
13. | DatabaseMetaData: getJDBCMajorVersion() | | |
14. | DatabaseMetaData: getJDBCMinorVersion() | | |
15. | DatabaseMetaData: getMaxCharLiteralLength() | | |
16. | DatabaseMetaData: getMaxRowSize() | | |
17. | DatabaseMetaData: getMaxStatementLength() | | |
18. | DatabaseMetaData: getMaxTablesInSelect() | | |
19. | DatabaseMetaData: getMaxTableNameLength() | | |
20. | DatabaseMetaData: getNumericFunctions() | | |
21. | DatabaseMetaData: getPrimaryKeys(String catalog, String schema, String table) | | |
22. | DatabaseMetaData: getProcedures(String catalog, String schemaPattern, String procedureNamePattern) | | |
23. | DatabaseMetaData: getProcedureTerm() | | |
24. | DatabaseMetaData: getSchemas() | | |
25. | DatabaseMetaData: getSQLKeywords() | | |
26. | DatabaseMetaData: getStringFunctions() | | |
27. | DatabaseMetaData: getSystemFunctions() | | |
28. | DatabaseMetaData: getTableTypes() | | |
29. | DatabaseMetaData: getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) | | |
30. | DatabaseMetaData: getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) | | |
31. | DatabaseMetaData: getTimeDateFunctions() | | |
32. | DatabaseMetaData: getTypeInfo() | | |
33. | DatabaseMetaData: getURL() | | |
34. | DatabaseMetaData: getUserName() | | |
35. | DatabaseMetaData: nullsAreSortedHigh() | | |
36. | DatabaseMetaData: supportsANSI92EntryLevelSQL() | | |
37. | DatabaseMetaData: supportsANSI92FullSQL() | | |
38. | DatabaseMetaData: supportsANSI92IntermediateSQL() | | |
39. | DatabaseMetaData: supportsBatchUpdates() | | |
40. | DatabaseMetaData: supportsCoreSQLGrammar() | | |
41. | DatabaseMetaData: supportsExtendedSQLGrammar() | | |
42. | DatabaseMetaData: supportsFullOuterJoins() | | |
43. | DatabaseMetaData: supportsMinimumSQLGrammar() | | |
44. | DatabaseMetaData: supportsMixedCaseQuotedIdentifiers() | | |
45. | DatabaseMetaData: supportsPositionedDelete() | | |
46. | DatabaseMetaData: supportsResultSetConcurrency(int type, int concurrency) | | |
47. | DatabaseMetaData: supportsResultSetHoldability(int holdability) | | |
48. | DatabaseMetaData: supportsResultSetType(int type) | | |
49. | DatabaseMetaData: supportsStatementPooling() | | |
50. | DatabaseMetaData: supportsTableCorrelationNames() | | |
51. | DatabaseMetaData: supportsTransactionIsolationLevel(int level) | | |
52. | DatabaseMetaData: supportsTransactions() | | |