Class WriteableRowSet

java.lang.Object

com.mcpdbwizard.pub.ReadOnlyRowSet

com.mcpdbwizard.pub.WriteableRowSet

public class WriteableRowSet
extends ReadOnlyRowSet

Create a writableRowSet that is based on a ResultSet.

Copyright 2003-2026 ATB Consultancy Services Ltd (formerly Orinda Software Ltd, Dublin, Ireland)

Under normal circumstances MCPDBWizard users will have no reason to use this class directly - the generated code will use it.

Version:

7

Author:

devteam@mcpdbwizard.com

Field Summary

Fields inherited from class com.mcpdbwizard.pub.ReadOnlyRowSet

colCount, columnDecimalPlaces, columnJavaDatatypes, columnLengths, columnNames, columnOracleDatatypeNames, currentRowNumber, downloadedFileDir, expireDate, hitMemLimit, hitRowLimit, keepFiles, keepLobs, minimumFreeMemoryBytes, objectUnloader, readOnlyRowSetData, rowCount, tempFilePrefix, tempFileSuffix, theLog, theNumberFormat, theTimestampFormat, underlyingOracleDatatypes, useByteArraysForLongsAndLOBS

Constructor Summary

Constructors

Constructor	Description
WriteableRowSet(Object[] theData, String[] columnNames, String[] columnOracleDatatypeNames, int[] underlyingOracleDatatypes, int[] columnJavaDatatypes, long[] columnLengths, int[] columnDecimalPlaces, LogInterface theLog, File downloadedFileDir, boolean keepFiles)	Create a ReadOnlyRowSet that is based on user defined data rather than a ResultSet.
WriteableRowSet(ResultSet theResultSet, String theQuery, int maxRows, LogInterface theLog)	Create a writableRowSet that is based on a ResultSet.

Method Summary

Modifier and Type	Method	Description
void	addNewRow(Object[] newRow)	Add a new row.
void	deleteCurrentRow()	Delete current row
void	setBoolean(int columnId, Boolean theValue)	Set column columnId as a native ISO-SQL BOOLEAN (23ai).
void	setBoolean(String theColumnName, Boolean theValue)	Set column columnName as a native ISO-SQL BOOLEAN (23ai).
void	setCurrentRow(Object[] currentRow)	Update current row as an array of Object
void	setJSON(int columnId, oracle.sql.json.OracleJsonValue theValue)	Set column columnId as a native Oracle JSON value (21c+).
void	setJSON(String theColumnName, oracle.sql.json.OracleJsonValue theValue)	Set column columnName as a native Oracle JSON value (21c+).
void	setString(int columnId, String theValue)	Set column columnId as a String.
void	setString(String theColumnName, String theValue)	Set column columnId as a String.
void	setVector(int columnId, double[] theValue)	Set column columnId as a native Oracle VECTOR (23ai).
void	setVector(String theColumnName, double[] theValue)	Set column columnName as a native Oracle VECTOR (23ai).
void	setVectorBinary(int columnId, byte[] theValue)	Set column columnId as a binary (bit-packed) Oracle VECTOR (23ai).
void	setVectorBinary(String theColumnName, byte[] theValue)	Set column columnName as a binary (bit-packed) Oracle VECTOR (23ai).
void	setVectorSparse(int columnId, SparseVector theValue)	Set column columnId as a sparse Oracle VECTOR (23ai).
void	setVectorSparse(String theColumnName, SparseVector theValue)	Set column columnName as a sparse Oracle VECTOR (23ai).

Methods inherited from class com.mcpdbwizard.pub.ReadOnlyRowSet

checkColumnName, checkRange, checkRows, convertNumberToString, convertTIMESTAMPLTZToDate, convertTIMESTAMPLTZToString, convertTIMESTAMPLTZToTimestamp, convertTIMESTAMPToDate, convertTimestampToString, convertTIMESTAMPToString, convertTIMESTAMPToTimestamp, convertTIMESTAMPTZToDate, convertTIMESTAMPTZToString, convertTIMESTAMPTZToTimestamp, createInvalidDatatypeCastException, deleteGeneratedFiles, first, getBFILE, getBFILE, getBigDecimal, getBigDecimal, getBLOB, getBLOB, getBoolean, getBoolean, getBooleanObj, getBooleanObj, getByte, getByte, getByteArray, getByteArray, getByteObj, getByteObj, getCharArray, getCharArray, getCLOB, getCLOB, getColumnId, getColumnName, getColumnNamesAsString, getColumnNamesAsStringArray, getColumnOracleDatatypeNames, getCurrentRow, getCurrentRowNumber, getDate, getDate, getDouble, getDouble, getDoubleObj, getDoubleObj, getExpireDate, getFile, getFile, getFloat, getFloat, getFloatObj, getFloatObj, getInt, getInt, getIntegerObj, getIntegerObj, getJSON, getJSON, getLong, getLong, getLongObj, getLongObj, getObject, getObject, getOpaque, getOpaque, getRowAsString, getShort, getShort, getShortObj, getShortObj, getString, getString, getTempFileSuffix, getTimestamp, getTimestamp, getTIMESTAMP, getTIMESTAMP, getTIMESTAMPLTZ, getTIMESTAMPLTZ, getTIMESTAMPTZ, getTIMESTAMPTZ, getVector, getVector, getVectorBinary, getVectorBinary, getVectorSparse, getVectorSparse, getWriteableRowSet, hasExpired, hitMemLimit, hitRowLimit, isNull, isNull, last, nextRow, prevRow, retainShallowestByIntColumn, setCurrentRowNumber, setExpireDate, setNumberFormat, setTempFileSuffix, setTimestampFormat, size, toString, unloadObject, width

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

WriteableRowSet

public WriteableRowSet(ResultSet theResultSet,
 String theQuery,
 int maxRows,
 LogInterface theLog)
                throws CSException

Create a writableRowSet that is based on a ResultSet.

Parameters:

theResultSet -

theQuery -

maxRows -

theLog -

Throws:

CSException

WriteableRowSet

public WriteableRowSet(Object[] theData,
 String[] columnNames,
 String[] columnOracleDatatypeNames,
 int[] underlyingOracleDatatypes,
 int[] columnJavaDatatypes,
 long[] columnLengths,
 int[] columnDecimalPlaces,
 LogInterface theLog,
 File downloadedFileDir,
 boolean keepFiles)

Create a ReadOnlyRowSet that is based on user defined data rather than a ResultSet.

This constructor is used to create a rowset based on a set of parameters for a stored procedure call.

Parameters:

theData - An array of Object that contains another array of Object. The inner arrays are all of the the same length and map to a row of columns.

columnNames -

columnOracleDatatypeNames -

underlyingOracleDatatypes -

columnJavaDatatypes -

theLog -

downloadedFileDir - A directory to keep files containing clobs and blobs

Method Details

setCurrentRow

public void setCurrentRow(Object[] currentRow)
                   throws CSNoDataInRowSetException

Update current row as an array of Object

Parameters:

currentRow - A one dimensional Object array to store as the current row.

Throws:

CSNoDataInRowSetException - if the rowset is empty.

deleteCurrentRow

public void deleteCurrentRow()
                      throws CSNoDataInRowSetException

Delete current row

Throws:

CSNoDataInRowSetException - if the rowset is empty.

addNewRow

public void addNewRow(Object[] newRow)
               throws CSNoDataInRowSetException

Add a new row. We assume that newRow is an array of Object whose structure exactly matches the existing rows

Parameters:

newRow - A one dimensional Object array to add as a new row.

Throws:

CSNoDataInRowSetException

setString

public void setString(String theColumnName,
 String theValue)
               throws CSInvalidColumnIdException,
CSNoDataInRowSetException,
CSDBInvalidDatatypeCastException,
CSUnsupportedDatatypeException

Set column columnId as a String. Numbers will be formatted. Dates will be formatted according to theTimeStampFormat.

Parameters:

theColumnName - The name of the column

theValue - of column #columnId.

Throws:

CSInvalidColumnIdException - if columnId is not the id of a valid column. Column numbering starts at 0.

CSNoDataInRowSetException - if there are no rows in this rowset.

CSDBInvalidDatatypeCastException - if columnId is not of a data type that can be turned into a String.

CSUnsupportedDatatypeException - if columnId is not of a data type that we support.

setString

public void setString(int columnId,
 String theValue)
               throws CSInvalidColumnIdException,
CSNoDataInRowSetException,
CSDBInvalidDatatypeCastException,
CSUnsupportedDatatypeException

Set column columnId as a String. Numbers will be formatted. Dates will be formatted according to theTimeStampFormat.

Parameters:

columnId - The number of the column.

theValue - value of column #columnId if it can be turned into a string.

Throws:

CSInvalidColumnIdException - if columnId is not the id of a valid column. Column numbering starts at 0.

CSNoDataInRowSetException - if there are no rows in this rowset.

CSDBInvalidDatatypeCastException - if columnId is not of a data type that can be turned into a String.

CSUnsupportedDatatypeException - if columnId is not of a data type that we support.

setJSON

public void setJSON(String theColumnName,
 oracle.sql.json.OracleJsonValue theValue)
             throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnName as a native Oracle JSON value (21c+).

Parameters:

theColumnName - The name of the column.

theValue - The JSON document (may be null).

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 21c

setJSON

public void setJSON(int columnId,
 oracle.sql.json.OracleJsonValue theValue)
             throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnId as a native Oracle JSON value (21c+).

Parameters:

columnId - The number of the column.

theValue - The JSON document (may be null).

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 21c

setVector

public void setVector(String theColumnName,
 double[] theValue)
               throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnName as a native Oracle VECTOR (23ai).

Parameters:

theColumnName - The name of the column.

theValue - One element per dimension (may be null).

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 23ai

setVector

public void setVector(int columnId,
 double[] theValue)
               throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnId as a native Oracle VECTOR (23ai).

Parameters:

columnId - The number of the column.

theValue - One element per dimension (may be null).

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 23ai

setVectorBinary

public void setVectorBinary(String theColumnName,
 byte[] theValue)
                     throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnName as a binary (bit-packed) Oracle VECTOR (23ai). Distinct from setVector(String, double[]) (dense FLOAT32/FLOAT64/INT8 vectors).

Parameters:

theColumnName - The name of the column.

theValue - The packed vector bytes (n bits = n/8 bytes), may be null.

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 23ai

setVectorBinary

public void setVectorBinary(int columnId,
 byte[] theValue)
                     throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnId as a binary (bit-packed) Oracle VECTOR (23ai).

Parameters:

columnId - The number of the column.

theValue - The packed vector bytes (n bits = n/8 bytes), may be null.

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 23ai

setVectorSparse

public void setVectorSparse(String theColumnName,
 SparseVector theValue)
                     throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnName as a sparse Oracle VECTOR (23ai). Distinct from setVector(String, double[]) (dense) and setVectorBinary(String, byte[]) (binary): a sparse vector carries {length, indices, values} and is not densified.

Parameters:

theColumnName - The name of the column.

theValue - The sparse vector (may be null).

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 23ai

setVectorSparse

public void setVectorSparse(int columnId,
 SparseVector theValue)
                     throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnId as a sparse Oracle VECTOR (23ai).

Parameters:

columnId - The number of the column.

theValue - The sparse vector (may be null).

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 23ai

setBoolean

public void setBoolean(String theColumnName,
 Boolean theValue)
                throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnName as a native ISO-SQL BOOLEAN (23ai).

Parameters:

theColumnName - The name of the column.

theValue - The boolean (may be null).

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 23ai

setBoolean

public void setBoolean(int columnId,
 Boolean theValue)
                throws CSInvalidColumnIdException,
CSNoDataInRowSetException

Set column columnId as a native ISO-SQL BOOLEAN (23ai).

Parameters:

columnId - The number of the column.

theValue - The boolean (may be null).

Throws:

CSInvalidColumnIdException

CSNoDataInRowSetException

Since:

Oracle 23ai