vortex.sql
Class vortexPreparedStatement

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

All Implemented Interfaces:

java.sql.PreparedStatement, java.sql.Statement

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

protected int

npa Number of Parameters

Fields inherited from class vortex.sql.vortexStatement

cName, conn, lcur, ldb, record, result

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

Constructor Summary

vortexPreparedStatement()

vortexPreparedStatement(java.sql.Connection c, dbChannel db, java.lang.String sql, int resultSetType, int resultSetConcurrency)

Method Summary

void	addBatch() Adds a set of parameters to the batch.
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 col, java.sql.Array x) Sets an Array parameter.
void	setAsciiStream(int column, java.io.InputStream x, int length) 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	setBigDecimal(int column, java.math.BigDecimal x) Set a parameter to a java.sql.Numeric value.
void	setBinaryStream(int column, java.io.InputStream x, int length) 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	setBlob(int col, java.sql.Blob x) Sets a BLOB parameter.
void	setBoolean(int column, boolean x) Set a parameter to a Java boolean value.
void	setByte(int column, byte x) Set a parameter to a Java byte value.
void	setBytes(int column, byte[] x) Set a parameter to a Java array of bytes.
void	setCharacterStream(int col, java.io.Reader reader, int length) Sets the designated parameter to the given Reader object, which is the given number of characters long.
void	setClob(int col, java.sql.Clob x) Sets a CLOB parameter.
void	setDate(int column, java.sql.Date x) Set a parameter to a java.sql.Date value.
void	setDate(int col, java.sql.Date x, java.util.Calendar cal) Sets the designated parameter to a java.sql.Date value, using the given Calendar object.
void	setDouble(int column, double x) Set a parameter to a Java double value.
void	setFloat(int column, float x) Set a parameter to a Java float value.
void	setInt(int column, int x) Set a parameter to a Java int value.
void	setLong(int column, long x) Set a parameter to a Java long value.
void	setNull(int column, int sqlType) Set a parameter to SQL NULL.
void	setNull(int parameterIndex, int sqlType, java.lang.String typeName) Sets the designated parameter to SQL NULL.
void	setObject(int col, 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 col, java.lang.Object x, int targetSqlType) This method is like setObject above, but assumes scale of zero.
void	setObject(int col, 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 col, java.sql.Ref x) Sets a REF() parameter.
void	setShort(int column, short x) Set a parameter to a Java short value.
void	setString(int column, java.lang.String x) Set a parameter to a Java String value.
void	setTime(int column, java.sql.Time x) Set a parameter to a java.sql.Time value.
void	setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) Sets the designated parameter to a java.sql.Time value, using the given Calendar object.
void	setTimestamp(int column, java.sql.Timestamp x) Set a parameter to a java.sql.Timestamp value.
void	setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) Sets the designated parameter to a java.sql.Timestamp value, using the given Calendar object.
void	setUnicodeStream(int column, java.io.InputStream x, int length) 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 parameterIndex, java.net.URL x) Sets the designated parameter to the given URL value.

Methods inherited from class vortex.sql.vortexStatement

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

Methods inherited from class java.lang.Object

clone, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout

Field Detail

npa

protected int npa

Number of Parameters

Constructor Detail

vortexPreparedStatement

public vortexPreparedStatement(java.sql.Connection c,
                               dbChannel db,
                               java.lang.String sql,
                               int resultSetType,
                               int resultSetConcurrency)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

vortexPreparedStatement

public vortexPreparedStatement()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

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 column,
                    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:

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

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

Throws:

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

setBoolean

public void setBoolean(int column,
                       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:

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

x - the parameter value

Throws:

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

setByte

public void setByte(int column,
                    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:

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

x - the parameter value

Throws:

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

setShort

public void setShort(int column,
                     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:

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

x - the parameter value

Throws:

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

setInt

public void setInt(int column,
                   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:

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

x - the parameter value

Throws:

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

setLong

public void setLong(int column,
                    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:

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

x - the parameter value

Throws:

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

setFloat

public void setFloat(int column,
                     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:

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

x - the parameter value

Throws:

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

setDouble

public void setDouble(int column,
                      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:

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

x - the parameter value

Throws:

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

setBigDecimal

public void setBigDecimal(int column,
                          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:

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

x - the parameter value

Throws:

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

setString

public void setString(int column,
                      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:

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

x - the parameter value

Throws:

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

setBytes

public void setBytes(int column,
                     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:

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

x - the parameter value

Throws:

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

setDate

public void setDate(int column,
                    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:

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

x - the parameter value

Throws:

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

setTime

public void setTime(int column,
                    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:

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

x - the parameter value

Throws:

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

setTimestamp

public void setTimestamp(int column,
                         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:

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

x - the parameter value

Throws:

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

setAsciiStream

public void setAsciiStream(int column,
                           java.io.InputStream x,
                           int length)
                    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:

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

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

length - the number of bytes in the stream

Throws:

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

setUnicodeStream

public void setUnicodeStream(int column,
                             java.io.InputStream x,
                             int length)
                      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:

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

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

Throws:

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

setBinaryStream

public void setBinaryStream(int column,
                            java.io.InputStream x,
                            int length)
                     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:

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

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

length - the number of bytes in the stream

Throws:

java.sql.SQLException - thrown if column 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 column out of range

setObject

public void setObject(int col,
                      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:

col - 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 col,
                      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:

col - 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 col,
                      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:

col - 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

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 col,
                               java.io.Reader reader,
                               int length)
                        throws java.sql.SQLException

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:

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

reader - the java reader which contains the UNICODE data

length - the number of characters in the stream

Throws:

java.sql.SQLException

setRef

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

Sets a REF() parameter.

Specified by:

setRef in interface java.sql.PreparedStatement

Parameters:

col - 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 col,
                    java.sql.Blob x)
             throws java.sql.SQLException

Sets a BLOB parameter.

Specified by:

setBlob in interface java.sql.PreparedStatement

Parameters:

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

x - an object representing a BLOB

Throws:

java.sql.SQLException

setClob

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

Sets a CLOB parameter.

Specified by:

setClob in interface java.sql.PreparedStatement

Parameters:

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

x - an object representing a CLOB

Throws:

java.sql.SQLException

setArray

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

Sets an Array parameter.

Specified by:

setArray in interface java.sql.PreparedStatement

Parameters:

col - 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 col,
                    java.sql.Date x,
                    java.util.Calendar cal)
             throws java.sql.SQLException

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:

col - 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 parameterIndex,
                    java.sql.Time x,
                    java.util.Calendar cal)
             throws java.sql.SQLException

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:

parameterIndex - 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 parameterIndex,
                         java.sql.Timestamp x,
                         java.util.Calendar cal)
                  throws java.sql.SQLException

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:

parameterIndex - 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 parameterIndex,
                    int sqlType,
                    java.lang.String typeName)
             throws java.sql.SQLException

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:

parameterIndex - 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 parameterIndex,
                   java.net.URL x)
            throws java.sql.SQLException

Sets the designated parameter to the given URL value. The driver converts this to an SQL DATALINK value whe it sends it to the database.

Specified by:

setURL in interface java.sql.PreparedStatement

Parameters:

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

x - URL value

Throws:

java.sql.SQLException