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


Copyright © Orinda Software Ltd 2011Logo