diff options
Diffstat (limited to 'src/interfaces/jdbc/org/postgresql/jdbc3/AbstractJdbc3Statement.java')
| -rw-r--r-- | src/interfaces/jdbc/org/postgresql/jdbc3/AbstractJdbc3Statement.java | 1374 |
1 files changed, 0 insertions, 1374 deletions
diff --git a/src/interfaces/jdbc/org/postgresql/jdbc3/AbstractJdbc3Statement.java b/src/interfaces/jdbc/org/postgresql/jdbc3/AbstractJdbc3Statement.java deleted file mode 100644 index 742b6f3757..0000000000 --- a/src/interfaces/jdbc/org/postgresql/jdbc3/AbstractJdbc3Statement.java +++ /dev/null @@ -1,1374 +0,0 @@ -package org.postgresql.jdbc3; - - -import java.math.BigDecimal; -import java.sql.*; -import java.util.Calendar; - -/* $PostgreSQL: pgsql/src/interfaces/jdbc/org/postgresql/jdbc3/AbstractJdbc3Statement.java,v 1.4 2003/11/29 19:52:11 pgsql Exp $ - * This class defines methods of the jdbc3 specification. This class extends - * org.postgresql.jdbc2.AbstractJdbc2Statement which provides the jdbc2 - * methods. The real Statement class (for jdbc2) is org.postgresql.jdbc3.Jdbc3Statement - */ -public abstract class AbstractJdbc3Statement extends org.postgresql.jdbc2.AbstractJdbc2Statement -{ - - public AbstractJdbc3Statement (AbstractJdbc3Connection c) - { - super(c); - } - - public AbstractJdbc3Statement(AbstractJdbc3Connection connection, String sql) throws SQLException - { - super(connection, sql); - } - - /** - * Moves to this <code>Statement</code> object's next result, deals with - * any current <code>ResultSet</code> object(s) according to the instructions - * specified by the given flag, and returns - * <code>true</code> if the next result is a <code>ResultSet</code> object. - * - * <P>There are no more results when the following is true: - * <PRE> - * <code>(!getMoreResults() && (getUpdateCount() == -1)</code> - * </PRE> - * - * @param current one of the following <code>Statement</code> - * constants indicating what should happen to current - * <code>ResultSet</code> objects obtained using the method - * <code>getResultSet</code: - * <code>CLOSE_CURRENT_RESULT</code>, - * <code>KEEP_CURRENT_RESULT</code>, or - * <code>CLOSE_ALL_RESULTS</code> - * @return <code>true</code> if the next result is a <code>ResultSet</code> - * object; <code>false</code> if it is an update count or there are no - * more results - * @exception SQLException if a database access error occurs - * @since 1.4 - * @see #execute - */ - public boolean getMoreResults(int current) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves any auto-generated keys created as a result of executing this - * <code>Statement</code> object. If this <code>Statement</code> object did - * not generate any keys, an empty <code>ResultSet</code> - * object is returned. - * - * @return a <code>ResultSet</code> object containing the auto-generated key(s) - * generated by the execution of this <code>Statement</code> object - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public ResultSet getGeneratedKeys() throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Executes the given SQL statement and signals the driver with the - * given flag about whether the - * auto-generated keys produced by this <code>Statement</code> object - * should be made available for retrieval. - * - * @param sql must be an SQL <code>INSERT</code>, <code>UPDATE</code> or - * <code>DELETE</code> statement or an SQL statement that - * returns nothing - * @param autoGeneratedKeys a flag indicating whether auto-generated keys - * should be made available for retrieval; - * one of the following constants: - * <code>Statement.RETURN_GENERATED_KEYS</code> - * <code>Statement.NO_GENERATED_KEYS</code> - * @return either the row count for <code>INSERT</code>, <code>UPDATE</code> - * or <code>DELETE</code> statements, or <code>0</code> for SQL - * statements that return nothing - * @exception SQLException if a database access error occurs, the given - * SQL statement returns a <code>ResultSet</code> object, or - * the given constant is not one of those allowed - * @since 1.4 - */ - public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Executes the given SQL statement and signals the driver that the - * auto-generated keys indicated in the given array should be made available - * for retrieval. The driver will ignore the array if the SQL statement - * is not an <code>INSERT</code> statement. - * - * @param sql an SQL <code>INSERT</code>, <code>UPDATE</code> or - * <code>DELETE</code> statement or an SQL statement that returns nothing, - * such as an SQL DDL statement - * @param columnIndexes an array of column indexes indicating the columns - * that should be returned from the inserted row - * @return either the row count for <code>INSERT</code>, <code>UPDATE</code>, - * or <code>DELETE</code> statements, or 0 for SQL statements - * that return nothing - * @exception SQLException if a database access error occurs or the SQL - * statement returns a <code>ResultSet</code> object - * @since 1.4 - */ - public int executeUpdate(String sql, int columnIndexes[]) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Executes the given SQL statement and signals the driver that the - * auto-generated keys indicated in the given array should be made available - * for retrieval. The driver will ignore the array if the SQL statement - * is not an <code>INSERT</code> statement. - * - * @param sql an SQL <code>INSERT</code>, <code>UPDATE</code> or - * <code>DELETE</code> statement or an SQL statement that returns nothing - * @param columnNames an array of the names of the columns that should be - * returned from the inserted row - * @return either the row count for <code>INSERT</code>, <code>UPDATE</code>, - * or <code>DELETE</code> statements, or 0 for SQL statements - * that return nothing - * @exception SQLException if a database access error occurs - * - * @since 1.4 - */ - public int executeUpdate(String sql, String columnNames[]) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Executes the given SQL statement, which may return multiple results, - * and signals the driver that any - * auto-generated keys should be made available - * for retrieval. The driver will ignore this signal if the SQL statement - * is not an <code>INSERT</code> statement. - * <P> - * In some (uncommon) situations, a single SQL statement may return - * multiple result sets and/or update counts. Normally you can ignore - * this unless you are (1) executing a stored procedure that you know may - * return multiple results or (2) you are dynamically executing an - * unknown SQL string. - * <P> - * The <code>execute</code> method executes an SQL statement and indicates the - * form of the first result. You must then use the methods - * <code>getResultSet</code> or <code>getUpdateCount</code> - * to retrieve the result, and <code>getMoreResults</code> to - * move to any subsequent result(s). - * - * @param sql any SQL statement - * @param autoGeneratedKeys a constant indicating whether auto-generated - * keys should be made available for retrieval using the method - * <code>getGeneratedKeys</code>; one of the following constants: - * <code>Statement.RETURN_GENERATED_KEYS</code> or - * <code>Statement.NO_GENERATED_KEYS</code> - * @return <code>true</code> if the first result is a <code>ResultSet</code> - * object; <code>false</code> if it is an update count or there are - * no results - * @exception SQLException if a database access error occurs - * @see #getResultSet - * @see #getUpdateCount - * @see #getMoreResults - * @see #getGeneratedKeys - * - * @since 1.4 - */ - public boolean execute(String sql, int autoGeneratedKeys) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Executes the given SQL statement, which may return multiple results, - * and signals the driver that the - * auto-generated keys indicated in the given array should be made available - * for retrieval. This array contains the indexes of the columns in the - * target table that contain the auto-generated keys that should be made - * available. The driver will ignore the array if the given SQL statement - * is not an <code>INSERT</code> statement. - * <P> - * Under some (uncommon) situations, a single SQL statement may return - * multiple result sets and/or update counts. Normally you can ignore - * this unless you are (1) executing a stored procedure that you know may - * return multiple results or (2) you are dynamically executing an - * unknown SQL string. - * <P> - * The <code>execute</code> method executes an SQL statement and indicates the - * form of the first result. You must then use the methods - * <code>getResultSet</code> or <code>getUpdateCount</code> - * to retrieve the result, and <code>getMoreResults</code> to - * move to any subsequent result(s). - * - * @param sql any SQL statement - * @param columnIndexes an array of the indexes of the columns in the - * inserted row that should be made available for retrieval by a - * call to the method <code>getGeneratedKeys</code> - * @return <code>true</code> if the first result is a <code>ResultSet</code> - * object; <code>false</code> if it is an update count or there - * are no results - * @exception SQLException if a database access error occurs - * @see #getResultSet - * @see #getUpdateCount - * @see #getMoreResults - * - * @since 1.4 - */ - public boolean execute(String sql, int columnIndexes[]) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Executes the given SQL statement, which may return multiple results, - * and signals the driver that the - * auto-generated keys indicated in the given array should be made available - * for retrieval. This array contains the names of the columns in the - * target table that contain the auto-generated keys that should be made - * available. The driver will ignore the array if the given SQL statement - * is not an <code>INSERT</code> statement. - * <P> - * In some (uncommon) situations, a single SQL statement may return - * multiple result sets and/or update counts. Normally you can ignore - * this unless you are (1) executing a stored procedure that you know may - * return multiple results or (2) you are dynamically executing an - * unknown SQL string. - * <P> - * The <code>execute</code> method executes an SQL statement and indicates the - * form of the first result. You must then use the methods - * <code>getResultSet</code> or <code>getUpdateCount</code> - * to retrieve the result, and <code>getMoreResults</code> to - * move to any subsequent result(s). - * - * @param sql any SQL statement - * @param columnNames an array of the names of the columns in the inserted - * row that should be made available for retrieval by a call to the - * method <code>getGeneratedKeys</code> - * @return <code>true</code> if the next result is a <code>ResultSet</code> - * object; <code>false</code> if it is an update count or there - * are no more results - * @exception SQLException if a database access error occurs - * @see #getResultSet - * @see #getUpdateCount - * @see #getMoreResults - * @see #getGeneratedKeys - * - * @since 1.4 - */ - public boolean execute(String sql, String columnNames[]) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the result set holdability for <code>ResultSet</code> objects - * generated by this <code>Statement</code> object. - * - * @return either <code>ResultSet.HOLD_CURSORS_OVER_COMMIT</code> or - * <code>ResultSet.CLOSE_CURSORS_AT_COMMIT</code> - * @exception SQLException if a database access error occurs - * - * @since 1.4 - */ - public int getResultSetHoldability() throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given <code>java.net.URL</code> value. - * The driver converts this to an SQL <code>DATALINK</code> value - * when it sends it to the database. - * - * @param parameterIndex the first parameter is 1, the second is 2, ... - * @param x the <code>java.net.URL</code> object to be set - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public void setURL(int parameterIndex, java.net.URL x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the number, types and properties of this - * <code>PreparedStatement</code> object's parameters. - * - * @return a <code>ParameterMetaData</code> object that contains information - * about the number, types and properties of this - * <code>PreparedStatement</code> object's parameters - * @exception SQLException if a database access error occurs - * @see ParameterMetaData - * @since 1.4 - */ - public ParameterMetaData getParameterMetaData() throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Registers the OUT parameter named - * <code>parameterName</code> to the JDBC type - * <code>sqlType</code>. All OUT parameters must be registered - * before a stored procedure is executed. - * <p> - * The JDBC type specified by <code>sqlType</code> for an OUT - * parameter determines the Java type that must be used - * in the <code>get</code> method to read the value of that parameter. - * <p> - * If the JDBC type expected to be returned to this output parameter - * is specific to this particular database, <code>sqlType</code> - * should be <code>java.sql.Types.OTHER</code>. The method - * {@link #getObject} retrieves the value. - * @param parameterName the name of the parameter - * @param sqlType the JDBC type code defined by <code>java.sql.Types</code>. - * If the parameter is of JDBC type <code>NUMERIC</code> - * or <code>DECIMAL</code>, the version of - * <code>registerOutParameter</code> that accepts a scale value - * should be used. - * @exception SQLException if a database access error occurs - * @since 1.4 - * @see Types - */ - public void registerOutParameter(String parameterName, int sqlType) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Registers the parameter named - * <code>parameterName</code> to be of JDBC type - * <code>sqlType</code>. This method must be called - * before a stored procedure is executed. - * <p> - * The JDBC type specified by <code>sqlType</code> for an OUT - * parameter determines the Java type that must be used - * in the <code>get</code> method to read the value of that parameter. - * <p> - * This version of <code>registerOutParameter</code> should be - * used when the parameter is of JDBC type <code>NUMERIC</code> - * or <code>DECIMAL</code>. - * @param parameterName the name of the parameter - * @param sqlType SQL type code defined by <code>java.sql.Types</code>. - * @param scale the desired number of digits to the right of the - * decimal point. It must be greater than or equal to zero. - * @exception SQLException if a database access error occurs - * @since 1.4 - * @see Types - */ - public void registerOutParameter(String parameterName, int sqlType, int scale) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Registers the designated output parameter. This version of - * the method <code>registerOutParameter</code> - * should be used for a user-named or REF output parameter. Examples - * of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and - * named array types. - * - * Before executing a stored procedure call, you must explicitly - * call <code>registerOutParameter</code> to register the type from - * <code>java.sql.Types</code> for each - * OUT parameter. For a user-named parameter the fully-qualified SQL - * type name of the parameter should also be given, while a REF - * parameter requires that the fully-qualified type name of the - * referenced type be given. A JDBC driver that does not need the - * type code and type name information may ignore it. To be portable, - * however, applications should always provide these values for - * user-named and REF parameters. - * - * Although it is intended for user-named and REF parameters, - * this method may be used to register a parameter of any JDBC type. - * If the parameter does not have a user-named or REF type, the - * typeName parameter is ignored. - * - * <P><B>Note:</B> When reading the value of an out parameter, you - * must use the <code>getXXX</code> method whose Java type XXX corresponds to the - * parameter's registered SQL type. - * - * @param parameterName the name of the parameter - * @param sqlType a value from {@link java.sql.Types} - * @param typeName the fully-qualified name of an SQL structured type - * @exception SQLException if a database access error occurs - * @see Types - * @since 1.4 - */ - public void registerOutParameter (String parameterName, int sqlType, String typeName) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of the designated JDBC <code>DATALINK</code> parameter as a - * <code>java.net.URL</code> object. - * - * @param parameterIndex the first parameter is 1, the second is 2,... - * @return a <code>java.net.URL</code> object that represents the - * JDBC <code>DATALINK</code> value used as the designated - * parameter - * @exception SQLException if a database access error occurs, - * or if the URL being returned is - * not a valid URL on the Java platform - * @see #setURL - * @since 1.4 - */ - public java.net.URL getURL(int parameterIndex) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given <code>java.net.URL</code> object. - * The driver converts this to an SQL <code>DATALINK</code> value when - * it sends it to the database. - * - * @param parameterName the name of the parameter - * @param val the parameter value - * @exception SQLException if a database access error occurs, - * or if a URL is malformed - * @see #getURL - * @since 1.4 - */ - public void setURL(String parameterName, java.net.URL val) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to SQL <code>NULL</code>. - * - * <P><B>Note:</B> You must specify the parameter's SQL type. - * - * @param parameterName the name of the parameter - * @param sqlType the SQL type code defined in <code>java.sql.Types</code> - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public void setNull(String parameterName, int sqlType) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java <code>boolean</code> value. - * The driver converts this - * to an SQL <code>BIT</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getBoolean - * @since 1.4 - */ - public void setBoolean(String parameterName, boolean x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java <code>byte</code> value. - * The driver converts this - * to an SQL <code>TINYINT</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getByte - * @since 1.4 - */ - public void setByte(String parameterName, byte x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java <code>short</code> value. - * The driver converts this - * to an SQL <code>SMALLINT</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getShort - * @since 1.4 - */ - public void setShort(String parameterName, short x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java <code>int</code> value. - * The driver converts this - * to an SQL <code>INTEGER</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getInt - * @since 1.4 - */ - public void setInt(String parameterName, int x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java <code>long</code> value. - * The driver converts this - * to an SQL <code>BIGINT</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getLong - * @since 1.4 - */ - public void setLong(String parameterName, long x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java <code>float</code> value. - * The driver converts this - * to an SQL <code>FLOAT</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getFloat - * @since 1.4 - */ - public void setFloat(String parameterName, float x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java <code>double</code> value. - * The driver converts this - * to an SQL <code>DOUBLE</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getDouble - * @since 1.4 - */ - public void setDouble(String parameterName, double x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given - * <code>java.math.BigDecimal</code> value. - * The driver converts this to an SQL <code>NUMERIC</code> value when - * it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getBigDecimal - * @since 1.4 - */ - public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java <code>String</code> value. - * The driver converts this - * to an SQL <code>VARCHAR</code> or <code>LONGVARCHAR</code> value - * (depending on the argument's - * size relative to the driver's limits on <code>VARCHAR</code> values) - * when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getString - * @since 1.4 - */ - public void setString(String parameterName, String x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given Java array of bytes. - * The driver converts this to an SQL <code>VARBINARY</code> or - * <code>LONGVARBINARY</code> (depending on the argument's size relative - * to the driver's limits on <code>VARBINARY</code> values) when it sends - * it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getBytes - * @since 1.4 - */ - public void setBytes(String parameterName, byte x[]) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given <code>java.sql.Date</code> value. - * The driver converts this - * to an SQL <code>DATE</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getDate - * @since 1.4 - */ - public void setDate(String parameterName, java.sql.Date x) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given <code>java.sql.Time</code> value. - * The driver converts this - * to an SQL <code>TIME</code> value when it sends it to the database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getTime - * @since 1.4 - */ - public void setTime(String parameterName, java.sql.Time x) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given <code>java.sql.Timestamp</code> value. - * The driver - * converts this to an SQL <code>TIMESTAMP</code> value when it sends it to the - * database. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @exception SQLException if a database access error occurs - * @see #getTimestamp - * @since 1.4 - */ - public void setTimestamp(String parameterName, java.sql.Timestamp x) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given input stream, which will have - * the specified number of bytes. - * When a very large ASCII value is input to a <code>LONGVARCHAR</code> - * parameter, it may be more practical to send it via a - * <code>java.io.InputStream</code>. Data will be read from the stream - * as needed until end-of-file is reached. The JDBC driver will - * do any necessary conversion from ASCII to the database char format. - * - * <P><B>Note:</B> This stream object can either be a standard - * Java stream object or your own subclass that implements the - * standard interface. - * - * @param parameterName the name of the parameter - * @param x the Java input stream that contains the ASCII parameter value - * @param length the number of bytes in the stream - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public void setAsciiStream(String parameterName, java.io.InputStream x, int length) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given input stream, which will have - * the specified number of bytes. - * When a very large binary value is input to a <code>LONGVARBINARY</code> - * parameter, it may be more practical to send it via a - * <code>java.io.InputStream</code> object. The data will be read from the stream - * as needed until end-of-file is reached. - * - * <P><B>Note:</B> This stream object can either be a standard - * Java stream object or your own subclass that implements the - * standard interface. - * - * @param parameterName the name of the parameter - * @param x the java input stream which contains the binary parameter value - * @param length the number of bytes in the stream - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public void setBinaryStream(String parameterName, java.io.InputStream x, - int length) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the value of the designated parameter with the given object. The second - * argument must be an object type; for integral values, the - * <code>java.lang</code> equivalent objects should be used. - * - * <p>The given Java object will be converted to the given targetSqlType - * before being sent to the database. - * - * If the object has a custom mapping (is of a class implementing the - * interface <code>SQLData</code>), - * the JDBC driver should call the method <code>SQLData.writeSQL</code> to write it - * to the SQL data stream. - * If, on the other hand, the object is of a class implementing - * <code>Ref</code>, <code>Blob</code>, <code>Clob</code>, <code>Struct</code>, - * or <code>Array</code>, the driver should pass it to the database as a - * value of the corresponding SQL type. - * <P> - * Note that this method may be used to pass datatabase- - * specific abstract data types. - * - * @param parameterName the name of the parameter - * @param x the object containing the input parameter value - * @param targetSqlType the SQL type (as defined in java.sql.Types) to be - * sent to the database. The scale argument may further qualify this type. - * @param scale for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, - * this is the number of digits after the decimal point. For all other - * types, this value will be ignored. - * @exception SQLException if a database access error occurs - * @see Types - * @see #getObject - * @since 1.4 - */ - public void setObject(String parameterName, Object x, int targetSqlType, int scale) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the value of the designated parameter with the given object. - * This method is like the method <code>setObject</code> - * above, except that it assumes a scale of zero. - * - * @param parameterName the name of the parameter - * @param x the object containing the input parameter value - * @param targetSqlType the SQL type (as defined in java.sql.Types) to be - * sent to the database - * @exception SQLException if a database access error occurs - * @see #getObject - * @since 1.4 - */ - public void setObject(String parameterName, Object x, int targetSqlType) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the value of the designated parameter with the given object. - * The second parameter must be of type <code>Object</code>; therefore, the - * <code>java.lang</code> equivalent objects should be used for built-in types. - * - * <p>The JDBC specification specifies a standard mapping from - * Java <code>Object</code> types to SQL types. The given argument - * will be converted to the corresponding SQL type before being - * sent to the database. - * - * <p>Note that this method may be used to pass datatabase- - * specific abstract data types, by using a driver-specific Java - * type. - * - * If the object is of a class implementing the interface <code>SQLData</code>, - * the JDBC driver should call the method <code>SQLData.writeSQL</code> - * to write it to the SQL data stream. - * If, on the other hand, the object is of a class implementing - * <code>Ref</code>, <code>Blob</code>, <code>Clob</code>, <code>Struct</code>, - * or <code>Array</code>, the driver should pass it to the database as a - * value of the corresponding SQL type. - * <P> - * This method throws an exception if there is an ambiguity, for example, if the - * object is of a class implementing more than one of the interfaces named above. - * - * @param parameterName the name of the parameter - * @param x the object containing the input parameter value - * @exception SQLException if a database access error occurs or if the given - * <code>Object</code> parameter is ambiguous - * @see #getObject - * @since 1.4 - */ - public void setObject(String parameterName, Object x) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - - /** - * Sets the designated parameter to the given <code>Reader</code> - * object, which is the given number of characters long. - * When a very large UNICODE value is input to a <code>LONGVARCHAR</code> - * parameter, it may be more practical to send it via a - * <code>java.io.Reader</code> object. The data will be read from the stream - * as needed until end-of-file is reached. The JDBC driver will - * do any necessary conversion from UNICODE to the database char format. - * - * <P><B>Note:</B> This stream object can either be a standard - * Java stream object or your own subclass that implements the - * standard interface. - * - * @param parameterName the name of the parameter - * @param reader the <code>java.io.Reader</code> object that - * contains the UNICODE data used as the designated parameter - * @param length the number of characters in the stream - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public void setCharacterStream(String parameterName, - java.io.Reader reader, - int length) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given <code>java.sql.Date</code> value, - * using the given <code>Calendar</code> object. The driver uses - * the <code>Calendar</code> object to construct an SQL <code>DATE</code> value, - * which the driver then sends to the database. With a - * a <code>Calendar</code> object, the driver can calculate the date - * taking into account a custom timezone. If no - * <code>Calendar</code> object is specified, the driver uses the default - * timezone, which is that of the virtual machine running the application. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @param cal the <code>Calendar</code> object the driver will use - * to construct the date - * @exception SQLException if a database access error occurs - * @see #getDate - * @since 1.4 - */ - public void setDate(String parameterName, java.sql.Date x, Calendar cal) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given <code>java.sql.Time</code> value, - * using the given <code>Calendar</code> object. The driver uses - * the <code>Calendar</code> object to construct an SQL <code>TIME</code> value, - * which the driver then sends to the database. With a - * a <code>Calendar</code> object, the driver can calculate the time - * taking into account a custom timezone. If no - * <code>Calendar</code> object is specified, the driver uses the default - * timezone, which is that of the virtual machine running the application. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @param cal the <code>Calendar</code> object the driver will use - * to construct the time - * @exception SQLException if a database access error occurs - * @see #getTime - * @since 1.4 - */ - public void setTime(String parameterName, java.sql.Time x, Calendar cal) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to the given <code>java.sql.Timestamp</code> value, - * using the given <code>Calendar</code> object. The driver uses - * the <code>Calendar</code> object to construct an SQL <code>TIMESTAMP</code> value, - * which the driver then sends to the database. With a - * a <code>Calendar</code> object, the driver can calculate the timestamp - * taking into account a custom timezone. If no - * <code>Calendar</code> object is specified, the driver uses the default - * timezone, which is that of the virtual machine running the application. - * - * @param parameterName the name of the parameter - * @param x the parameter value - * @param cal the <code>Calendar</code> object the driver will use - * to construct the timestamp - * @exception SQLException if a database access error occurs - * @see #getTimestamp - * @since 1.4 - */ - public void setTimestamp(String parameterName, java.sql.Timestamp x, Calendar cal) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Sets the designated parameter to SQL <code>NULL</code>. - * This version of the method <code>setNull</code> should - * be used for user-defined types and REF type parameters. Examples - * of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and - * named array types. - * - * <P><B>Note:</B> To be portable, applications must give the - * SQL type code and the fully-qualified SQL type name when specifying - * a NULL user-defined or REF parameter. In the case of a user-defined type - * the name is the type name of the parameter itself. For a REF - * parameter, the name is the type name of the referenced type. If - * a JDBC driver does not need the type code or type name information, - * it may ignore it. - * - * Although it is intended for user-defined and Ref parameters, - * this method may be used to set a null parameter of any JDBC type. - * If the parameter does not have a user-defined or REF type, the given - * typeName is ignored. - * - * - * @param paramName the name of the parameter - * @param sqlType a value from <code>java.sql.Types</code> - * @param typeName the fully-qualified name of an SQL user-defined type; - * ignored if the parameter is not a user-defined type or - * SQL <code>REF</code> value - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public void setNull (String parameterName, int sqlType, String typeName) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>CHAR</code>, <code>VARCHAR</code>, - * or <code>LONGVARCHAR</code> parameter as a <code>String</code> in - * the Java programming language. - * <p> - * For the fixed-length type JDBC <code>CHAR</code>, - * the <code>String</code> object - * returned has exactly the same value the JDBC - * <code>CHAR</code> value had in the - * database, including any padding added by the database. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, the result - * is <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setString - * @since 1.4 - */ - public String getString(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>BIT</code> parameter as a - * <code>boolean</code> in the Java programming language. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, the result - * is <code>false</code>. - * @exception SQLException if a database access error occurs - * @see #setBoolean - * @since 1.4 - */ - public boolean getBoolean(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>TINYINT</code> parameter as a <code>byte</code> - * in the Java programming language. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, the result - * is <code>0</code>. - * @exception SQLException if a database access error occurs - * @see #setByte - * @since 1.4 - */ - public byte getByte(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>SMALLINT</code> parameter as a <code>short</code> - * in the Java programming language. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, the result - * is <code>0</code>. - * @exception SQLException if a database access error occurs - * @see #setShort - * @since 1.4 - */ - public short getShort(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>INTEGER</code> parameter as an <code>int</code> - * in the Java programming language. - * - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, - * the result is <code>0</code>. - * @exception SQLException if a database access error occurs - * @see #setInt - * @since 1.4 - */ - public int getInt(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>BIGINT</code> parameter as a <code>long</code> - * in the Java programming language. - * - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, - * the result is <code>0</code>. - * @exception SQLException if a database access error occurs - * @see #setLong - * @since 1.4 - */ - public long getLong(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>FLOAT</code> parameter as a <code>float</code> - * in the Java programming language. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, - * the result is <code>0</code>. - * @exception SQLException if a database access error occurs - * @see #setFloat - * @since 1.4 - */ - public float getFloat(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>DOUBLE</code> parameter as a <code>double</code> - * in the Java programming language. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, - * the result is <code>0</code>. - * @exception SQLException if a database access error occurs - * @see #setDouble - * @since 1.4 - */ - public double getDouble(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>BINARY</code> or <code>VARBINARY</code> - * parameter as an array of <code>byte</code> values in the Java - * programming language. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, the result is - * <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setBytes - * @since 1.4 - */ - public byte[] getBytes(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>DATE</code> parameter as a - * <code>java.sql.Date</code> object. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, the result - * is <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setDate - * @since 1.4 - */ - public java.sql.Date getDate(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>TIME</code> parameter as a - * <code>java.sql.Time</code> object. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, the result - * is <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setTime - * @since 1.4 - */ - public java.sql.Time getTime(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>TIMESTAMP</code> parameter as a - * <code>java.sql.Timestamp</code> object. - * @param parameterName the name of the parameter - * @return the parameter value. If the value is SQL <code>NULL</code>, the result - * is <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setTimestamp - * @since 1.4 - */ - public java.sql.Timestamp getTimestamp(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a parameter as an <code>Object</code> in the Java - * programming language. If the value is an SQL <code>NULL</code>, the - * driver returns a Java <code>null</code>. - * <p> - * This method returns a Java object whose type corresponds to the JDBC - * type that was registered for this parameter using the method - * <code>registerOutParameter</code>. By registering the target JDBC - * type as <code>java.sql.Types.OTHER</code>, this method can be used - * to read database-specific abstract data types. - * @param parameterName the name of the parameter - * @return A <code>java.lang.Object</code> holding the OUT parameter value. - * @exception SQLException if a database access error occurs - * @see Types - * @see #setObject - * @since 1.4 - */ - public Object getObject(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>NUMERIC</code> parameter as a - * <code>java.math.BigDecimal</code> object with as many digits to the - * right of the decimal point as the value contains. - * @param parameterName the name of the parameter - * @return the parameter value in full precision. If the value is - * SQL <code>NULL</code>, the result is <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setBigDecimal - * @since 1.4 - */ - public BigDecimal getBigDecimal(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Returns an object representing the value of OUT parameter - * <code>i</code> and uses <code>map</code> for the custom - * mapping of the parameter value. - * <p> - * This method returns a Java object whose type corresponds to the - * JDBC type that was registered for this parameter using the method - * <code>registerOutParameter</code>. By registering the target - * JDBC type as <code>java.sql.Types.OTHER</code>, this method can - * be used to read database-specific abstract data types. - * @param parameterName the name of the parameter - * @param map the mapping from SQL type names to Java classes - * @return a <code>java.lang.Object</code> holding the OUT parameter value - * @exception SQLException if a database access error occurs - * @see #setObject - * @since 1.4 - */ - public Object getObject (String parameterName, java.util.Map map) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>REF(<structured-type>)</code> - * parameter as a {@link Ref} object in the Java programming language. - * - * @param parameterName the name of the parameter - * @return the parameter value as a <code>Ref</code> object in the - * Java programming language. If the value was SQL <code>NULL</code>, - * the value <code>null</code> is returned. - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public Ref getRef (String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>BLOB</code> parameter as a - * {@link Blob} object in the Java programming language. - * - * @param parameterName the name of the parameter - * @return the parameter value as a <code>Blob</code> object in the - * Java programming language. If the value was SQL <code>NULL</code>, - * the value <code>null</code> is returned. - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public Blob getBlob (String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>CLOB</code> parameter as a - * <code>Clob</code> object in the Java programming language. - * @param parameterName the name of the parameter - * @return the parameter value as a <code>Clob</code> object in the - * Java programming language. If the value was SQL <code>NULL</code>, - * the value <code>null</code> is returned. - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public Clob getClob (String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>ARRAY</code> parameter as an - * {@link Array} object in the Java programming language. - * - * @param parameterName the name of the parameter - * @return the parameter value as an <code>Array</code> object in - * Java programming language. If the value was SQL <code>NULL</code>, - * the value <code>null</code> is returned. - * @exception SQLException if a database access error occurs - * @since 1.4 - */ - public Array getArray (String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>DATE</code> parameter as a - * <code>java.sql.Date</code> object, using - * the given <code>Calendar</code> object - * to construct the date. - * With a <code>Calendar</code> object, the driver - * can calculate the date taking into account a custom timezone and locale. - * If no <code>Calendar</code> object is specified, the driver uses the - * default timezone and locale. - * - * @param parameterName the name of the parameter - * @param cal the <code>Calendar</code> object the driver will use - * to construct the date - * @return the parameter value. If the value is SQL <code>NULL</code>, - * the result is <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setDate - * @since 1.4 - */ - public java.sql.Date getDate(String parameterName, Calendar cal) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>TIME</code> parameter as a - * <code>java.sql.Time</code> object, using - * the given <code>Calendar</code> object - * to construct the time. - * With a <code>Calendar</code> object, the driver - * can calculate the time taking into account a custom timezone and locale. - * If no <code>Calendar</code> object is specified, the driver uses the - * default timezone and locale. - * - * @param parameterName the name of the parameter - * @param cal the <code>Calendar</code> object the driver will use - * to construct the time - * @return the parameter value; if the value is SQL <code>NULL</code>, the result is - * <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setTime - * @since 1.4 - */ - public java.sql.Time getTime(String parameterName, Calendar cal) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>TIMESTAMP</code> parameter as a - * <code>java.sql.Timestamp</code> object, using - * the given <code>Calendar</code> object to construct - * the <code>Timestamp</code> object. - * With a <code>Calendar</code> object, the driver - * can calculate the timestamp taking into account a custom timezone and locale. - * If no <code>Calendar</code> object is specified, the driver uses the - * default timezone and locale. - * - * - * @param parameterName the name of the parameter - * @param cal the <code>Calendar</code> object the driver will use - * to construct the timestamp - * @return the parameter value. If the value is SQL <code>NULL</code>, the result is - * <code>null</code>. - * @exception SQLException if a database access error occurs - * @see #setTimestamp - * @since 1.4 - */ - public java.sql.Timestamp getTimestamp(String parameterName, Calendar cal) - throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - /** - * Retrieves the value of a JDBC <code>DATALINK</code> parameter as a - * <code>java.net.URL</code> object. - * - * @param parameterName the name of the parameter - * @return the parameter value as a <code>java.net.URL</code> object in the - * Java programming language. If the value was SQL <code>NULL</code>, the - * value <code>null</code> is returned. - * @exception SQLException if a database access error occurs, - * or if there is a problem with the URL - * @see #setURL - * @since 1.4 - */ - public java.net.URL getURL(String parameterName) throws SQLException - { - throw org.postgresql.Driver.notImplemented(); - } - - public void setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException - { - switch (targetSqlType) - { - case Types.BOOLEAN: - super.setObject(parameterIndex, x, Types.BIT, scale); - default: - super.setObject(parameterIndex, x, targetSqlType, scale); - } - } - -} |