Author: steve.ebersole(a)jboss.com Date: 2009-11-13 22:45:27 -0500 (Fri, 13 Nov 2009) New Revision: 17979 Modified: core/trunk/core/src/main/java/org/hibernate/engine/jdbc/JdbcSupportLoader.java core/trunk/jdbc4-testing/src/test/java/org/hibernate/engine/jdbc/jdbc4/JdbcSupportTest.java Log: HHH-4572 - check if the connection supports jdbc4 before looking for the createClob method Modified: core/trunk/core/src/main/java/org/hibernate/engine/jdbc/JdbcSupportLoader.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/engine/jdbc/JdbcSupportLoader.java 2009-11-13 19:04:09 UTC (rev 17978) +++ core/trunk/core/src/main/java/org/hibernate/engine/jdbc/JdbcSupportLoader.java 2009-11-14 03:45:27 UTC (rev 17979) @@ -45,6 +45,7 @@ * * @param jdbcConnection A JDBC {@link java.sql.Connection} which can be used to gauge the drivers level of support, * specifically for creating LOB references. + * * @return An appropriate {@link JdbcSupport} instance. */ public static JdbcSupport loadJdbcSupport(Connection jdbcConnection) { @@ -61,25 +62,30 @@ * throwing an exception). * * @param jdbcConnection The connection whcih can be used in level-of-support testing. + * * @return True if the connection can be used to create LOBs; false otherwise. */ private static boolean useContextualLobCreation(Connection jdbcConnection) { if ( jdbcConnection == null ) { + log.info( "Disabling contextual LOB creation as connection was null" ); return false; } try { try { - DatabaseMetaData meta = jdbcConnection.getMetaData(); + DatabaseMetaData meta = jdbcConnection.getMetaData(); // if the jdbc driver version is less than 4, it shouldn't have createClob if ( meta.getJDBCMajorVersion() < 4 ) { - log.info("Disabling contextual LOB creation as JDBC driver version (" + - meta.getJDBCMajorVersion()+ - ") is less than 4"); + log.info( + "Disabling contextual LOB creation as JDBC driver reported JDBC version [" + + meta.getJDBCMajorVersion() + "] less than 4" + ); return false; } } - catch(SQLException eat) { /* ignore exception and continue */} + catch ( SQLException ignore ) { + // ignore exception and continue + } Class connectionClass = Connection.class; Method createClobMethod = connectionClass.getMethod( "createClob", NO_ARG_SIG ); @@ -99,7 +105,7 @@ return true; } catch ( Throwable t ) { - log.info( "createClob() method threw error : " + t ); + log.info( "Disabling contextual LOB creation as createClob() method threw error : " + t ); } } } Modified: core/trunk/jdbc4-testing/src/test/java/org/hibernate/engine/jdbc/jdbc4/JdbcSupportTest.java =================================================================== --- core/trunk/jdbc4-testing/src/test/java/org/hibernate/engine/jdbc/jdbc4/JdbcSupportTest.java 2009-11-13 19:04:09 UTC (rev 17978) +++ core/trunk/jdbc4-testing/src/test/java/org/hibernate/engine/jdbc/jdbc4/JdbcSupportTest.java 2009-11-14 03:45:27 UTC (rev 17979) @@ -53,6 +53,7 @@ public class JdbcSupportTest extends TestCase { public void testConnectedLobCreator() throws SQLException { final Connection connection = createConnectionProxy( + 4, new JdbcLobBuilder() { public Blob createBlob() { return new JdbcBlob(); @@ -65,10 +66,6 @@ public NClob createNClob() { return new JdbcNClob(); } - - public DatabaseMetaData getMetaData() { - return new JdbcMetadata(4); - } } ); final LobCreationContext lobCreationContext = new LobCreationContext() { @@ -108,6 +105,7 @@ public void testConnectedLobCreatorWithUnSupportedCreations() throws SQLException { final Connection connection = createConnectionProxy( + 3, new JdbcLobBuilder() { public Blob createBlob() { throw new UnsupportedOperationException(); @@ -120,10 +118,6 @@ public NClob createNClob() { throw new UnsupportedOperationException(); } - - public DatabaseMetaData getMetaData() { - return new JdbcMetadata(3); - } } ); final LobCreationContext lobCreationContext = new LobCreationContext() { @@ -190,14 +184,15 @@ public Blob createBlob(); public Clob createClob(); public NClob createNClob(); - public DatabaseMetaData getMetaData(); } private class ConnectionProxyHandler implements InvocationHandler { private final JdbcLobBuilder lobBuilder; + private final DatabaseMetaData metadata; - private ConnectionProxyHandler(JdbcLobBuilder lobBuilder) { + private ConnectionProxyHandler(int version, JdbcLobBuilder lobBuilder) { this.lobBuilder = lobBuilder; + this.metadata = createMetadataProxy( version ); } public Object invoke(Object proxy, Method method, Object[] args) throws Throwable { @@ -214,20 +209,43 @@ return lobBuilder.createNClob(); } else if ( "getMetaData".equals( methodName ) ) { - return lobBuilder.getMetaData(); + return metadata; } } return null; } } - private static Class[] PROXY_TYPES = new Class[] { Connection.class }; + private static Class[] CONN_PROXY_TYPES = new Class[] { Connection.class }; - private Connection createConnectionProxy(JdbcLobBuilder jdbcLobBuilder) { - ConnectionProxyHandler handler = new ConnectionProxyHandler( jdbcLobBuilder ); - return ( Connection ) Proxy.newProxyInstance( getClass().getClassLoader(), PROXY_TYPES, handler ); + private Connection createConnectionProxy(int version, JdbcLobBuilder jdbcLobBuilder) { + ConnectionProxyHandler handler = new ConnectionProxyHandler( version, jdbcLobBuilder ); + return ( Connection ) Proxy.newProxyInstance( getClass().getClassLoader(), CONN_PROXY_TYPES, handler ); } + private class MetadataProxyHandler implements InvocationHandler { + private final int jdbcVersion; + + private MetadataProxyHandler(int jdbcVersion) { + this.jdbcVersion = jdbcVersion; + } + + public Object invoke(Object proxy, Method method, Object[] args) throws Throwable { + final String methodName = method.getName(); + if ( "getJDBCMajorVersion".equals( methodName ) ) { + return jdbcVersion; + } + return null; + } + } + + private static Class[] META_PROXY_TYPES = new Class[] { DatabaseMetaData.class }; + + private DatabaseMetaData createMetadataProxy(int version) { + MetadataProxyHandler handler = new MetadataProxyHandler( version ); + return ( DatabaseMetaData ) Proxy.newProxyInstance( getClass().getClassLoader(), META_PROXY_TYPES, handler ); + } + private class JdbcBlob implements Blob { public long length() throws SQLException { return 0; @@ -326,3365 +344,4 @@ private class JdbcNClob extends JdbcClob implements NClob { } - - private class JdbcMetadata implements DatabaseMetaData { - - private final int jdbcVersion; - - JdbcMetadata(int jdbcVersion) { - this.jdbcVersion = jdbcVersion; - } - - /** - * Retrieves whether the current user can call all the procedures - * returned by the method <code>getProcedures</code>. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean allProceduresAreCallable() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether the current user can use all the tables returned - * by the method <code>getTables</code> in a <code>SELECT</code> - * statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean allTablesAreSelectable() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the URL for this DBMS. - * - * @return the URL for this DBMS or <code>null</code> if it cannot be - * generated - * @throws java.sql.SQLException if a database access error occurs - */ - public String getURL() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the user name as known to this database. - * - * @return the database user name - * @throws java.sql.SQLException if a database access error occurs - */ - public String getUserName() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database is in read-only mode. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean isReadOnly() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether <code>NULL</code> values are sorted high. - * Sorted high means that <code>NULL</code> values - * sort higher than any other value in a domain. In an ascending order, - * if this method returns <code>true</code>, <code>NULL</code> values - * will appear at the end. By contrast, the method - * <code>nullsAreSortedAtEnd</code> indicates whether <code>NULL</code> values - * are sorted at the end regardless of sort order. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean nullsAreSortedHigh() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether <code>NULL</code> values are sorted low. - * Sorted low means that <code>NULL</code> values - * sort lower than any other value in a domain. In an ascending order, - * if this method returns <code>true</code>, <code>NULL</code> values - * will appear at the beginning. By contrast, the method - * <code>nullsAreSortedAtStart</code> indicates whether <code>NULL</code> values - * are sorted at the beginning regardless of sort order. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean nullsAreSortedLow() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether <code>NULL</code> values are sorted at the start regardless - * of sort order. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean nullsAreSortedAtStart() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether <code>NULL</code> values are sorted at the end regardless of - * sort order. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean nullsAreSortedAtEnd() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the name of this database product. - * - * @return database product name - * @throws java.sql.SQLException if a database access error occurs - */ - public String getDatabaseProductName() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the version number of this database product. - * - * @return database version number - * @throws java.sql.SQLException if a database access error occurs - */ - public String getDatabaseProductVersion() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the name of this JDBC driver. - * - * @return JDBC driver name - * @throws java.sql.SQLException if a database access error occurs - */ - public String getDriverName() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the version number of this JDBC driver as a <code>String</code>. - * - * @return JDBC driver version - * @throws java.sql.SQLException if a database access error occurs - */ - public String getDriverVersion() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves this JDBC driver's major version number. - * - * @return JDBC driver major version - */ - public int getDriverMajorVersion() - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves this JDBC driver's minor version number. - * - * @return JDBC driver minor version number - */ - public int getDriverMinorVersion() - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database stores tables in a local file. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean usesLocalFiles() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database uses a file for each table. - * - * @return <code>true</code> if this database uses a local file for each table; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean usesLocalFilePerTable() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database treats mixed case unquoted SQL identifiers as - * case sensitive and as a result stores them in mixed case. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsMixedCaseIdentifiers() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database treats mixed case unquoted SQL identifiers as - * case insensitive and stores them in upper case. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean storesUpperCaseIdentifiers() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database treats mixed case unquoted SQL identifiers as - * case insensitive and stores them in lower case. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean storesLowerCaseIdentifiers() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database treats mixed case unquoted SQL identifiers as - * case insensitive and stores them in mixed case. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean storesMixedCaseIdentifiers() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database treats mixed case quoted SQL identifiers as - * case sensitive and as a result stores them in mixed case. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database treats mixed case quoted SQL identifiers as - * case insensitive and stores them in upper case. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean storesUpperCaseQuotedIdentifiers() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database treats mixed case quoted SQL identifiers as - * case insensitive and stores them in lower case. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean storesLowerCaseQuotedIdentifiers() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database treats mixed case quoted SQL identifiers as - * case insensitive and stores them in mixed case. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean storesMixedCaseQuotedIdentifiers() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the string used to quote SQL identifiers. - * This method returns a space " " if identifier quoting is not supported. - * - * @return the quoting string or a space if quoting is not supported - * @throws java.sql.SQLException if a database access error occurs - */ - public String getIdentifierQuoteString() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a comma-separated list of all of this database's SQL keywords - * that are NOT also SQL:2003 keywords. - * - * @return the list of this database's keywords that are not also - * SQL:2003 keywords - * @throws java.sql.SQLException if a database access error occurs - */ - public String getSQLKeywords() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a comma-separated list of math functions available with - * this database. These are the Open /Open CLI math function names used in - * the JDBC function escape clause. - * - * @return the list of math functions supported by this database - * @throws java.sql.SQLException if a database access error occurs - */ - public String getNumericFunctions() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a comma-separated list of string functions available with - * this database. These are the Open Group CLI string function names used - * in the JDBC function escape clause. - * - * @return the list of string functions supported by this database - * @throws java.sql.SQLException if a database access error occurs - */ - public String getStringFunctions() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a comma-separated list of system functions available with - * this database. These are the Open Group CLI system function names used - * in the JDBC function escape clause. - * - * @return a list of system functions supported by this database - * @throws java.sql.SQLException if a database access error occurs - */ - public String getSystemFunctions() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a comma-separated list of the time and date functions available - * with this database. - * - * @return the list of time and date functions supported by this database - * @throws java.sql.SQLException if a database access error occurs - */ - public String getTimeDateFunctions() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the string that can be used to escape wildcard characters. - * This is the string that can be used to escape '_' or '%' in - * the catalog search parameters that are a pattern (and therefore use one - * of the wildcard characters). - * <p/> - * <P>The '_' character represents any single character; - * the '%' character represents any sequence of zero or - * more characters. - * - * @return the string used to escape wildcard characters - * @throws java.sql.SQLException if a database access error occurs - */ - public String getSearchStringEscape() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves all the "extra" characters that can be used in unquoted - * identifier names (those beyond a-z, A-Z, 0-9 and _). - * - * @return the string containing the extra characters - * @throws java.sql.SQLException if a database access error occurs - */ - public String getExtraNameCharacters() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports <code>ALTER TABLE</code> - * with add column. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsAlterTableWithAddColumn() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports <code>ALTER TABLE</code> - * with drop column. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsAlterTableWithDropColumn() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports column aliasing. - * <p/> - * <P>If so, the SQL AS clause can be used to provide names for - * computed columns or to provide alias names for columns as - * required. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsColumnAliasing() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports concatenations between - * <code>NULL</code> and non-<code>NULL</code> values being - * <code>NULL</code>. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean nullPlusNonNullIsNull() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the JDBC scalar function - * <code>CONVERT</code> for the conversion of one JDBC type to another. - * The JDBC types are the generic SQL data types defined - * in <code>java.sql.Types</code>. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsConvert() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the JDBC scalar function - * <code>CONVERT</code> for conversions between the JDBC types <i>fromType</i> - * and <i>toType</i>. The JDBC types are the generic SQL data types defined - * in <code>java.sql.Types</code>. - * - * @param fromType the type to convert from; one of the type codes from - * the class <code>java.sql.Types</code> - * @param toType the type to convert to; one of the type codes from - * the class <code>java.sql.Types</code> - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @see java.sql.Types - */ - public boolean supportsConvert(int fromType, int toType) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports table correlation names. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsTableCorrelationNames() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether, when table correlation names are supported, they - * are restricted to being different from the names of the tables. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsDifferentTableCorrelationNames() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports expressions in - * <code>ORDER BY</code> lists. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsExpressionsInOrderBy() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports using a column that is - * not in the <code>SELECT</code> statement in an - * <code>ORDER BY</code> clause. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsOrderByUnrelated() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports some form of - * <code>GROUP BY</code> clause. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsGroupBy() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports using a column that is - * not in the <code>SELECT</code> statement in a - * <code>GROUP BY</code> clause. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsGroupByUnrelated() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports using columns not included in - * the <code>SELECT</code> statement in a <code>GROUP BY</code> clause - * provided that all of the columns in the <code>SELECT</code> statement - * are included in the <code>GROUP BY</code> clause. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsGroupByBeyondSelect() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports specifying a - * <code>LIKE</code> escape clause. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsLikeEscapeClause() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports getting multiple - * <code>ResultSet</code> objects from a single call to the - * method <code>execute</code>. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsMultipleResultSets() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database allows having multiple - * transactions open at once (on different connections). - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsMultipleTransactions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether columns in this database may be defined as non-nullable. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsNonNullableColumns() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the ODBC Minimum SQL grammar. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsMinimumSQLGrammar() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the ODBC Core SQL grammar. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsCoreSQLGrammar() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the ODBC Extended SQL grammar. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsExtendedSQLGrammar() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the ANSI92 entry level SQL - * grammar. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsANSI92EntryLevelSQL() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsANSI92IntermediateSQL() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the ANSI92 full SQL grammar supported. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsANSI92FullSQL() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the SQL Integrity - * Enhancement Facility. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsIntegrityEnhancementFacility() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports some form of outer join. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsOuterJoins() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports full nested outer joins. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsFullOuterJoins() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database provides limited support for outer - * joins. (This will be <code>true</code> if the method - * <code>supportsFullOuterJoins</code> returns <code>true</code>). - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsLimitedOuterJoins() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the database vendor's preferred term for "schema". - * - * @return the vendor term for "schema" - * @throws java.sql.SQLException if a database access error occurs - */ - public String getSchemaTerm() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the database vendor's preferred term for "procedure". - * - * @return the vendor term for "procedure" - * @throws java.sql.SQLException if a database access error occurs - */ - public String getProcedureTerm() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the database vendor's preferred term for "catalog". - * - * @return the vendor term for "catalog" - * @throws java.sql.SQLException if a database access error occurs - */ - public String getCatalogTerm() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a catalog appears at the start of a fully qualified - * table name. If not, the catalog appears at the end. - * - * @return <code>true</code> if the catalog name appears at the beginning - * of a fully qualified table name; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean isCatalogAtStart() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the <code>String</code> that this database uses as the - * separator between a catalog and table name. - * - * @return the separator string - * @throws java.sql.SQLException if a database access error occurs - */ - public String getCatalogSeparator() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a schema name can be used in a data manipulation statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSchemasInDataManipulation() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a schema name can be used in a procedure call statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSchemasInProcedureCalls() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a schema name can be used in a table definition statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSchemasInTableDefinitions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a schema name can be used in an index definition statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSchemasInIndexDefinitions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a schema name can be used in a privilege definition statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a catalog name can be used in a data manipulation statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsCatalogsInDataManipulation() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a catalog name can be used in a procedure call statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsCatalogsInProcedureCalls() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a catalog name can be used in a table definition statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsCatalogsInTableDefinitions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a catalog name can be used in an index definition statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsCatalogsInIndexDefinitions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a catalog name can be used in a privilege definition statement. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports positioned <code>DELETE</code> - * statements. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsPositionedDelete() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports positioned <code>UPDATE</code> - * statements. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsPositionedUpdate() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports <code>SELECT FOR UPDATE</code> - * statements. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSelectForUpdate() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports stored procedure calls - * that use the stored procedure escape syntax. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsStoredProcedures() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports subqueries in comparison - * expressions. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSubqueriesInComparisons() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports subqueries in - * <code>EXISTS</code> expressions. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSubqueriesInExists() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports subqueries in - * <code>IN</code> expressions. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSubqueriesInIns() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports subqueries in quantified - * expressions. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsSubqueriesInQuantifieds() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports correlated subqueries. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsCorrelatedSubqueries() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports SQL <code>UNION</code>. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsUnion() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports SQL <code>UNION ALL</code>. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsUnionAll() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports keeping cursors open - * across commits. - * - * @return <code>true</code> if cursors always remain open; - * <code>false</code> if they might not remain open - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsOpenCursorsAcrossCommit() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports keeping cursors open - * across rollbacks. - * - * @return <code>true</code> if cursors always remain open; - * <code>false</code> if they might not remain open - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsOpenCursorsAcrossRollback() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports keeping statements open - * across commits. - * - * @return <code>true</code> if statements always remain open; - * <code>false</code> if they might not remain open - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsOpenStatementsAcrossCommit() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports keeping statements open - * across rollbacks. - * - * @return <code>true</code> if statements always remain open; - * <code>false</code> if they might not remain open - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsOpenStatementsAcrossRollback() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of hex characters this database allows in an - * inline binary literal. - * - * @return max the maximum length (in hex characters) for a binary literal; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxBinaryLiteralLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters this database allows - * for a character literal. - * - * @return the maximum number of characters allowed for a character literal; - * a result of zero means that there is no limit or the limit is - * not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxCharLiteralLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters this database allows - * for a column name. - * - * @return the maximum number of characters allowed for a column name; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxColumnNameLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of columns this database allows in a - * <code>GROUP BY</code> clause. - * - * @return the maximum number of columns allowed; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxColumnsInGroupBy() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of columns this database allows in an index. - * - * @return the maximum number of columns allowed; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxColumnsInIndex() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of columns this database allows in an - * <code>ORDER BY</code> clause. - * - * @return the maximum number of columns allowed; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxColumnsInOrderBy() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of columns this database allows in a - * <code>SELECT</code> list. - * - * @return the maximum number of columns allowed; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxColumnsInSelect() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of columns this database allows in a table. - * - * @return the maximum number of columns allowed; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxColumnsInTable() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of concurrent connections to this - * database that are possible. - * - * @return the maximum number of active connections possible at one time; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxConnections() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters that this database allows in a - * cursor name. - * - * @return the maximum number of characters allowed in a cursor name; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxCursorNameLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of bytes this database allows for an - * index, including all of the parts of the index. - * - * @return the maximum number of bytes allowed; this limit includes the - * composite of all the constituent parts of the index; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxIndexLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters that this database allows in a - * schema name. - * - * @return the maximum number of characters allowed in a schema name; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxSchemaNameLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters that this database allows in a - * procedure name. - * - * @return the maximum number of characters allowed in a procedure name; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxProcedureNameLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters that this database allows in a - * catalog name. - * - * @return the maximum number of characters allowed in a catalog name; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxCatalogNameLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of bytes this database allows in - * a single row. - * - * @return the maximum number of bytes allowed for a row; a result of - * zero means that there is no limit or the limit is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxRowSize() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether the return value for the method - * <code>getMaxRowSize</code> includes the SQL data types - * <code>LONGVARCHAR</code> and <code>LONGVARBINARY</code>. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean doesMaxRowSizeIncludeBlobs() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters this database allows in - * an SQL statement. - * - * @return the maximum number of characters allowed for an SQL statement; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxStatementLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of active statements to this database - * that can be open at the same time. - * - * @return the maximum number of statements that can be open at one time; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxStatements() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters this database allows in - * a table name. - * - * @return the maximum number of characters allowed for a table name; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxTableNameLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of tables this database allows in a - * <code>SELECT</code> statement. - * - * @return the maximum number of tables allowed in a <code>SELECT</code> - * statement; a result of zero means that there is no limit or - * the limit is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxTablesInSelect() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the maximum number of characters this database allows in - * a user name. - * - * @return the maximum number of characters allowed for a user name; - * a result of zero means that there is no limit or the limit - * is not known - * @throws java.sql.SQLException if a database access error occurs - */ - public int getMaxUserNameLength() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves this database's default transaction isolation level. The - * possible values are defined in <code>java.sql.Connection</code>. - * - * @return the default isolation level - * @throws java.sql.SQLException if a database access error occurs - * @see java.sql.Connection - */ - public int getDefaultTransactionIsolation() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports transactions. If not, invoking the - * method <code>commit</code> is a noop, and the isolation level is - * <code>TRANSACTION_NONE</code>. - * - * @return <code>true</code> if transactions are supported; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsTransactions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the given transaction isolation level. - * - * @param level one of the transaction isolation levels defined in - * <code>java.sql.Connection</code> - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @see java.sql.Connection - */ - public boolean supportsTransactionIsolationLevel(int level) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports both data definition and - * data manipulation statements within a transaction. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports only data manipulation - * statements within a transaction. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean supportsDataManipulationTransactionsOnly() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a data definition statement within a transaction forces - * the transaction to commit. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean dataDefinitionCausesTransactionCommit() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database ignores a data definition statement - * within a transaction. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - */ - public boolean dataDefinitionIgnoredInTransactions() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the stored procedures available in the given - * catalog. - * <p/> - * Only procedure descriptions matching the schema and - * procedure name criteria are returned. They are ordered by - * <code>PROCEDURE_CAT</code>, <code>PROCEDURE_SCHEM</code>, - * <code>PROCEDURE_NAME</code> and <code>SPECIFIC_ NAME</code>. - * <p/> - * <P>Each procedure description has the the following columns: - * <OL> - * <LI><B>PROCEDURE_CAT</B> String => procedure catalog (may be <code>null</code>) - * <LI><B>PROCEDURE_SCHEM</B> String => procedure schema (may be <code>null</code>) - * <LI><B>PROCEDURE_NAME</B> String => procedure name - * <LI> reserved for future use - * <LI> reserved for future use - * <LI> reserved for future use - * <LI><B>REMARKS</B> String => explanatory comment on the procedure - * <LI><B>PROCEDURE_TYPE</B> short => kind of procedure: - * <UL> - * <LI> procedureResultUnknown - Cannot determine if a return value - * will be returned - * <LI> procedureNoResult - Does not return a return value - * <LI> procedureReturnsResult - Returns a return value - * </UL> - * <LI><B>SPECIFIC_NAME</B> String => The name which uniquely identifies this - * procedure within its schema. - * </OL> - * <p/> - * A user may not have permissions to execute any of the procedures that are - * returned by <code>getProcedures</code> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema name pattern; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param procedureNamePattern a procedure name pattern; must match the - * procedure name as it is stored in the database - * @return <code>ResultSet</code> - each row is a procedure description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - */ - public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the given catalog's stored procedure parameter - * and result columns. - * <p/> - * <P>Only descriptions matching the schema, procedure and - * parameter name criteria are returned. They are ordered by - * PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME and SPECIFIC_NAME. Within this, the return value, - * if any, is first. Next are the parameter descriptions in call - * order. The column descriptions follow in column number order. - * <p/> - * <P>Each row in the <code>ResultSet</code> is a parameter description or - * column description with the following fields: - * <OL> - * <LI><B>PROCEDURE_CAT</B> String => procedure catalog (may be <code>null</code>) - * <LI><B>PROCEDURE_SCHEM</B> String => procedure schema (may be <code>null</code>) - * <LI><B>PROCEDURE_NAME</B> String => procedure name - * <LI><B>COLUMN_NAME</B> String => column/parameter name - * <LI><B>COLUMN_TYPE</B> Short => kind of column/parameter: - * <UL> - * <LI> procedureColumnUnknown - nobody knows - * <LI> procedureColumnIn - IN parameter - * <LI> procedureColumnInOut - INOUT parameter - * <LI> procedureColumnOut - OUT parameter - * <LI> procedureColumnReturn - procedure return value - * <LI> procedureColumnResult - result column in <code>ResultSet</code> - * </UL> - * <LI><B>DATA_TYPE</B> int => SQL type from java.sql.Types - * <LI><B>TYPE_NAME</B> String => SQL type name, for a UDT type the - * type name is fully qualified - * <LI><B>PRECISION</B> int => precision - * <LI><B>LENGTH</B> int => length in bytes of data - * <LI><B>SCALE</B> short => scale - null is returned for data types where - * SCALE is not applicable. - * <LI><B>RADIX</B> short => radix - * <LI><B>NULLABLE</B> short => can it contain NULL. - * <UL> - * <LI> procedureNoNulls - does not allow NULL values - * <LI> procedureNullable - allows NULL values - * <LI> procedureNullableUnknown - nullability unknown - * </UL> - * <LI><B>REMARKS</B> String => comment describing parameter/column - * <LI><B>COLUMN_DEF</B> String => default value for the column, which should be interpreted as a string when the value is enclosed in single quotes (may be <code>null</code>) - * <UL> - * <LI> The string NULL (not enclosed in quotes) - if NULL was specified as the default value - * <LI> TRUNCATE (not enclosed in quotes) - if the specified default value cannot be represented without truncation - * <LI> NULL - if a default value was not specified - * </UL> - * <LI><B>SQL_DATA_TYPE</B> int => reserved for future use - * <LI><B>SQL_DATETIME_SUB</B> int => reserved for future use - * <LI><B>CHAR_OCTET_LENGTH</B> int => the maximum length of binary and character based columns. For any other datatype the returned value is a - * NULL - * <LI><B>ORDINAL_POSITION</B> int => the ordinal position, starting from 1, for the input and output parameters for a procedure. A value of 0 - * is returned if this row describes the procedure's return value. For result set columns, it is the - * ordinal position of the column in the result set starting from 1. If there are - * multiple result sets, the column ordinal positions are implementation - * defined. - * <LI><B>IS_NULLABLE</B> String => ISO rules are used to determine the nullability for a column. - * <UL> - * <LI> YES --- if the parameter can include NULLs - * <LI> NO --- if the parameter cannot include NULLs - * <LI> empty string --- if the nullability for the - * parameter is unknown - * </UL> - * <LI><B>SPECIFIC_NAME</B> String => the name which uniquely identifies this procedure within its schema. - * </OL> - * <p/> - * <P><B>Note:</B> Some databases may not return the column - * descriptions for a procedure. - * <p/> - * <p>The PRECISION column represents the specified column size for the given column. - * For numeric data, this is the maximum precision. For character data, this is the length in characters. - * For datetime datatypes, this is the length in characters of the String representation (assuming the - * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, - * this is the length in bytes. Null is returned for data types where the - * column size is not applicable. - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema name pattern; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param procedureNamePattern a procedure name pattern; must match the - * procedure name as it is stored in the database - * @param columnNamePattern a column name pattern; must match the column name - * as it is stored in the database - * @return <code>ResultSet</code> - each row describes a stored procedure parameter or - * column - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - */ - public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the tables available in the given catalog. - * Only table descriptions matching the catalog, schema, table - * name and type criteria are returned. They are ordered by - * <code>TABLE_TYPE</code>, <code>TABLE_CAT</code>, - * <code>TABLE_SCHEM</code> and <code>TABLE_NAME</code>. - * <p/> - * Each table description has the following columns: - * <OL> - * <LI><B>TABLE_CAT</B> String => table catalog (may be <code>null</code>) - * <LI><B>TABLE_SCHEM</B> String => table schema (may be <code>null</code>) - * <LI><B>TABLE_NAME</B> String => table name - * <LI><B>TABLE_TYPE</B> String => table type. Typical types are "TABLE", - * "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", - * "LOCAL TEMPORARY", "ALIAS", "SYNONYM". - * <LI><B>REMARKS</B> String => explanatory comment on the table - * <LI><B>TYPE_CAT</B> String => the types catalog (may be <code>null</code>) - * <LI><B>TYPE_SCHEM</B> String => the types schema (may be <code>null</code>) - * <LI><B>TYPE_NAME</B> String => type name (may be <code>null</code>) - * <LI><B>SELF_REFERENCING_COL_NAME</B> String => name of the designated - * "identifier" column of a typed table (may be <code>null</code>) - * <LI><B>REF_GENERATION</B> String => specifies how values in - * SELF_REFERENCING_COL_NAME are created. Values are - * "SYSTEM", "USER", "DERIVED". (may be <code>null</code>) - * </OL> - * <p/> - * <P><B>Note:</B> Some databases may not return information for - * all tables. - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema name pattern; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param tableNamePattern a table name pattern; must match the - * table name as it is stored in the database - * @param types a list of table types, which must be from the list of table types - * returned from {@link #getTableTypes},to include; <code>null</code> returns - * all types - * @return <code>ResultSet</code> - each row is a table description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - */ - public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the schema names available in this database. The results - * are ordered by <code>TABLE_CATALOG</code> and - * <code>TABLE_SCHEM</code>. - * <p/> - * <P>The schema columns are: - * <OL> - * <LI><B>TABLE_SCHEM</B> String => schema name - * <LI><B>TABLE_CATALOG</B> String => catalog name (may be <code>null</code>) - * </OL> - * - * @return a <code>ResultSet</code> object in which each row is a - * schema description - * @throws java.sql.SQLException if a database access error occurs - */ - public ResultSet getSchemas() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the catalog names available in this database. The results - * are ordered by catalog name. - * <p/> - * <P>The catalog column is: - * <OL> - * <LI><B>TABLE_CAT</B> String => catalog name - * </OL> - * - * @return a <code>ResultSet</code> object in which each row has a - * single <code>String</code> column that is a catalog name - * @throws java.sql.SQLException if a database access error occurs - */ - public ResultSet getCatalogs() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the table types available in this database. The results - * are ordered by table type. - * <p/> - * <P>The table type is: - * <OL> - * <LI><B>TABLE_TYPE</B> String => table type. Typical types are "TABLE", - * "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", - * "LOCAL TEMPORARY", "ALIAS", "SYNONYM". - * </OL> - * - * @return a <code>ResultSet</code> object in which each row has a - * single <code>String</code> column that is a table type - * @throws java.sql.SQLException if a database access error occurs - */ - public ResultSet getTableTypes() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of table columns available in - * the specified catalog. - * <p/> - * <P>Only column descriptions matching the catalog, schema, table - * and column name criteria are returned. They are ordered by - * <code>TABLE_CAT</code>,<code>TABLE_SCHEM</code>, - * <code>TABLE_NAME</code>, and <code>ORDINAL_POSITION</code>. - * <p/> - * <P>Each column description has the following columns: - * <OL> - * <LI><B>TABLE_CAT</B> String => table catalog (may be <code>null</code>) - * <LI><B>TABLE_SCHEM</B> String => table schema (may be <code>null</code>) - * <LI><B>TABLE_NAME</B> String => table name - * <LI><B>COLUMN_NAME</B> String => column name - * <LI><B>DATA_TYPE</B> int => SQL type from java.sql.Types - * <LI><B>TYPE_NAME</B> String => Data source dependent type name, - * for a UDT the type name is fully qualified - * <LI><B>COLUMN_SIZE</B> int => column size. - * <LI><B>BUFFER_LENGTH</B> is not used. - * <LI><B>DECIMAL_DIGITS</B> int => the number of fractional digits. Null is returned for data types where - * DECIMAL_DIGITS is not applicable. - * <LI><B>NUM_PREC_RADIX</B> int => Radix (typically either 10 or 2) - * <LI><B>NULLABLE</B> int => is NULL allowed. - * <UL> - * <LI> columnNoNulls - might not allow <code>NULL</code> values - * <LI> columnNullable - definitely allows <code>NULL</code> values - * <LI> columnNullableUnknown - nullability unknown - * </UL> - * <LI><B>REMARKS</B> String => comment describing column (may be <code>null</code>) - * <LI><B>COLUMN_DEF</B> String => default value for the column, which should be interpreted as a string when the value is enclosed in single quotes (may be <code>null</code>) - * <LI><B>SQL_DATA_TYPE</B> int => unused - * <LI><B>SQL_DATETIME_SUB</B> int => unused - * <LI><B>CHAR_OCTET_LENGTH</B> int => for char types the - * maximum number of bytes in the column - * <LI><B>ORDINAL_POSITION</B> int => index of column in table - * (starting at 1) - * <LI><B>IS_NULLABLE</B> String => ISO rules are used to determine the nullability for a column. - * <UL> - * <LI> YES --- if the parameter can include NULLs - * <LI> NO --- if the parameter cannot include NULLs - * <LI> empty string --- if the nullability for the - * parameter is unknown - * </UL> - * <LI><B>SCOPE_CATLOG</B> String => catalog of table that is the scope - * of a reference attribute (<code>null</code> if DATA_TYPE isn't REF) - * <LI><B>SCOPE_SCHEMA</B> String => schema of table that is the scope - * of a reference attribute (<code>null</code> if the DATA_TYPE isn't REF) - * <LI><B>SCOPE_TABLE</B> String => table name that this the scope - * of a reference attribure (<code>null</code> if the DATA_TYPE isn't REF) - * <LI><B>SOURCE_DATA_TYPE</B> short => source type of a distinct type or user-generated - * Ref type, SQL type from java.sql.Types (<code>null</code> if DATA_TYPE - * isn't DISTINCT or user-generated REF) - * <LI><B>IS_AUTOINCREMENT</B> String => Indicates whether this column is auto incremented - * <UL> - * <LI> YES --- if the column is auto incremented - * <LI> NO --- if the column is not auto incremented - * <LI> empty string --- if it cannot be determined whether the column is auto incremented - * parameter is unknown - * </UL> - * </OL> - * <p/> - * <p>The COLUMN_SIZE column the specified column size for the given column. - * For numeric data, this is the maximum precision. For character data, this is the length in characters. - * For datetime datatypes, this is the length in characters of the String representation (assuming the - * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, - * this is the length in bytes. Null is returned for data types where the - * column size is not applicable. - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema name pattern; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param tableNamePattern a table name pattern; must match the - * table name as it is stored in the database - * @param columnNamePattern a column name pattern; must match the column - * name as it is stored in the database - * @return <code>ResultSet</code> - each row is a column description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - */ - public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the access rights for a table's columns. - * <p/> - * <P>Only privileges matching the column name criteria are - * returned. They are ordered by COLUMN_NAME and PRIVILEGE. - * <p/> - * <P>Each privilige description has the following columns: - * <OL> - * <LI><B>TABLE_CAT</B> String => table catalog (may be <code>null</code>) - * <LI><B>TABLE_SCHEM</B> String => table schema (may be <code>null</code>) - * <LI><B>TABLE_NAME</B> String => table name - * <LI><B>COLUMN_NAME</B> String => column name - * <LI><B>GRANTOR</B> String => grantor of access (may be <code>null</code>) - * <LI><B>GRANTEE</B> String => grantee of access - * <LI><B>PRIVILEGE</B> String => name of access (SELECT, - * INSERT, UPDATE, REFRENCES, ...) - * <LI><B>IS_GRANTABLE</B> String => "YES" if grantee is permitted - * to grant to others; "NO" if not; <code>null</code> if unknown - * </OL> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schema a schema name; must match the schema name as it is - * stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param table a table name; must match the table name as it is - * stored in the database - * @param columnNamePattern a column name pattern; must match the column - * name as it is stored in the database - * @return <code>ResultSet</code> - each row is a column privilege description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - */ - public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the access rights for each table available - * in a catalog. Note that a table privilege applies to one or - * more columns in the table. It would be wrong to assume that - * this privilege applies to all columns (this may be true for - * some systems but is not true for all.) - * <p/> - * <P>Only privileges matching the schema and table name - * criteria are returned. They are ordered by - * <code>TABLE_CAT</code>, - * <code>TABLE_SCHEM</code>, <code>TABLE_NAME</code>, - * and <code>PRIVILEGE</code>. - * <p/> - * <P>Each privilige description has the following columns: - * <OL> - * <LI><B>TABLE_CAT</B> String => table catalog (may be <code>null</code>) - * <LI><B>TABLE_SCHEM</B> String => table schema (may be <code>null</code>) - * <LI><B>TABLE_NAME</B> String => table name - * <LI><B>GRANTOR</B> String => grantor of access (may be <code>null</code>) - * <LI><B>GRANTEE</B> String => grantee of access - * <LI><B>PRIVILEGE</B> String => name of access (SELECT, - * INSERT, UPDATE, REFRENCES, ...) - * <LI><B>IS_GRANTABLE</B> String => "YES" if grantee is permitted - * to grant to others; "NO" if not; <code>null</code> if unknown - * </OL> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema name pattern; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param tableNamePattern a table name pattern; must match the - * table name as it is stored in the database - * @return <code>ResultSet</code> - each row is a table privilege description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - */ - public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of a table's optimal set of columns that - * uniquely identifies a row. They are ordered by SCOPE. - * <p/> - * <P>Each column description has the following columns: - * <OL> - * <LI><B>SCOPE</B> short => actual scope of result - * <UL> - * <LI> bestRowTemporary - very temporary, while using row - * <LI> bestRowTransaction - valid for remainder of current transaction - * <LI> bestRowSession - valid for remainder of current session - * </UL> - * <LI><B>COLUMN_NAME</B> String => column name - * <LI><B>DATA_TYPE</B> int => SQL data type from java.sql.Types - * <LI><B>TYPE_NAME</B> String => Data source dependent type name, - * for a UDT the type name is fully qualified - * <LI><B>COLUMN_SIZE</B> int => precision - * <LI><B>BUFFER_LENGTH</B> int => not used - * <LI><B>DECIMAL_DIGITS</B> short => scale - Null is returned for data types where - * DECIMAL_DIGITS is not applicable. - * <LI><B>PSEUDO_COLUMN</B> short => is this a pseudo column - * like an Oracle ROWID - * <UL> - * <LI> bestRowUnknown - may or may not be pseudo column - * <LI> bestRowNotPseudo - is NOT a pseudo column - * <LI> bestRowPseudo - is a pseudo column - * </UL> - * </OL> - * <p/> - * <p>The COLUMN_SIZE column represents the specified column size for the given column. - * For numeric data, this is the maximum precision. For character data, this is the length in characters. - * For datetime datatypes, this is the length in characters of the String representation (assuming the - * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, - * this is the length in bytes. Null is returned for data types where the - * column size is not applicable. - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schema a schema name; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param table a table name; must match the table name as it is stored - * in the database - * @param scope the scope of interest; use same values as SCOPE - * @param nullable include columns that are nullable. - * @return <code>ResultSet</code> - each row is a column description - * @throws java.sql.SQLException if a database access error occurs - */ - public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of a table's columns that are automatically - * updated when any value in a row is updated. They are - * unordered. - * <p/> - * <P>Each column description has the following columns: - * <OL> - * <LI><B>SCOPE</B> short => is not used - * <LI><B>COLUMN_NAME</B> String => column name - * <LI><B>DATA_TYPE</B> int => SQL data type from <code>java.sql.Types</code> - * <LI><B>TYPE_NAME</B> String => Data source-dependent type name - * <LI><B>COLUMN_SIZE</B> int => precision - * <LI><B>BUFFER_LENGTH</B> int => length of column value in bytes - * <LI><B>DECIMAL_DIGITS</B> short => scale - Null is returned for data types where - * DECIMAL_DIGITS is not applicable. - * <LI><B>PSEUDO_COLUMN</B> short => whether this is pseudo column - * like an Oracle ROWID - * <UL> - * <LI> versionColumnUnknown - may or may not be pseudo column - * <LI> versionColumnNotPseudo - is NOT a pseudo column - * <LI> versionColumnPseudo - is a pseudo column - * </UL> - * </OL> - * <p/> - * <p>The COLUMN_SIZE column represents the specified column size for the given column. - * For numeric data, this is the maximum precision. For character data, this is the length in characters. - * For datetime datatypes, this is the length in characters of the String representation (assuming the - * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, - * this is the length in bytes. Null is returned for data types where the - * column size is not applicable. - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schema a schema name; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param table a table name; must match the table name as it is stored - * in the database - * @return a <code>ResultSet</code> object in which each row is a - * column description - * @throws java.sql.SQLException if a database access error occurs - */ - public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the given table's primary key columns. They - * are ordered by COLUMN_NAME. - * <p/> - * <P>Each primary key column description has the following columns: - * <OL> - * <LI><B>TABLE_CAT</B> String => table catalog (may be <code>null</code>) - * <LI><B>TABLE_SCHEM</B> String => table schema (may be <code>null</code>) - * <LI><B>TABLE_NAME</B> String => table name - * <LI><B>COLUMN_NAME</B> String => column name - * <LI><B>KEY_SEQ</B> short => sequence number within primary key( a value - * of 1 represents the first column of the primary key, a value of 2 would - * represent the second column within the primary key). - * <LI><B>PK_NAME</B> String => primary key name (may be <code>null</code>) - * </OL> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schema a schema name; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param table a table name; must match the table name as it is stored - * in the database - * @return <code>ResultSet</code> - each row is a primary key column description - * @throws java.sql.SQLException if a database access error occurs - */ - public ResultSet getPrimaryKeys(String catalog, String schema, String table) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the primary key columns that are - * referenced by the given table's foreign key columns (the primary keys - * imported by a table). They are ordered by PKTABLE_CAT, - * PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ. - * <p/> - * <P>Each primary key column description has the following columns: - * <OL> - * <LI><B>PKTABLE_CAT</B> String => primary key table catalog - * being imported (may be <code>null</code>) - * <LI><B>PKTABLE_SCHEM</B> String => primary key table schema - * being imported (may be <code>null</code>) - * <LI><B>PKTABLE_NAME</B> String => primary key table name - * being imported - * <LI><B>PKCOLUMN_NAME</B> String => primary key column name - * being imported - * <LI><B>FKTABLE_CAT</B> String => foreign key table catalog (may be <code>null</code>) - * <LI><B>FKTABLE_SCHEM</B> String => foreign key table schema (may be <code>null</code>) - * <LI><B>FKTABLE_NAME</B> String => foreign key table name - * <LI><B>FKCOLUMN_NAME</B> String => foreign key column name - * <LI><B>KEY_SEQ</B> short => sequence number within a foreign key( a value - * of 1 represents the first column of the foreign key, a value of 2 would - * represent the second column within the foreign key). - * <LI><B>UPDATE_RULE</B> short => What happens to a - * foreign key when the primary key is updated: - * <UL> - * <LI> importedNoAction - do not allow update of primary - * key if it has been imported - * <LI> importedKeyCascade - change imported key to agree - * with primary key update - * <LI> importedKeySetNull - change imported key to <code>NULL</code> - * if its primary key has been updated - * <LI> importedKeySetDefault - change imported key to default values - * if its primary key has been updated - * <LI> importedKeyRestrict - same as importedKeyNoAction - * (for ODBC 2.x compatibility) - * </UL> - * <LI><B>DELETE_RULE</B> short => What happens to - * the foreign key when primary is deleted. - * <UL> - * <LI> importedKeyNoAction - do not allow delete of primary - * key if it has been imported - * <LI> importedKeyCascade - delete rows that import a deleted key - * <LI> importedKeySetNull - change imported key to NULL if - * its primary key has been deleted - * <LI> importedKeyRestrict - same as importedKeyNoAction - * (for ODBC 2.x compatibility) - * <LI> importedKeySetDefault - change imported key to default if - * its primary key has been deleted - * </UL> - * <LI><B>FK_NAME</B> String => foreign key name (may be <code>null</code>) - * <LI><B>PK_NAME</B> String => primary key name (may be <code>null</code>) - * <LI><B>DEFERRABILITY</B> short => can the evaluation of foreign key - * constraints be deferred until commit - * <UL> - * <LI> importedKeyInitiallyDeferred - see SQL92 for definition - * <LI> importedKeyInitiallyImmediate - see SQL92 for definition - * <LI> importedKeyNotDeferrable - see SQL92 for definition - * </UL> - * </OL> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schema a schema name; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param table a table name; must match the table name as it is stored - * in the database - * @return <code>ResultSet</code> - each row is a primary key column description - * @throws java.sql.SQLException if a database access error occurs - * @see #getExportedKeys - */ - public ResultSet getImportedKeys(String catalog, String schema, String table) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the foreign key columns that reference the - * given table's primary key columns (the foreign keys exported by a - * table). They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, - * FKTABLE_NAME, and KEY_SEQ. - * <p/> - * <P>Each foreign key column description has the following columns: - * <OL> - * <LI><B>PKTABLE_CAT</B> String => primary key table catalog (may be <code>null</code>) - * <LI><B>PKTABLE_SCHEM</B> String => primary key table schema (may be <code>null</code>) - * <LI><B>PKTABLE_NAME</B> String => primary key table name - * <LI><B>PKCOLUMN_NAME</B> String => primary key column name - * <LI><B>FKTABLE_CAT</B> String => foreign key table catalog (may be <code>null</code>) - * being exported (may be <code>null</code>) - * <LI><B>FKTABLE_SCHEM</B> String => foreign key table schema (may be <code>null</code>) - * being exported (may be <code>null</code>) - * <LI><B>FKTABLE_NAME</B> String => foreign key table name - * being exported - * <LI><B>FKCOLUMN_NAME</B> String => foreign key column name - * being exported - * <LI><B>KEY_SEQ</B> short => sequence number within foreign key( a value - * of 1 represents the first column of the foreign key, a value of 2 would - * represent the second column within the foreign key). - * <LI><B>UPDATE_RULE</B> short => What happens to - * foreign key when primary is updated: - * <UL> - * <LI> importedNoAction - do not allow update of primary - * key if it has been imported - * <LI> importedKeyCascade - change imported key to agree - * with primary key update - * <LI> importedKeySetNull - change imported key to <code>NULL</code> if - * its primary key has been updated - * <LI> importedKeySetDefault - change imported key to default values - * if its primary key has been updated - * <LI> importedKeyRestrict - same as importedKeyNoAction - * (for ODBC 2.x compatibility) - * </UL> - * <LI><B>DELETE_RULE</B> short => What happens to - * the foreign key when primary is deleted. - * <UL> - * <LI> importedKeyNoAction - do not allow delete of primary - * key if it has been imported - * <LI> importedKeyCascade - delete rows that import a deleted key - * <LI> importedKeySetNull - change imported key to <code>NULL</code> if - * its primary key has been deleted - * <LI> importedKeyRestrict - same as importedKeyNoAction - * (for ODBC 2.x compatibility) - * <LI> importedKeySetDefault - change imported key to default if - * its primary key has been deleted - * </UL> - * <LI><B>FK_NAME</B> String => foreign key name (may be <code>null</code>) - * <LI><B>PK_NAME</B> String => primary key name (may be <code>null</code>) - * <LI><B>DEFERRABILITY</B> short => can the evaluation of foreign key - * constraints be deferred until commit - * <UL> - * <LI> importedKeyInitiallyDeferred - see SQL92 for definition - * <LI> importedKeyInitiallyImmediate - see SQL92 for definition - * <LI> importedKeyNotDeferrable - see SQL92 for definition - * </UL> - * </OL> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in this database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schema a schema name; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param table a table name; must match the table name as it is stored - * in this database - * @return a <code>ResultSet</code> object in which each row is a - * foreign key column description - * @throws java.sql.SQLException if a database access error occurs - * @see #getImportedKeys - */ - public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the foreign key columns in the given foreign key - * table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table). - * The number of columns returned from the parent table must match the number of - * columns that make up the foreign key. They - * are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and - * KEY_SEQ. - * <p/> - * <P>Each foreign key column description has the following columns: - * <OL> - * <LI><B>PKTABLE_CAT</B> String => parent key table catalog (may be <code>null</code>) - * <LI><B>PKTABLE_SCHEM</B> String => parent key table schema (may be <code>null</code>) - * <LI><B>PKTABLE_NAME</B> String => parent key table name - * <LI><B>PKCOLUMN_NAME</B> String => parent key column name - * <LI><B>FKTABLE_CAT</B> String => foreign key table catalog (may be <code>null</code>) - * being exported (may be <code>null</code>) - * <LI><B>FKTABLE_SCHEM</B> String => foreign key table schema (may be <code>null</code>) - * being exported (may be <code>null</code>) - * <LI><B>FKTABLE_NAME</B> String => foreign key table name - * being exported - * <LI><B>FKCOLUMN_NAME</B> String => foreign key column name - * being exported - * <LI><B>KEY_SEQ</B> short => sequence number within foreign key( a value - * of 1 represents the first column of the foreign key, a value of 2 would - * represent the second column within the foreign key). - * <LI><B>UPDATE_RULE</B> short => What happens to - * foreign key when parent key is updated: - * <UL> - * <LI> importedNoAction - do not allow update of parent - * key if it has been imported - * <LI> importedKeyCascade - change imported key to agree - * with parent key update - * <LI> importedKeySetNull - change imported key to <code>NULL</code> if - * its parent key has been updated - * <LI> importedKeySetDefault - change imported key to default values - * if its parent key has been updated - * <LI> importedKeyRestrict - same as importedKeyNoAction - * (for ODBC 2.x compatibility) - * </UL> - * <LI><B>DELETE_RULE</B> short => What happens to - * the foreign key when parent key is deleted. - * <UL> - * <LI> importedKeyNoAction - do not allow delete of parent - * key if it has been imported - * <LI> importedKeyCascade - delete rows that import a deleted key - * <LI> importedKeySetNull - change imported key to <code>NULL</code> if - * its primary key has been deleted - * <LI> importedKeyRestrict - same as importedKeyNoAction - * (for ODBC 2.x compatibility) - * <LI> importedKeySetDefault - change imported key to default if - * its parent key has been deleted - * </UL> - * <LI><B>FK_NAME</B> String => foreign key name (may be <code>null</code>) - * <LI><B>PK_NAME</B> String => parent key name (may be <code>null</code>) - * <LI><B>DEFERRABILITY</B> short => can the evaluation of foreign key - * constraints be deferred until commit - * <UL> - * <LI> importedKeyInitiallyDeferred - see SQL92 for definition - * <LI> importedKeyInitiallyImmediate - see SQL92 for definition - * <LI> importedKeyNotDeferrable - see SQL92 for definition - * </UL> - * </OL> - * - * @param parentCatalog a catalog name; must match the catalog name - * as it is stored in the database; "" retrieves those without a - * catalog; <code>null</code> means drop catalog name from the selection criteria - * @param parentSchema a schema name; must match the schema name as - * it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means drop schema name from the selection criteria - * @param parentTable the name of the table that exports the key; must match - * the table name as it is stored in the database - * @param foreignCatalog a catalog name; must match the catalog name as - * it is stored in the database; "" retrieves those without a - * catalog; <code>null</code> means drop catalog name from the selection criteria - * @param foreignSchema a schema name; must match the schema name as it - * is stored in the database; "" retrieves those without a schema; - * <code>null</code> means drop schema name from the selection criteria - * @param foreignTable the name of the table that imports the key; must match - * the table name as it is stored in the database - * @return <code>ResultSet</code> - each row is a foreign key column description - * @throws java.sql.SQLException if a database access error occurs - * @see #getImportedKeys - */ - public ResultSet getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of all the data types supported by - * this database. They are ordered by DATA_TYPE and then by how - * closely the data type maps to the corresponding JDBC SQL type. - * <p/> - * <P>If the database supports SQL distinct types, then getTypeInfo() will return - * a single row with a TYPE_NAME of DISTINCT and a DATA_TYPE of Types.DISTINCT. - * If the database supports SQL structured types, then getTypeInfo() will return - * a single row with a TYPE_NAME of STRUCT and a DATA_TYPE of Types.STRUCT. - * <p/> - * <P>If SQL distinct or structured types are supported, then information on the - * individual types may be obtained from the getUDTs() method. - * <p/> - * <p/> - * <p/> - * <P>Each type description has the following columns: - * <OL> - * <LI><B>TYPE_NAME</B> String => Type name - * <LI><B>DATA_TYPE</B> int => SQL data type from java.sql.Types - * <LI><B>PRECISION</B> int => maximum precision - * <LI><B>LITERAL_PREFIX</B> String => prefix used to quote a literal - * (may be <code>null</code>) - * <LI><B>LITERAL_SUFFIX</B> String => suffix used to quote a literal - * (may be <code>null</code>) - * <LI><B>CREATE_PARAMS</B> String => parameters used in creating - * the type (may be <code>null</code>) - * <LI><B>NULLABLE</B> short => can you use NULL for this type. - * <UL> - * <LI> typeNoNulls - does not allow NULL values - * <LI> typeNullable - allows NULL values - * <LI> typeNullableUnknown - nullability unknown - * </UL> - * <LI><B>CASE_SENSITIVE</B> boolean=> is it case sensitive. - * <LI><B>SEARCHABLE</B> short => can you use "WHERE" based on this type: - * <UL> - * <LI> typePredNone - No support - * <LI> typePredChar - Only supported with WHERE .. LIKE - * <LI> typePredBasic - Supported except for WHERE .. LIKE - * <LI> typeSearchable - Supported for all WHERE .. - * </UL> - * <LI><B>UNSIGNED_ATTRIBUTE</B> boolean => is it unsigned. - * <LI><B>FIXED_PREC_SCALE</B> boolean => can it be a money value. - * <LI><B>AUTO_INCREMENT</B> boolean => can it be used for an - * auto-increment value. - * <LI><B>LOCAL_TYPE_NAME</B> String => localized version of type name - * (may be <code>null</code>) - * <LI><B>MINIMUM_SCALE</B> short => minimum scale supported - * <LI><B>MAXIMUM_SCALE</B> short => maximum scale supported - * <LI><B>SQL_DATA_TYPE</B> int => unused - * <LI><B>SQL_DATETIME_SUB</B> int => unused - * <LI><B>NUM_PREC_RADIX</B> int => usually 2 or 10 - * </OL> - * <p/> - * <p>The PRECISION column represents the maximum column size that the server supports for the given datatype. - * For numeric data, this is the maximum precision. For character data, this is the length in characters. - * For datetime datatypes, this is the length in characters of the String representation (assuming the - * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, - * this is the length in bytes. Null is returned for data types where the - * column size is not applicable. - * - * @return a <code>ResultSet</code> object in which each row is an SQL - * type description - * @throws java.sql.SQLException if a database access error occurs - */ - public ResultSet getTypeInfo() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the given table's indices and statistics. They are - * ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION. - * <p/> - * <P>Each index column description has the following columns: - * <OL> - * <LI><B>TABLE_CAT</B> String => table catalog (may be <code>null</code>) - * <LI><B>TABLE_SCHEM</B> String => table schema (may be <code>null</code>) - * <LI><B>TABLE_NAME</B> String => table name - * <LI><B>NON_UNIQUE</B> boolean => Can index values be non-unique. - * false when TYPE is tableIndexStatistic - * <LI><B>INDEX_QUALIFIER</B> String => index catalog (may be <code>null</code>); - * <code>null</code> when TYPE is tableIndexStatistic - * <LI><B>INDEX_NAME</B> String => index name; <code>null</code> when TYPE is - * tableIndexStatistic - * <LI><B>TYPE</B> short => index type: - * <UL> - * <LI> tableIndexStatistic - this identifies table statistics that are - * returned in conjuction with a table's index descriptions - * <LI> tableIndexClustered - this is a clustered index - * <LI> tableIndexHashed - this is a hashed index - * <LI> tableIndexOther - this is some other style of index - * </UL> - * <LI><B>ORDINAL_POSITION</B> short => column sequence number - * within index; zero when TYPE is tableIndexStatistic - * <LI><B>COLUMN_NAME</B> String => column name; <code>null</code> when TYPE is - * tableIndexStatistic - * <LI><B>ASC_OR_DESC</B> String => column sort sequence, "A" => ascending, - * "D" => descending, may be <code>null</code> if sort sequence is not supported; - * <code>null</code> when TYPE is tableIndexStatistic - * <LI><B>CARDINALITY</B> int => When TYPE is tableIndexStatistic, then - * this is the number of rows in the table; otherwise, it is the - * number of unique values in the index. - * <LI><B>PAGES</B> int => When TYPE is tableIndexStatisic then - * this is the number of pages used for the table, otherwise it - * is the number of pages used for the current index. - * <LI><B>FILTER_CONDITION</B> String => Filter condition, if any. - * (may be <code>null</code>) - * </OL> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in this database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schema a schema name; must match the schema name - * as it is stored in this database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param table a table name; must match the table name as it is stored - * in this database - * @param unique when true, return only indices for unique values; - * when false, return indices regardless of whether unique or not - * @param approximate when true, result is allowed to reflect approximate - * or out of data values; when false, results are requested to be - * accurate - * @return <code>ResultSet</code> - each row is an index column description - * @throws java.sql.SQLException if a database access error occurs - */ - public ResultSet getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the given result set type. - * - * @param type defined in <code>java.sql.ResultSet</code> - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @see java.sql.Connection - * @since 1.2 - */ - public boolean supportsResultSetType(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the given concurrency type - * in combination with the given result set type. - * - * @param type defined in <code>java.sql.ResultSet</code> - * @param concurrency type defined in <code>java.sql.ResultSet</code> - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @see java.sql.Connection - * @since 1.2 - */ - public boolean supportsResultSetConcurrency(int type, int concurrency) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether for the given type of <code>ResultSet</code> object, - * the result set's own updates are visible. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if updates are visible for the given result set type; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean ownUpdatesAreVisible(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a result set's own deletes are visible. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if deletes are visible for the given result set type; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean ownDeletesAreVisible(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a result set's own inserts are visible. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if inserts are visible for the given result set type; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean ownInsertsAreVisible(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether updates made by others are visible. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if updates made by others - * are visible for the given result set type; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean othersUpdatesAreVisible(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether deletes made by others are visible. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if deletes made by others - * are visible for the given result set type; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean othersDeletesAreVisible(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether inserts made by others are visible. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if inserts made by others - * are visible for the given result set type; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean othersInsertsAreVisible(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether or not a visible row update can be detected by - * calling the method <code>ResultSet.rowUpdated</code>. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if changes are detected by the result set type; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean updatesAreDetected(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether or not a visible row delete can be detected by - * calling the method <code>ResultSet.rowDeleted</code>. If the method - * <code>deletesAreDetected</code> returns <code>false</code>, it means that - * deleted rows are removed from the result set. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if deletes are detected by the given result set type; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean deletesAreDetected(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether or not a visible row insert can be detected - * by calling the method <code>ResultSet.rowInserted</code>. - * - * @param type the <code>ResultSet</code> type; one of - * <code>ResultSet.TYPE_FORWARD_ONLY</code>, - * <code>ResultSet.TYPE_SCROLL_INSENSITIVE</code>, or - * <code>ResultSet.TYPE_SCROLL_SENSITIVE</code> - * @return <code>true</code> if changes are detected by the specified result - * set type; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean insertsAreDetected(int type) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports batch updates. - * - * @return <code>true</code> if this database supports batch upcates; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public boolean supportsBatchUpdates() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the user-defined types (UDTs) defined - * in a particular schema. Schema-specific UDTs may have type - * <code>JAVA_OBJECT</code>, <code>STRUCT</code>, - * or <code>DISTINCT</code>. - * <p/> - * <P>Only types matching the catalog, schema, type name and type - * criteria are returned. They are ordered by <code>DATA_TYPE</code>, - * <code>TYPE_CAT</code>, <code>TYPE_SCHEM</code> and - * <code>TYPE_NAME</code>. The type name parameter may be a fully-qualified - * name. In this case, the catalog and schemaPattern parameters are - * ignored. - * <p/> - * <P>Each type description has the following columns: - * <OL> - * <LI><B>TYPE_CAT</B> String => the type's catalog (may be <code>null</code>) - * <LI><B>TYPE_SCHEM</B> String => type's schema (may be <code>null</code>) - * <LI><B>TYPE_NAME</B> String => type name - * <LI><B>CLASS_NAME</B> String => Java class name - * <LI><B>DATA_TYPE</B> int => type value defined in java.sql.Types. - * One of JAVA_OBJECT, STRUCT, or DISTINCT - * <LI><B>REMARKS</B> String => explanatory comment on the type - * <LI><B>BASE_TYPE</B> short => type code of the source type of a - * DISTINCT type or the type that implements the user-generated - * reference type of the SELF_REFERENCING_COLUMN of a structured - * type as defined in java.sql.Types (<code>null</code> if DATA_TYPE is not - * DISTINCT or not STRUCT with REFERENCE_GENERATION = USER_DEFINED) - * </OL> - * <p/> - * <P><B>Note:</B> If the driver does not support UDTs, an empty - * result set is returned. - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema pattern name; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param typeNamePattern a type name pattern; must match the type name - * as it is stored in the database; may be a fully qualified name - * @param types a list of user-defined types (JAVA_OBJECT, - * STRUCT, or DISTINCT) to include; <code>null</code> returns all types - * @return <code>ResultSet</code> object in which each row describes a UDT - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - * @since 1.2 - */ - public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the connection that produced this metadata object. - * <p/> - * - * @return the connection that produced this metadata object - * @throws java.sql.SQLException if a database access error occurs - * @since 1.2 - */ - public Connection getConnection() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports savepoints. - * - * @return <code>true</code> if savepoints are supported; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public boolean supportsSavepoints() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports named parameters to callable - * statements. - * - * @return <code>true</code> if named parameters are supported; - * <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public boolean supportsNamedParameters() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether it is possible to have multiple <code>ResultSet</code> objects - * returned from a <code>CallableStatement</code> object - * simultaneously. - * - * @return <code>true</code> if a <code>CallableStatement</code> object - * can return multiple <code>ResultSet</code> objects - * simultaneously; <code>false</code> otherwise - * @throws java.sql.SQLException if a datanase access error occurs - * @since 1.4 - */ - public boolean supportsMultipleOpenResults() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether auto-generated keys can be retrieved after - * a statement has been executed - * - * @return <code>true</code> if auto-generated keys can be retrieved - * after a statement has executed; <code>false</code> otherwise - * <p>If <code>true</code> is returned, the JDBC driver must support the - * returning of auto-generated keys for at least SQL INSERT statements - * <p/> - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public boolean supportsGetGeneratedKeys() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the user-defined type (UDT) hierarchies defined in a - * particular schema in this database. Only the immediate super type/ - * sub type relationship is modeled. - * <p/> - * Only supertype information for UDTs matching the catalog, - * schema, and type name is returned. The type name parameter - * may be a fully-qualified name. When the UDT name supplied is a - * fully-qualified name, the catalog and schemaPattern parameters are - * ignored. - * <p/> - * If a UDT does not have a direct super type, it is not listed here. - * A row of the <code>ResultSet</code> object returned by this method - * describes the designated UDT and a direct supertype. A row has the following - * columns: - * <OL> - * <LI><B>TYPE_CAT</B> String => the UDT's catalog (may be <code>null</code>) - * <LI><B>TYPE_SCHEM</B> String => UDT's schema (may be <code>null</code>) - * <LI><B>TYPE_NAME</B> String => type name of the UDT - * <LI><B>SUPERTYPE_CAT</B> String => the direct super type's catalog - * (may be <code>null</code>) - * <LI><B>SUPERTYPE_SCHEM</B> String => the direct super type's schema - * (may be <code>null</code>) - * <LI><B>SUPERTYPE_NAME</B> String => the direct super type's name - * </OL> - * <p/> - * <P><B>Note:</B> If the driver does not support type hierarchies, an - * empty result set is returned. - * - * @param catalog a catalog name; "" retrieves those without a catalog; - * <code>null</code> means drop catalog name from the selection criteria - * @param schemaPattern a schema name pattern; "" retrieves those - * without a schema - * @param typeNamePattern a UDT name pattern; may be a fully-qualified - * name - * @return a <code>ResultSet</code> object in which a row gives information - * about the designated UDT - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - * @since 1.4 - */ - public ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the table hierarchies defined in a particular - * schema in this database. - * <p/> - * <P>Only supertable information for tables matching the catalog, schema - * and table name are returned. The table name parameter may be a fully- - * qualified name, in which case, the catalog and schemaPattern parameters - * are ignored. If a table does not have a super table, it is not listed here. - * Supertables have to be defined in the same catalog and schema as the - * sub tables. Therefore, the type description does not need to include - * this information for the supertable. - * <p/> - * <P>Each type description has the following columns: - * <OL> - * <LI><B>TABLE_CAT</B> String => the type's catalog (may be <code>null</code>) - * <LI><B>TABLE_SCHEM</B> String => type's schema (may be <code>null</code>) - * <LI><B>TABLE_NAME</B> String => type name - * <LI><B>SUPERTABLE_NAME</B> String => the direct super type's name - * </OL> - * <p/> - * <P><B>Note:</B> If the driver does not support type hierarchies, an - * empty result set is returned. - * - * @param catalog a catalog name; "" retrieves those without a catalog; - * <code>null</code> means drop catalog name from the selection criteria - * @param schemaPattern a schema name pattern; "" retrieves those - * without a schema - * @param tableNamePattern a table name pattern; may be a fully-qualified - * name - * @return a <code>ResultSet</code> object in which each row is a type description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - * @since 1.4 - */ - public ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the given attribute of the given type - * for a user-defined type (UDT) that is available in the given schema - * and catalog. - * <p/> - * Descriptions are returned only for attributes of UDTs matching the - * catalog, schema, type, and attribute name criteria. They are ordered by - * <code>TYPE_CAT</code>, <code>TYPE_SCHEM</code>, - * <code>TYPE_NAME</code> and <code>ORDINAL_POSITION</code>. This description - * does not contain inherited attributes. - * <p/> - * The <code>ResultSet</code> object that is returned has the following - * columns: - * <OL> - * <LI><B>TYPE_CAT</B> String => type catalog (may be <code>null</code>) - * <LI><B>TYPE_SCHEM</B> String => type schema (may be <code>null</code>) - * <LI><B>TYPE_NAME</B> String => type name - * <LI><B>ATTR_NAME</B> String => attribute name - * <LI><B>DATA_TYPE</B> int => attribute type SQL type from java.sql.Types - * <LI><B>ATTR_TYPE_NAME</B> String => Data source dependent type name. - * For a UDT, the type name is fully qualified. For a REF, the type name is - * fully qualified and represents the target type of the reference type. - * <LI><B>ATTR_SIZE</B> int => column size. For char or date - * types this is the maximum number of characters; for numeric or - * decimal types this is precision. - * <LI><B>DECIMAL_DIGITS</B> int => the number of fractional digits. Null is returned for data types where - * DECIMAL_DIGITS is not applicable. - * <LI><B>NUM_PREC_RADIX</B> int => Radix (typically either 10 or 2) - * <LI><B>NULLABLE</B> int => whether NULL is allowed - * <UL> - * <LI> attributeNoNulls - might not allow NULL values - * <LI> attributeNullable - definitely allows NULL values - * <LI> attributeNullableUnknown - nullability unknown - * </UL> - * <LI><B>REMARKS</B> String => comment describing column (may be <code>null</code>) - * <LI><B>ATTR_DEF</B> String => default value (may be <code>null</code>) - * <LI><B>SQL_DATA_TYPE</B> int => unused - * <LI><B>SQL_DATETIME_SUB</B> int => unused - * <LI><B>CHAR_OCTET_LENGTH</B> int => for char types the - * maximum number of bytes in the column - * <LI><B>ORDINAL_POSITION</B> int => index of the attribute in the UDT - * (starting at 1) - * <LI><B>IS_NULLABLE</B> String => ISO rules are used to determine - * the nullability for a attribute. - * <UL> - * <LI> YES --- if the attribute can include NULLs - * <LI> NO --- if the attribute cannot include NULLs - * <LI> empty string --- if the nullability for the - * attribute is unknown - * </UL> - * <LI><B>SCOPE_CATALOG</B> String => catalog of table that is the - * scope of a reference attribute (<code>null</code> if DATA_TYPE isn't REF) - * <LI><B>SCOPE_SCHEMA</B> String => schema of table that is the - * scope of a reference attribute (<code>null</code> if DATA_TYPE isn't REF) - * <LI><B>SCOPE_TABLE</B> String => table name that is the scope of a - * reference attribute (<code>null</code> if the DATA_TYPE isn't REF) - * <LI><B>SOURCE_DATA_TYPE</B> short => source type of a distinct type or user-generated - * Ref type,SQL type from java.sql.Types (<code>null</code> if DATA_TYPE - * isn't DISTINCT or user-generated REF) - * </OL> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema name pattern; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param typeNamePattern a type name pattern; must match the - * type name as it is stored in the database - * @param attributeNamePattern an attribute name pattern; must match the attribute - * name as it is declared in the database - * @return a <code>ResultSet</code> object in which each row is an - * attribute description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - * @since 1.4 - */ - public ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports the given result set holdability. - * - * @param holdability one of the following constants: - * <code>ResultSet.HOLD_CURSORS_OVER_COMMIT</code> or - * <code>ResultSet.CLOSE_CURSORS_AT_COMMIT<code> - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @see java.sql.Connection - * @since 1.4 - */ - public boolean supportsResultSetHoldability(int holdability) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves this database's default holdability for <code>ResultSet</code> - * objects. - * - * @return the default holdability; either - * <code>ResultSet.HOLD_CURSORS_OVER_COMMIT</code> or - * <code>ResultSet.CLOSE_CURSORS_AT_COMMIT</code> - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public int getResultSetHoldability() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the major version number of the underlying database. - * - * @return the underlying database's major version - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public int getDatabaseMajorVersion() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the minor version number of the underlying database. - * - * @return underlying database's minor version - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public int getDatabaseMinorVersion() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the major JDBC version number for this - * driver. - * - * @return JDBC version major number - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public int getJDBCMajorVersion() throws SQLException - { - return jdbcVersion; - } - - /** - * Retrieves the minor JDBC version number for this - * driver. - * - * @return JDBC version minor number - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public int getJDBCMinorVersion() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Indicates whether the SQLSTATE returned by <code>SQLException.getSQLState</code> - * is X/Open (now known as Open Group) SQL CLI or SQL:2003. - * - * @return the type of SQLSTATE; one of: - * sqlStateXOpen or - * sqlStateSQL - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public int getSQLStateType() throws SQLException - { - return 0; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Indicates whether updates made to a LOB are made on a copy or directly - * to the LOB. - * - * @return <code>true</code> if updates are made to a copy of the LOB; - * <code>false</code> if updates are made directly to the LOB - * @throws java.sql.SQLException if a database access error occurs - * @since 1.4 - */ - public boolean locatorsUpdateCopy() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports statement pooling. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws SQLExcpetion if a database access error occurs - * @since 1.4 - */ - public boolean supportsStatementPooling() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Indicates whether or not this data source supports the SQL <code>ROWID</code> type, - * and if so the lifetime for which a <code>RowId</code> object remains valid. - * <p/> - * The returned int values have the following relationship: - * <pre> - * ROWID_UNSUPPORTED < ROWID_VALID_OTHER < ROWID_VALID_TRANSACTION - * < ROWID_VALID_SESSION < ROWID_VALID_FOREVER - * </pre> - * so conditional logic such as - * <pre> - * if (metadata.getRowIdLifetime() > DatabaseMetaData.ROWID_VALID_TRANSACTION) - * </pre> - * can be used. Valid Forever means valid across all Sessions, and valid for - * a Session means valid across all its contained Transactions. - * - * @return the status indicating the lifetime of a <code>RowId</code> - * @throws java.sql.SQLException if a database access error occurs - * @since 1.6 - */ - public RowIdLifetime getRowIdLifetime() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves the schema names available in this database. The results - * are ordered by <code>TABLE_CATALOG</code> and - * <code>TABLE_SCHEM</code>. - * <p/> - * <P>The schema columns are: - * <OL> - * <LI><B>TABLE_SCHEM</B> String => schema name - * <LI><B>TABLE_CATALOG</B> String => catalog name (may be <code>null</code>) - * </OL> - * - * @param catalog a catalog name; must match the catalog name as it is stored - * in the database;"" retrieves those without a catalog; null means catalog - * name should not be used to narrow down the search. - * @param schemaPattern a schema name; must match the schema name as it is - * stored in the database; null means - * schema name should not be used to narrow down the search. - * @return a <code>ResultSet</code> object in which each row is a - * schema description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - * @since 1.6 - */ - public ResultSet getSchemas(String catalog, String schemaPattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether this database supports invoking user-defined or vendor functions - * using the stored procedure escape syntax. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.6 - */ - public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves whether a <code>SQLException</code> while autoCommit is <code>true</code> inidcates - * that all open ResultSets are closed, even ones that are holdable. When a <code>SQLException</code> occurs while - * autocommit is <code>true</code>, it is vendor specific whether the JDBC driver responds with a commit operation, a - * rollback operation, or by doing neither a commit nor a rollback. A potential result of this difference - * is in whether or not holdable ResultSets are closed. - * - * @return <code>true</code> if so; <code>false</code> otherwise - * @throws java.sql.SQLException if a database access error occurs - * @since 1.6 - */ - public boolean autoCommitFailureClosesAllResultSets() throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a list of the client info properties - * that the driver supports. The result set contains the following columns - * <p/> - * <ol> - * <li><b>NAME</b> String=> The name of the client info property<br> - * <li><b>MAX_LEN</b> int=> The maximum length of the value for the property<br> - * <li><b>DEFAULT_VALUE</b> String=> The default value of the property<br> - * <li><b>DESCRIPTION</b> String=> A description of the property. This will typically - * contain information as to where this property is - * stored in the database. - * </ol> - * <p/> - * The <code>ResultSet</code> is sorted by the NAME column - * <p/> - * - * @throws java.sql.SQLException if a database access error occurs - * <p/> - * @return A <code>ResultSet</code> object; each row is a supported client info - * property - * <p/> - * @since 1.6 - */ - public ResultSet getClientInfoProperties() throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the system and user functions available - * in the given catalog. - * <p/> - * Only system and user function descriptions matching the schema and - * function name criteria are returned. They are ordered by - * <code>FUNCTION_CAT</code>, <code>FUNCTION_SCHEM</code>, - * <code>FUNCTION_NAME</code> and - * <code>SPECIFIC_ NAME</code>. - * <p/> - * <P>Each function description has the the following columns: - * <OL> - * <LI><B>FUNCTION_CAT</B> String => function catalog (may be <code>null</code>) - * <LI><B>FUNCTION_SCHEM</B> String => function schema (may be <code>null</code>) - * <LI><B>FUNCTION_NAME</B> String => function name. This is the name - * used to invoke the function - * <LI><B>REMARKS</B> String => explanatory comment on the function - * <LI><B>FUNCTION_TYPE</B> short => kind of function: - * <UL> - * <LI>functionResultUnknown - Cannot determine if a return value - * or table will be returned - * <LI> functionNoTable- Does not return a table - * <LI> functionReturnsTable - Returns a table - * </UL> - * <LI><B>SPECIFIC_NAME</B> String => the name which uniquely identifies - * this function within its schema. This is a user specified, or DBMS - * generated, name that may be different then the <code>FUNCTION_NAME</code> - * for example with overload functions - * </OL> - * <p/> - * A user may not have permission to execute any of the functions that are - * returned by <code>getFunctions</code> - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema name pattern; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param functionNamePattern a function name pattern; must match the - * function name as it is stored in the database - * @return <code>ResultSet</code> - each row is a function description - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - * @since 1.6 - */ - public ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Retrieves a description of the given catalog's system or user - * function parameters and return type. - * <p/> - * <P>Only descriptions matching the schema, function and - * parameter name criteria are returned. They are ordered by - * <code>FUNCTION_CAT</code>, <code>FUNCTION_SCHEM</code>, - * <code>FUNCTION_NAME</code> and - * <code>SPECIFIC_ NAME</code>. Within this, the return value, - * if any, is first. Next are the parameter descriptions in call - * order. The column descriptions follow in column number order. - * <p/> - * <P>Each row in the <code>ResultSet</code> - * is a parameter description, column description or - * return type description with the following fields: - * <OL> - * <LI><B>FUNCTION_CAT</B> String => function catalog (may be <code>null</code>) - * <LI><B>FUNCTION_SCHEM</B> String => function schema (may be <code>null</code>) - * <LI><B>FUNCTION_NAME</B> String => function name. This is the name - * used to invoke the function - * <LI><B>COLUMN_NAME</B> String => column/parameter name - * <LI><B>COLUMN_TYPE</B> Short => kind of column/parameter: - * <UL> - * <LI> functionColumnUnknown - nobody knows - * <LI> functionColumnIn - IN parameter - * <LI> functionColumnInOut - INOUT parameter - * <LI> functionColumnOut - OUT parameter - * <LI> functionColumnReturn - function return value - * <LI> functionColumnResult - Indicates that the parameter or column - * is a column in the <code>ResultSet</code> - * </UL> - * <LI><B>DATA_TYPE</B> int => SQL type from java.sql.Types - * <LI><B>TYPE_NAME</B> String => SQL type name, for a UDT type the - * type name is fully qualified - * <LI><B>PRECISION</B> int => precision - * <LI><B>LENGTH</B> int => length in bytes of data - * <LI><B>SCALE</B> short => scale - null is returned for data types where - * SCALE is not applicable. - * <LI><B>RADIX</B> short => radix - * <LI><B>NULLABLE</B> short => can it contain NULL. - * <UL> - * <LI> functionNoNulls - does not allow NULL values - * <LI> functionNullable - allows NULL values - * <LI> functionNullableUnknown - nullability unknown - * </UL> - * <LI><B>REMARKS</B> String => comment describing column/parameter - * <LI><B>CHAR_OCTET_LENGTH</B> int => the maximum length of binary - * and character based parameters or columns. For any other datatype the returned value - * is a NULL - * <LI><B>ORDINAL_POSITION</B> int => the ordinal position, starting - * from 1, for the input and output parameters. A value of 0 - * is returned if this row describes the function's return value. - * For result set columns, it is the - * ordinal position of the column in the result set starting from 1. - * <LI><B>IS_NULLABLE</B> String => ISO rules are used to determine - * the nullability for a parameter or column. - * <UL> - * <LI> YES --- if the parameter or column can include NULLs - * <LI> NO --- if the parameter or column cannot include NULLs - * <LI> empty string --- if the nullability for the - * parameter or column is unknown - * </UL> - * <LI><B>SPECIFIC_NAME</B> String => the name which uniquely identifies - * this function within its schema. This is a user specified, or DBMS - * generated, name that may be different then the <code>FUNCTION_NAME</code> - * for example with overload functions - * </OL> - * <p/> - * <p>The PRECISION column represents the specified column size for the given - * parameter or column. - * For numeric data, this is the maximum precision. For character data, this is the length in characters. - * For datetime datatypes, this is the length in characters of the String representation (assuming the - * maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, - * this is the length in bytes. Null is returned for data types where the - * column size is not applicable. - * - * @param catalog a catalog name; must match the catalog name as it - * is stored in the database; "" retrieves those without a catalog; - * <code>null</code> means that the catalog name should not be used to narrow - * the search - * @param schemaPattern a schema name pattern; must match the schema name - * as it is stored in the database; "" retrieves those without a schema; - * <code>null</code> means that the schema name should not be used to narrow - * the search - * @param functionNamePattern a procedure name pattern; must match the - * function name as it is stored in the database - * @param columnNamePattern a parameter name pattern; must match the - * parameter or column name as it is stored in the database - * @return <code>ResultSet</code> - each row describes a - * user function parameter, column or return type - * @throws java.sql.SQLException if a database access error occurs - * @see #getSearchStringEscape - * @since 1.6 - */ - public ResultSet getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Returns an object that implements the given interface to allow access to - * non-standard methods, or standard methods not exposed by the proxy. - * <p/> - * If the receiver implements the interface then the result is the receiver - * or a proxy for the receiver. If the receiver is a wrapper - * and the wrapped object implements the interface then the result is the - * wrapped object or a proxy for the wrapped object. Otherwise return the - * the result of calling <code>unwrap</code> recursively on the wrapped object - * or a proxy for that result. If the receiver is not a - * wrapper and does not implement the interface, then an <code>SQLException</code> is thrown. - * - * @param iface A Class defining an interface that the result must implement. - * @return an object that implements the interface. May be a proxy for the actual implementing object. - * @throws java.sql.SQLException If no object found that implements the interface - * @since 1.6 - */ - public <T> T unwrap(Class<T> iface) throws SQLException - { - return null; //To change body of implemented methods use File | Settings | File Templates. - } - - /** - * Returns true if this either implements the interface argument or is directly or indirectly a wrapper - * for an object that does. Returns false otherwise. If this implements the interface then return true, - * else if this is a wrapper then return the result of recursively calling <code>isWrapperFor</code> on the wrapped - * object. If this does not implement the interface and is not a wrapper, return false. - * This method should be implemented as a low-cost operation compared to <code>unwrap</code> so that - * callers can use this method to avoid expensive <code>unwrap</code> calls that may fail. If this method - * returns true then calling <code>unwrap</code> with the same argument should succeed. - * - * @param iface a Class defining an interface. - * @return true if this implements the interface or directly or indirectly wraps an object that does. - * @throws java.sql.SQLException if an error occurs while determining whether this is a wrapper - * for an object with the given interface. - * @since 1.6 - */ - public boolean isWrapperFor(Class<?> iface) throws SQLException - { - return false; //To change body of implemented methods use File | Settings | File Templates. - } - } - }