A B C D E F G H I J L M N O P Q R S T U W X

A

addJTextArea(JTextArea, int) - Method in class com.orindasoft.pub.UiLog

Set a new Text Area

addNewRow(Object[]) - Method in class com.orindasoft.pub.WriteableRowSet

Add a new row.

allowsNulls - Variable in class com.orindasoft.pub.CSColumnException

Whether null is allowed

B

bindParameters(CallableStatement) - Method in class com.orindasoft.pub.CallableStatementParameters

Bind these parameters to a Prepared Statement.

bindParameters(PreparedStatement) - Method in class com.orindasoft.pub.StatementParameters2

Bind these parameter to a Prepared Statement.

C

CACHE_FOREVER - Static variable in class com.orindasoft.pub.QueryStatement

Constant for caching data for the life of the class.

CACHE_NEVER - Static variable in class com.orindasoft.pub.QueryStatement

Constant for not caching data.

CallableStatementParameters - class com.orindasoft.pub.CallableStatementParameters.

A set of parameters for a Callable Statement statement call This class represents OUT or IN/OUT parameters for a Stored Procedure or function.

CallableStatementParameters(int, LogInterface) - Constructor for class com.orindasoft.pub.CallableStatementParameters

Create a set of statement Parameters of size howMany.

CallableStatementParameters(String, LogInterface) - Constructor for class com.orindasoft.pub.CallableStatementParameters

Create a set of statement Parameters by counting '?' characters in a SQL statement

checkBuild(int) - Static method in class com.orindasoft.pub.StatementParameters2

Return version of this class This menthod is used by generated code to make sure that it's using the right version of com.orindasoft.pub.

checkColumnName(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Make sure that theColumnName is a valid column.

checkSet() - Method in class com.orindasoft.pub.StatementParameters2

Complain if not all parameters set...

checkSet() - Method in class com.orindasoft.pub.CallableStatementParameters

Complain if not all parameters set...

clearCache() - Method in class com.orindasoft.pub.QueryStatement

Clear the cache.

clearJTextArea() - Method in class com.orindasoft.pub.UiLog

Clear the text area

clearParameters() - Method in class com.orindasoft.pub.StatementParameters2

Clear our parameter array

clearParameters() - Method in class com.orindasoft.pub.CallableStatementParameters

Clear our parameter array

close() - Method in class com.orindasoft.pub.TextLog

Flush and close the current log file.

COLUMN_LENGTH_EXCEEDED - Static variable in class com.orindasoft.pub.CSColumnException

Constant to indicate String is to long or a number has too many digits to the left of the decimal point.

columnName - Variable in class com.orindasoft.pub.CSColumnException

Column name

com.orindasoft.pub - package com.orindasoft.pub

Provides classes and interfaces used by JDBCWizard 6.0.2839 generated code.

confirmDirectory(String) - Static method in class com.orindasoft.pub.IOUtils

Make sure directory directoryName exists.

connectionIsUsable() - Method in class com.orindasoft.pub.DmlStatement

Check if our connection is usable

ConsoleLog - class com.orindasoft.pub.ConsoleLog.

This is a lightweight implementation of LogInterface that uses standard output for information messages and standard error for everything else.

ConsoleLog() - Constructor for class com.orindasoft.pub.ConsoleLog

Create an instance of ConsoleLog.

copyFile(File, File) - Static method in class com.orindasoft.pub.IOUtils

Copies a file.

countParameters(String) - Static method in class com.orindasoft.pub.SqlUtils

Count parameters in a SQL Statement This method has a known bug

createBfileLocator(String, String, Connection, LogInterface, boolean) - Static method in class com.orindasoft.pub.SqlUtils

Create and return a BFILE locator.

CSAttemptToGetNullException - exception com.orindasoft.pub.CSAttemptToGetNullException.

Thrown when a method which returns a native type such as int,long,double is called for a column whose value is null.

CSAttemptToGetNullException() - Constructor for class com.orindasoft.pub.CSAttemptToGetNullException

Default constructor

CSAttemptToGetNullException(String, int) - Constructor for class com.orindasoft.pub.CSAttemptToGetNullException

Constructor which takes an message and a columnId

CSColumnException - exception com.orindasoft.pub.CSColumnException.

Thrown by the rowValidate method when a non-null column is null or a number column's contents don't match the size of the corresponding database column.

CSColumnException(String, String, int, Object, boolean, int, int, String) - Constructor for class com.orindasoft.pub.CSColumnException

Contructor with parameters

CSDBException - exception com.orindasoft.pub.CSDBException.

Thrown when a SQLException is generated.

CSDBException() - Constructor for class com.orindasoft.pub.CSDBException

Default constructor

CSDBException(int, String, String, String) - Constructor for class com.orindasoft.pub.CSDBException

Contructor with parameters

CSDBInvalidDatatypeCastException - exception com.orindasoft.pub.CSDBInvalidDatatypeCastException.

Thrown when an attempt is made to retrieve a value in a form that it can not be converted to.

CSDBInvalidDatatypeCastException() - Constructor for class com.orindasoft.pub.CSDBInvalidDatatypeCastException

Default constructor

CSDBInvalidDatatypeCastException(String, String, String) - Constructor for class com.orindasoft.pub.CSDBInvalidDatatypeCastException

Constructer that takes parameters.

CSDBNullObjectException - exception com.orindasoft.pub.CSDBNullObjectException.

Thrown when a null is found where an object is required
(c) Copyright 2003 - 2011 Orinda Software Ltd

CSDBNullObjectException() - Constructor for class com.orindasoft.pub.CSDBNullObjectException

CSException - exception com.orindasoft.pub.CSException.

An extension of Exception used by this package.

CSException() - Constructor for class com.orindasoft.pub.CSException

Default constructor

CSException(String) - Constructor for class com.orindasoft.pub.CSException

Default constructor that takes a String

CSInvalidColumnIdException - exception com.orindasoft.pub.CSInvalidColumnIdException.

Thrown when an attempt is made to retrieve a value from a column that does not exist.

CSInvalidColumnIdException() - Constructor for class com.orindasoft.pub.CSInvalidColumnIdException

Default constructor

CSInvalidColumnIdException(String, int) - Constructor for class com.orindasoft.pub.CSInvalidColumnIdException

CSInvalidDataTypeException - exception com.orindasoft.pub.CSInvalidDataTypeException.

Thrown when an we encounter a value whose data type is unsupported
(c) Copyright 2003 - 2011 Orinda Software Ltd

CSInvalidDataTypeException() - Constructor for class com.orindasoft.pub.CSInvalidDataTypeException

Default constructor

CSInvalidDataTypeException(String, String, String) - Constructor for class com.orindasoft.pub.CSInvalidDataTypeException

Thrown when an we encounter a value whose data type is unsupported

CSIOException - exception com.orindasoft.pub.CSIOException.

Thrown when we encounter an IOException
(c) Copyright 2003 - 2011 Orinda Software Ltd

CSIOException() - Constructor for class com.orindasoft.pub.CSIOException

Default constructor

CSIOException(String) - Constructor for class com.orindasoft.pub.CSIOException

Constructor with parameters.

CSNoDataInRowSetException - exception com.orindasoft.pub.CSNoDataInRowSetException.

Thrown when an attempt is made to retrieve a value from an empty readOnlyRowset.

CSNoDataInRowSetException() - Constructor for class com.orindasoft.pub.CSNoDataInRowSetException

Default constructor

CSNoDataInRowSetException(String) - Constructor for class com.orindasoft.pub.CSNoDataInRowSetException

Constructor with parameters.

CSNoNanosAllowedException - exception com.orindasoft.pub.CSNoNanosAllowedException.

Thrown when a Timestamp contains nanoseconds but the Oracle table/record it will be used against is DATA and doesn't support nanonseconds.

CSNoNanosAllowedException(String, Timestamp) - Constructor for class com.orindasoft.pub.CSNoNanosAllowedException

CSNumberFormatException - exception com.orindasoft.pub.CSNumberFormatException.

Thrown when an attempt to turn a String into a number fails
(c) Copyright 2003 - 2011 Orinda Software Ltd

CSNumberFormatException(String, String) - Constructor for class com.orindasoft.pub.CSNumberFormatException

CSUnsupportedDatatypeException - exception com.orindasoft.pub.CSUnsupportedDatatypeException.

Thrown when an attempt is made to retrieve a value from a column has an unsupported datatype
(c) Copyright 2003 - 2011 Orinda Software Ltd

CSUnsupportedDatatypeException() - Constructor for class com.orindasoft.pub.CSUnsupportedDatatypeException

Default constructor

CSUnsupportedDatatypeException(String, String) - Constructor for class com.orindasoft.pub.CSUnsupportedDatatypeException

Constructor with parameters.

D

DDL - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being DDL statements

DEBUG - Static variable in interface com.orindasoft.pub.LogInterface

Constant used when formatting message strings

debug(String) - Method in class com.orindasoft.pub.GenericLog

debug(String) - Method in interface com.orindasoft.pub.LogInterface

Log a debug message.

debug(String, boolean, boolean) - Method in class com.orindasoft.pub.GenericLog

debug(String, boolean, boolean) - Method in interface com.orindasoft.pub.LogInterface

Log a debug message.

debugOff() - Method in class com.orindasoft.pub.GenericLog

Turn debug messages off

debugOff() - Method in interface com.orindasoft.pub.LogInterface

Turn debug messages off

debugOn() - Method in class com.orindasoft.pub.GenericLog

Turn debug messages on

debugOn() - Method in interface com.orindasoft.pub.LogInterface

Turn debug messages on

DECIMAL_PLACES_EXCEEDED - Static variable in class com.orindasoft.pub.CSColumnException

Constant to indicate column is a number that has too many digits to the left of the decimal point.

decimalPlaces - Variable in class com.orindasoft.pub.CSColumnException

How many digits a number has to the right of the decimal point.

DEFAULT_FIELD_DELIMITER - Static variable in interface com.orindasoft.pub.LogInterface

Constant for the field delimiter used in log messages

DEFAULT_FILENAME_DAY_FORMAT - Static variable in interface com.orindasoft.pub.LogInterface

Default format for day component of log file names.

DEFAULT_FILENAME_TIME_FORMAT - Static variable in interface com.orindasoft.pub.LogInterface

Default format for time component of log file names.

DEFAULT_QUERIES_CACHED - Static variable in class com.orindasoft.pub.QueryStatement

Default value for how many different queries we can cache...

DEFAULT_QUERY_ROWS - Static variable in class com.orindasoft.pub.QueryStatement

Default value for how many rows returned by a query we actually use...

DEFAULT_TIME_FORMAT_STRING - Static variable in interface com.orindasoft.pub.LogInterface

Constant for the time format used in log messages

DELETE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being deletes

deleteCurrentRow() - Method in class com.orindasoft.pub.WriteableRowSet

Delete current row

deleteGeneratedFiles() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Delete all files in this ReadOnlyRowSet This is a cleanup method that you can use when the underlying cursor contained one or more LOB columns and you need to explicitly remove the resulting files.

DmlStatement - class com.orindasoft.pub.DmlStatement.

A parameterized SQL statement that continues to exist even if the connection it uses is withdrawn.

DmlStatement(String, LogInterface) - Constructor for class com.orindasoft.pub.DmlStatement

Create a DML Statement object.

DmlStatement(String, LogInterface, Connection) - Constructor for class com.orindasoft.pub.DmlStatement

Create a DML Statement object and give it a connection

E

ERROR - Static variable in interface com.orindasoft.pub.LogInterface

Constant used when formatting message strings

error(Exception) - Method in class com.orindasoft.pub.GenericLog

error(Exception) - Method in interface com.orindasoft.pub.LogInterface

Log an Exception.

error(Exception, boolean, boolean) - Method in class com.orindasoft.pub.GenericLog

error(Exception, boolean, boolean) - Method in interface com.orindasoft.pub.LogInterface

Log an error message.

error(String) - Method in class com.orindasoft.pub.GenericLog

error(String) - Method in interface com.orindasoft.pub.LogInterface

Log an error message.

error(String, boolean, boolean) - Method in class com.orindasoft.pub.GenericLog

error(String, boolean, boolean) - Method in interface com.orindasoft.pub.LogInterface

Log an error message.

exceptionType - Variable in class com.orindasoft.pub.CSColumnException

What kind of CSColumnException this is - one of NULL_NOT_ALLOWED_HERE, COLUMN_LENGTH_EXCEEDED or DECIMAL_PLACES_EXCEEDED

execute() - Method in class com.orindasoft.pub.QueryStatement

Execute the statement and return a ReadOnlyRowSet If caching is in use the cache will be checked and a cached copy returned if possible.

F

FAILED_TO_CONVERT_INTERNAL - Static variable in class com.orindasoft.pub.SqlUtils

Constant for ORA-17059 message - invalid name pattern The most common cause for this is a DB/Driver version mismatch

first() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Move to first row of the RowSet.

flush() - Method in class com.orindasoft.pub.GenericLog

flush() - Method in class com.orindasoft.pub.ConsoleLog

This is required by LogInterface but is not used in the implementation.

flush() - Method in class com.orindasoft.pub.TextLog

Flush any outstanding changes.

flush() - Method in interface com.orindasoft.pub.LogInterface

If the log is buffered then flush any outstanding changes.

flush() - Method in class com.orindasoft.pub.Log4JLog

This method is not meaningful to org.apache.log4j.Logger but is implemented as a null-op because it's part of LogInterface

flush() - Method in class com.orindasoft.pub.JavaLog

This method is not meaningful to java.util.logging.Logger but is implemented as a null-op because it's part of LogInterface

freeConnection() - Method in class com.orindasoft.pub.DmlStatement

Release the current connection

freeMemAsPct() - Static method in class com.orindasoft.pub.ResourceWatcher

Return free memory expressed as a percentage of total memory.

G

GenericLog - class com.orindasoft.pub.GenericLog.

Partial implementation of LogInterface that composes error messages but leaves the actual logging to other classes.

GenericLog() - Constructor for class com.orindasoft.pub.GenericLog

Create an instance of GenericLog.

getArray() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the array data

getArray() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data

getArrayAsBigDecimal() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the array data as java.math.BigDecimal[] This convenience method returns the contents of the array as an array of BigDecimal.

getArrayAsBigDecimal() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as java.math.BigDecimal[] This convenience method returns the contents of the array as an array of BigDecimal.

getArrayAsDouble(double) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the array data as double[] This convenience method returns the contents of the array as an array of double.

getArrayAsDouble(double) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as double[] This convenience method returns the contents of the array as an array of double.

getArrayAsDoubleObject() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as Double[] This convenience method returns the contents of the array as an array of BigDecimal.

getArrayAsFloat(float) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the array data as float[] This convenience method returns the contents of the array as an array of float.

getArrayAsFloat(float) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as float[] This convenience method returns the contents of the array as an array of float.

getArrayAsFloatObject() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as Float[] This convenience method returns the contents of the array as an array of BigDecimal.

getArrayAsInt(int) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the array data as int[] This convenience method returns the contents of the array as an array of int.

getArrayAsInt(int) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as int[] This convenience method returns the contents of the array as an array of int.

getArrayAsIntegerObject() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as Integer[] This convenience method returns the contents of the array as an array of BigDecimal.

getArrayAsLong(long) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the array data as long[] This convenience method returns the contents of the array as an array of long.

getArrayAsLong(long) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as long[] This convenience method returns the contents of the array as an array of long.

getArrayAsLongObject() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as Long[] This convenience method returns the contents of the array as an array of BigDecimal.

getArrayAsRaw() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as byte[] This convenience method returns the contents of the array as an array of byte[].

getArrayAsString() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the array data as String[] This convenience method returns the contents of the array as an array of String.

getArrayAsString() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as String[] This convenience method returns the contents of the array as an array of String.

getArrayAsTimestamp() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the array data as java.sql.Timestamp This convenience method returns the contents of the array as an array of java.sql.Timestamp.

getArrayLength() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the length of the array

getArrayLength() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the length of the array

getArrayName() - Method in interface com.orindasoft.pub.PlsqlArray

Return array name

getBFILE(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.BFILE Object This method will only work if 'keepLobs' was set to true.

getBFILE(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.BFILE Object This method will only work if 'keepLobs' was set to true.

getBigDecimal(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a java.math.BigDecimal Object

getBigDecimal(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a java.math.BigDecimal Object

getBLOB(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.BLOB Object This method will only work if 'keepLobs' was set to true.

getBLOB(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.BLOB Object This method will only work if 'keepLobs' was set to true.

getBoolean(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a boolean.

getBoolean(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a boolean.

getBooleanObj(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Boolean Object

getBooleanObj(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Boolean Object

getBufferSize() - Method in class com.orindasoft.pub.QueryStatement

Get current file io buffer size

getByte(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a byte.

getByte(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a byte.

getByteArray(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a byte[] Object

getByteArray(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a byte[] Object

getByteObj(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Byte Object

getByteObj(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Byte Object

getCacheSize() - Method in class com.orindasoft.pub.QueryStatement

Return the number of queries currently in the cache.

getCharArray(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a char[] Object

getCharArray(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a char[] Object

getCLOB(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.CLOB Object This method will only work if 'keepLobs' was set to true.

getCLOB(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.CLOB Object This method will only work if 'keepLobs' was set to true.

getColumnId(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get the position of a named column in rows of the underlying result set.

getColumnName(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get the name of a column.

getColumnNamesAsString(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return the row's column names in the form of a delimited string

getColumnNamesAsStringArray() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return the row's column names in the form of a string Array

getColumnOracleDatatypeNames() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return the Oracle data types of the the columns as an array of String

getConsoleOutput() - Method in class com.orindasoft.pub.TextLog

Find out whether messages are being sent to standard output and standard error.

getCurrentLog() - Method in class com.orindasoft.pub.GenericLog

getCurrentLog() - Method in class com.orindasoft.pub.ConsoleLog

This is required by LogInterface but is not used in the implementation.

getCurrentLog() - Method in class com.orindasoft.pub.TextLog

Get current log file name.

getCurrentLog() - Method in interface com.orindasoft.pub.LogInterface

Returns a string with the name of the current log.

getCurrentLog() - Method in class com.orindasoft.pub.Log4JLog

Returns the name of the current logging object.

getCurrentLog() - Method in class com.orindasoft.pub.JavaLog

Returns the name of the current logging object.

getCurrentRow() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return current row as an array of Object

getCurrentRowNumber() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return the current row number

getCurrentValuesAsObject(Connection) - Method in interface com.orindasoft.pub.PlsqlArray

Return array as Object[]

getDataTypeCode() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the underlying OracleType code for the array.

getDataTypeCode() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the official OracleType code for the array.

getDate(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a java.sql.Date

getDate(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a java.sql.Date

getDateFormat() - Method in class com.orindasoft.pub.GenericLog

Return date format string

getDateFormat() - Method in interface com.orindasoft.pub.LogInterface

Returns the current Date Format

getDebug() - Method in class com.orindasoft.pub.GenericLog

Get debug status

getDebug() - Method in interface com.orindasoft.pub.LogInterface

Get debug status

getDouble(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a double.

getDouble(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a double.

getDoubleObj(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Double Object

getDoubleObj(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Double Object

getElementMaxCount() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the maximum size this table can be after an update or retrieval.

getElementMaxCount() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the maximum size this table can be after an update or retrieval.

getElementMaxLength() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Get the maximum length of an element in the table

getElementMaxLength() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the maximum length of an element in the table

getErrors() - Method in interface com.orindasoft.pub.StatsInterface

Get Errors

getErrors() - Method in class com.orindasoft.pub.QueryStatement

Return counter containing number of errors.

getExecutions() - Method in interface com.orindasoft.pub.StatsInterface

Get executions

getExecutions() - Method in class com.orindasoft.pub.QueryStatement

Return counter containing number of executions.

getExecutionTime() - Method in interface com.orindasoft.pub.StatsInterface

Get execution time

getExecutionTime() - Method in class com.orindasoft.pub.QueryStatement

Return counter containing time spent executing statement in milliseconds.

getExpireDate() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Set how long the result will remain up to date.

getFile(int, File) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get a long text or binary column columnId as a File BLOBS, CLOBS and LONGS are downloaded to File's if in a ResultSet used to create a ReadOnlyRowSet.

getFile(String, File) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get a long text or binary column columnId as a File BLOBS, CLOBS and LONGS are downloaded to File's if in a ResultSet used to create a ReadOnlyRowSet.

getFloat(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a float.

getFloat(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a float.

getFloatObj(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Float Object

getFloatObj(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Float Object

getInt(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as an int.

getInt(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as an int.

getIntegerObj(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Integer Object

getIntegerObj(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Integer Object

getKeepFiles() - Method in class com.orindasoft.pub.QueryStatement

Get keepFiles flag

getKeepLobs() - Method in class com.orindasoft.pub.QueryStatement

Get keepLobs

getLatestQuerySignature() - Method in class com.orindasoft.pub.QueryStatement

Return an up to date signature of the query parameters.

getLibraryVersion() - Static method in class com.orindasoft.pub.LibraryInfo

Return version of public library we are using.

getLogger() - Method in class com.orindasoft.pub.Log4JLog

Return a copy of the current Logger object

getLogger() - Method in class com.orindasoft.pub.JavaLog

Return a copy of the current Logger object

getLong(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a long.

getLong(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a long.

getLongObj(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Long Object

getLongObj(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Long Object

getObject(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as an Object.

getObject(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as an Object.

getOpaque(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as an oracle.sql.OPAQUE.

getOpaque(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as an oracle.sql.OPAQUE.

getOsTempDir() - Static method in class com.orindasoft.pub.IOUtils

Return an OS-Specific temporary directory File

getParam(int) - Method in class com.orindasoft.pub.StatementParameters2

Get a parameter

getParamCount() - Method in class com.orindasoft.pub.StatementParameters2

Return number of parameters that are null

getParameters() - Method in class com.orindasoft.pub.StatementParameters2

Get all parameters

getParses() - Method in interface com.orindasoft.pub.StatsInterface

Get Parses

getParses() - Method in class com.orindasoft.pub.QueryStatement

Return counter containing number of parses.

getParseTime() - Method in interface com.orindasoft.pub.StatsInterface

Get Parse time

getParseTime() - Method in class com.orindasoft.pub.QueryStatement

Return counter containing time spent parsing in milliseconds.

getProductVersion() - Static method in class com.orindasoft.pub.LibraryInfo

Return build of public library we are using.

getRealDataTypeCode() - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Get the actual OracleType code for the array.

getReleases() - Method in interface com.orindasoft.pub.StatsInterface

Get Releases

getReleases() - Method in class com.orindasoft.pub.QueryStatement

Return counter containing number of releases.

getRetrievalTime() - Method in interface com.orindasoft.pub.StatsInterface

Get Retrieval time

getRetrievalTime() - Method in class com.orindasoft.pub.QueryStatement

Return counter containing time spent retrieving data in milliseconds.

getRowAsString(String, String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return the entire row in the form of a delimited string

getShort(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a short.

getShort(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a short.

getShortObj(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Short Object

getShortObj(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a Short Object

getSignature() - Method in class com.orindasoft.pub.StatementParameters2

Return a String that uniquely identifies a set of parameters.

getStatementType(String) - Static method in class com.orindasoft.pub.SqlUtils

Classify a SQL statement as a SELECT, INSERT, UPDATE, etc.

getString(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a String.

getString(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a String.

getStringFromConsole(String, boolean) - Static method in class com.orindasoft.pub.IOUtils

Get the user to enter a String

getTempDir() - Method in class com.orindasoft.pub.QueryStatement

Get temporary directory

getTempFilePrefix() - Method in class com.orindasoft.pub.QueryStatement

Get the prefix used for generating temporary files

getTempFileSuffix() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get the prefix used for generating temporary files

getTempFileSuffix() - Method in class com.orindasoft.pub.QueryStatement

Get the suffix used for generating temporary files

getTimestamp(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a java.sql.Timestamp

getTIMESTAMP(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a TIMESTAMP Object

getTimestamp(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a java.sql.Timestamp

getTIMESTAMP(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.TIMESTAMP Object

getTIMESTAMPLTZ(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a TIMESTAMPLTZ Object

getTIMESTAMPLTZ(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.TIMESTAMPLTZ Object

getTIMESTAMPTZ(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a TIMESTAMPTZ Object

getTIMESTAMPTZ(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Get column columnId as a oracle.sql.TIMESTAMPTZ Object

getUnderlyingOracleDatatype(String) - Static method in class com.orindasoft.pub.SqlUtils

Return an int that represents the underlying oracle data type.

getUnderlyingStatement() - Method in class com.orindasoft.pub.DmlStatement

Return underlying java.sql.Statement Object.

getUseByteArraysForLongsAndLOBS() - Method in class com.orindasoft.pub.QueryStatement

Get keepLobs

getWriteableRowSet() - Method in class com.orindasoft.pub.ReadOnlyRowSet

grep(String, File) - Static method in class com.orindasoft.pub.IOUtils

An extremely crude implemtation of 'grep'

H

hasExpired() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Set how long the result will remain up to date.

hasResources() - Method in interface com.orindasoft.pub.OracleResourceUser

Used to tell if the object is using Oracle resources.

hasResources() - Method in class com.orindasoft.pub.DmlStatement

Used to tell if the object is using Oracle resources.

hitMemLimit() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Identify when we had to stop adding rows to the ResultSet because we ran out of memory.

hitRowLimit() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Identify when we had to stop adding rows to the ResultSet because we reached the limit on the number of rows that are to be stored.

I

INFO - Static variable in interface com.orindasoft.pub.LogInterface

Constant used when formatting message strings

info(String) - Method in class com.orindasoft.pub.GenericLog

info(String) - Method in interface com.orindasoft.pub.LogInterface

Log an informational message.

info(String, boolean, boolean) - Method in class com.orindasoft.pub.GenericLog

info(String, boolean, boolean) - Method in interface com.orindasoft.pub.LogInterface

Log an informational message.

INSERT - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being inserts

INVALID_NAME_PATTERN - Static variable in class com.orindasoft.pub.SqlUtils

Constant for ORA-17074 message - invalid name pattern

IO_BUFFER_SIZE - Static variable in class com.orindasoft.pub.IOUtils

Default block size for IO operations

IOUtils - class com.orindasoft.pub.IOUtils.

A set of useful static methods for working with files.

IOUtils() - Constructor for class com.orindasoft.pub.IOUtils

IOUtils is a set of static methods for working with files.

isNull(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return true if the column is null.

isNull(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return true if the column is null.

J

JAVA_DATE_TO_CHAR_MASK - Static variable in class com.orindasoft.pub.PlsqlIndexByTable2

Date format mask used by Java for converting Timestamp to String

JavaLog - class com.orindasoft.pub.JavaLog.

An Implementation of LogInterface that uses GenericLog to create a logging mechanism that is compatible with java.util.logging.Logger This class extends GenericLog - a partially abstract implementation of LogInterface.

JavaLog(Logger) - Constructor for class com.orindasoft.pub.JavaLog

Constructor that uses a supplied java.util.logging.Logger.

JavaLog(String) - Constructor for class com.orindasoft.pub.JavaLog

Constructor that creates a java.util.logging.Logger based on a supplied name.

JavaLog(String, String) - Constructor for class com.orindasoft.pub.JavaLog

Constructor that creates a java.util.logging.Logger based on supplied parameters.

L

last() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Move to last row of the RowSet.

length - Variable in class com.orindasoft.pub.CSColumnException

How long a String is or how many digits a number has to the left of the decimal point.

LibraryInfo - class com.orindasoft.pub.LibraryInfo.

Static class for providing information about the JDBCWizard Public Library.

LibraryInfo() - Constructor for class com.orindasoft.pub.LibraryInfo

loadBFILE(BFILE, File, int) - Static method in class com.orindasoft.pub.LongObjectLoader

Attempts to upload a File to a BFILE This always fails as BFILES are read only.

loadBLOB(BLOB, byte[]) - Static method in class com.orindasoft.pub.LongObjectLoader

Unloads a byte array to a BLOB

loadBLOB(BLOB, File, int) - Static method in class com.orindasoft.pub.LongObjectLoader

Loads a File into a BLOB

loadByteArrayIntoFile(byte[], File, LogInterface) - Static method in class com.orindasoft.pub.IOUtils

Turn a byte array into a File.

loadByteArrayIntoFile(byte[], String, String, String, LogInterface) - Static method in class com.orindasoft.pub.IOUtils

Turn a byte array into a Temporary File.

loadCharArrayIntoFile(char[], File, LogInterface) - Static method in class com.orindasoft.pub.IOUtils

Turn a char array into a File.

loadCharArrayIntoFile(char[], String, String, String, LogInterface) - Static method in class com.orindasoft.pub.IOUtils

Turn a char array into a Temporary File.

loadCLOB(CLOB, byte[]) - Static method in class com.orindasoft.pub.LongObjectLoader

Loads a byte array into a CLOB

loadCLOB(CLOB, char[]) - Static method in class com.orindasoft.pub.LongObjectLoader

Loads a char array into a CLOB

loadCLOB(CLOB, File, int) - Static method in class com.orindasoft.pub.LongObjectLoader

Loads a File into a CLOB

loadFileIntoByteArray(File) - Static method in class com.orindasoft.pub.IOUtils

Loads a file into a byte array.

loadFileIntoCharArray(File) - Static method in class com.orindasoft.pub.IOUtils

Loads a file into a char array.

loadFileIntoString(File) - Static method in class com.orindasoft.pub.IOUtils

Loads a file into a String.

loadStringIntoFile(String, File, LogInterface) - Static method in class com.orindasoft.pub.IOUtils

Turn a String into a File.

loadStringIntoFile(String, String, String, String, LogInterface) - Static method in class com.orindasoft.pub.IOUtils

Turn a String into a File.

LOCK - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being Lock statements

Log4JLog - class com.orindasoft.pub.Log4JLog.

Implementation of LogInterface that uses GenericLog to create a logging mechanism that is compatible with org.apache.log4j.Logger This class extends GenericLog - a partially abstract implementation of LogInterface.

Log4JLog(Logger) - Constructor for class com.orindasoft.pub.Log4JLog

Constructor that uses a supplied org.apache.log4j.Logger.

Log4JLog(String) - Constructor for class com.orindasoft.pub.Log4JLog

Constructor that creates a org.apache.log4j.Logger based on a supplied name.

LogInterface - interface com.orindasoft.pub.LogInterface.

Interface for Logging used by OrindaSoft software.

LongObjectLoader - class com.orindasoft.pub.LongObjectLoader.

This utility class is used to get LOB objects into and out of the database.

LongObjectLoader() - Constructor for class com.orindasoft.pub.LongObjectLoader

This utility class is used to get LOB objects into and out of the database.

M

mapMessageType(String) - Static method in class com.orindasoft.pub.UiLog

Map LogInterface message types to JOptionPane message types

MERGE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being Merge statements

MIN_SAFE_MEMORY_PCT - Static variable in class com.orindasoft.pub.ResourceWatcher

Constant used to decide when we are about to run out of memory.

N

nextRow() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Move to next row of the RowSet.

NULL_NOT_ALLOWED_HERE - Static variable in class com.orindasoft.pub.CSColumnException

Constant to indicate column should not be null or a zero length string.

O

OBJECT_DOES_NOT_EXIST - Static variable in class com.orindasoft.pub.SqlUtils

Constant for ORA-4043 - Object does not exist

ORACLE_BFILE_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle BFILE datatypes

ORACLE_BINARY_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle Binary datatypes

ORACLE_BLOB_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle BLOB datatypes

ORACLE_BOOLEAN_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying PL/SQL Boolean

ORACLE_CLOB_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle CLOB datatypes

ORACLE_DATE_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle Date datatypes

ORACLE_DATE_TO_CHAR_MASK - Static variable in class com.orindasoft.pub.PlsqlIndexByTable2

Date format mask used by Oracle for converting date to String

ORACLE_INTERVAL_DAY_TO_SECOND_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying INTERVAL DAY TO SECOND Datatype

ORACLE_INTERVAL_YEAR_TO_MONTH_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying INTERVAL YEAR TO MONTH Datatype

ORACLE_LONG_BINARY_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle Long Binary datatypes

ORACLE_LONGTEXT_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle Long Text datatypes

ORACLE_NULL_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying null datatypes

ORACLE_NUMBER_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle Number datatypes

ORACLE_OBJECT_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying Oracle OBJECT Datatype

ORACLE_OTHER_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying unrecognized oracle datatypes

ORACLE_PLSQL_INDEXBY_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying PL/SQL Index By tables

ORACLE_PLSQL_INDEXBY_ROWTYPE_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying PL/SQL Index By tables

ORACLE_REFCURSOR_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle ref cursors

ORACLE_ROWID_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying ROWID

ORACLE_ROWTYPE_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying PL/SQL Rowtype Datatype

ORACLE_SDO_GEOMETRY_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying ORACLE_SDO_GEOMETRY_DATATYPE

ORACLE_TABLE_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle Collection's TABLE

ORACLE_TEXT_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle Text datatypes

ORACLE_TIMESTAMP_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying TIMESTAMP

ORACLE_TIMESTAMP_TO_CHAR_MASK - Static variable in class com.orindasoft.pub.PlsqlIndexByTable2

Date format mask used by Oracle for converting timestamp to String

ORACLE_TIMESTAMPLTZ_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying TIMESTAMPLTZ

ORACLE_TIMESTAMPTZ_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying TIMESTAMPTZ

ORACLE_UROWID_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying UROWID

ORACLE_VARRAY_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying oracle Collection's VARRAY

ORACLE_XMLTYPE_DATATYPE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying XMLType

OracleResourceUser - interface com.orindasoft.pub.OracleResourceUser.

An interface that can be inplemented by objects that tend to use up cursors and other oracle resources.

ORINDASOFT_READONLYROWSET - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying PL/SQL Boolean

P

PLSQL - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being PL/SQL statements

PlsqlArray - interface com.orindasoft.pub.PlsqlArray.

Represents a PL/SQL VARRAY or TABLE

PlsqlIndexByTable - class com.orindasoft.pub.PlsqlIndexByTable.

Holds state variables for PL/SQL Index By Table parameters

PlsqlIndexByTable() - Constructor for class com.orindasoft.pub.PlsqlIndexByTable

Contruct an empty INDEX BY table

PlsqlIndexByTable2 - class com.orindasoft.pub.PlsqlIndexByTable2.

Holds state variables for PL/SQL Index By Table parameters

PlsqlIndexByTable2(int, int) - Constructor for class com.orindasoft.pub.PlsqlIndexByTable2

Contruct an empty INDEX BY table

prevRow() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Move to previous row of the RowSet.

purgeExpiredCacheEntries(int) - Method in class com.orindasoft.pub.QueryStatement

Remove entries that are too old from the cache

purgeUnderusedCacheEntries(int, int) - Method in class com.orindasoft.pub.QueryStatement

Remove entries that have not been reused from the cache

Q

QueryStatement - class com.orindasoft.pub.QueryStatement.

A SELECT statement with caching.

QueryStatement(String, LogInterface) - Constructor for class com.orindasoft.pub.QueryStatement

Create a DML Statement object.

QueryStatement(String, LogInterface, Connection) - Constructor for class com.orindasoft.pub.QueryStatement

Create a DML Statement object and give it a connection

R

ReadOnlyRowSet - class com.orindasoft.pub.ReadOnlyRowSet.

A class for representing a ResultSet or set of stored procedure parameters.

ReadOnlyRowSet(Object[], String[], String[], int[], int[], long[], int[], LogInterface, File, boolean) - Constructor for class com.orindasoft.pub.ReadOnlyRowSet

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

ReadOnlyRowSet(ResultSet, String, int, LogInterface) - Constructor for class com.orindasoft.pub.ReadOnlyRowSet

Create a ReadOnlyRowSet that is based on a ResultSet.

ReadOnlyRowSet(ResultSet, String, int, LogInterface, File, boolean, String, String) - Constructor for class com.orindasoft.pub.ReadOnlyRowSet

Create a ReadOnlyRowSet that is based on a ResultSet.

ReadOnlyRowSet(ResultSet, String, int, LogInterface, File, boolean, String, String, boolean) - Constructor for class com.orindasoft.pub.ReadOnlyRowSet

Create a ReadOnlyRowSet that is based on a ResultSet.

ReadOnlyRowSet(ResultSet, String, int, LogInterface, File, boolean, String, String, boolean, boolean) - Constructor for class com.orindasoft.pub.ReadOnlyRowSet

Create a ReadOnlyRowSet that is based on a ResultSet.

releaseResources() - Method in interface com.orindasoft.pub.OracleResourceUser

Used to tell an object to release its Oracle resources.

releaseResources() - Method in class com.orindasoft.pub.DmlStatement

Used to tell an object to release its Oracle resources.

RESERVED_WORDS - Static variable in class com.orindasoft.pub.SqlUtils

Array containing words which are not legal identifers...

resetStatsCounters() - Method in interface com.orindasoft.pub.StatsInterface

Reset all counters Set the counters for Parses, Executions and Releases to zero.

resetStatsCounters() - Method in class com.orindasoft.pub.QueryStatement

Reset all stats counters to 0.

ResourceWatcher - class com.orindasoft.pub.ResourceWatcher.

A static class for keeping track of free memory.

S

SAVEPOINT - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being Lock statements

SELECT - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being queries

SET_CONSTRAINTS - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being Lock statements

SET_ROLE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being Lock statements

SET_TRANSACTION - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being Lock statements

setArray(byte[][]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using byte[][] This convenience method returns sets the array using an array of byte[][]

setArray(double[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the array data using double[] This convenience method returns sets the array using an array of double[]

setArray(double[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using double[] This convenience method returns sets the array using an array of double[] WARNING: The precision of the value actually stored is limited to what the underlying Oracle object expects, so if you pass 1.00003f into a NUMBER(4,2) the '3' will be lost

setArray(Double[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using Double[] This convenience method returns sets the array using an array of Double[] WARNING: The precision of the value actually stored is limited to what the underlying Oracle object expects, so if you pass 1.00003f into a NUMBER(4,2) the '3' will be lost

setArray(float[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the array data using float[] This convenience method returns sets the array using an array of float[]

setArray(float[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using float[] This convenience method returns sets the array using an array of float[] WARNING: The precision of the value actually stored is limited to what the underlying Oracle object expects, so if you pass 1.00003f into a NUMBER(4,2) the '3' will be lost

setArray(Float[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using Float[] This convenience method returns sets the array using an array of Float[] WARNING: The precision of the value actually stored is limited to what the underlying Oracle object expects, so if you pass 1.00003f into a NUMBER(4,2) the '3' will be lost

setArray(int[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the array data using int[] This convenience method returns sets the array using an array of int[]

setArray(int[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using int[] This convenience method sets the array using an array of int[]

setArray(Integer[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using Integer[] This convenience method returns sets the array using an array of Integer[] WARNING: The precision of the value actually stored is limited to what the underlying Oracle object expects, so if you pass 1.00003f into a NUMBER(4,2) the '3' will be lost

setArray(long[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the array data using long[] This convenience method returns sets the array using an array of long[]

setArray(long[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using long[] This convenience method returns sets the array using an array of long[]

setArray(Long[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using Long[] This convenience method returns sets the array using an array of Long[] WARNING: The precision of the value actually stored is limited to what the underlying Oracle object expects, so if you pass 1.00003f into a NUMBER(4,2) the '3' will be lost

setArray(Object[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the contents of the Array.

setArray(Object[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the contents of the Array.

setArray(Timestamp[]) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the array data using java.sql.Timestamp[] This convenience method returns sets the array using an array of java.sql.Timestamp[]

setAutoFlush(boolean) - Method in class com.orindasoft.pub.GenericLog

Controls whether the class should flush the log every time it is asked to print a message.

setAutoFlush(boolean) - Method in class com.orindasoft.pub.ConsoleLog

This is required by LogInterface but is not used in the implementation.

setAutoFlush(boolean) - Method in interface com.orindasoft.pub.LogInterface

Controls whether the class should flush the log every time it is asked to print a message.

setAutoLog(boolean) - Method in class com.orindasoft.pub.GenericLog

Controls whether the class should log every message unless told not to.

setAutoLog(boolean) - Method in interface com.orindasoft.pub.LogInterface

Controls whether the class should log every message unless told not to.

setBufferSize(int) - Method in class com.orindasoft.pub.LongObjectLoader

Set buffer size for IO operations

setBufferSize(int) - Method in class com.orindasoft.pub.QueryStatement

Set new file io buffer size

setCacheRows(int) - Method in class com.orindasoft.pub.QueryStatement

Specify how many results will be cached.

setCacheSeconds(int) - Method in class com.orindasoft.pub.QueryStatement

Specify how long results will be cached.

setConnection(Connection) - Method in class com.orindasoft.pub.DmlStatement

Provide a connection

setConsoleOutput(boolean) - Method in class com.orindasoft.pub.TextLog

Set whether messages are to be sent to standard output and standard error.

setCurrentRow(Object[]) - Method in class com.orindasoft.pub.WriteableRowSet

Update current row as an array of Object

setCurrentRowNumber(int) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Move to a specific row of the RowSet.

setDataType(int) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the official Oracle data type

setDataTypeNumber() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the data type to Numbers

setDataTypeString() - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the data type to Strings

setElementMaxCount(int) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the maximum size this table can be after an update or retrieval.

setElementMaxCount(int) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the maximum size this table can be after an update or retrieval.

setElementMaxLength(int) - Method in class com.orindasoft.pub.PlsqlIndexByTable

Set the maximum length of an element in the table

setElementMaxLength(int) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the maximum length of an element in the table

setExpireDate(long) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Set how long the result will remain up to date.

setKeepFiles(boolean) - Method in class com.orindasoft.pub.LongObjectLoader

Sets flag used to determine whether we call the 'deleteOnExit' method for files we download.

setKeepFiles(boolean) - Method in class com.orindasoft.pub.QueryStatement

Set keepFiles

setKeepLobs(boolean) - Method in class com.orindasoft.pub.QueryStatement

Set keepLobs

setNewValuesAsObject(Object[]) - Method in interface com.orindasoft.pub.PlsqlArray

Method to set the ArrayList by passing in an array of Object

setNumberFormat(NumberFormat) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Change the way Numbers are converted to Strings

setOutParam(int, int) - Method in class com.orindasoft.pub.CallableStatementParameters

Set an out parameter

setOutParam(int, int, String) - Method in class com.orindasoft.pub.CallableStatementParameters

Set an OPAQUE out parameter

setParam(int, BFILE) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set a BFILE parameter.

setParam(int, BigDecimal) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an double parameter.

setParam(int, BLOB) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set a BLOB parameter.

setParam(int, boolean) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set a boolean parameter.

setParam(int, Boolean) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set a boolean parameter.

setParam(int, BufferedInputStream, int, int) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set a BufferedInputStream parameter.

setParam(int, byte) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an byte parameter.

setParam(int, Byte) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an byte parameter.

setParam(int, byte[]) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an byte[] parameter.

setParam(int, CLOB) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set a CLOB parameter.

setParam(int, Date) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter.

setParam(int, Date) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter

setParam(int, double) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an double parameter.

setParam(int, Double) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an double parameter.

setParam(int, File) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an File parameter.

setParam(int, float) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an float parameter.

setParam(int, Float) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an float parameter.

setParam(int, InputStream, int, int) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an InputStream parameter.

setParam(int, int) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an int parameter.

setParam(int, Integer) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an int parameter.

setParam(int, INTERVALYM) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter

setParam(int, long) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an long parameter.

setParam(int, Long) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an long parameter.

setParam(int, ReadOnlyRowSet) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set a ReadOnlyRowSet parameter.

setParam(int, ROWID) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter

setParam(int, short) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an short parameter.

setParam(int, Short) - Method in class com.orindasoft.pub.StatementParameters2

A convenience method to set an short parameter.

setParam(int, String) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter

setParam(int, Timestamp) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter

setParam(int, TIMESTAMP) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter

setParam(int, TIMESTAMPLTZ) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter

setParam(int, TIMESTAMPTZ) - Method in class com.orindasoft.pub.StatementParameters2

Set a parameter

setPlSqlTableArrayOutParam(int, PlsqlArray) - Method in class com.orindasoft.pub.CallableStatementParameters

Set an out parameter for a PL/SQL Array In order to retrieve a PL/SQL varray or table you need to specify the oracle collection name.

setPlSqlTableArrayParam(int, Object) - Method in class com.orindasoft.pub.StatementParameters2

/** Set an Array parameter

setQueryRows(int) - Method in class com.orindasoft.pub.QueryStatement

Specify how many rows can be brought back

setRealDataType(int) - Method in class com.orindasoft.pub.PlsqlIndexByTable2

Set the actual Oracle data type

setString(int, String) - Method in class com.orindasoft.pub.WriteableRowSet

Set column columnId as a String.

setString(String, String) - Method in class com.orindasoft.pub.WriteableRowSet

Set column columnId as a String.

setTempDir(File) - Method in class com.orindasoft.pub.QueryStatement

Set temporary directory

setTempFilePrefix(String) - Method in class com.orindasoft.pub.QueryStatement

Set the prefix used for generating temporary files

setTempFileSuffix(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Set the suffix used for generating temporary files

setTempFileSuffix(String) - Method in class com.orindasoft.pub.QueryStatement

Set the suffix used for generating temporary files

setTimestampFormat(String) - Method in class com.orindasoft.pub.ReadOnlyRowSet

Change the way Timestamps are converted to Strings

setUseByteArraysForLongsAndLOBS(boolean) - Method in class com.orindasoft.pub.QueryStatement

SetUseByteArraysForLongsAndLOBS

size() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return the number of rows

SqlUtils - class com.orindasoft.pub.SqlUtils.

A set of useful static methods for working with SQL.

SqlUtils() - Constructor for class com.orindasoft.pub.SqlUtils

A set of useful static methods for working with SQL.

StatementParameters2 - class com.orindasoft.pub.StatementParameters2.

A set of parameters for a PreparedStatement or CallableStatement

StatementParameters2(int, LogInterface) - Constructor for class com.orindasoft.pub.StatementParameters2

Create a set of statement Parameters of size howMany.

StatementParameters2(String, LogInterface) - Constructor for class com.orindasoft.pub.StatementParameters2

Create a set of statement Parameters by counting '?' characters in a SQL statement

StatsInterface - interface com.orindasoft.pub.StatsInterface.

An interface for tracking and accessing basic performance information.

SYSERR - Static variable in interface com.orindasoft.pub.LogInterface

Constant used when formatting message strings

syserror(Exception) - Method in class com.orindasoft.pub.GenericLog

syserror(Exception) - Method in interface com.orindasoft.pub.LogInterface

Log a serious Exception.

syserror(Exception, boolean, boolean) - Method in class com.orindasoft.pub.GenericLog

syserror(Exception, boolean, boolean) - Method in interface com.orindasoft.pub.LogInterface

Log a serious Exception.

syserror(String) - Method in class com.orindasoft.pub.GenericLog

syserror(String) - Method in interface com.orindasoft.pub.LogInterface

Log a serious error message.

syserror(String, boolean, boolean) - Method in class com.orindasoft.pub.GenericLog

syserror(String, boolean, boolean) - Method in interface com.orindasoft.pub.LogInterface

Log a serious error message.

T

tableName - Variable in class com.orindasoft.pub.CSColumnException

Table name

TextLog - class com.orindasoft.pub.TextLog.

A heavyweight implementation of LogInterface.

TextLog(String) - Constructor for class com.orindasoft.pub.TextLog

Create an instance of TextLog.

TextLog(String, String) - Constructor for class com.orindasoft.pub.TextLog

Create an instance of TextLog.

theApplicationComment - Variable in class com.orindasoft.pub.CSColumnException

An optional comment

theCastedDatatype - Variable in class com.orindasoft.pub.CSDBInvalidDatatypeCastException

The data type we were trying to convert from

theCasteeDatatype - Variable in class com.orindasoft.pub.CSDBInvalidDatatypeCastException

The data type we were trying to convert to

theColumnId - Variable in class com.orindasoft.pub.CSAttemptToGetNullException

Which column we were looking at when this happened.

theSqlCode - Variable in class com.orindasoft.pub.CSDBException

The oracle Error code

theValue - Variable in class com.orindasoft.pub.CSColumnException

The value in question

toString() - Method in class com.orindasoft.pub.CSColumnException

Return a String representation of this exception

toString() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return a String representation of the start of the row set

TYPE_HAS_DEPENDENTS - Static variable in class com.orindasoft.pub.SqlUtils

Constant for ORA-2303 message - cannot drop or replace a type with type or table dependents

U

UiLog - class com.orindasoft.pub.UiLog.

This is an implementation of LogInterface that uses a javax.swing.JLabel field to display messages.

UiLog(String, String, JLabel, JFrame) - Constructor for class com.orindasoft.pub.UiLog

Create an instance of UiLog.

UNKNOWN - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being unidentifiable

unloadBfile(File, BFILE) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a BFILE column into a file

unloadBfileIntoByteArray(BFILE) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a BFILE column into a byte array

unloadBinaryStream(File, InputStream, String) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a Binary Stream into a file

unloadBinaryStream(File, String, String) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a LONG column into a file

unloadBinaryStreamIntoByteArray(InputStream, String) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a Binary Stream into a byte array.

unloadBlob(File, BLOB) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a BLOB column into a file

unloadBlobIntoByteArray(BLOB) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a BLOB column into a byte array

unloadClob(File, CLOB) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a CLOB column into a file

unloadClobIntoByteArray(CLOB) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a CLOB column into a byte array

unloadClobIntoCharArray(CLOB) - Method in class com.orindasoft.pub.LongObjectLoader

Unloads a CLOB column into a char array

unloadParameters(CallableStatement) - Method in class com.orindasoft.pub.CallableStatementParameters

Unload these parameter from a Prepared Statement.

UPDATE - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being updates

useJTextArea(boolean) - Method in class com.orindasoft.pub.UiLog

Prevent or allow messages from being written to the text area as well as the log file.

W

WARN - Static variable in interface com.orindasoft.pub.LogInterface

Constant used when formatting message strings

warning(String) - Method in class com.orindasoft.pub.GenericLog

warning(String) - Method in interface com.orindasoft.pub.LogInterface

Log a warning message.

warning(String, boolean, boolean) - Method in class com.orindasoft.pub.GenericLog

warning(String, boolean, boolean) - Method in interface com.orindasoft.pub.LogInterface

Log a warning message.

width() - Method in class com.orindasoft.pub.ReadOnlyRowSet

Return the number of columns

WriteableRowSet - class com.orindasoft.pub.WriteableRowSet.

Create a writableRowSet that is based on a ResultSet.

WriteableRowSet(Object[], String[], String[], int[], int[], long[], int[], LogInterface, File, boolean) - Constructor for class com.orindasoft.pub.WriteableRowSet

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

WriteableRowSet(ResultSet, String, int, LogInterface) - Constructor for class com.orindasoft.pub.WriteableRowSet

Create a writableRowSet that is based on a ResultSet.

X

XPLAN - Static variable in class com.orindasoft.pub.SqlUtils

Constant for identifying statements as being Lock statements

A B C D E F G H I J L M N O P Q R S T U W X