Index

A B C D E F G I L M N O P R S T U V
All Classes and Interfaces|All Packages

A

affectedRows() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the number of rows that were updated, inserted or deleted by the query.
autoCommitOff() - Method in class com.firstworks.sqlrelay.SQLRConnection: Instructs the database to wait for the client to tell it when to commit.
autoCommitOn() - Method in class com.firstworks.sqlrelay.SQLRConnection: Instructs the database to perform a commit after every successful query.

B

begin() - Method in class com.firstworks.sqlrelay.SQLRConnection: Begins a transaction.
bindFormat() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns a string representing the bind variable format used by the database.

C

cacheOff() - Method in class com.firstworks.sqlrelay.SQLRCursor: Sets query caching off.
cacheToFile(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Sets query caching on.
clearBinds() - Method in class com.firstworks.sqlrelay.SQLRCursor: Clears all bind variables.
clientVersion() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the version of the sqlrelay client software.
closeResultSet() - Method in class com.firstworks.sqlrelay.SQLRCursor: Closes the current result set, if one is open.
colCount() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the number of columns in the current result set.
com.firstworks.sqlrelay - package com.firstworks.sqlrelay
commit() - Method in class com.firstworks.sqlrelay.SQLRConnection: Commits a transaction.
connection - Variable in class com.firstworks.sqlrelay.SQLRConnection: connection is used internally, it's just public to make the JNI wrapper work faster.
connection - Variable in class com.firstworks.sqlrelay.SQLRCursor
countBindVariables() - Method in class com.firstworks.sqlrelay.SQLRCursor: Parses the previously prepared query, counts the number of bind variables defined in it and returns that number.
cursor - Variable in class com.firstworks.sqlrelay.SQLRCursor: cursor and connection are used internally, they're just public to make the JNI wrapper work faster.

D

dbHostName() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the host name of the database
dbIpAddress() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the ip address of the database
dbVersion() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the version of the database
debugOff() - Method in class com.firstworks.sqlrelay.SQLRConnection: Turns debugging off.
debugOn() - Method in class com.firstworks.sqlrelay.SQLRConnection: Causes verbose debugging information to be sent to standard output.
defineOutputBindBlob(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a binary lob output bind variable.
defineOutputBindClob(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a character lob output bind variable.
defineOutputBindCursor(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a cursor output bind variable.
defineOutputBindDate(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a date output bind variable.
defineOutputBindDouble(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a decimal output bind variable.
defineOutputBindInteger(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an integer output bind variable.
defineOutputBindString(String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an output bind variable.
delete() - Method in class com.firstworks.sqlrelay.SQLRConnection: Disconnects and ends the session if it hasn't been ended already.
delete() - Method in class com.firstworks.sqlrelay.SQLRCursor: Destroys the cursor and cleans up all associated result set data.
disableEncryption() - Method in class com.firstworks.sqlrelay.SQLRConnection: Disables encryption.
dontGetColumnInfo() - Method in class com.firstworks.sqlrelay.SQLRCursor: Tells the server not to send any column info (names, types, sizes).

E

enableKerberos(String, String, String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Enables Kerberos authentication and encryption.
enableTls(String, String, String, String, String, String, short) - Method in class com.firstworks.sqlrelay.SQLRConnection: Enables TLS/SSL encryption, and optionally authentication.
endOfResultSet() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns false if part of the result set is still pending on the server and true if not.
endSession() - Method in class com.firstworks.sqlrelay.SQLRConnection: Ends the session.
errorMessage() - Method in class com.firstworks.sqlrelay.SQLRConnection: If an operation failed and generated an error, the error message is available here.
errorMessage() - Method in class com.firstworks.sqlrelay.SQLRCursor: If a query failed and generated an error, the error message is available here.
errorNumber() - Method in class com.firstworks.sqlrelay.SQLRConnection: If an operation failed and generated an error, the error number is available here.
errorNumber() - Method in class com.firstworks.sqlrelay.SQLRCursor: If a query failed and generated an error, the error number is available here.
executeQuery() - Method in class com.firstworks.sqlrelay.SQLRCursor: Execute the query that was previously prepared and bound.

F

fetchFromBindCursor() - Method in class com.firstworks.sqlrelay.SQLRCursor: Fetch from a cursor that was returned as an output bind variable.
firstRowIndex() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the index of the first buffered row.

G

getAutoCommit() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns true if auto-commit is currently on, false otherwise.
getBindVariableDelimiterAtSignSupported() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns true if at-signs (@) are considered to be valid bind variable delimiters.
getBindVariableDelimiterColonSupported() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns true if colons (:) are considered to be valid bind variable delimiters.
getBindVariableDelimiterDollarSignSupported() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns true if dollar signs ($) are considered to be valid bind variable delimiters.
getBindVariableDelimiterQuestionMarkSupported() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns true if question marks (?) are considered to be valid bind variable delimiters.
getCacheFileName() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the name of the file containing the cached result set.
getCatalogList(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing catalogs that match the pattern "catalog".
getCatalogListWithFormat(String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getClientInfo() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the string that was set by setClientInfo().
getColumnInfo() - Method in class com.firstworks.sqlrelay.SQLRCursor: Tells the server to send column info.
getColumnIsAutoIncrement(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column auto-increments and false otherwise.
getColumnIsAutoIncrement(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column auto-increments and false otherwise.
getColumnIsBinary(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column contains binary data and false otherwise.
getColumnIsBinary(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column contains binary data and false otherwise.
getColumnIsNullable(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column can contain nulls and false otherwise.
getColumnIsNullable(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column can contain nulls and false otherwise.
getColumnIsPartOfKey(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column is part of a composite key and false otherwise.
getColumnIsPartOfKey(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column is part of a composite key and false otherwise.
getColumnIsPrimaryKey(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column is a primary key and false otherwise.
getColumnIsPrimaryKey(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column is a primary key and false otherwise.
getColumnIsUnique(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column is unique and false otherwise.
getColumnIsUnique(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column is unique and false otherwise.
getColumnIsUnsigned(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column is an unsigned number and false otherwise.
getColumnIsUnsigned(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column is an unsigned number and false otherwise.
getColumnIsZeroFilled(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column was created with the zero-fill flag and false otherwise.
getColumnIsZeroFilled(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if the specified column was created with the zero-fill flag and false otherwise.
getColumnLength(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the number of bytes required on the server to store the data for the specified column
getColumnLength(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the number of bytes required on the server to store the data for the specified column
getColumnList(String, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing the columns of "table", which match the pattern "columns".
getColumnListWithFormat(String, String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getColumnName(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the name of the specified column.
getColumnNames() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns a null terminated array of the column names of the current result set.
getColumnPrecision(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the precision of the specified column.
getColumnPrecision(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the precision of the specified column.
getColumnScale(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the scale of the specified column.
getColumnScale(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the scale of the specified column.
getColumnType(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the type of the specified column.
getColumnType(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the type of the specified column.
getConnectionPort() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the inet port that the connection is communicating over.
getConnectionSocket() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the unix socket that the connection is communicating over.
getConnectTimeoutMicroseconds() - Method in class com.firstworks.sqlrelay.SQLRConnection: Gets the server connect timeout in microseconds.
getConnectTimeoutSeconds() - Method in class com.firstworks.sqlrelay.SQLRConnection: Gets the server connect timeout in seconds.
getCurrentCatalog() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the catalog that is currently in use.
getCurrentDatabase() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the database that is currently in use.
getCurrentSchema() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the schema that is currently in use.
getCurrentUser() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the user that sqlrelay is currently logged in to the database as, or null if no user could be determined or if an error occurred.
getDatabaseFeature(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the value of the specified database "feature".
getDatabaseIsSchema() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns true if the backend database equates "database" with "schema", and false if it equates "database" with "catalog".
getDatabaseList(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing databases that match the pattern "databases".
getDatabaseListWithFormat(String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getDebug() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns false if debugging is off and true if debugging is on.
getDefaultIsolationLevel() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the database-specific default isolation level, or null if an error occurred.
getDefaultIsolationLevel(int) - Method in class com.firstworks.sqlrelay.SQLRConnection
getDefaultTransactionModel() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the database's native transaction model.
getField(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a string.
getField(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a string.
getFieldAsBoolean(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a boolean.
getFieldAsBoolean(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a boolean.
getFieldAsBooleanIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a boolean, ignoring the case of "col".
getFieldAsByteArray(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a byte array.
getFieldAsByteArray(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a byte array.
getFieldAsDateDay(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the day component.
getFieldAsDateDay(long, int, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the day component.
getFieldAsDateDay(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the day component.
getFieldAsDateDay(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the day component.
getFieldAsDateDayIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the day component, ignoring the case of "col".
getFieldAsDateDayIgnoringCase(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the day component, ignoring the case of "col".
getFieldAsDateHour(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the hour component.
getFieldAsDateHour(long, int, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the hour component.
getFieldAsDateHour(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the hour component.
getFieldAsDateHour(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the hour component.
getFieldAsDateHourIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the hour component, ignoring the case of "col".
getFieldAsDateHourIgnoringCase(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the hour component, ignoring the case of "col".
getFieldAsDateIsNegative(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns whether the hour component is negative.
getFieldAsDateIsNegative(long, int, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns whether the hour component is negative.
getFieldAsDateIsNegative(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns whether the hour component is negative.
getFieldAsDateIsNegative(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns whether the hour component is negative.
getFieldAsDateIsNegativeIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns whether the hour component is negative, ignoring the case of "col".
getFieldAsDateIsNegativeIgnoringCase(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns whether the hour component is negative, ignoring the case of "col".
getFieldAsDateMicrosecond(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the microsecond component.
getFieldAsDateMicrosecond(long, int, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the microsecond component.
getFieldAsDateMicrosecond(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the microsecond component.
getFieldAsDateMicrosecond(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the microsecond component.
getFieldAsDateMicrosecondIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the microsecond component, ignoring the case of "col".
getFieldAsDateMicrosecondIgnoringCase(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the microsecond component, ignoring the case of "col".
getFieldAsDateMinute(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the minute component.
getFieldAsDateMinute(long, int, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the minute component.
getFieldAsDateMinute(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the minute component.
getFieldAsDateMinute(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the minute component.
getFieldAsDateMinuteIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the minute component, ignoring the case of "col".
getFieldAsDateMinuteIgnoringCase(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the minute component, ignoring the case of "col".
getFieldAsDateMonth(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the month component.
getFieldAsDateMonth(long, int, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the month component.
getFieldAsDateMonth(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the month component.
getFieldAsDateMonth(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the month component.
getFieldAsDateMonthIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the month component, ignoring the case of "col".
getFieldAsDateMonthIgnoringCase(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the month component, ignoring the case of "col".
getFieldAsDateSecond(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the second component.
getFieldAsDateSecond(long, int, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the second component.
getFieldAsDateSecond(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the second component.
getFieldAsDateSecond(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the second component.
getFieldAsDateSecondIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the second component, ignoring the case of "col".
getFieldAsDateSecondIgnoringCase(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the second component, ignoring the case of "col".
getFieldAsDateYear(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the year component.
getFieldAsDateYear(long, int, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the year component.
getFieldAsDateYear(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the year component.
getFieldAsDateYear(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the year component.
getFieldAsDateYearIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the year component, ignoring the case of "col".
getFieldAsDateYearIgnoringCase(long, String, boolean, boolean, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Interprets the specified field as a date and returns the year component, ignoring the case of "col".
getFieldAsDouble(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a decimal.
getFieldAsDouble(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a decimal.
getFieldAsDoubleIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a decimal, ignoring the case of "col".
getFieldAsInteger(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as an integer.
getFieldAsInteger(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as an integer.
getFieldAsIntegerIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as an integer, ignoring the case of "col".
getFieldIgnoringCase(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the specified field as a string, ignoring the case of "col".
getFieldLength(long, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the length of the specified field.
getFieldLength(long, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the length of the specified field.
getInTransaction() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns true if the session is currently inside a transaction, false otherwise.
getIsolationLevel() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the database-specific isolation level, "unknown" if the isolation level is unknown, or null if an error occurred.
getIsolationLevel(int) - Method in class com.firstworks.sqlrelay.SQLRConnection
getKeyAndIndexList(String, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing the keys and indexes of "table", which match the pattern "qualifier".
getKeyAndIndexListWithFormat(String, String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getLastInsertId() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the value of the autoincrement column for the last insert
getLastInsertIdList() - Method in class com.firstworks.sqlrelay.SQLRCursor
getLongest(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the length of the longest field in the specified column.
getLongest(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the length of the longest field in the specified column.
getNullsAsEmptyStrings() - Method in class com.firstworks.sqlrelay.SQLRCursor: Tells the connection to return NULL fields and output bind variables as empty strings.
getNullsAsNulls() - Method in class com.firstworks.sqlrelay.SQLRCursor: Tells the connection to return NULL fields and output bind variables as NULL's rather than as empty strings.
getOutputBindAsByteArray(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the length of the value stored in a previously defined output bind variable.
getOutputBindBlob(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the value stored in a previously defined binary lob output bind variable.
getOutputBindClob(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the value stored in a previously defined character lob output bind variable.
getOutputBindCursor(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the cursor associated with a previously defined output bind variable.
getOutputBindDateDay(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the day from a previously defined date output bind variable.
getOutputBindDateHour(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the hour from a previously defined date output bind variable.
getOutputBindDateIsNegative(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get whether the value is negative from a previously defined date output bind variable.
getOutputBindDateMicrosecond(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the microsecond from a previously defined date output bind variable.
getOutputBindDateMinute(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the minute from a previously defined date output bind variable.
getOutputBindDateMonth(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the month from a previously defined date output bind variable.
getOutputBindDateSecond(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the second from a previously defined date output bind variable.
getOutputBindDateTz(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the time zone from a previously defined date output bind variable.
getOutputBindDateYear(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the year from a previously defined date output bind variable.
getOutputBindDouble(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the value stored in a previously defined decimal output bind variable.
getOutputBindInteger(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the value stored in a previously defined integer output bind variable.
getOutputBindLength(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the length of the value stored in a previously defined output bind variable.
getOutputBindString(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Get the value stored in a previously defined string output bind variable.
getPrimaryKeysList(String, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing the primary keys of "table", which match the pattern "columns".
getPrimaryKeysListWithFormat(String, String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getProcedureList(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing procedures that match the pattern "procedures".
getProcedureListWithFormat(String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getProcedureParameterList(String, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing the parameters of "procedure", which match the pattern "parameters".
getProcedureParameterListWithFormat(String, String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getResponseTimeoutMicroseconds() - Method in class com.firstworks.sqlrelay.SQLRConnection: Gets the response timeout in microseconds.
getResponseTimeoutSeconds() - Method in class com.firstworks.sqlrelay.SQLRConnection: Gets the response timeout in seconds.
getResultSetBufferSize() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the number of result set rows that will be buffered at a time or 0 for the entire result set.
getResultSetId() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the internal ID of this result set.
getRow(long) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns a null terminated array of the values of the fields in the specified row.
getRowLengths(long) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns a null terminated array of the lengths of the fields in the specified row.
getSchemaList(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing schemas that match the pattern "schemas".
getSchemaListWithFormat(String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getTableList(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing the tables in the current database and schema that match the pattern "tables".
getTableListWithFormat(String, int, int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getTableTypeList() - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing supported table types.
getTableTypeListWithFormat(int) - Method in class com.firstworks.sqlrelay.SQLRCursor
getTransactionModel() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the current transaction model.
getTypeInfoList(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Generates a result set containing data type information for "type".
getTypeInfoListWithFormat(String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor

I

identify() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the type of database: oracle, postgresql, mysql, etc.
inputBind(String, double, int, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a decimal input bind variable.
inputBind(String, long) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a integer input bind variable.
inputBind(String, short, short, short, short, short, short, int, String, boolean) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a date input bind variable.
inputBind(String, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a string input bind variable.
inputBind(String, String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a string input bind variable.
inputBindBlob(String, byte[], long) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a binary lob input bind variable.
inputBindClob(String, String, long) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a character lob input bind variable.
inputBinds(String[], double[], int[], int[]) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an array of decimal input bind variables.
inputBinds(String[], long[]) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an array of integer input bind variables.
inputBinds(String[], String[]) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an array of string input bind variables.
isBinaryType(String) - Method in class com.firstworks.sqlrelay.SQLRCursor
isBlobType(String) - Method in class com.firstworks.sqlrelay.SQLRCursor
isClobType(String) - Method in class com.firstworks.sqlrelay.SQLRCursor
isDateTimeType(String) - Method in class com.firstworks.sqlrelay.SQLRCursor
isNumberType(String) - Method in class com.firstworks.sqlrelay.SQLRCursor
isUnsignedType(String) - Method in class com.firstworks.sqlrelay.SQLRCursor

L

lowerCaseColumnNames() - Method in class com.firstworks.sqlrelay.SQLRCursor: Columns names are converted to lower case.

M

mixedCaseColumnNames() - Method in class com.firstworks.sqlrelay.SQLRCursor: Columns names are returned in the same case as they are defined in the database.

N

nextResultSet() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true and acts like executeQuery() when there is another result set available from the server.
nextvalFormat() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns a string representing the format of the sequence nextval command used in the database.

O

openCachedResultSet(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Opens a cached result set.

P

ping() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns true if the database is up and false if it's down.
prepareFileQuery(String, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Prepare to execute the contents of "path"/"filename".
prepareQuery(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Prepare to execute "query".
prepareQuery(String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Prepare to execute "query" with length "length".

R

resumeCachedResultSet(short, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Resumes a result set previously left open using suspendSession() and continues caching the result set to "filename".
resumeResultSet(short) - Method in class com.firstworks.sqlrelay.SQLRCursor: Resumes a result set previously left open using suspendSession().
resumeSession(short, String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Resumes a session previously left open using suspendSession().
rollback() - Method in class com.firstworks.sqlrelay.SQLRConnection: Rolls back a transaction.
rowCount() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the number of rows in the current result set (if the result set is being stepped through, this returns the number of rows processed so far).

S

selectCatalog(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Sets the current catalog to "catalog"
selectDatabase(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Sets the current database to "database".
selectSchema(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Sets the current schema to "schema"
sendFileQuery(String, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Sends the query in file "path"/"filename" directly and gets a result set.
sendQuery(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Sends "query" directly and gets a result set.
sendQuery(String, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Sends "query" with length "length" directly and gets a result set.
serverVersion() - Method in class com.firstworks.sqlrelay.SQLRConnection: Returns the version of the sqlrelay server software.
setBindVariableDelimiters(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Sets which delimiters are used to identify bind variables in countBindVariables() and validateBinds().
setCacheTtl(int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Sets the time-to-live for cached result sets.
setClientInfo(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Allows you to set a string that will be passed to the server and ultimately included in server-side logging along with queries that were run by this instance of the client.
setConnectTimeout(int, int) - Method in class com.firstworks.sqlrelay.SQLRConnection: Sets the server connect timeout in seconds and microseconds.
setDebugFile(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Allows you to specify a file to write debug to.
setIsolationLevel(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Sets the transaction isolation level to "isolationlevel".
setIsolationLevel(String, int) - Method in class com.firstworks.sqlrelay.SQLRConnection
setResponseTimeout(int, int) - Method in class com.firstworks.sqlrelay.SQLRConnection: Sets the response timeout (for queries, commits, rollbacks, pings, etc.) in seconds and microseconds.
setResultSetBufferSize(long) - Method in class com.firstworks.sqlrelay.SQLRCursor: Sets the number of rows of the result set to buffer at a time.
setTransactionModel(String) - Method in class com.firstworks.sqlrelay.SQLRConnection: Sets the current transaction model to "txmodel" which should be one of: * native - the database's native transaction model * none - no transactions * "implicit" * in a transaction when the session begins * commit/rollback implicitly starts a new transcaction * autocommit on/off take effect immediately * "explicit" * not in a transaction when the session begins * begin required to start a new transaction * commit/rollback does not start a new transcaction * autocommit on/off take effect immediately * "explicit-deferred" * not in a transaction when the session begins * begin required to start a new transaction * commit/rollback does not start a new transcaction * while in a begin-initiated transaction, autocommit on takes effect at next commit/rollback (deferred) * while in an autocommit-off-initiated transaction, autocommit on takes effect immediately * "explicit-error" * not in a transaction when the session begins * begin required to start a new transaction * commit/rollback does not start a new transcaction * while in a transaction, autocommit on/off throw error Returns true on success and false on failure.
SQLRConnection - Class in com.firstworks.sqlrelay
SQLRConnection(String, short, String, String, String, int, int) - Constructor for class com.firstworks.sqlrelay.SQLRConnection: Initiates a connection to "server" on "port" or to the unix "socket" on the local machine and auths with "user" and "password".
SQLRCursor - Class in com.firstworks.sqlrelay
SQLRCursor(SQLRConnection) - Constructor for class com.firstworks.sqlrelay.SQLRCursor: Creates a cursor to run queries and fetch result sets using connecton "sqlrc".
substitution(String, double, int, int) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a decimal substitution variable.
substitution(String, long) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an integer substitution variable.
substitution(String, String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines a string substitution variable.
substitutions(String[], double[], int[], int[]) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an array of decimal substitution variables.
substitutions(String[], long[]) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an array of integer substitution variables.
substitutions(String[], String[]) - Method in class com.firstworks.sqlrelay.SQLRCursor: Defines an array of string substitution variables.
suspendResultSet() - Method in class com.firstworks.sqlrelay.SQLRCursor: Tells the server to leave this result set open when the connection calls suspendSession() so that another connection can connect to it using resumeResultSet() after it calls resumeSession().
suspendSession() - Method in class com.firstworks.sqlrelay.SQLRConnection: Disconnects this connection from the current session but leaves the session open so that another connection can connect to it using resumeSession().

T

totalRows() - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns the total number of rows that will be returned in the result set.

U

upperCaseColumnNames() - Method in class com.firstworks.sqlrelay.SQLRCursor: Columns names are converted to upper case.

V

validateBinds() - Method in class com.firstworks.sqlrelay.SQLRCursor: If you are binding to any variables that might not actually be in your query, call this to ensure that the database won't try to bind them unless they really are in the query.
validBind(String) - Method in class com.firstworks.sqlrelay.SQLRCursor: Returns true if "variable" was a valid bind variable of the query.

A B C D E F G I L M N O P R S T U V
All Classes and Interfaces|All Packages