vortex.sql
Class vortexPreparedStatement

java.lang.Object
  vortex.sql.vortexStatement
      vortex.sql.vortexPreparedStatement

All Implemented Interfaces:

java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

Direct Known Subclasses:

vortexCallableStatement

public class vortexPreparedStatement
extends vortexStatement
implements java.sql.PreparedStatement

A SQL statement is pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: The setXXX methods for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type Integer then setInt should be used.

If arbitrary parameter type conversions are required then the setObject method should be used with a target SQL type.

See Also:

Connection.prepareStatement(java.lang.String), ResultSet

Field Summary

Fields inherited from interface java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Method Summary

void	addBatch() Not supported by VORTEXjdbc.
void	clearParameters() In general parameter values remain in force for repeated use of a Statement.
boolean	execute() Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.
java.sql.ResultSet	executeQuery() A prepared SQL query is executed and its ResultSet is returned.
int	executeUpdate() Execute a SQL INSERT, UPDATE or DELETE statement.
java.sql.ResultSetMetaData	getMetaData() Gets the number, types and properties of a ResultSet's columns.
java.sql.ParameterMetaData	getParameterMetaData() Retrieves the number, types and properties of this PreparedStatement's parameters.
void	setArray(int paramIndex, java.sql.Array x) Not supported by VORTEXjdbc.
void	setAsciiStream(int paramIndex, java.io.InputStream x) Not supported by VORTEXjdbc.
void	setAsciiStream(int paramIndex, java.io.InputStream x, int len) When a very large ASCII value is input to a LONGVARCHAR parameter it may be more practical to send it via a java.io.InputStream.
void	setAsciiStream(int paramIndex, java.io.InputStream x, long len) Not supported by VORTEXjdbc.
void	setBigDecimal(int paramIndex, java.math.BigDecimal x) Set a parameter to a java.sql.Numeric value.
void	setBinaryStream(int paramIndex, java.io.InputStream x) Not supported by VORTEXjdbc.
void	setBinaryStream(int paramIndex, java.io.InputStream x, int len) When a very large binary value is input to a LONGVARBINARY parameter it may be more practical to send it via a java.io.InputStream.
void	setBinaryStream(int paramIndex, java.io.InputStream x, long len) Not supported by VORTEXjdbc.
void	setBinaryStream(int paramIndex, java.io.Reader x) Not supported by VORTEXjdbc.
void	setBlob(int paramIndex, java.sql.Blob x) Sets a BLOB parameter.
void	setBlob(int paramIndex, java.io.InputStream x) Not supported by VORTEXjdbc.
void	setBlob(int paramIndex, java.io.InputStream x, long len) Not supported by VORTEXjdbc.
void	setBoolean(int paramIndex, boolean x) Set a parameter to a Java boolean value.
void	setByte(int paramIndex, byte x) Set a parameter to a Java byte value.
void	setBytes(int paramIndex, byte[] x) Set a parameter to a Java array of bytes.
void	setCharacterStream(int paramIndex, java.io.Reader x) Not supported by VORTEXjdbc.
void	setCharacterStream(int paramIndex, java.io.Reader reader, int len) Not supported by VORTEXjdbc.
void	setCharacterStream(int paramIndex, java.io.Reader reader, long len) Not supported by VORTEXjdbc.
void	setClob(int paramIndex, java.sql.Clob x) Sets a CLOB parameter.
void	setClob(int paramIndex, java.io.Reader x) Not supported by VORTEXjdbc.
void	setClob(int paramIndex, java.io.Reader x, long len) Not supported by VORTEXjdbc.
void	setDate(int paramIndex, java.sql.Date x) Set a parameter to a java.sql.Date value.
void	setDate(int paramIndex, java.sql.Date x, java.util.Calendar cal) Not supported by VORTEXjdbc.
void	setDouble(int paramIndex, double x) Set a parameter to a Java double value.
void	setFloat(int paramIndex, float x) Set a parameter to a Java float value.
void	setInt(int paramIndex, int x) Set a parameter to a Java int value.
void	setLong(int paramIndex, long x) Set a parameter to a Java long value.
void	setNCharacterStream(int paramIndex, java.io.Reader x) Not supported by VORTEXjdbc.
void	setNCharacterStream(int paramIndex, java.io.Reader x, long len) Not supported by VORTEXjdbc.
void	setNClob(int paramIndex, java.sql.NClob x) Not supported by VORTEXjdbc.
void	setNClob(int paramIndex, java.io.Reader x) Not supported by VORTEXjdbc.
void	setNClob(int paramIndex, java.io.Reader x, long len) Not supported by VORTEXjdbc.
void	setNString(int paramIndex, java.lang.String x) Not supported by VORTEXjdbc.
void	setNull(int paramIndex, int sqlType) Set a parameter to SQL NULL.
void	setNull(int paramIndex, int sqlType, java.lang.String typeName) Not supported by VORTEXjdbc.
void	setObject(int paramIndex, java.lang.Object x) Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.
void	setObject(int paramIndex, java.lang.Object x, int targetSqlType) This method is like setObject above, but assumes scale of zero.
void	setObject(int paramIndex, java.lang.Object x, int targetSqlType, int scale) Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.
void	setRef(int paramIndex, java.sql.Ref x) Not supported by VORTEXjdbc.
void	setRowId(int paramIndex, java.sql.RowId x) Not supported by VORTEXjdbc.
void	setShort(int paramIndex, short x) Set a parameter to a Java short value.
void	setSQLXML(int paramIndex, java.sql.SQLXML x) Not supported by VORTEXjdbc.
void	setString(int paramIndex, java.lang.String x) Set a parameter to a Java String value.
void	setTime(int paramIndex, java.sql.Time x) Set a parameter to a java.sql.Time value.
void	setTime(int paramIndex, java.sql.Time x, java.util.Calendar cal) Not supported by VORTEXjdbc.
void	setTimestamp(int paramIndex, java.sql.Timestamp x) Set a parameter to a java.sql.Timestamp value.
void	setTimestamp(int paramIndex, java.sql.Timestamp x, java.util.Calendar cal) Not supported by VORTEXjdbc.
void	setUnicodeStream(int paramIndex, java.io.InputStream x, int len) When a very large UNICODE value is input to a LONGVARCHAR parameter it may be more practical to send it via a java.io.InputStream.
void	setURL(int paramIndex, java.net.URL x) Not supported by VORTEXjdbc.

Methods inherited from class vortex.sql.vortexStatement

addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finalize, getConnection, getCursorName, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

A prepared SQL query is executed and its ResultSet is returned.

Specified by:

executeQuery in interface java.sql.PreparedStatement

Returns:

a ResultSet that contains the data produced by the query

Throws:

java.sql.SQLException - Not use

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Execute a SQL INSERT, UPDATE or DELETE statement. In addition, SQL statements that return nothing such as SQL DDL statements can be executed.

Specified by:

executeUpdate in interface java.sql.PreparedStatement

Returns:

either the row count for INSERT, UPDATE or DELETE; or 0 for SQL statements that return nothing

Throws:

java.sql.SQLException - thrown if DB actions fail.

setNull

public void setNull(int paramIndex,
                    int sqlType)
             throws java.sql.SQLException

Set a parameter to SQL NULL.

Note: You must specify the parameter's SQL type.

Specified by:

setNull in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

sqlType - SQL type code defined by java.sql.Types

Throws:

java.sql.SQLException - thrown if paramIndex out of range

setBoolean

public void setBoolean(int paramIndex,
                       boolean x)
                throws java.sql.SQLException

Set a parameter to a Java boolean value. The driver converts this to a SQL BIT value when it sends it to the database.

Specified by:

setBoolean in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setByte

public void setByte(int paramIndex,
                    byte x)
             throws java.sql.SQLException

Set a parameter to a Java byte value. The driver converts this to a SQL TINYINT value when it sends it to the database.

Specified by:

setByte in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setShort

public void setShort(int paramIndex,
                     short x)
              throws java.sql.SQLException

Set a parameter to a Java short value. The driver converts this to a SQL SMALLINT value when it sends it to the database.

Specified by:

setShort in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setInt

public void setInt(int paramIndex,
                   int x)
            throws java.sql.SQLException

Set a parameter to a Java int value. The driver converts this to a SQL INTEGER value when it sends it to the database.

Specified by:

setInt in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setLong

public void setLong(int paramIndex,
                    long x)
             throws java.sql.SQLException

Set a parameter to a Java long value. The driver converts this to a SQL BIGINT value when it sends it to the database.

Specified by:

setLong in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setFloat

public void setFloat(int paramIndex,
                     float x)
              throws java.sql.SQLException

Set a parameter to a Java float value. The driver converts this to a SQL FLOAT value when it sends it to the database.

Specified by:

setFloat in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setDouble

public void setDouble(int paramIndex,
                      double x)
               throws java.sql.SQLException

Set a parameter to a Java double value. The driver converts this to a SQL DOUBLE value when it sends it to the database.

Specified by:

setDouble in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setBigDecimal

public void setBigDecimal(int paramIndex,
                          java.math.BigDecimal x)
                   throws java.sql.SQLException

Set a parameter to a java.sql.Numeric value. VORTEXjdbc converts this to a character string value when it sends it to the database.

Specified by:

setBigDecimal in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setString

public void setString(int paramIndex,
                      java.lang.String x)
               throws java.sql.SQLException

Set a parameter to a Java String value. The driver converts this to a SQL VARCHAR or LONGVARCHAR value (depending on the arguments size relative to the driver's limits on VARCHARs) when it sends it to the database.

Specified by:

setString in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setBytes

public void setBytes(int paramIndex,
                     byte[] x)
              throws java.sql.SQLException

Set a parameter to a Java array of bytes. The driver converts this to a SQL VARBINARY or LONGVARBINARY (depending on the arguments size relative to the driver's limits on VARBINARYs) when it sends

Specified by:

setBytes in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setDate

public void setDate(int paramIndex,
                    java.sql.Date x)
             throws java.sql.SQLException

Set a parameter to a java.sql.Date value. The driver converts this to a SQL DATE value when it sends it to the database.

Specified by:

setDate in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setTime

public void setTime(int paramIndex,
                    java.sql.Time x)
             throws java.sql.SQLException

Set a parameter to a java.sql.Time value. The driver converts this to a SQL TIME value when it sends it to the database.

Specified by:

setTime in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setTimestamp

public void setTimestamp(int paramIndex,
                         java.sql.Timestamp x)
                  throws java.sql.SQLException

Set a parameter to a java.sql.Timestamp value. The driver converts this to a SQL VARCHAR value when it sends it to the database.

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setAsciiStream

public void setAsciiStream(int paramIndex,
                           java.io.InputStream x,
                           int len)
                    throws java.sql.SQLException

When a very large ASCII value is input to a LONGVARCHAR parameter it may be more practical to send it via a java.io.InputStream. JDBC will read the data from the stream as needed, until it reaches end-of-file. The JDBC driver will do any necessary conversion from ASCII to the database char format.

Note: this stream object can either be a standard Java stream object, or your own subclass that implements the standard interface.

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the java input stream which contains the ASCII parameter value

len - the number of bytes in the stream

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setUnicodeStream

public void setUnicodeStream(int paramIndex,
                             java.io.InputStream x,
                             int len)
                      throws java.sql.SQLException

When a very large UNICODE value is input to a LONGVARCHAR parameter it may be more practical to send it via a java.io.InputStream. JDBC will read the data from the stream as needed, until it reaches end-of-file. The JDBC driver will do any necessary conversion from UNICODE to the database char format.

Note: this stream object can either be a standard Java stream object, or your own subclass that implements the standard interface.

Specified by:

setUnicodeStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the java input stream which contains the UNICODE parameter value @param len the number of bytes in the stream

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

setBinaryStream

public void setBinaryStream(int paramIndex,
                            java.io.InputStream x,
                            int len)
                     throws java.sql.SQLException

When a very large binary value is input to a LONGVARBINARY parameter it may be more practical to send it via a java.io.InputStream. JDBC will read the data from the stream as needed, until it reaches end-of-file.

Note: this stream object can either be a standard Java stream object, or your own subclass that implements the standard interface.

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the java input stream which contains the binary parameter value

len - the number of bytes in the stream

Throws:

java.sql.SQLException - thrown if paramIndex out of range or unable to bind parameter

clearParameters

public void clearParameters()
                     throws java.sql.SQLException

In general parameter values remain in force for repeated use of a Statement. Setting a parameter value automatically clears its previous value. However In some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling clearParameters.

Specified by:

clearParameters in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException - thrown if paramIndex out of range

setObject

public void setObject(int paramIndex,
                      java.lang.Object x,
                      int targetSqlType,
                      int scale)
               throws java.sql.SQLException

Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.

The given Java object will be converted to the targetSqlType 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 and using a targetSqlType of java.sql.types.OTHER.

Specified by:

setObject in interface java.sql.PreparedStatement

Parameters:

paramIndex - The first parameter is 1, the second is 2, ...

x - The object containing the input parameter value

targetSqlType - The SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.

scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types this is the number of digits after the decimal. For all other types this value will be ignored,

Throws:

java.sql.SQLException - if object is not supported

See Also:

Types

setObject

public void setObject(int paramIndex,
                      java.lang.Object x,
                      int targetSqlType)
               throws java.sql.SQLException

This method is like setObject above, but assumes scale of zero.

Specified by:

setObject in interface java.sql.PreparedStatement

Parameters:

paramIndex - The first parameter is 1, the second is 2, ...

x - The object containing the input parameter value

targetSqlType - The SQL type (as defined in java.sql.Types) to be sent to the database.

Throws:

java.sql.SQLException - if object not supported

setObject

public void setObject(int paramIndex,
                      java.lang.Object x)
               throws java.sql.SQLException

Set the value of a parameter using an object; use the java.lang equivalent objects for integral values.

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

Note that this method may be used to pass database specific abstract data types, by using a Driver specific Java type.

Specified by:

setObject in interface java.sql.PreparedStatement

Parameters:

paramIndex - The first parameter is 1, the second is 2, ...

x - The object containing the input parameter value

Throws:

java.sql.SQLException - if object is not supported

execute

public boolean execute()
                throws java.sql.SQLException

Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.

Specified by:

execute in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException - thrown on database errors

See Also:

Statement.execute(java.lang.String)

addBatch

public void addBatch()
              throws java.sql.SQLException

Not supported by VORTEXjdbc. Adds a set of parameters to the batch.

Specified by:

addBatch in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws java.sql.SQLException

Retrieves the number, types and properties of this PreparedStatement's parameters.

Specified by:

getParameterMetaData in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int paramIndex,
                               java.io.Reader reader,
                               int len)
                        throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader. JDBC will read the data from the stream as needed, until it reaches end-of-file. The JDBC driver will do any necessary conversion from UNICODE to the database char format. Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

reader - the java reader which contains the UNICODE data

len - the number of characters in the stream

Throws:

java.sql.SQLException

setRef

public void setRef(int paramIndex,
                   java.sql.Ref x)
            throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets a REF() parameter.

Specified by:

setRef in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - an object representing data of an SQL REF Type

Throws:

java.sql.SQLException

setBlob

public void setBlob(int paramIndex,
                    java.sql.Blob x)
             throws java.sql.SQLException

Sets a BLOB parameter.

Specified by:

setBlob in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - an object representing a BLOB

Throws:

java.sql.SQLException

setClob

public void setClob(int paramIndex,
                    java.sql.Clob x)
             throws java.sql.SQLException

Sets a CLOB parameter.

Specified by:

setClob in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - an object representing a CLOB

Throws:

java.sql.SQLException

setArray

public void setArray(int paramIndex,
                     java.sql.Array x)
              throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets an Array parameter.

Specified by:

setArray in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - an object representing an SQL array

Throws:

java.sql.SQLException

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Gets the number, types and properties of a ResultSet's columns.

Specified by:

getMetaData in interface java.sql.PreparedStatement

Returns:

the description of a ResultSet's columns

Throws:

java.sql.SQLException

setDate

public void setDate(int paramIndex,
                    java.sql.Date x,
                    java.util.Calendar cal)
             throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a java.sql.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE, which the driver then sends to the database. With a Calendar object, the driver can calculate the date taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.

Specified by:

setDate in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

cal - the Calendar object the driver will use to construct the date

Throws:

java.sql.SQLException

setTime

public void setTime(int paramIndex,
                    java.sql.Time x,
                    java.util.Calendar cal)
             throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a java.sql.Time value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIME, which the driver then sends to the database. With a Calendar object, the driver can calculate the time taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.

Specified by:

setTime in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

cal - the Calendar object the driver will use to construct the time

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int paramIndex,
                         java.sql.Timestamp x,
                         java.util.Calendar cal)
                  throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a java.sql.Timestamp value, using the given Calendar object. The driver uses the Calendar object to construct an SQL TIMESTAMP, which the driver then sends to the database. With a Calendar object, the driver can calculate the timestamp taking into account a custom timezone and locale. If no Calendar object is specified, the driver uses the default timezone and locale.

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

cal - the Calendar object the driver will use to construct the timestamp

Throws:

java.sql.SQLException

setNull

public void setNull(int paramIndex,
                    int sqlType,
                    java.lang.String typeName)
             throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to SQL NULL. This version of setNull should be used for user-named types and REF type parameters. Examples of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types. 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-named 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-named 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-named or REF type, the given typeName is ignored.

Specified by:

setNull in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

sqlType - a value from java.sql.Types

typeName - the fully-qualified name of an SQL user-named type, ignored if the parameter is not a user-named type or REF

Throws:

java.sql.SQLException

setURL

public void setURL(int paramIndex,
                   java.net.URL x)
            throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given URL value. The driver converts this to an SQL DATALINK value when it sends it to the database.

Specified by:

setURL in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - URL value

Throws:

java.sql.SQLException

setNClob

public void setNClob(int paramIndex,
                     java.sql.NClob x)
              throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a java.sql.NClob object. The driver converts this to a SQL NCLOB value when it sends it to the database.

Specified by:

setNClob in interface java.sql.PreparedStatement

Parameters:

paramIndex - - of the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatementSQLFeatureNotSupportedException - if the JDBC driver does not support this method

setNClob

public void setNClob(int paramIndex,
                     java.io.Reader x)
              throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a Reader object.

Specified by:

setNClob in interface java.sql.PreparedStatement

Parameters:

paramIndex - - of the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatementSQLFeatureNotSupportedException - if the JDBC driver does not support this method

setNClob

public void setNClob(int paramIndex,
                     java.io.Reader x,
                     long len)
              throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a Reader object.

Specified by:

setNClob in interface java.sql.PreparedStatement

Parameters:

paramIndex - - of the first parameter is 1, the second is 2, ...

x - the parameter value

len - the number of characters in the stream

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatementSQLFeatureNotSupportedException - if the JDBC driver does not support this method

setBlob

public void setBlob(int paramIndex,
                    java.io.InputStream x,
                    long len)
             throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a InputStream object. The inputstream must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed.

Specified by:

setBlob in interface java.sql.PreparedStatement

Parameters:

paramIndex - - index of the first parameter is 1, the second is 2, ...

x - An InputStream object that contains the data.

len - the number of bytes in the parameter data.

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatement; if the length specified is less than zero or if the number of bytes in the inputstream does not match the specfied length.SQLFeatureNotSupportedException - if the JDBC driver does not support this method

setBlob

public void setBlob(int paramIndex,
                    java.io.InputStream x)
             throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a InputStream object. The inputstream must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed.

Specified by:

setBlob in interface java.sql.PreparedStatement

Parameters:

paramIndex - - index of the first parameter is 1, the second is 2, ...

x - An InputStream object that contains the data.

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatement; if the length specified is less than zero or if the number of bytes in the inputstream does not match the specfied length.SQLFeatureNotSupportedException - if the JDBC driver does not support this method

setClob

public void setClob(int paramIndex,
                    java.io.Reader x)
             throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a Reader object.

Specified by:

setClob in interface java.sql.PreparedStatement

Parameters:

paramIndex - - of the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatementSQLFeatureNotSupportedException - if the JDBC driver does not support this method

setClob

public void setClob(int paramIndex,
                    java.io.Reader x,
                    long len)
             throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to a Reader object.

Specified by:

setClob in interface java.sql.PreparedStatement

Parameters:

paramIndex - - of the first parameter is 1, the second is 2, ...

x - the parameter value

len - the number of bytes in the parameter data.

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatementSQLFeatureNotSupportedException - if the JDBC driver does not support this method

setNCharacterStream

public void setNCharacterStream(int paramIndex,
                                java.io.Reader x)
                         throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given Reader object.

Specified by:

setNCharacterStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException

setNCharacterStream

public void setNCharacterStream(int paramIndex,
                                java.io.Reader x,
                                long len)
                         throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given Reader object.

Specified by:

setNCharacterStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

len - the number of bytes in the parameter data.

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int paramIndex,
                               java.io.Reader x)
                        throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given Reader object.

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int paramIndex,
                            java.io.Reader x)
                     throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given Reader object.

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int paramIndex,
                            java.io.InputStream x)
                     throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given InputStream object.

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int paramIndex,
                            java.io.InputStream x,
                            long len)
                     throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given InputStream object.

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

len - the number of bytes in the parameter data.

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int paramIndex,
                           java.io.InputStream x)
                    throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given InputStream object.

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int paramIndex,
                           java.io.InputStream x,
                           long len)
                    throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given InputStream object.

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

len - the number of bytes in the parameter data.

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int paramIndex,
                               java.io.Reader reader,
                               long len)
                        throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader. JDBC will read the data from the stream as needed, until it reaches end-of-file. The JDBC driver will do any necessary conversion from UNICODE to the database char format. Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Parameters:

paramIndex - the first parameter is 1, the second is 2, ...

reader - the java reader which contains the UNICODE data

len - the number of characters in the stream

Throws:

java.sql.SQLException

setSQLXML

public void setSQLXML(int paramIndex,
                      java.sql.SQLXML x)
               throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated parameter to the given java.sql.SQLXML object. The driver converts this to an SQL XML value when it sends it to the database.

Specified by:

setSQLXML in interface java.sql.PreparedStatement

Parameters:

paramIndex - index of the first parameter is 1, the second is 2, ...

x - a SQLXML object that maps an SQL XML value

Throws:

java.sql.SQLException - if paramIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs; this method is called on a closed PreparedStatement or the java.xml.transform.Result, Writer or OutputStream has not been closed for the SQLXML object

java.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this method

setNString

public void setNString(int paramIndex,
                       java.lang.String x)
                throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated paramter to the given String object. The driver converts this to a SQL NCHAR or NVARCHAR or LONGNVARCHAR value (depending on the argument's size relative to the driver's limits on NVARCHAR values) when it sends it to the database.

Specified by:

setNString in interface java.sql.PreparedStatement

Parameters:

paramIndex - index of the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if the driver does not support national character sets; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatement

java.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this method

setRowId

public void setRowId(int paramIndex,
                     java.sql.RowId x)
              throws java.sql.SQLException

Not supported by VORTEXjdbc. Sets the designated paramter to the given RowId object.

Specified by:

setRowId in interface java.sql.PreparedStatement

Parameters:

paramIndex - index of the first parameter is 1, the second is 2, ...

x - the parameter value

Throws:

java.sql.SQLException - - if paramIndex does not correspond to a parameter marker in the SQL statement; if the driver can detect that a data conversion error could occur; if a database access error occurs; or this method is called on a closed PreparedStatement

java.sql.SQLFeatureNotSupportedException - if the JDBC driver does not support this method