You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@harmony.apache.org by py...@apache.org on 2007/07/25 05:36:29 UTC
svn commit: r559303 -
/harmony/enhanced/classlib/branches/java6/modules/sql/src/main/java/javax/sql/RowSet.java
Author: pyang
Date: Tue Jul 24 20:36:28 2007
New Revision: 559303
URL: http://svn.apache.org/viewvc?view=rev&rev=559303
Log:
Apply patch for HARMONY-4525([classlib][sql] [java6] new methods in javax.sql.RowSet)
Modified:
harmony/enhanced/classlib/branches/java6/modules/sql/src/main/java/javax/sql/RowSet.java
Modified: harmony/enhanced/classlib/branches/java6/modules/sql/src/main/java/javax/sql/RowSet.java
URL: http://svn.apache.org/viewvc/harmony/enhanced/classlib/branches/java6/modules/sql/src/main/java/javax/sql/RowSet.java?view=diff&rev=559303&r1=559302&r2=559303
==============================================================================
--- harmony/enhanced/classlib/branches/java6/modules/sql/src/main/java/javax/sql/RowSet.java (original)
+++ harmony/enhanced/classlib/branches/java6/modules/sql/src/main/java/javax/sql/RowSet.java Tue Jul 24 20:36:28 2007
@@ -17,13 +17,16 @@
package javax.sql;
+import java.sql.NClob;
import java.sql.ResultSet;
+import java.sql.RowId;
import java.sql.SQLException;
import java.sql.Array;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Date;
import java.sql.Ref;
+import java.sql.SQLXML;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.Map;
@@ -31,6 +34,7 @@
import java.io.Reader;
import java.util.Calendar;
import java.math.BigDecimal;
+import java.net.URL;
/**
* A RowSet is an interface which provides access to data being sent from/to a
@@ -266,6 +270,59 @@
int length) throws SQLException;
/**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * ASCII data in the supplied java.io.InputStream value. Data is read from
+ * the InputStream until end-of-file is reached.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theInputStream
+ * an InputStream containing the ASCII data to set into the
+ * parameter value
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+
+ public void setAsciiStream(int parameterIndex, InputStream theInputStream)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * ASCII data in the supplied java.io.InputStream value. Data is read from
+ * the InputStream until end-of-file is reached.
+ *
+ * @param parameterName
+ * the name for parameter
+ * @param theInputStream
+ * an InputStream containing the ASCII data to set into the
+ * parameter value
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+
+ public void setAsciiStream(String parameterName, InputStream theInputStream)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * ASCII data in the supplied java.io.InputStream value. Data is read from
+ * the InputStream until end-of-file is reached.
+ *
+ * @param parameterName
+ * the name for parameter
+ * @param theInputStream
+ * an InputStream containing the ASCII data to set into the
+ * parameter value
+ * @param length
+ * the length of the data in bytes
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setAsciiStream(String parameterName,
+ InputStream theInputStream, int length) throws SQLException;
+
+ /**
* Sets the value of the specified SQL NUMERIC parameter in the RowSet
* command with the data in the supplied java.math.BigDecimal value.
*
@@ -281,6 +338,20 @@
throws SQLException;
/**
+ * Sets the value of the specified SQL NUMERIC parameter in the RowSet
+ * command with the data in the supplied java.math.BigDecimal value.
+ *
+ * @param parameterName
+ * the name for parameter
+ * @param theBigDecimal
+ * the BigDecimal containing the value
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBigDecimal(String parameterName, BigDecimal theBigDecimal)
+ throws SQLException;
+
+ /**
* Sets the value of the specified parameter in the RowSet command with the
* binary data in the supplied java.io.InputStream value. Data is read from
* the InputStream until end-of-file is reached.
@@ -301,6 +372,57 @@
/**
* Sets the value of the specified parameter in the RowSet command with the
+ * binary data in the supplied java.io.InputStream value. Data is read from
+ * the InputStream until end-of-file is reached.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theInputStream
+ * an InputStream containing the binary data to set into the
+ * parameter value
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBinaryStream(int parameterIndex, InputStream theInputStream)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * binary data in the supplied java.io.InputStream value. Data is read from
+ * the InputStream until end-of-file is reached.
+ *
+ * @param parameterName
+ * the name for parameter
+ * @param theInputStream
+ * an InputStream containing the binary data to set into the
+ * parameter value
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBinaryStream(String parameterName, InputStream theInputStream)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * binary data in the supplied java.io.InputStream value. Data is read from
+ * the InputStream until end-of-file is reached.
+ *
+ * @param parameterName
+ * the name for parameter
+ * @param theInputStream
+ * an InputStream containing the binary data to set into the
+ * parameter value
+ * @param length
+ * the length of the data in bytes
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBinaryStream(String parameterName,
+ InputStream theInputStream, int length) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
* value of a supplied java.sql.Blob.
*
* @param parameterIndex
@@ -314,6 +436,89 @@
public void setBlob(int parameterIndex, Blob theBlob) throws SQLException;
/**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.InputStream. Data is read from the
+ * InputStream until end-of-file is reached.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theInputStream
+ * an InputStream containing the binary data to set into the
+ * parameter value
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBlob(int parameterIndex, InputStream theInputStream)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.InputStream. Data is read from the
+ * InputStream until end-of-file is reached.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theInputStream
+ * an InputStream containing the binary data to set into the
+ * parameter value
+ * @param length
+ * the length of the data in bytes
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBlob(int parameterIndex, InputStream theInputStream,
+ long length) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.InputStream. Data is read from the
+ * InputStream until end-of-file is reached.
+ *
+ * @param parameterName
+ * the name for parameter
+ * @param theInputStream
+ * an InputStream containing the binary data to set into the
+ * parameter value
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBlob(String parameterName, InputStream theInputStream)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.InputStream. Data is read from the
+ * InputStream until end-of-file is reached.
+ *
+ * @param parameterName
+ * the name for parameter
+ * @param theInputStream
+ * an InputStream containing the binary data to set into the
+ * parameter value
+ * @param length
+ * the length of the data in bytes
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBlob(String parameterName, InputStream theInputStream,
+ long length) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.sql.Blob.
+ *
+ * @param parameterName
+ * the name for parameter
+ * @param theBlob
+ * the Blob value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBlob(String parameterName, Blob theBlob) throws SQLException;
+
+ /**
* Sets the value of the specified parameter in the RowSet command to the
* supplied boolean.
*
@@ -330,6 +535,20 @@
/**
* Sets the value of the specified parameter in the RowSet command to the
+ * supplied boolean.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theBoolean
+ * the boolean value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBoolean(String parameterName, boolean theBoolean)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to the
* supplied byte value.
*
* @param parameterIndex
@@ -344,6 +563,19 @@
/**
* Sets the value of the specified parameter in the RowSet command to the
+ * supplied byte value.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theByte
+ * the byte value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setByte(String parameterName, byte theByte) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to the
* supplied byte array value.
*
* @param parameterIndex
@@ -359,6 +591,20 @@
/**
* Sets the value of the specified parameter in the RowSet command to the
+ * supplied byte array value.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theByteArray
+ * the array of bytes to set into the parameter.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setBytes(String parametername, byte[] theByteArray)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to the
* sequence of Unicode characters carried by the supplied java.io.Reader.
*
* @param parameterIndex
@@ -376,75 +622,203 @@
int length) throws SQLException;
/**
- * Sets the value of the specified parameter in the RowSet command with the
- * value of a supplied java.sql.Clob.
+ * Sets the value of the specified parameter in the RowSet command to the
+ * sequence of Unicode characters carried by the supplied java.io.Reader.
*
* @param parameterIndex
* index of the parameter to set, where the first parameter has
* index = 1.
- * @param theClob
- * the Clob value to set
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setClob(int parameterIndex, Clob theClob) throws SQLException;
+ public void setCharacterStream(int parameterIndex, Reader theReader)
+ throws SQLException;
/**
- * Sets the Command property for this RowSet - the command is an SQL Query
- * which runs when the <code>execute</code> method is invoked. This
- * property is optional for datasources that do not support commands.
+ * Sets the value of the specified parameter in the RowSet command to the
+ * sequence of Unicode characters carried by the supplied java.io.Reader.
*
- * @param cmd
- * a String containing the SQL Query. Can be null.
+ * @param parameterName
+ * name for parameter
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setCommand(String cmd) throws SQLException;
+ public void setCharacterStream(String parameterName, Reader theReader)
+ throws SQLException;
/**
- * Sets the concurrency property of this RowSet. The default value is
- * ResultSet.CONCUR_READ_ONLY.
+ * Sets the value of the specified parameter in the RowSet command to the
+ * sequence of Unicode characters carried by the supplied java.io.Reader.
*
- * @param concurrency
- * the new concurrency value - one of: ResultSet.CONCUR_READ_ONLY
- * or ResultSet.CONCUR_UPDATABLE
+ * @param parameterName
+ * name for parameter
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @param length
+ * the length of the data in the Reader in characters
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setConcurrency(int concurrency) throws SQLException;
+ public void setCharacterStream(String parameterName, Reader theReader,
+ int length) throws SQLException;
/**
- * Sets the Data Source Name property for the RowSet.
- * <p>
- * The Data Source Name can be used to find a <code>DataSource</code>
- * which has been registered with a naming service - the DataSource can then
- * be used to create a connection to the database.
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.sql.Clob.
*
- * @param name
- * a String with the new Data Source Name.
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theClob
+ * the Clob value to set
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setDataSourceName(String name) throws SQLException;
+ public void setClob(int parameterIndex, Clob theClob) throws SQLException;
/**
* Sets the value of the specified parameter in the RowSet command with the
- * value of a supplied java.sql.Date.
+ * value of a supplied java.io.Reader.
*
* @param parameterIndex
* index of the parameter to set, where the first parameter has
* index = 1.
- * @param theDate
- * the Date to use
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setDate(int parameterIndex, Date theDate) throws SQLException;
+ public void setClob(int parameterIndex, Reader theReader)
+ throws SQLException;
/**
* Sets the value of the specified parameter in the RowSet command with the
- * value of a supplied java.sql.Date, where the conversion of the Date to an
- * SQL DATE value is calculated using a supplied Calendar.
+ * value of a supplied java.io.Reader.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @param length
+ * the length of the data in the Reader in characters
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setClob(int parameterIndex, Reader theReader, long length)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.sql.Clob.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param Clob
+ * the specific Clob object
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setClob(String parameterName, Clob x) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.Reader.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theClob
+ * the Clob value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setClob(String parameterName, Reader theReader)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.Reader.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @param length
+ * the length of the data in the Reader in characters
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setClob(String parameterName, Reader theReader, long length)
+ throws SQLException;
+
+ /**
+ * Sets the Command property for this RowSet - the command is an SQL Query
+ * which runs when the <code>execute</code> method is invoked. This
+ * property is optional for datasources that do not support commands.
+ *
+ * @param cmd
+ * a String containing the SQL Query. Can be null.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setCommand(String cmd) throws SQLException;
+
+ /**
+ * Sets the concurrency property of this RowSet. The default value is
+ * ResultSet.CONCUR_READ_ONLY.
+ *
+ * @param concurrency
+ * the new concurrency value - one of: ResultSet.CONCUR_READ_ONLY
+ * or ResultSet.CONCUR_UPDATABLE
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setConcurrency(int concurrency) throws SQLException;
+
+ /**
+ * Sets the Data Source Name property for the RowSet.
+ * <p>
+ * The Data Source Name can be used to find a <code>DataSource</code>
+ * which has been registered with a naming service - the DataSource can then
+ * be used to create a connection to the database.
+ *
+ * @param name
+ * a String with the new Data Source Name.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setDataSourceName(String name) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.sql.Date.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theDate
+ * the Date to use
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setDate(int parameterIndex, Date theDate) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.sql.Date, where the conversion of the Date to an
+ * SQL DATE value is calculated using a supplied Calendar.
*
* @param parameterIndex
* index of the parameter to set, where the first parameter has
@@ -462,113 +836,410 @@
/**
* Sets the value of the specified parameter in the RowSet command with the
- * supplied double.
+ * value of a supplied java.sql.Date, where the conversion of the Date to an
+ * SQL DATE value is calculated using a supplied Calendar.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theDate
+ * the Date to use
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setDate(String parameterName, Date theDate) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.sql.Date, where the conversion of the Date to an
+ * SQL DATE value is calculated using a supplied Calendar.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theDate
+ * the Date to use
+ * @param theCalendar
+ * the Calendar to use in converting the Date to an SQL DATE
+ * value
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setDate(String parameterName, Date theDate, Calendar theCalendar)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * supplied double.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theDouble
+ * the double value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setDouble(int parameterIndex, double theDouble)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * supplied double.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theDouble
+ * the double value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setDouble(String parameterName, double theDouble)
+ throws SQLException;
+
+ /**
+ * Sets the Escape Processing status for this RowSet. If escape processing
+ * is on, the driver performs escape substitution before sending an SQL
+ * command to the database. The default value for escape processing is on.
+ *
+ * @param enable
+ * true to enable Escape Processing, false to turn it off.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setEscapeProcessing(boolean enable) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * supplied float.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theFloat
+ * the float value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setFloat(int parameterIndex, float theFloat)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * supplied float.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theFloat
+ * the float value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setFloat(String parameterName, float theFloat)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * supplied integer.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theInteger
+ * the integer value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setInt(int parameterIndex, int theInteger) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * supplied integer.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theInteger
+ * the integer value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setInt(String parameterName, int theInteger)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * supplied long.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theLong
+ * the long value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setLong(int parameterIndex, long theLong) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * supplied long.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theLong
+ * the long value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setLong(String parameterName, long theLong) throws SQLException;
+
+ /**
+ * Sets the maximum number of bytes which can be returned for a column value
+ * where the column type BINARY, VARBINARY, LONGVARBINARYBINARY, CHAR,
+ * VARCHAR, or LONGVARCHAR. Data which exceeds this limit is silently
+ * discarded. For portability, a value greater than 256 is recommended.
+ *
+ * @param max
+ * the maximum size of the returned column value in bytes. 0
+ * means unlimited.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setMaxFieldSize(int max) throws SQLException;
+
+ /**
+ * Sets the maximum number of rows which can be held by the RowSet. Any
+ * additional rows are silently discarded.
+ *
+ * @param max
+ * the maximum number of rows which can be held in the RowSet. 0
+ * means no limit.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setMaxRows(int max) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.Reader.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setNCharacterStream(int parameterIndex, Reader theReader)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.Reader.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @param length
+ * the length of the data in the Reader in characters
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setNCharacterStream(int parameterIndex, Reader theReader,
+ long length) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.Reader.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theClob
+ * the Clob value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setNCharacterStream(String parameterName, Reader theReader)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.Reader.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @param length
+ * the length of the data in the Reader in characters
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setNCharacterStream(String parameterName, Reader theReader,
+ long length) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.sql.Clob.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theClob
+ * the Clob value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setNClob(int parameterIndex, NClob theNClob)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.Reader.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setNClob(int parameterIndex, Reader theReader)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.io.Reader.
*
* @param parameterIndex
* index of the parameter to set, where the first parameter has
* index = 1.
- * @param theDouble
- * the double value to set
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @param length
+ * the length of the data in the Reader in characters
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setDouble(int parameterIndex, double theDouble)
+ public void setNClob(int parameterIndex, Reader theReader, long length)
throws SQLException;
/**
- * Sets the Escape Processing status for this RowSet. If escape processing
- * is on, the driver performs escape substitution before sending an SQL
- * command to the database. The default value for escape processing is on.
+ * Sets the value of the specified parameter in the RowSet command with the
+ * value of a supplied java.sql.NClob.
*
- * @param enable
- * true to enable Escape Processing, false to turn it off.
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param value
+ * the given NClob object
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setEscapeProcessing(boolean enable) throws SQLException;
+ public void setNClob(String parameterName, NClob value) throws SQLException;
/**
* Sets the value of the specified parameter in the RowSet command with the
- * supplied float.
+ * value of a supplied java.io.Reader.
*
- * @param parameterIndex
- * index of the parameter to set, where the first parameter has
- * index = 1.
- * @param theFloat
- * the float value to set
+ * @param parameterName
+ * name for parameter
+ * @param theNClob
+ * the NClob value to set
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setFloat(int parameterIndex, float theFloat)
+ public void setNClob(String parameterName, Reader theReader)
throws SQLException;
/**
* Sets the value of the specified parameter in the RowSet command with the
- * supplied integer.
+ * value of a supplied java.io.Reader.
*
* @param parameterIndex
* index of the parameter to set, where the first parameter has
* index = 1.
- * @param theInteger
- * the integer value to set
+ * @param theReader
+ * the Reader which contains the Unicode data to set into the
+ * parameter
+ * @param length
+ * the length of the data in the Reader in characters
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setInt(int parameterIndex, int theInteger) throws SQLException;
+ public void setNClob(String parameterName, Reader theReader, long length)
+ throws SQLException;
/**
- * Sets the value of the specified parameter in the RowSet command with the
- * supplied long.
+ * Sets the value of the specified parameter in the RowSet command to the
+ * supplied NString
*
* @param parameterIndex
* index of the parameter to set, where the first parameter has
* index = 1.
- * @param theLong
- * the long value to set
+ * @param theNString
+ * the NString value to set
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setLong(int parameterIndex, long theLong) throws SQLException;
+ public void setNString(int parameterIndex, String theNString)
+ throws SQLException;
/**
- * Sets the maximum number of bytes which can be returned for a column value
- * where the column type BINARY, VARBINARY, LONGVARBINARYBINARY, CHAR,
- * VARCHAR, or LONGVARCHAR. Data which exceeds this limit is silently
- * discarded. For portability, a value greater than 256 is recommended.
+ * Sets the value of the specified parameter in the RowSet command to the
+ * supplied NString.
*
- * @param max
- * the maximum size of the returned column value in bytes. 0
- * means unlimited.
+ * @param parameterName
+ * name for parameter
+ * @param theNString
+ * the NString value to set
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setMaxFieldSize(int max) throws SQLException;
+ public void setNString(String parameterName, String theNString)
+ throws SQLException;
/**
- * Sets the maximum number of rows which can be held by the RowSet. Any
- * additional rows are silently discarded.
+ * Sets the value of the specified parameter in the RowSet command to SQL
+ * NULL.
*
- * @param max
- * the maximum number of rows which can be held in the RowSet. 0
- * means no limit.
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param sqlType
+ * the type of the parameter, as defined by java.sql.Types.
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setMaxRows(int max) throws SQLException;
+ public void setNull(int parameterIndex, int sqlType) throws SQLException;
/**
* Sets the value of the specified parameter in the RowSet command to SQL
- * NULL.
+ * NULL. This form of the <code>setNull</code> method should be used for
+ * User Defined Types and REF parameters.
*
* @param parameterIndex
* index of the parameter to set, where the first parameter has
* index = 1.
* @param sqlType
* the type of the parameter, as defined by java.sql.Types.
+ * @param typeName
+ * the fully qualified name of an SQL User Defined Type or the
+ * name of the SQL structured type referenced by a REF type.
+ * Ignored if the sqlType is not a UDT or REF type.
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setNull(int parameterIndex, int sqlType) throws SQLException;
+ public void setNull(int parameterIndex, int sqlType, String typeName)
+ throws SQLException;
/**
* Sets the value of the specified parameter in the RowSet command to SQL
@@ -580,6 +1251,20 @@
* index = 1.
* @param sqlType
* the type of the parameter, as defined by java.sql.Types.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setNull(String parameterName, int sqlType) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to SQL
+ * NULL. This form of the <code>setNull</code> method should be used for
+ * User Defined Types and REF parameters.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param sqlType
+ * the type of the parameter, as defined by java.sql.Types.
* @param typeName
* the fully qualified name of an SQL User Defined Type or the
* name of the SQL structured type referenced by a REF type.
@@ -587,7 +1272,7 @@
* @throws SQLException
* if an error occurs accessing the database.
*/
- public void setNull(int parameterIndex, int sqlType, String typeName)
+ public void setNull(String parameterName, int sqlType, String typeName)
throws SQLException;
/**
@@ -650,6 +1335,58 @@
int targetSqlType, int scale) throws SQLException;
/**
+ * Sets the value of the specified parameter in the RowSet command to a
+ * supplied Java object.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theObject
+ * the Java object containing the data value.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setObject(String parameterName, Object theObject)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to a
+ * supplied Java object.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theObject
+ * the Java object containing the data value.
+ * @param targetSqlType
+ * the SQL type to send to the database, as defined in
+ * java.sql.Types.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setObject(String parameterName, Object theObject,
+ int targetSqlType) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to a
+ * supplied Java object.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theObject
+ * the Java object containing the data value.
+ * @param targetSqlType
+ * the SQL type to send to the database, as defined in
+ * java.sql.Types.
+ * @param scale
+ * the number of digits after the decimal point, for
+ * java.sql.Types.DECIMAL and java.sql.Types.NUMERIC types.
+ * Ignored for all other types.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setObject(String parameterName, Object theObject,
+ int targetSqlType, int scale) throws SQLException;
+
+ /**
* Sets the database Password for this RowSet.
*
* @param password
@@ -713,6 +1450,20 @@
/**
* Sets the value of the specified parameter in the RowSet command to a
+ * supplied short integer.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theShort
+ * the short value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setShort(String parameterName, short theShort)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to a
* supplied String. The String is placed into the database as a VARCHAR or
* LONGVARCHAR SQL value, depending on the database limits for the length of
* VARCHAR values.
@@ -729,6 +1480,79 @@
/**
* Sets the value of the specified parameter in the RowSet command to a
+ * supplied String. The String is placed into the database as a VARCHAR or
+ * LONGVARCHAR SQL value, depending on the database limits for the length of
+ * VARCHAR values.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theString
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setString(String parameterName, String theString)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to the
+ * supplied RowId
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theRowId
+ * the RowId value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setRowId(int parameterIndex, RowId theRowId)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to the
+ * supplied RowId.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theRowId
+ * the RowId value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setRowId(String parameterName, RowId theRowId)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to the
+ * supplied SQLXML
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theSQLXML
+ * the SQLXML value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setSQLXML(int parameterIndex, SQLXML theSQLXML)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to the
+ * supplied SQLXML.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theSQLXML
+ * the SQLXML value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setSQLXML(String parameterName, SQLXML theSQLXML)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to a
* supplied java.sql.Time, converting to an SQL TIME value using the system
* default Calendar.
*
@@ -762,6 +1586,37 @@
/**
* Sets the value of the specified parameter in the RowSet command to a
+ * supplied java.sql.Time, converting to an SQL TIME value using a supplied
+ * Calendar.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theTime
+ * the Time value to set
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setTime(String parameterName, Time theTime) throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to a
+ * supplied java.sql.Time, converting to an SQL TIME value using a supplied
+ * Calendar.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theTime
+ * the Time value to set
+ * @param theCalendar
+ * the Calendar to use in the conversion operation
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setTime(String parameterName, Time theTime, Calendar theCalendar)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to a
* supplied java.sql.Timestamp, converting to an SQL TIMESTAMP value using
* the system default Calendar.
*
@@ -793,6 +1648,37 @@
Calendar theCalendar) throws SQLException;
/**
+ * Sets the value of the specified parameter in the RowSet command to a
+ * supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using a
+ * supplied Calendar.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theCalendar
+ * the Calendar to use in the conversion operation
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setTimestamp(String parameterName, Timestamp theTimestamp)
+ throws SQLException;
+
+ /**
+ * Sets the value of the specified parameter in the RowSet command to a
+ * supplied java.sql.Timestamp converting to an SQL TIMESTAMP value using a
+ * supplied Calendar.
+ *
+ * @param parameterName
+ * name for parameter
+ * @param theTimestamp
+ * @param theCalendar
+ * the Calendar to use in the conversion operation
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setTimestamp(String parameterName, Timestamp theTimestamp,
+ Calendar theCalendar) throws SQLException;
+
+ /**
* Updates the target instance's transaction isolation level to one of a
* discrete set of possible values.
*
@@ -843,6 +1729,21 @@
* if an error occurs accessing the database.
*/
public void setUrl(String theURL) throws SQLException;
+
+ /**
+ * Sets the URL used by this RowSet to access the database via a
+ * <code>DriverManager</code>. The URL is optional - an alternative is to
+ * use a Data Source Name to create a connection.
+ *
+ * @param parameterIndex
+ * index of the parameter to set, where the first parameter has
+ * index = 1.
+ * @param theURL
+ * a java.net.URL containing the URL for the database.
+ * @throws SQLException
+ * if an error occurs accessing the database.
+ */
+ public void setURL(int parameterIndex, URL theURL) throws SQLException;
/**
* Sets the Username property for the RowSet, used to authenticate a