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