DatabaseMetaData: getDefaultTransactionIsolation()
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class Main {
public static void main(String[] argv) {
Connection connection = null;
Statement statement;
ResultSet rs;
try {
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/AccountsDB");
connection = ds.getConnection();
DatabaseMetaData md = connection.getMetaData();
statement = connection.createStatement();
System.out.println("getURL() - " + md.getURL());
System.out.println("getUserName() - " + md.getUserName());
System.out.println("getDatabaseProductVersion - " + md.getDatabaseProductVersion());
System.out.println("getDriverMajorVersion - " + md.getDriverMajorVersion());
System.out.println("getDriverMinorVersion - " + md.getDriverMinorVersion());
System.out.println("nullAreSortedHigh - " + md.nullsAreSortedHigh());
System.out.println("<H1>Feature Support</H1>");
System.out.println("supportsAlterTableWithDropColumn - "
+ md.supportsAlterTableWithDropColumn() + "<BR>");
System.out.println("supportsBatchUpdates - " + md.supportsBatchUpdates());
System.out.println("supportsTableCorrelationNames - " + md.supportsTableCorrelationNames());
System.out.println("supportsPositionedDelete - " + md.supportsPositionedDelete());
System.out.println("supportsFullOuterJoins - " + md.supportsFullOuterJoins());
System.out.println("supportsStoredProcedures - " + md.supportsStoredProcedures());
System.out.println("supportsMixedCaseQuotedIdentifiers - "
+ md.supportsMixedCaseQuotedIdentifiers());
System.out.println("supportsANSI92EntryLevelSQL - " + md.supportsANSI92EntryLevelSQL());
System.out.println("supportsCoreSQLGrammar - " + md.supportsCoreSQLGrammar());
System.out.println("getMaxRowSize - " + md.getMaxRowSize());
System.out.println("getMaxStatementLength - " + md.getMaxStatementLength());
System.out.println("getMaxTablesInSelect - " + md.getMaxTablesInSelect());
System.out.println("getMaxConnections - " + md.getMaxConnections());
System.out.println("getMaxCharLiteralLength - " + md.getMaxCharLiteralLength());
System.out.println("getTableTypes()");
rs = md.getTableTypes();
while (rs.next()) {
System.out.println(rs.getString(1));
}
System.out.println("getTables()");
rs = md.getTables("accounts", "", "%", new String[0]);
while (rs.next()) {
System.out.println(rs.getString("TABLE_NAME"));
}
System.out.println("Transaction Support");
System.out.println("getDefaultTransactionIsolation() - "
+ md.getDefaultTransactionIsolation());
System.out.println("dataDefinitionIgnoredInTransactions() - "
+ md.dataDefinitionIgnoredInTransactions());
System.out.println("General Source Information");
System.out.println("getMaxTablesInSelect - " + md.getMaxTablesInSelect());
System.out.println("getMaxColumnsInTable - " + md.getMaxColumnsInTable());
System.out.println("getTimeDateFunctions - " + md.getTimeDateFunctions());
System.out.println("supportsCoreSQLGrammar - " + md.supportsCoreSQLGrammar());
System.out.println("getTypeInfo()");
rs = md.getTypeInfo();
while (rs.next()) {
System.out.println(rs.getString(1));
}
} catch (Exception e) {
e.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: getDriverName() | | |
9. | DatabaseMetaData: getDriverVersion() | | |
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() | | |