Mega Code Archive

 

Categories / Java Tutorial / Database

 

Display Database Limitation for your connection

import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; public class Main {   public static void main(String[] args) throws Exception {     Connection conn = getConnection();     DatabaseMetaData mtdt = conn.getMetaData();     System.out.println("ANSI92 Entry Level: " + mtdt.supportsANSI92EntryLevelSQL());     System.out.println("ANSI92 Intermediate: " + mtdt.supportsANSI92IntermediateSQL());     System.out.println("ANSI92 Full SQL: " + mtdt.supportsANSI92FullSQL());     System.out.println("Minimum SQL Grammar: " + mtdt.supportsMinimumSQLGrammar());     System.out.println("Core SQL Grammar: " + mtdt.supportsCoreSQLGrammar());     System.out.println("Extended SQL Grammar: " + mtdt.supportsExtendedSQLGrammar());     conn.close();   }   private static Connection getConnection() throws Exception {     Class.forName("org.hsqldb.jdbcDriver");     String url = "jdbc:hsqldb:mem:data/tutorial";     return DriverManager.getConnection(url, "sa", "");   } } ANSI92 Entry Level: false ANSI92 Intermediate: false ANSI92 Full SQL: false Minimum SQL Grammar: false Core SQL Grammar: true Extended SQL Grammar: false