Serialized Form


Package com.mckoi.database

Class com.mckoi.database.Assignment extends java.lang.Object implements Serializable

serialVersionUID: 498589698743066869L

Serialized Fields

variable

Variable variable
The Variable that is the lhs of the assignment.


expression

Expression expression
Set expression that is the rhs of the assignment.

Class com.mckoi.database.CorrelatedVariable extends java.lang.Object implements Serializable

serialVersionUID: -607848111230634419L

Serialized Fields

variable

Variable variable
The Variable reference itself.


query_level_offset

int query_level_offset
The number of sub-query branches back that the reference for this variable can be found.

Class com.mckoi.database.DatabaseConstraintViolationException extends java.lang.RuntimeException implements Serializable

Serialized Fields

error_code

int error_code
The error code.

Class com.mckoi.database.DatabaseException extends java.lang.Exception implements Serializable

Serialized Fields

error_code

int error_code

Class com.mckoi.database.Expression extends java.lang.Object implements Serializable

serialVersionUID: 6981261114471924028L

Serialization Methods

readObject

private void readObject(java.io.ObjectInputStream in)
                 throws java.io.IOException,
                        java.lang.ClassNotFoundException
Reads the state of this object from the object stream.

Throws:
java.io.IOException
java.lang.ClassNotFoundException

writeObject

private void writeObject(java.io.ObjectOutputStream out)
                  throws java.io.IOException
Writes the state of this object to the object stream. This method is implemented because GCJ doesn't like it if you implement readObject without writeObject.

Throws:
java.io.IOException
Serialized Fields

elements

java.util.ArrayList elements
The list of elements followed by operators in our expression. The expression elements may be of any type represented by the database (see 'addElement' method for the accepted objects). The expression operators may be '+', '-', '*', '*', '/', '=', '>=', '<>', etc (as an Operator object (see the Operator class for details)).

This list is stored in postfix order.


text

java.lang.StringBuffer text
The expression as a plain human readable string. This is in a form that can be readily parsed to an Expression object.

Class com.mckoi.database.FunctionDef extends java.lang.Object implements Serializable

serialVersionUID: 3339781003247956829L

Serialized Fields

name

java.lang.String name
The name of the function.


params

Expression[] params
The list of parameters for the function.

Class com.mckoi.database.JoiningSet extends java.lang.Object implements Serializable

serialVersionUID: -380871062550922402L

Serialized Fields

join_set

java.util.ArrayList join_set
The list of tables we are joining together a JoinPart object that represents how the tables are joined.

Class com.mckoi.database.JoiningSet.JoinPart extends java.lang.Object implements Serializable

serialVersionUID: -1664565759669808084L

Serialized Fields

type

int type
The type of join. Either LEFT_OUTER_JOIN, RIGHT_OUTER_JOIN, FULL_OUTER_JOIN, INNER_JOIN.


on_expression

Expression on_expression
The expression that we are joining on (eg. ON clause in SQL). If there is no ON expression (such as in the case of natural joins) then this is null.

Class com.mckoi.database.Operator extends java.lang.Object implements Serializable

serialVersionUID: 516615288995154064L

Serialized Fields

op

java.lang.String op
A string that represents this operator.


set_type

int set_type
If this is a set operator such as ANY or ALL then this is set with the flag type.


precedence

int precedence
The precedence of this operator.

Class com.mckoi.database.ParameterSubstitution extends java.lang.Object implements Serializable

serialVersionUID: -740886588230246432L

Serialized Fields

parameter_id

int parameter_id
The numerical number of this parameter substitution. The first substitution is '0', the second is '1', etc.

Class com.mckoi.database.ProcedureException extends java.lang.RuntimeException implements Serializable

Class com.mckoi.database.QueryPlan.BranchQueryPlanNode extends java.lang.Object implements Serializable

serialVersionUID: 2938130775577221138L

Serialized Fields

left

QueryPlanNode left
The left and right node.


right

QueryPlanNode right
The left and right node.

Class com.mckoi.database.QueryPlan.CachePointNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: 7866310557831478639L

Serialized Fields

id

long id
The unique identifier of this cache point.

Class com.mckoi.database.QueryPlan.CompositeNode extends QueryPlan.BranchQueryPlanNode implements Serializable

serialVersionUID: -560587816928425857L

Serialized Fields

composite_op

int composite_op
The composite operation (either CompositeTable.UNION, EXCEPT, INTERSECT).


all_op

boolean all_op
If this is true, the composite includes all results from both children, otherwise removes deplicates.

Class com.mckoi.database.QueryPlan.ConstantSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -4435336817396073146L

Serialized Fields

expression

Expression expression
The search expression.

Class com.mckoi.database.QueryPlan.CreateFunctionsNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -181012844247626327L

Serialized Fields

function_list

Expression[] function_list
The list of functions to create.


name_list

java.lang.String[] name_list
The list of names to give each function table.

Class com.mckoi.database.QueryPlan.DistinctNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -1538264313804102373L

Serialized Fields

columns

Variable[] columns
The list of columns to be distinct.

Class com.mckoi.database.QueryPlan.EquiJoinNode extends QueryPlan.BranchQueryPlanNode implements Serializable

serialVersionUID: 113332589582049607L

Serialized Fields

left_columns

Variable[] left_columns
The columns in the left table.


right_columns

Variable[] right_columns
The columns in the right table.

Class com.mckoi.database.QueryPlan.ExhaustiveSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -2005551680157574172L

Serialized Fields

expression

Expression expression
The search expression.

Class com.mckoi.database.QueryPlan.FetchTableNode extends java.lang.Object implements Serializable

serialVersionUID: 7545493568015241717L

Serialized Fields

table_name

TableName table_name
The name of the table to fetch.


alias_name

TableName alias_name
The name to alias the table as.

Class com.mckoi.database.QueryPlan.FetchViewNode extends java.lang.Object implements Serializable

serialVersionUID: -6557333346211179284L

Serialized Fields

table_name

TableName table_name
The name of the view to fetch.


alias_name

TableName alias_name
The name to alias the table as.

Class com.mckoi.database.QueryPlan.FunctionalSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -1428022600352236457L

Serialized Fields

expression

Expression expression
The function expression (eg. CONCAT(a, ' ', b) == 'abba bo').

Class com.mckoi.database.QueryPlan.GroupNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: 7140928678192396348L

Serialized Fields

columns

Variable[] columns
The columns to group by.


group_max_column

Variable group_max_column
The group max column.


function_list

Expression[] function_list
Any aggregate functions (or regular function columns) that are to be planned.


name_list

java.lang.String[] name_list
The list of names to give each function table.

Class com.mckoi.database.QueryPlan.JoinNode extends QueryPlan.BranchQueryPlanNode implements Serializable

serialVersionUID: 4133205808616807832L

Serialized Fields

left_var

Variable left_var
The variable in the left table to be joined.


join_op

Operator join_op
The operator to join under (=, <>, >, <, >=, <=).


right_expression

Expression right_expression
The expression evaluated on the right table.

Class com.mckoi.database.QueryPlan.LeftOuterJoinNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: 8908801499550863492L

Serialized Fields

complete_mark_name

java.lang.String complete_mark_name
The name of the mark that points to the left table that represents the complete set.

Class com.mckoi.database.QueryPlan.LogicalUnionNode extends QueryPlan.BranchQueryPlanNode implements Serializable

serialVersionUID: -7783166856668779902L

Class com.mckoi.database.QueryPlan.MarkerNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -8321710589608765270L

Serialized Fields

mark_name

java.lang.String mark_name
The name of this mark.

Class com.mckoi.database.QueryPlan.MultiColumnEquiSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -1407710412096857588L

Serialized Fields

columns

Variable[] columns
The list of columns to select the range of.


values

Expression[] values
The values of the cells to equi-select (must be constant expressions).

Class com.mckoi.database.QueryPlan.NaturalJoinNode extends QueryPlan.BranchQueryPlanNode implements Serializable

serialVersionUID: 942526205653132810L

Class com.mckoi.database.QueryPlan.NonCorrelatedAnyAllNode extends QueryPlan.BranchQueryPlanNode implements Serializable

serialVersionUID: 7480579008259288291L

Serialized Fields

left_columns

Variable[] left_columns
The columns in the left table.


sub_query_operator

Operator sub_query_operator
The SubQuery operator, eg. '= ANY', '<> ALL'

Class com.mckoi.database.QueryPlan.RangeSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -108747827391465748L

Serialized Fields

expression

Expression expression
A simple expression that represents the range to select. See the class comments for a description for how this expression must be formed.

Class com.mckoi.database.QueryPlan.SimplePatternSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: -8247282157310682761L

Serialized Fields

expression

Expression expression
The search expression.

Class com.mckoi.database.QueryPlan.SimpleSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: 5502157970886270867L

Serialized Fields

left_var

Variable left_var
The LHS variable.


op

Operator op
The operator to select under (=, <>, >, <, >=, <=).


right_expression

Expression right_expression
The RHS expression.

Class com.mckoi.database.QueryPlan.SingleQueryPlanNode extends java.lang.Object implements Serializable

serialVersionUID: -6753991881140638658L

Serialized Fields

child

QueryPlanNode child
The single child node.

Class com.mckoi.database.QueryPlan.SingleRowTableNode extends java.lang.Object implements Serializable

serialVersionUID: -7180494964138911604L

Class com.mckoi.database.QueryPlan.SortNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: 3644480534542996928L

Serialized Fields

columns

Variable[] columns
The list of columns to sort.


correct_ascending

boolean[] correct_ascending
Whether to sort the column in ascending or descending order

Class com.mckoi.database.QueryPlan.SubsetNode extends QueryPlan.SingleQueryPlanNode implements Serializable

serialVersionUID: 3784462788248510832L

Serialized Fields

original_columns

Variable[] original_columns
The original columns in the child that we are to make the subset of.


new_column_names

Variable[] new_column_names
New names to assign the columns.

Class com.mckoi.database.StatementException extends java.lang.RuntimeException implements Serializable

Class com.mckoi.database.StatementTree extends java.lang.Object implements Serializable

serialVersionUID: -5907058730080713004L

Serialized Fields

statement_class

java.lang.String statement_class
The class of statement this is. This is set to one of the query objects from the com.mckoi.database.interpret package. For example, if this is a select statement then it points to 'com.mckoi.database.interpret.Select'.


map

java.util.HashMap map
A map that maps from the name of the tree element to the object that contains information about. For example, if this is an SQL SELECT statement then entries in this map may be;
   "columns" -> sql.SelectColumn[]
   "distinct" -> new Boolean(true)
 

Class com.mckoi.database.TableName extends java.lang.Object implements Serializable

serialVersionUID: 6527135256976754916L

Serialized Fields

schema_name

java.lang.String schema_name
The name of the schema of the table. This value can be 'null' which means the schema is currently unknown.


table_name

java.lang.String table_name
The name of the table.

Class com.mckoi.database.TArrayType extends TType implements Serializable

serialVersionUID: 6551509064212831922L

Class com.mckoi.database.TBinaryType extends TType implements Serializable

serialVersionUID: 5141996433600529406L

Serialized Fields

max_size

int max_size
This constrained size of the binary block of data or -1 if there is no size limit.

Class com.mckoi.database.TBooleanType extends TType implements Serializable

serialVersionUID: 5602396246537490259L

Class com.mckoi.database.TDateType extends TType implements Serializable

serialVersionUID: 1494137367081481985L

Class com.mckoi.database.TJavaObjectType extends TType implements Serializable

serialVersionUID: -4413863997719593305L

Serialized Fields

class_type

java.lang.String class_type
The type of class this is contrained to or null if it is not constrained to a java class.

Class com.mckoi.database.TNullType extends TType implements Serializable

serialVersionUID: -271824967935043427L

Class com.mckoi.database.TNumericType extends TType implements Serializable

serialVersionUID: -5133489773377747175L

Serialized Fields

size

int size
The size of the number.


scale

int scale
The scale of the number.

Class com.mckoi.database.TObject extends java.lang.Object implements Serializable

serialVersionUID: -5129157457207765079L

Serialization Methods

readObject

private void readObject(java.io.ObjectInputStream in)
                 throws java.io.IOException,
                        java.lang.ClassNotFoundException
Serialization overwritten method. We overwrite this method because of a change with how strings are stored. In 0.93 we stored strings in this object as java.lang.String and in 0.94 we stored strings as java.lang.StringObject. This performs a conversion between the old and new format.

Throws:
java.io.IOException
java.lang.ClassNotFoundException

writeObject

private void writeObject(java.io.ObjectOutputStream out)
                  throws java.io.IOException
Writes the state of this object to the object stream. This method is implemented because GCJ doesn't like it if you implement readObject without writeObject.

Throws:
java.io.IOException
Serialized Fields

type

TType type
The type of this object.


ob

java.lang.Object ob
The Java representation of the object.

Class com.mckoi.database.TQueryPlanType extends TType implements Serializable

serialVersionUID: -1122548450083929179L

Class com.mckoi.database.TransactionException extends java.lang.Exception implements Serializable

Serialized Fields

type

int type
The type of error.

Class com.mckoi.database.TStringType extends TType implements Serializable

serialVersionUID: -4189752898050725908L

Serialized Fields

max_size

int max_size
The maximum allowed size for the string.


locale

java.util.Locale locale
The locale of the string.


strength

int strength
The strength of the collator for this string (as defined in java.text.Collator).


decomposition

int decomposition
The decomposition mode of the collator for this string type (as defined in java.text.Collator).

Class com.mckoi.database.TType extends java.lang.Object implements Serializable

serialVersionUID: 5866230818579853961L

Serialized Fields

sql_type

int sql_type
The type as an SQL identifier from com.mckoi.database.global.SQLTypes.

Class com.mckoi.database.UserAccessException extends DatabaseException implements Serializable

Class com.mckoi.database.Variable extends java.lang.Object implements Serializable

serialVersionUID: -8772800465139383297L

Serialized Fields

table_name

TableName table_name
The TableName that is the context of this column. This may be UNKNOWN_TABLE_NAME if the table name is not known.


column_name

java.lang.String column_name
The column name itself.


Package com.mckoi.database.global

Class com.mckoi.database.global.ByteLongObject extends java.lang.Object implements Serializable

serialVersionUID: -6843780673892019530L

Serialized Fields

data

byte[] data
The binary data.

Class com.mckoi.database.global.NullObject extends java.lang.Object implements Serializable

serialVersionUID: 8599490526855696529L

Class com.mckoi.database.global.StringObject extends java.lang.Object implements Serializable

serialVersionUID: 6066215992031250481L

Serialized Fields

str

java.lang.String str
The java.lang.String object.


Package com.mckoi.database.interpret

Class com.mckoi.database.interpret.AlterTableAction extends java.lang.Object implements Serializable

serialVersionUID: -3180332341627416727L

Serialized Fields

elements

java.util.ArrayList elements
Element parameters to do with the action.


action

java.lang.String action
The action to perform.

Class com.mckoi.database.interpret.ByColumn extends java.lang.Object implements Serializable

serialVersionUID: 8194415767416200855L

Serialized Fields

name

Variable name
The name of the column in the 'by'.


exp

Expression exp
The expression that we are ordering by.


ascending

boolean ascending
If 'order by' then true if sort is ascending (default).

Class com.mckoi.database.interpret.ColumnDef extends java.lang.Object implements Serializable

serialVersionUID: 8347617136528650961L

Serialized Fields

name

java.lang.String name

type

TType type

index_str

java.lang.String index_str

default_expression

Expression default_expression

original_default_expression

Expression original_default_expression

not_null

boolean not_null

primary_key

boolean primary_key

unique

boolean unique

Class com.mckoi.database.interpret.ConstraintDef extends java.lang.Object implements Serializable

serialVersionUID: -6648793780645431100L

Serialized Fields

type

int type

name

java.lang.String name

check_expression

Expression check_expression

original_check_expression

Expression original_check_expression

column_list

java.util.ArrayList column_list

column_list2

java.util.ArrayList column_list2

reference_table_name

java.lang.String reference_table_name

update_rule

java.lang.String update_rule

delete_rule

java.lang.String delete_rule

deferred

short deferred

Class com.mckoi.database.interpret.FromClause extends java.lang.Object implements Serializable

serialVersionUID: 565726601314503609L

Serialized Fields

join_set

JoiningSet join_set
The JoiningSet object that we have created to represent the joins in this FROM clause.


def_list

java.util.ArrayList def_list
A list of all FromTableDef objects in this clause in order of when they were specified.


all_table_names

java.util.ArrayList all_table_names
A list of all table names in this from clause.


table_key

int table_key
An id used for making unique names for anonymous inner selects.

Class com.mckoi.database.interpret.FromTableDef extends java.lang.Object implements Serializable

serialVersionUID: -606852454508224625L

Serialized Fields

subquery_table

boolean subquery_table
If this is true, then the table def represents a sub-query table. The 'getSubSelectStatement' and 'getAlias' method can be used to get the table information.

eg. FROM ( SELECT id, number FROM Part ) AS part_info, ....


unique_key

java.lang.String unique_key
The unique key name given to this table definition.


table_name

java.lang.String table_name
The name of the table this definition references.


table_alias

java.lang.String table_alias
The alias of the table or null if no alias was defined.


subselect_table

TableSelectExpression subselect_table
The TableSelectExpression if this is a subquery table.

Class com.mckoi.database.interpret.SearchExpression extends java.lang.Object implements Serializable

serialVersionUID: 2888486150597671440L

Serialized Fields

search_expression

Expression search_expression
The originating expression.

Class com.mckoi.database.interpret.SelectColumn extends java.lang.Object implements Serializable

serialVersionUID: 2507375247510606004L

Serialized Fields

glob_name

java.lang.String glob_name
If the column represents a glob of columns (eg. 'Part.*' or '*') then this is set to the glob string and 'expression' is left blank.


resolved_name

Variable resolved_name
The fully resolved name that this column is given in the resulting table.


alias

java.lang.String alias
The alias of this column string.


expression

Expression expression
The expression of this column. This is only NOT set when name == "*" indicating all the columns.


internal_name

Variable internal_name
The name of this column used internally to reference it.

Class com.mckoi.database.interpret.TableSelectExpression extends java.lang.Object implements Serializable

serialVersionUID: 6946017316981412561L

Serialized Fields

distinct

boolean distinct
True if we only search for distinct elements.


columns

java.util.ArrayList columns
The list of columns to select from. (SelectColumn)


from_clause

FromClause from_clause
The from clause.


where_clause

SearchExpression where_clause
The where clause.


group_by

java.util.ArrayList group_by
The list of columns to group by. (ByColumn)


group_max

Variable group_max
The group max variable or null if no group max.


having_clause

SearchExpression having_clause
The having clause.


composite_function

int composite_function
If there is a composite function this is set to the composite enumeration from CompositeTable.


is_composite_all

boolean is_composite_all
If this is an ALL composite (no removal of duplicate rows) it is true.


next_composite

TableSelectExpression next_composite
The composite table itself.


Package com.mckoi.database.jdbc

Class com.mckoi.database.jdbc.MSQLException extends java.sql.SQLException implements Serializable

Serialized Fields

server_error_msg

java.lang.String server_error_msg

server_stack_trace

java.lang.String server_stack_trace

Class com.mckoi.database.jdbc.ResultPart extends java.util.Vector implements Serializable

Class com.mckoi.database.jdbc.SQLLoginException extends java.sql.SQLException implements Serializable


Package com.mckoi.database.sql

Class com.mckoi.database.sql.ParseException extends java.lang.Exception implements Serializable

Serialized Fields

specialConstructor

boolean specialConstructor
This variable determines which constructor was used to create this object and thereby affects the semantics of the "getMessage" method (see below).


currentToken

Token currentToken
This is the last token that has been consumed successfully. If this object has been created due to a parse error, the token followng this token will (therefore) be the first error token.


expectedTokenSequences

int[][] expectedTokenSequences
Each entry in this array is an array of integers. Each array of integers represents a sequence of tokens (by their ordinal values) that is expected at this point of the parse.


tokenImage

java.lang.String[] tokenImage
This is a reference to the "tokenImage" array of the generated parser within which the parse error occurred. This array is defined in the generated ...Constants interface.


eol

java.lang.String eol
The end of line string for this machine.

Class com.mckoi.database.sql.TokenMgrError extends java.lang.Error implements Serializable

Serialized Fields

errorCode

int errorCode
Indicates the reason why the exception is thrown. It will have one of the above 4 values.


Package com.mckoi.jfccontrols

Class com.mckoi.jfccontrols.ResultSetTableModel extends javax.swing.table.AbstractTableModel implements Serializable

Serialized Fields

result_set

java.sql.ResultSet result_set
The scrollable ResultSet source.


meta_data

java.sql.ResultSetMetaData meta_data
The ResultSetMetaData object for this result set.


row_count

int row_count
The number of rows in the result set.


preserve_table_structure

boolean preserve_table_structure
If true, a table structure change event is NOT thrown if the result set looks similar to an updated result set.


Package com.mckoi.tools

Class com.mckoi.tools.JDBCQueryTool extends javax.swing.JComponent implements Serializable

Serialized Fields

query_agent

QueryAgent query_agent
The agent used to make queries on the JDBC connection.


query_text_area

javax.swing.JTextArea query_text_area
The JTextArea where the query is entered.


result_table

javax.swing.JTable result_table
The JTable where the query result is printed.


table_model

ResultSetTableModel table_model
The ResultSetTableModel for the table model that contains our result set.


status_text

javax.swing.JLabel status_text
The JLabel status bar at the bottom of the window.


auto_resize_result_table

javax.swing.JCheckBoxMenuItem auto_resize_result_table
Set to true if the table is auto resize (default).


total_row_count

int total_row_count
Total number of rows in the result.


query_time

int query_time
The time it took to execute the query in milliseconds.


Package com.mckoi.util

Class com.mckoi.util.BigNumber extends java.lang.Number implements Serializable

serialVersionUID: -8681578742639638105L

Serialized Fields

number_state

byte number_state
The state of the number, either 0 for number is the BigDecimal, 1 for negative infinity, 2 for positive infinity and 3 for NaN.


big_decimal

java.math.BigDecimal big_decimal
The BigDecimal representation.


long_representation

long long_representation
A 'long' representation of this number.


byte_count

byte byte_count
If this can be represented as an int or long, this contains the number of bytes needed to represent the number.

Class com.mckoi.util.IntegerVector extends java.lang.Object implements Serializable

Serialized Fields

list

int[] list
The int array.


index

int index
The index of the last value of the array.