Package com.firstworks.sqlrelay

Class SQLRCursor

java.lang.Object
com.firstworks.sqlrelay.SQLRCursor
public class SQLRCursor extends Object

  • Field Details

    • cursor

      public long cursor
      cursor and connection are used internally, they're just public to make the JNI wrapper work faster.

    • connection

      public SQLRConnection connection

  • Constructor Details

    • SQLRCursor

      public SQLRCursor(SQLRConnection con)
      Creates a cursor to run queries and fetch result sets using connecton "sqlrc".

  • Method Details

    • delete

      public void delete()
      Destroys the cursor and cleans up all associated result set data.

    • setResultSetBufferSize

      public void setResultSetBufferSize(long rows)
      Sets the number of rows of the result set to buffer at a time. 0 (the default) means buffer the entire result set.

    • getResultSetBufferSize

      public long getResultSetBufferSize()
      Returns the number of result set rows that will be buffered at a time or 0 for the entire result set.

    • dontGetColumnInfo

      public void dontGetColumnInfo()
      Tells the server not to send any column info (names, types, sizes). If you don't need that info, you should call this method to improve performance.

    • getColumnInfo

      public void getColumnInfo()
      Tells the server to send column info.

    • mixedCaseColumnNames

      public void mixedCaseColumnNames()
      Columns names are returned in the same case as they are defined in the database. This is the default.

    • upperCaseColumnNames

      public void upperCaseColumnNames()
      Columns names are converted to upper case.

    • lowerCaseColumnNames

      public void lowerCaseColumnNames()
      Columns names are converted to lower case.

    • cacheToFile

      public void cacheToFile(String filename)
      Sets query caching on. Future queries will be cached to the file "filename". A default time-to-live of 10 minutes is also set. Note that once cacheToFile() is called, the result sets of all future queries will be cached to that file until another call to cacheToFile() changes which file to cache to or a call to cacheOff() turns off caching.

    • setCacheTtl

      public void setCacheTtl(int ttl)
      Sets the time-to-live for cached result sets. The sqlr-cachemanger will remove each cached result set "ttl" seconds after it's created, provided it's scanning the directory containing the cache files.

    • getCacheFileName

      public String getCacheFileName()
      Returns the name of the file containing the cached result set.

    • cacheOff

      public void cacheOff()
      Sets query caching off.

    • getDatabaseList

      public boolean getDatabaseList(String databases)
      Generates a result set containing databases that match the pattern "databases". The result set will contain the following columns:
      • Database
      If "databases" is empty or null then a result set containing all databases will be returned. May actually return a result set of catalogs or schemas, depending on whether the backend database equates "database" with catalog or schema. See getDatabaseIsSchema(). If SQL Relay doesn't support getting a list of databases for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getCatalogList

      public boolean getCatalogList(String catalogs)
      Generates a result set containing catalogs that match the pattern "catalog". The result set will contain the following columns:
      • Database
      If "catalog" is empty or null then a result set containing all catalogs will be returned. If SQL Relay doesn't support getting a list of catalogs for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getSchemaList

      public boolean getSchemaList(String schemas)
      Generates a result set containing schemas that match the pattern "schemas". The result set will contain the following columns:
      • Database
      (The column name is a bit of a misnomer, the results are schemas, not databases.) If "schemas" is empty or null then a result set containing all schemas in the current database will be returned. If SQL Relay doesn't support getting a list of schemas for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getTableTypeList

      public boolean getTableTypeList()
      Generates a result set containing supported table types. The result set will contain the following columns:
      • table_type
      If SQL Relay doesn't support getting a list of table types for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getTableList

      public boolean getTableList(String tables)
      Generates a result set containing the tables in the current database and schema that match the pattern "tables". The result set will contain the following columns:
      • Tables_in_xxx
      If "tables" is empty or null then a result set containing all tables in the current database/schema will be returned. If SQL Relay doesn't support getting a list of tables for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getTypeInfoList

      public boolean getTypeInfoList(String type)
      Generates a result set containing data type information for "type". The result set will contain the following columns:
      • type_name
      • data_type
      • precision
      • literal_prefix
      • literal_suffix
      • create_params
      • nullable
      • case_sensitive
      • searchable
      • unsigned_attribute
      • fixed_prec_scale
      • auto_increment
      • local_type_name
      • minumum_scale
      • maxiumm_scale
      • sql_data_type
      • sql_datetime_sub
      • num_prec_radix
      • interval_precision
      If "type" is empty or null then a result set containing all data types in the current databas/schema will be returned. If SQL Relay doesn't support getting type info for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getColumnList

      public boolean getColumnList(String table, String columns)
      Generates a result set containing the columns of "table", which match the pattern "columns". The result set will contain the following columns:
      • column_name
      • data_type
      • character_maximum_length
      • numeric_precision
      • numeric_scale
      • is_nullable
      • column_key
      • column_default
      • extra
      If "columns" is empty or null then a list of all columns of "table" will be returned. If SQL Relay doesn't support getting a list of columns for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getPrimaryKeysList

      public boolean getPrimaryKeysList(String table, String columns)
      Generates a result set containing the primary keys of "table", which match the pattern "columns". The result set will contain the following columns:
      • table
      • non_unique
      • key_name
      • seq_in_index
      • column_name
      • collation
      • cardinality
      • sub_part
      • packed
      • null
      • index_type
      • comment
      • index_comment
      If "columns" is empty or null then a result set containing all primary keys of "table" will be returned. If SQL Relay doesn't support getting a list of primary keys for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getKeyAndIndexList

      public boolean getKeyAndIndexList(String table, String qualifier)
      Generates a result set containing the keys and indexes of "table", which match the pattern "qualifier". The result set will contain the following columns:
      • table
      • non_unique
      • key_name
      • seq_in_index
      • column_name
      • collation
      • cardinality
      • sub_part
      • packed
      • null
      • index_type
      • comment
      • index_comment
      If "qualifier" is empty or null then a result set containing all keys and indexes of "table" will be returned. If SQL Relay doesn't support getting a list of keys and indexes for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getProcedureList

      public boolean getProcedureList(String procedures)
      Generates a result set containing procedures that match the pattern "procedures". The result set will contain the following columns:
      • routine_catalog
      • routine_schema
      • routine_name
      • data_type
      If "procedures" is empty or null then a result set containing all procedures in the current database/schema will be returned. If SQL Relay doesn't support getting a list of procedures for the current database backend (or the database doesn't) then an empty result set will be returned.

    • getProcedureParameterList

      public boolean getProcedureParameterList(String procedure, String parameters)
      Generates a result set containing the parameters of "procedure", which match the pattern "parameters". The result set will contain the following columns:
      • parameter_name
      • parameter_mode
      • data_type
      • character_maximum_length
      • ordinal_position
      If "parameters" is empty or null then a result set containing all parameters of "procedure" will be returned. If SQL Relay doesn't support getting a list of procedure parameters for the current database backend (or the database doesn't) then an empty result set will be returned.

    • sendQuery

      public boolean sendQuery(String query)
      Sends "query" directly and gets a result set.

    • sendQuery

      public boolean sendQuery(String query, int length)
      Sends "query" with length "length" directly and gets a result set. This method must be used if the query contains binary data.

    • sendFileQuery

      public boolean sendFileQuery(String path, String filename)
      Sends the query in file "path"/"filename" directly and gets a result set.

    • prepareQuery

      public void prepareQuery(String query)
      Prepare to execute "query".

    • prepareQuery

      public void prepareQuery(String query, int length)
      Prepare to execute "query" with length "length". This method must be used if the query contains binary data.

    • prepareFileQuery

      public boolean prepareFileQuery(String path, String filename)
      Prepare to execute the contents of "path"/"filename". Returns false if the file couldn't be opened.

    • clearBinds

      public void clearBinds()
      Clears all bind variables.

    • substitution

      public void substitution(String variable, String value)
      Defines a string substitution variable.

    • substitution

      public void substitution(String variable, long value)
      Defines an integer substitution variable.

    • substitution

      public void substitution(String variable, double value, int precision, int scale)
      Defines a decimal substitution variable.

    • countBindVariables

      public short countBindVariables()
      Parses the previously prepared query, counts the number of bind variables defined in it and returns that number.

    • inputBind

      public void inputBind(String variable, String value)
      Defines a string input bind variable.

    • inputBind

      public void inputBind(String variable, String value, int length)
      Defines a string input bind variable.

    • inputBind

      public void inputBind(String variable, long value)
      Defines a integer input bind variable.

    • inputBind

      public void inputBind(String variable, double value, int precision, int scale)
      Defines a decimal input bind variable. (If you don't have the precision and scale then set them both 0. However in that case you may get unexpected rounding behavior if the server is faking binds.)

    • inputBind

      public void inputBind(String variable, short year, short month, short day, short hour, short minute, short second, int microsecond, String tz, boolean isnegative)
      Defines a date input bind variable. "day" and "month" are 1-based. Some databases distinguish between date, time, and datetime types. For those databases... * The input bind variable will be interpreted as a time type if year and/or month are negative. * The input bind variable will be interpreted as a date type if hour, minute, second, and/or microsecond are negative. * The input bind variable will be interpreted as a datetime type if all parts are positive. "tz" is the timezone abbreviation, and may be left null. Most databases ignore "tz". Set "isnegative" may be set to true to represent a negative time interval. However, few databases support negative time intervals and ignore "isnegative".

    • inputBindBlob

      public void inputBindBlob(String variable, byte[] value, long size)
      Defines a binary lob input bind variable.

    • inputBindClob

      public void inputBindClob(String variable, String value, long size)
      Defines a character lob input bind variable.

    • defineOutputBindString

      public void defineOutputBindString(String variable, int bufferlength)
      Defines an output bind variable. "bufferlength" bytes will be reserved to store the value.

    • defineOutputBindInteger

      public void defineOutputBindInteger(String variable)
      Defines an integer output bind variable.

    • defineOutputBindDouble

      public void defineOutputBindDouble(String variable)
      Defines a decimal output bind variable.

    • defineOutputBindBlob

      public void defineOutputBindBlob(String variable)
      Defines a binary lob output bind variable.

    • defineOutputBindClob

      public void defineOutputBindClob(String variable)
      Defines a character lob output bind variable.

    • defineOutputBindCursor

      public void defineOutputBindCursor(String variable)
      Defines a cursor output bind variable.

    • defineOutputBindDate

      public void defineOutputBindDate(String variable)
      Defines a date output bind variable.

    • substitutions

      public void substitutions(String[] variables, String[] values)
      Defines an array of string substitution variables.

    • substitutions

      public void substitutions(String[] variables, long[] values)
      Defines an array of integer substitution variables.

    • substitutions

      public void substitutions(String[] variables, double[] values, int[] precisions, int[] scales)
      Defines an array of decimal substitution variables.

    • inputBinds

      public void inputBinds(String[] variables, String[] values)
      Defines an array of string input bind variables.

    • inputBinds

      public void inputBinds(String[] variables, long[] values)
      Defines an array of integer input bind variables.

    • inputBinds

      public void inputBinds(String[] variables, double[] values, int[] precisions, int[] scales)
      Defines an array of decimal input bind variables.

    • validateBinds

      public void validateBinds()
      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. There is a performance penalty for calling this method.

    • validBind

      public boolean validBind(String variable)
      Returns true if "variable" was a valid bind variable of the query.

    • executeQuery

      public boolean executeQuery()
      Execute the query that was previously prepared and bound.

    • fetchFromBindCursor

      public boolean fetchFromBindCursor()
      Fetch from a cursor that was returned as an output bind variable.

    • getOutputBindString

      public String getOutputBindString(String variable)
      Get the value stored in a previously defined string output bind variable.

    • getOutputBindBlob

      public byte[] getOutputBindBlob(String variable)
      Get the value stored in a previously defined binary lob output bind variable.

    • getOutputBindClob

      public String getOutputBindClob(String variable)
      Get the value stored in a previously defined character lob output bind variable.

    • getOutputBindAsByteArray

      public byte[] getOutputBindAsByteArray(String variable)
      Get the length of the value stored in a previously defined output bind variable.

    • getOutputBindInteger

      public long getOutputBindInteger(String variable)
      Get the value stored in a previously defined integer output bind variable.

    • getOutputBindDouble

      public double getOutputBindDouble(String variable)
      Get the value stored in a previously defined decimal output bind variable.

    • getOutputBindLength

      public long getOutputBindLength(String variable)
      Get the length of the value stored in a previously defined output bind variable.

    • getOutputBindDateYear

      public short getOutputBindDateYear(String variable)
      Get the year from a previously defined date output bind variable.

    • getOutputBindDateMonth

      public short getOutputBindDateMonth(String variable)
      Get the month from a previously defined date output bind variable.

    • getOutputBindDateDay

      public short getOutputBindDateDay(String variable)
      Get the day from a previously defined date output bind variable.

    • getOutputBindDateHour

      public short getOutputBindDateHour(String variable)
      Get the hour from a previously defined date output bind variable.

    • getOutputBindDateMinute

      public short getOutputBindDateMinute(String variable)
      Get the minute from a previously defined date output bind variable.

    • getOutputBindDateSecond

      public short getOutputBindDateSecond(String variable)
      Get the second from a previously defined date output bind variable.

    • getOutputBindDateMicrosecond

      public int getOutputBindDateMicrosecond(String variable)
      Get the microsecond from a previously defined date output bind variable.

    • getOutputBindDateTz

      public String getOutputBindDateTz(String variable)
      Get the time zone from a previously defined date output bind variable.

    • getOutputBindDateIsNegative

      public boolean getOutputBindDateIsNegative(String variable)
      Get whether the value is negative from a previously defined date output bind variable.

    • getOutputBindCursor

      public SQLRCursor getOutputBindCursor(String variable)
      Get the cursor associated with a previously defined output bind variable.

    • openCachedResultSet

      public boolean openCachedResultSet(String filename)
      Opens a cached result set. Returns true on success and false on failure.

    • colCount

      public int colCount()
      Returns the number of columns in the current result set.

    • rowCount

      public long rowCount()
      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).

    • totalRows

      public long totalRows()
      Returns the total number of rows that will be returned in the result set. Not all databases support this call. Don't use it for applications which are designed to be portable across databases. 0 is returned by databases which don't support this option.

    • affectedRows

      public long affectedRows()
      Returns the number of rows that were updated, inserted or deleted by the query. Not all databases support this call. Don't use it for applications which are designed to be portable across databases. 0 is returned by databases which don't support this option.

    • firstRowIndex

      public long firstRowIndex()
      Returns the index of the first buffered row. This is useful when buffering only part of the result set at a time.

    • endOfResultSet

      public boolean endOfResultSet()
      Returns false if part of the result set is still pending on the server and true if not. This method can only return false if setResultSetBufferSize() has been called with a parameter other than 0.

    • nextResultSet

      public boolean nextResultSet()
      Returns true and acts like executeQuery() when there is another result set available from the server.

    • errorMessage

      public String errorMessage()
      If a query failed and generated an error, the error message is available here. If the query succeeded then this method returns NULL.

    • errorNumber

      public long errorNumber()
      If a query failed and generated an error, the error number is available here. If there is no error then this method returns 0.

    • getNullsAsEmptyStrings

      public void getNullsAsEmptyStrings()
      Tells the connection to return NULL fields and output bind variables as empty strings. This is the default.

    • getNullsAsNulls

      public void getNullsAsNulls()
      Tells the connection to return NULL fields and output bind variables as NULL's rather than as empty strings.

    • getField

      public String getField(long row, int col)
      Returns the specified field as a string.

    • getField

      public String getField(long row, String col)
      Returns the specified field as a string.

    • getFieldIgnoringCase

      public String getFieldIgnoringCase(long row, String col)
      Returns the specified field as a string, ignoring the case of "col".

    • getFieldAsInteger

      public long getFieldAsInteger(long row, int col)
      Returns the specified field as an integer.

    • getFieldAsInteger

      public long getFieldAsInteger(long row, String col)
      Returns the specified field as an integer.

    • getFieldAsIntegerIgnoringCase

      public long getFieldAsIntegerIgnoringCase(long row, String col)
      Returns the specified field as an integer, ignoring the case of "col".

    • getFieldAsDouble

      public double getFieldAsDouble(long row, int col)
      Returns the specified field as a decimal.

    • getFieldAsDouble

      public double getFieldAsDouble(long row, String col)
      Returns the specified field as a decimal.

    • getFieldAsDoubleIgnoringCase

      public double getFieldAsDoubleIgnoringCase(long row, String col)
      Returns the specified field as a decimal, ignoring the case of "col".

    • getFieldAsBoolean

      public boolean getFieldAsBoolean(long row, int col)
      Returns the specified field as a boolean.

    • getFieldAsBoolean

      public boolean getFieldAsBoolean(long row, String col)
      Returns the specified field as a boolean.

    • getFieldAsBooleanIgnoringCase

      public boolean getFieldAsBooleanIgnoringCase(long row, String col)
      Returns the specified field as a boolean, ignoring the case of "col".

    • getFieldAsDateYear

      public short getFieldAsDateYear(long row, int col)
      Interprets the specified field as a date and returns the year component.

    • getFieldAsDateYear

      public short getFieldAsDateYear(long row, int col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the year component.

    • getFieldAsDateYear

      public short getFieldAsDateYear(long row, String col)
      Interprets the specified field as a date and returns the year component.

    • getFieldAsDateYear

      public short getFieldAsDateYear(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the year component.

    • getFieldAsDateYearIgnoringCase

      public short getFieldAsDateYearIgnoringCase(long row, String col)
      Interprets the specified field as a date and returns the year component, ignoring the case of "col".

    • getFieldAsDateYearIgnoringCase

      public short getFieldAsDateYearIgnoringCase(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the year component, ignoring the case of "col".

    • getFieldAsDateMonth

      public short getFieldAsDateMonth(long row, int col)
      Interprets the specified field as a date and returns the month component.

    • getFieldAsDateMonth

      public short getFieldAsDateMonth(long row, int col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the month component.

    • getFieldAsDateMonth

      public short getFieldAsDateMonth(long row, String col)
      Interprets the specified field as a date and returns the month component.

    • getFieldAsDateMonth

      public short getFieldAsDateMonth(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the month component.

    • getFieldAsDateMonthIgnoringCase

      public short getFieldAsDateMonthIgnoringCase(long row, String col)
      Interprets the specified field as a date and returns the month component, ignoring the case of "col".

    • getFieldAsDateMonthIgnoringCase

      public short getFieldAsDateMonthIgnoringCase(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the month component, ignoring the case of "col".

    • getFieldAsDateDay

      public short getFieldAsDateDay(long row, int col)
      Interprets the specified field as a date and returns the day component.

    • getFieldAsDateDay

      public short getFieldAsDateDay(long row, int col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the day component.

    • getFieldAsDateDay

      public short getFieldAsDateDay(long row, String col)
      Interprets the specified field as a date and returns the day component.

    • getFieldAsDateDay

      public short getFieldAsDateDay(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the day component.

    • getFieldAsDateDayIgnoringCase

      public short getFieldAsDateDayIgnoringCase(long row, String col)
      Interprets the specified field as a date and returns the day component, ignoring the case of "col".

    • getFieldAsDateDayIgnoringCase

      public short getFieldAsDateDayIgnoringCase(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the day component, ignoring the case of "col".

    • getFieldAsDateHour

      public short getFieldAsDateHour(long row, int col)
      Interprets the specified field as a date and returns the hour component.

    • getFieldAsDateHour

      public short getFieldAsDateHour(long row, int col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the hour component.

    • getFieldAsDateHour

      public short getFieldAsDateHour(long row, String col)
      Interprets the specified field as a date and returns the hour component.

    • getFieldAsDateHour

      public short getFieldAsDateHour(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the hour component.

    • getFieldAsDateHourIgnoringCase

      public short getFieldAsDateHourIgnoringCase(long row, String col)
      Interprets the specified field as a date and returns the hour component, ignoring the case of "col".

    • getFieldAsDateHourIgnoringCase

      public short getFieldAsDateHourIgnoringCase(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the hour component, ignoring the case of "col".

    • getFieldAsDateMinute

      public short getFieldAsDateMinute(long row, int col)
      Interprets the specified field as a date and returns the minute component.

    • getFieldAsDateMinute

      public short getFieldAsDateMinute(long row, int col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the minute component.

    • getFieldAsDateMinute

      public short getFieldAsDateMinute(long row, String col)
      Interprets the specified field as a date and returns the minute component.

    • getFieldAsDateMinute

      public short getFieldAsDateMinute(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the minute component.

    • getFieldAsDateMinuteIgnoringCase

      public short getFieldAsDateMinuteIgnoringCase(long row, String col)
      Interprets the specified field as a date and returns the minute component, ignoring the case of "col".

    • getFieldAsDateMinuteIgnoringCase

      public short getFieldAsDateMinuteIgnoringCase(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the minute component, ignoring the case of "col".

    • getFieldAsDateSecond

      public short getFieldAsDateSecond(long row, int col)
      Interprets the specified field as a date and returns the second component.

    • getFieldAsDateSecond

      public short getFieldAsDateSecond(long row, int col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the second component.

    • getFieldAsDateSecond

      public short getFieldAsDateSecond(long row, String col)
      Interprets the specified field as a date and returns the second component.

    • getFieldAsDateSecond

      public short getFieldAsDateSecond(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the second component.

    • getFieldAsDateSecondIgnoringCase

      public short getFieldAsDateSecondIgnoringCase(long row, String col)
      Interprets the specified field as a date and returns the second component, ignoring the case of "col".

    • getFieldAsDateSecondIgnoringCase

      public short getFieldAsDateSecondIgnoringCase(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the second component, ignoring the case of "col".

    • getFieldAsDateMicrosecond

      public int getFieldAsDateMicrosecond(long row, int col)
      Interprets the specified field as a date and returns the microsecond component.

    • getFieldAsDateMicrosecond

      public int getFieldAsDateMicrosecond(long row, int col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the microsecond component.

    • getFieldAsDateMicrosecond

      public int getFieldAsDateMicrosecond(long row, String col)
      Interprets the specified field as a date and returns the microsecond component.

    • getFieldAsDateMicrosecond

      public int getFieldAsDateMicrosecond(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the microsecond component.

    • getFieldAsDateMicrosecondIgnoringCase

      public int getFieldAsDateMicrosecondIgnoringCase(long row, String col)
      Interprets the specified field as a date and returns the microsecond component, ignoring the case of "col".

    • getFieldAsDateMicrosecondIgnoringCase

      public int getFieldAsDateMicrosecondIgnoringCase(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns the microsecond component, ignoring the case of "col".

    • getFieldAsDateIsNegative

      public boolean getFieldAsDateIsNegative(long row, int col)
      Interprets the specified field as a date and returns whether the hour component is negative.

    • getFieldAsDateIsNegative

      public boolean getFieldAsDateIsNegative(long row, int col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns whether the hour component is negative.

    • getFieldAsDateIsNegative

      public boolean getFieldAsDateIsNegative(long row, String col)
      Interprets the specified field as a date and returns whether the hour component is negative.

    • getFieldAsDateIsNegative

      public boolean getFieldAsDateIsNegative(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns whether the hour component is negative.

    • getFieldAsDateIsNegativeIgnoringCase

      public boolean getFieldAsDateIsNegativeIgnoringCase(long row, String col)
      Interprets the specified field as a date and returns whether the hour component is negative, ignoring the case of "col".

    • getFieldAsDateIsNegativeIgnoringCase

      public boolean getFieldAsDateIsNegativeIgnoringCase(long row, String col, boolean ddmm, boolean yyyyddmm, String datedelimiters)
      Interprets the specified field as a date and returns whether the hour component is negative, ignoring the case of "col".

    • getFieldAsByteArray

      public byte[] getFieldAsByteArray(long row, int col)
      Returns the specified field as a byte array.

    • getFieldAsByteArray

      public byte[] getFieldAsByteArray(long row, String col)
      Returns the specified field as a byte array.

    • getFieldLength

      public long getFieldLength(long row, int col)
      Returns the length of the specified field.

    • getFieldLength

      public long getFieldLength(long row, String col)
      Returns the length of the specified field.

    • getRow

      public String[] getRow(long row)
      Returns a null terminated array of the values of the fields in the specified row.

    • getRowLengths

      public long[] getRowLengths(long row)
      Returns a null terminated array of the lengths of the fields in the specified row.

    • getColumnNames

      public String[] getColumnNames()
      Returns a null terminated array of the column names of the current result set.

    • getColumnName

      public String getColumnName(int col)
      Returns the name of the specified column.

    • getColumnType

      public String getColumnType(int col)
      Returns the type of the specified column.

    • getColumnType

      public String getColumnType(String col)
      Returns the type of the specified column.

    • getColumnPrecision

      public long getColumnPrecision(int col)
      Returns the precision of the specified column. Precision is the total number of digits in a number. eg: 123.45 has a precision of 5. For non-numeric types, it's the number of characters in the string.

    • getColumnPrecision

      public long getColumnPrecision(String col)
      Returns the precision of the specified column. Precision is the total number of digits in a number. eg: 123.45 has a precision of 5. For non-numeric types, it's the number of characters in the string.

    • getColumnScale

      public long getColumnScale(int col)
      Returns the scale of the specified column. Scale is the total number of digits to the right of the decimal point in a number. eg: 123.45 has a scale of 2.

    • getColumnScale

      public long getColumnScale(String col)
      Returns the scale of the specified column. Scale is the total number of digits to the right of the decimal point in a number. eg: 123.45 has a scale of 2.

    • getColumnIsNullable

      public boolean getColumnIsNullable(int col)
      Returns true if the specified column can contain nulls and false otherwise.

    • getColumnIsNullable

      public boolean getColumnIsNullable(String col)
      Returns true if the specified column can contain nulls and false otherwise.

    • getColumnIsPrimaryKey

      public boolean getColumnIsPrimaryKey(int col)
      Returns true if the specified column is a primary key and false otherwise.

    • getColumnIsPrimaryKey

      public boolean getColumnIsPrimaryKey(String col)
      Returns true if the specified column is a primary key and false otherwise.

    • getColumnIsUnique

      public boolean getColumnIsUnique(int col)
      Returns true if the specified column is unique and false otherwise.

    • getColumnIsUnique

      public boolean getColumnIsUnique(String col)
      Returns true if the specified column is unique and false otherwise.

    • getColumnIsPartOfKey

      public boolean getColumnIsPartOfKey(int col)
      Returns true if the specified column is part of a composite key and false otherwise.

    • getColumnIsPartOfKey

      public boolean getColumnIsPartOfKey(String col)
      Returns true if the specified column is part of a composite key and false otherwise.

    • getColumnIsUnsigned

      public boolean getColumnIsUnsigned(int col)
      Returns true if the specified column is an unsigned number and false otherwise.

    • getColumnIsUnsigned

      public boolean getColumnIsUnsigned(String col)
      Returns true if the specified column is an unsigned number and false otherwise.

    • getColumnIsZeroFilled

      public boolean getColumnIsZeroFilled(int col)
      Returns true if the specified column was created with the zero-fill flag and false otherwise.

    • getColumnIsZeroFilled

      public boolean getColumnIsZeroFilled(String col)
      Returns true if the specified column was created with the zero-fill flag and false otherwise.

    • getColumnIsBinary

      public boolean getColumnIsBinary(int col)
      Returns true if the specified column contains binary data and false otherwise.

    • getColumnIsBinary

      public boolean getColumnIsBinary(String col)
      Returns true if the specified column contains binary data and false otherwise.

    • getColumnIsAutoIncrement

      public boolean getColumnIsAutoIncrement(int col)
      Returns true if the specified column auto-increments and false otherwise.

    • getColumnIsAutoIncrement

      public boolean getColumnIsAutoIncrement(String col)
      Returns true if the specified column auto-increments and false otherwise.

    • getColumnLength

      public int getColumnLength(int col)
      Returns the number of bytes required on the server to store the data for the specified column

    • getColumnLength

      public int getColumnLength(String col)
      Returns the number of bytes required on the server to store the data for the specified column

    • getLongest

      public int getLongest(int col)
      Returns the length of the longest field in the specified column.

    • getLongest

      public int getLongest(String col)
      Returns the length of the longest field in the specified column.

    • suspendResultSet

      public void suspendResultSet()
      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().

    • getResultSetId

      public short getResultSetId()
      Returns the internal ID of this result set. This parameter may be passed to another cursor for use in the resumeResultSet() method. Note: The value this method returns is only valid after a call to suspendResultSet().

    • resumeResultSet

      public boolean resumeResultSet(short id)
      Resumes a result set previously left open using suspendSession(). Returns true on success and false on failure.

    • resumeCachedResultSet

      public boolean resumeCachedResultSet(short id, String filename)
      Resumes a result set previously left open using suspendSession() and continues caching the result set to "filename". Returns true on success and false on failure.

    • closeResultSet

      public void closeResultSet()
      Closes the current result set, if one is open. Data that has been fetched already is still available but no more data may be fetched. Server side resources for the result set are freed as well.

    • getDatabaseListWithFormat

      public boolean getDatabaseListWithFormat(String databases, int listformat)

    • getCatalogListWithFormat

      public boolean getCatalogListWithFormat(String catalogs, int listformat)

    • getSchemaListWithFormat

      public boolean getSchemaListWithFormat(String schemas, int listformat)

    • getTableListWithFormat

      public boolean getTableListWithFormat(String tables, int listformat, int objecttypes)

    • getTableTypeListWithFormat

      public boolean getTableTypeListWithFormat(int listformat)

    • getColumnListWithFormat

      public boolean getColumnListWithFormat(String table, String columns, int listformat)

    • getPrimaryKeysListWithFormat

      public boolean getPrimaryKeysListWithFormat(String table, String columns, int listformat)

    • getKeyAndIndexListWithFormat

      public boolean getKeyAndIndexListWithFormat(String table, String qualifier, int listformat)

    • getTypeInfoListWithFormat

      public boolean getTypeInfoListWithFormat(String type, int listformat)

    • getProcedureListWithFormat

      public boolean getProcedureListWithFormat(String procedures, int listformat)

    • getProcedureParameterListWithFormat

      public boolean getProcedureParameterListWithFormat(String procedure, String parameters, int listformat)

    • getLastInsertIdList

      public boolean getLastInsertIdList()

    • isNumberType

      public boolean isNumberType(String type)

    • isDateTimeType

      public boolean isDateTimeType(String type)

    • isBinaryType

      public boolean isBinaryType(String type)

    • isUnsignedType

      public boolean isUnsignedType(String type)

    • isClobType

      public boolean isClobType(String type)

    • isBlobType

      public boolean isBlobType(String type)