Java Doc for AbstractJdbc3Statement.java in  » Database-JDBC-Connection-Pool » postgresql » org » postgresql » jdbc3 » Java Source Code / Java DocumentationJava Source Code and Java Documentation

This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method registerOutParameter.

For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.
Parameters:
  parameterName - the name of the parameter the parameter value.

The JDBC specification specifies a standard mapping from Java Object types to SQL types.

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.

The execute method executes an SQL statement and indicates the form of the first result. You must then use the methods getResultSet or getUpdateCount to retrieve the result, and getMoreResults to move to any subsequent result(s).
Parameters:
  sql - any SQL statement
Parameters:
  autoGeneratedKeys - a constant indicating whether auto-generatedkeys should be made available for retrieval using the methodgetGeneratedKeys; one of the following constants:Statement.RETURN_GENERATED_KEYS orStatement.NO_GENERATED_KEYS true if the first result is a ResultSetobject; false if it is an update count or there areno results
exception:
  SQLException - if a database access error occurs
See Also:   AbstractJdbc3Statement.getResultSet
See Also:   AbstractJdbc3Statement.getUpdateCount
See Also:   AbstractJdbc3Statement.getMoreResults
See Also:   AbstractJdbc3Statement.getGeneratedKeys
since:
   1.4

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.

The execute method executes an SQL statement and indicates the form of the first result. You must then use the methods getResultSet or getUpdateCount to retrieve the result, and getMoreResults to move to any subsequent result(s).
Parameters:
  sql - any SQL statement
Parameters:
  columnIndexes - an array of the indexes of the columns in theinserted row that should be made available for retrieval by acall to the method getGeneratedKeys true if the first result is a ResultSetobject; false if it is an update count or thereare no results
exception:
  SQLException - if a database access error occurs
See Also:   AbstractJdbc3Statement.getResultSet
See Also:   AbstractJdbc3Statement.getUpdateCount
See Also:   AbstractJdbc3Statement.getMoreResults
since:
   1.4

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.

The execute method executes an SQL statement and indicates the form of the first result. You must then use the methods getResultSet or getUpdateCount to retrieve the result, and getMoreResults to move to any subsequent result(s).
Parameters:
  sql - any SQL statement
Parameters:
  columnNames - an array of the names of the columns in the insertedrow that should be made available for retrieval by a call to themethod getGeneratedKeys true if the next result is a ResultSetobject; false if it is an update count or thereare no more results
exception:
  SQLException - if a database access error occurs
See Also:   AbstractJdbc3Statement.getResultSet
See Also:   AbstractJdbc3Statement.getUpdateCount
See Also:   AbstractJdbc3Statement.getMoreResults
See Also:   AbstractJdbc3Statement.getGeneratedKeys
since:
   1.4

There are no more results when the following is true:

 (!getMoreResults() && (getUpdateCount() == -1)
 

This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method registerOutParameter. By registering the target JDBC type as java.sql.Types.OTHER, this method can be used to read database-specific abstract data types.
Parameters:
  parameterName - the name of the parameter A java.lang.Object holding the OUT parameter value.
exception:
  SQLException - if a database access error occurs
See Also:   Types
See Also:   AbstractJdbc3Statement.setObject
since:
   1.4

This method returns a Java object whose type corresponds to the JDBC type that was registered for this parameter using the method registerOutParameter. By registering the target JDBC type as java.sql.Types.OTHER, this method can be used to read database-specific abstract data types.
Parameters:
  parameterName - the name of the parameter
Parameters:
  map - the mapping from SQL type names to Java classes a java.lang.Object holding the OUT parameter value
exception:
  SQLException - if a database access error occurs
See Also:   AbstractJdbc3Statement.setObject
since:
   1.4

For the fixed-length type JDBC CHAR, the String object returned has exactly the same value the JDBC CHAR value had in the database, including any padding added by the database.
Parameters:
  parameterName - the name of the parameter the parameter value. If the value is SQL NULL, the resultis null.
exception:
  SQLException - if a database access error occurs
See Also:   AbstractJdbc3Statement.setString
since:
   1.4

The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

If the JDBC type expected to be returned to this output parameter is specific to this particular database, sqlType should be java.sql.Types.OTHER. The method AbstractJdbc3Statement.getObject retrieves the value.
Parameters:
  parameterName - the name of the parameter
Parameters:
  sqlType - the JDBC type code defined by java.sql.Types.If the parameter is of JDBC type NUMERICor DECIMAL, the version ofregisterOutParameter that accepts a scale valueshould be used.
exception:
  SQLException - if a database access error occurs
since:
   1.4
See Also:   Types

The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.

This version of registerOutParameter should be used when the parameter is of JDBC type NUMERIC or DECIMAL.
Parameters:
  parameterName - the name of the parameter
Parameters:
  sqlType - SQL type code defined by java.sql.Types.
Parameters:
  scale - the desired number of digits to the right of thedecimal point. It must be greater than or equal to zero.
exception:
  SQLException - if a database access error occurs
since:
   1.4
See Also:   Types

Note: When reading the value of an out parameter, you must use the getXXX method whose Java type XXX corresponds to the parameter's registered SQL type.
Parameters:
  parameterName - the name of the parameter
Parameters:
  sqlType - a value from java.sql.Types
Parameters:
  typeName - the fully-qualified name of an SQL structured type
exception:
  SQLException - if a database access error occurs
See Also:   Types
since:
   1.4

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Parameters:
  parameterName - the name of the parameter
Parameters:
  x - the Java input stream that contains the ASCII parameter value
Parameters:
  length - the number of bytes in the stream
exception:
  SQLException - if a database access error occurs
since:
   1.4

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Parameters:
  parameterName - the name of the parameter
Parameters:
  x - the java input stream which contains the binary parameter value
Parameters:
  length - the number of bytes in the stream
exception:
  SQLException - if a database access error occurs
since:
   1.4

Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Parameters:
  parameterName - the name of the parameter
Parameters:
  reader - the java.io.Reader object thatcontains the UNICODE data used as the designated parameter
Parameters:
  length - the number of characters in the stream
exception:
  SQLException - if a database access error occurs
since:
   1.4

Note: You must specify the parameter's SQL type.
Parameters:
  parameterName - the name of the parameter
Parameters:
  sqlType - the SQL type code defined in java.sql.Types
exception:
  SQLException - if a database access error occurs
since:
   1.4

Note: 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.
Parameters:
  parameterName - the name of the parameter
Parameters:
  sqlType - a value from java.sql.Types
Parameters:
  typeName - the fully-qualified name of an SQL user-defined type;ignored if the parameter is not a user-defined type orSQL REF value
exception:
  SQLException - if a database access error occurs
since:
   1.4

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 SQLData), the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob, Clob, Struct, or Array, the driver should pass it to the database as a value of the corresponding SQL type.

Note that this method may be used to pass datatabase- specific abstract data types.
Parameters:
  parameterName - the name of the parameter
Parameters:
  x - the object containing the input parameter value
Parameters:
  targetSqlType - the SQL type (as defined in java.sql.Types) to besent to the database. The scale argument may further qualify this type.
Parameters:
  scale - for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types,this is the number of digits after the decimal point. For all othertypes, this value will be ignored.
exception:
  SQLException - if a database access error occurs
See Also:   Types
See Also:   AbstractJdbc3Statement.getObject
since:
   1.4

The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database.

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 SQLData, the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob, Clob, Struct, or Array, the driver should pass it to the database as a value of the corresponding SQL type.

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.
Parameters:
  parameterName - the name of the parameter
Parameters:
  x - the object containing the input parameter value
exception:
  SQLException - if a database access error occurs or if the givenObject parameter is ambiguous
See Also:   AbstractJdbc3Statement.getObject
since:
   1.4