KickJava   Java API By Example, From Geeks To Geeks.

Java > Java SE, EE, ME > java > sql > DatabaseMetaData

java.sql
Interface DatabaseMetaData

See Also:
Top Examples, Source Code
boolean allProceduresAreCallable()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  


[514]Get db table column size
By Anonymous on 2003/11/14 18:02:29  Rate
public static int getTableColumnSize  
  ( Connection dbConnection, String tableName, String columnName, int defaultValue )  
 throws SQLException  {  
  
  
 DatabaseMetaData dmd = dbConnection.getMetaData (  ) ; 
 final String dbURL = dmd.getURL (  ) ; 
 final String hashValue = dbURL+" [ "+tableName+" ] " +" [ "+columnName+" ] "; 
  
  
 // Try to retrieve stored column length from cache 
 Integer cachedCLength =  ( Integer ) columnLengthCache.get ( hashValue ) ; 
 if  ( cachedCLength != null )   {  
     int cachedLength = cachedCLength.intValue (  ) ; 
     if  ( cachedLength != 0  )   {  
     return cachedLength; 
      }  else  {  
     return defaultValue; 
      }  
  }  
  
  
 // Determine column length value from database schema 
 ResultSet rs = dmd.getColumns  ( null, null, tableName, columnName ) ; 
 int cLength = 0; 
 short dataType = 0; 
 if  ( rs.next (  )  )   {  
     cLength = rs.getInt ( "COLUMN_SIZE" ) ; 
     dataType = rs.getShort ( "DATA_TYPE" ) ; 
  }  else  {  
     cLength = defaultValue; 
     logger.warn ( "Schema query not supported. " 
         + "Using default value for column length." ) ; 
  }  
 rs.close (  ) ; 
  
  
 // Save column length value in cache 
 columnLengthCache.put ( hashValue, new Integer ( cLength )  ) ; 
  
  
 // Test if information is not supplied  ( e.g. Hypersonic DB )  
 if  (  ( dataType == java.sql.Types.VARCHAR )  &&  ( cLength == 0 )  )   {  
     cLength = defaultValue; 
     logger.warn ( "Illegal maximum varchar length  ( 0 )  received " 
         + "from schema. Using default value instead." ) ; 
  }  
 return cLength; 
  
  
  }  
  
  
  
 //allProceduresAreCallable

[1446]_
By p_shiv2003 { at } yahoo { dot } com on 2005/06/01 08:21:55  Rate
I am a computer stduent. This the good notes Please can you give me..

[1470]_
By Anonymous on 2005/07/01 20:59:47  Rate
To get the code to work you need to have a property named columnLengthCache 
  
  
  
 Example: 
 Map columnLengthCache = new HashMap (  ) ; 
boolean allTablesAreSelectable()
                               throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final short attributeNoNulls
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final short attributeNullable
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final short attributeNullableUnknown
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int bestRowNotPseudo
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int bestRowPseudo
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int bestRowSession
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int bestRowTemporary
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int bestRowTransaction
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int bestRowUnknown
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int columnNoNulls
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int columnNullable
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int columnNullableUnknown
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean dataDefinitionCausesTransactionCommit()
                                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean dataDefinitionIgnoredInTransactions()
                                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean deletesAreDetected(int type)
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean doesMaxRowSizeIncludeBlobs()
                                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getAttributes(String catalog,
                        String schemaPattern,
                        String typeNamePattern,
                        String attributeNamePattern)
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getBestRowIdentifier(String catalog,
                               String schema,
                               String table,
                               int scope,
                               boolean nullable)
                               throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getCatalogs()
                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getCatalogSeparator()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getCatalogTerm()
                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getColumnPrivileges(String catalog,
                              String schema,
                              String table,
                              String columnNamePattern)
                              throws SQLException
See Also:
getSearchStringEscape()
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getColumns(String catalog,
                     String schemaPattern,
                     String tableNamePattern,
                     String columnNamePattern)
                     throws SQLException
See Also:
getSearchStringEscape()
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

Connection getConnection()
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getCrossReference(String primaryCatalog,
                            String primarySchema,
                            String primaryTable,
                            String foreignCatalog,
                            String foreignSchema,
                            String foreignTable)
                            throws SQLException
See Also:
getImportedKeys(java.lang.String, java.lang.String, java.lang.String)
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getDatabaseMajorVersion()
                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getDatabaseMinorVersion()
                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getDatabaseProductName()
                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getDatabaseProductVersion()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getDefaultTransactionIsolation()
                                   throws SQLException
See Also:
Connection
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getDriverMajorVersion()
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getDriverMinorVersion()
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getDriverName()
                     throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getDriverVersion()
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getExportedKeys(String catalog,
                          String schema,
                          String table)
                          throws SQLException
See Also:
getImportedKeys(java.lang.String, java.lang.String, java.lang.String)
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getExtraNameCharacters()
                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getIdentifierQuoteString()
                                throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getImportedKeys(String catalog,
                          String schema,
                          String table)
                          throws SQLException
See Also:
getExportedKeys(java.lang.String, java.lang.String, java.lang.String)
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getIndexInfo(String catalog,
                       String schema,
                       String table,
                       boolean unique,
                       boolean approximate)
                       throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getJDBCMajorVersion()
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getJDBCMinorVersion()
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxBinaryLiteralLength()
                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxCatalogNameLength()
                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  


[1409]Get db table max column name length
By rs_nere { at } yahoo { dot } com on 2005/05/02 04:46:53  Rate
DatabaseMetaData dmd = Con.getMetaData (  ) ; 
 System.out.println ( "Max Column Name Length : " + dmd.getMaxColumnNameLength (  )  ) ;
int getMaxCharLiteralLength()
                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxColumnNameLength()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxColumnsInGroupBy()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxColumnsInIndex()
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxColumnsInOrderBy()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxColumnsInSelect()
                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxColumnsInTable()
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxConnections()
                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxCursorNameLength()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxIndexLength()
                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxProcedureNameLength()
                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxRowSize()
                  throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxSchemaNameLength()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxStatementLength()
                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxStatements()
                     throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxTableNameLength()
                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxTablesInSelect()
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getMaxUserNameLength()
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getNumericFunctions()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getPrimaryKeys(String catalog,
                         String schema,
                         String table)
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getProcedureColumns(String catalog,
                              String schemaPattern,
                              String procedureNamePattern,
                              String columnNamePattern)
                              throws SQLException
See Also:
getSearchStringEscape()
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  


[397]Get stored procedure parameter names
By leodonald { at } yahoo { dot } com on 2003/09/16 02:53:43  Rate
java.sql.DatabaseMetaData dbmd = Oconn.getMetaData (  ) ;  
       java.sql.ResultSet rsPrcDet = dbmd.getProcedureColumns ( "PACKAGE_NAME", "%", "PEOCEDURE_NAME","%" ) ; 
  while  ( rsPrcDet.next (  )  )   {   
   System.out.println ( rProc.getString ( 4 )  ) ; // Returns the parameter names 
         // Look into the Description link for further ResultSet content 
   }  
ResultSet getProcedures(String catalog,
                        String schemaPattern,
                        String procedureNamePattern)
                        throws SQLException
See Also:
getSearchStringEscape()
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  


[232]Print names of matching stored procedures
By Anonymous on 2003/04/24 23:54:21  Rate
 try  {  
  
  
         String schema = "AAAA"; 
         String procName = "AAAA"; 
         java.sql.DatabaseMetaData dmd = connection.getMetaData (  ) ; 
         java.sql.ResultSet rProc = dmd.getProcedures ( "", schema, procName ) ; 
         while  ( rProc.next (  )  )   {  
           System.out.println ( rProc.getInt ( 1 )  ) ; 
          }  
         rProc.close (  ) ; 
        } catch ( java.sql.SQLException e )   {  
       System.out.println ( "aaaaaaa" + e ) ; 
        } 

[356]Print all the stored procedures Names
By certzen { at } yahoo { dot } com on 2003/08/19 06:40:25  Rate
// To Print all the Procedure Names 
 java.sql.DatabaseMetaData dbmd = conn.getMetaData (  ) ; 
 rs = dbmd.getProcedures ( null,"","%" ) ; 
 while ( rs.next (  )  )  {  
  System.out.println ( rs.getString ( 3 )  ) ; 
  } 
String getProcedureTerm()
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getResultSetHoldability()
                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getSchemas()
                     throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getSchemaTerm()
                     throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getSearchStringEscape()
                             throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getSQLKeywords()
                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

int getSQLStateType()
                    throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getStringFunctions()
                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getSuperTables(String catalog,
                         String schemaPattern,
                         String tableNamePattern)
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getSuperTypes(String catalog,
                        String schemaPattern,
                        String typeNamePattern)
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getSystemFunctions()
                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getTablePrivileges(String catalog,
                             String schemaPattern,
                             String tableNamePattern)
                             throws SQLException
See Also:
getSearchStringEscape()
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getTables(String catalog,
                    String schemaPattern,
                    String tableNamePattern,
                    String[] types)
                    throws SQLException
See Also:
getSearchStringEscape()
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  


[755]Retrive all the tables
By picoro { at } mail { dot } com on 2004/04/30 06:52:07  Rate
try  {  
         // Gets the database metadata 
         DatabaseMetaData dbmd = connection.getMetaData (  ) ; 
      
         // Specify the type of object; in this case we want tables 
         String [  ]  types =  { "TABLE" } ; 
 // % all nameTables 
         ResultSet resultSet = dbmd.getTables ( null, null, "%", types ) ; 
      
         // Get the table names 
         while  ( resultSet.next (  )  )   {  
             // Get the table name 
             String tableName = resultSet.getString ( 3 ) ; 
      
             // Get the table's catalog and schema names  ( if any )  
             String tableCatalog = resultSet.getString ( 1 ) ; 
             String tableSchema = resultSet.getString ( 2 ) ; 
          }  
      }  catch  ( SQLException e )   {  
      }  
 
ResultSet getTableTypes()
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getTimeDateFunctions()
                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getTypeInfo()
                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getUDTs(String catalog,
                  String schemaPattern,
                  String typeNamePattern,
                  int[] types)
                  throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getURL()
              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

String getUserName()
                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

ResultSet getVersionColumns(String catalog,
                            String schema,
                            String table)
                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int importedKeyCascade
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int importedKeyInitiallyDeferred
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int importedKeyInitiallyImmediate
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int importedKeyNoAction
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int importedKeyNotDeferrable
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int importedKeyRestrict
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int importedKeySetDefault
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int importedKeySetNull
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean insertsAreDetected(int type)
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean isCatalogAtStart()
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean isReadOnly()
                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean locatorsUpdateCopy()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean nullPlusNonNullIsNull()
                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean nullsAreSortedAtEnd()
                            throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean nullsAreSortedAtStart()
                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean nullsAreSortedHigh()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean nullsAreSortedLow()
                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean othersDeletesAreVisible(int type)
                                throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean othersInsertsAreVisible(int type)
                                throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean othersUpdatesAreVisible(int type)
                                throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean ownDeletesAreVisible(int type)
                             throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean ownInsertsAreVisible(int type)
                             throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean ownUpdatesAreVisible(int type)
                             throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureColumnIn
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureColumnInOut
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureColumnOut
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureColumnResult
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureColumnReturn
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureColumnUnknown
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureNoNulls
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureNoResult
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureNullable
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureNullableUnknown
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureResultUnknown
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int procedureReturnsResult
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int sqlStateSQL99
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int sqlStateXOpen
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean storesLowerCaseIdentifiers()
                                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean storesLowerCaseQuotedIdentifiers()
                                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean storesMixedCaseIdentifiers()
                                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean storesMixedCaseQuotedIdentifiers()
                                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean storesUpperCaseIdentifiers()
                                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean storesUpperCaseQuotedIdentifiers()
                                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsAlterTableWithAddColumn()
                                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsAlterTableWithDropColumn()
                                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsANSI92EntryLevelSQL()
                                    throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsANSI92FullSQL()
                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsANSI92IntermediateSQL()
                                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsBatchUpdates()
                             throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsCatalogsInDataManipulation()
                                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsCatalogsInIndexDefinitions()
                                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsCatalogsInPrivilegeDefinitions()
                                               throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsCatalogsInProcedureCalls()
                                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsCatalogsInTableDefinitions()
                                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsColumnAliasing()
                               throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsConvert()
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsConvert(int fromType,
                        int toType)
                        throws SQLException
See Also:
Types
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsCoreSQLGrammar()
                               throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsCorrelatedSubqueries()
                                     throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsDataDefinitionAndDataManipulationTransactions()
                                                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsDataManipulationTransactionsOnly()
                                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsDifferentTableCorrelationNames()
                                               throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsExpressionsInOrderBy()
                                     throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsExtendedSQLGrammar()
                                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsFullOuterJoins()
                               throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsGetGeneratedKeys()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsGroupBy()
                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsGroupByBeyondSelect()
                                    throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsGroupByUnrelated()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsIntegrityEnhancementFacility()
                                             throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsLikeEscapeClause()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsLimitedOuterJoins()
                                  throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsMinimumSQLGrammar()
                                  throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsMixedCaseIdentifiers()
                                     throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsMixedCaseQuotedIdentifiers()
                                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsMultipleOpenResults()
                                    throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsMultipleResultSets()
                                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsMultipleTransactions()
                                     throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsNamedParameters()
                                throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsNonNullableColumns()
                                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsOpenCursorsAcrossCommit()
                                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsOpenCursorsAcrossRollback()
                                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsOpenStatementsAcrossCommit()
                                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsOpenStatementsAcrossRollback()
                                             throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsOrderByUnrelated()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsOuterJoins()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsPositionedDelete()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsPositionedUpdate()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsResultSetConcurrency(int type,
                                     int concurrency)
                                     throws SQLException
See Also:
Connection
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsResultSetHoldability(int holdability)
                                     throws SQLException
See Also:
Connection
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsResultSetType(int type)
                              throws SQLException
See Also:
Connection
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSavepoints()
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSchemasInDataManipulation()
                                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSchemasInIndexDefinitions()
                                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSchemasInPrivilegeDefinitions()
                                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSchemasInProcedureCalls()
                                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSchemasInTableDefinitions()
                                          throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSelectForUpdate()
                                throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsStatementPooling()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsStoredProcedures()
                                 throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSubqueriesInComparisons()
                                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSubqueriesInExists()
                                   throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSubqueriesInIns()
                                throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsSubqueriesInQuantifieds()
                                        throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsTableCorrelationNames()
                                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsTransactionIsolationLevel(int level)
                                          throws SQLException
See Also:
Connection
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsTransactions()
                             throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsUnion()
                      throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean supportsUnionAll()
                         throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final short tableIndexClustered
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final short tableIndexHashed
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final short tableIndexOther
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final short tableIndexStatistic
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int typeNoNulls
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int typeNullable
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int typeNullableUnknown
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int typePredBasic
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int typePredChar
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int typePredNone
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int typeSearchable
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean updatesAreDetected(int type)
                           throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean usesLocalFilePerTable()
                              throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

boolean usesLocalFiles()
                       throws SQLException
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int versionColumnNotPseudo
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int versionColumnPseudo
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  

static final int versionColumnUnknown
Geek's Notes:
Description  Add your codes or notes  Search More Java Examples  
Popular Tags