Serialized Form
-
Package com.mckoi.database
-
Class com.mckoi.database.Assignment
class Assignment extends Object implements Serializable- serialVersionUID:
- 498589698743066869L
-
Serialized Fields
-
expression
Expression expression
Set expression that is the rhs of the assignment. -
variable
Variable variable
The Variable that is the lhs of the assignment.
-
-
Exception com.mckoi.database.DatabaseConstraintViolationException
class DatabaseConstraintViolationException extends RuntimeException implements Serializable-
Serialized Fields
-
error_code
int error_code
The error code.
-
-
-
Exception com.mckoi.database.DatabaseException
class DatabaseException extends Exception implements Serializable-
Serialized Fields
-
error_code
int error_code
-
-
-
Class com.mckoi.database.Expression
class Expression extends Object implements Serializable- serialVersionUID:
- 6981261114471924028L
-
Serialization Methods
-
readObject
Reads the state of this object from the object stream.- Throws:
IOException
ClassNotFoundException
-
writeObject
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:
IOException
-
-
Serialized Fields
-
elements
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
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
class FunctionDef extends Object implements Serializable- serialVersionUID:
- 3339781003247956829L
-
Serialized Fields
-
name
String name
The name of the function. -
params
Expression[] params
The list of parameters for the function.
-
-
Class com.mckoi.database.JoiningSet
class JoiningSet extends Object implements Serializable- serialVersionUID:
- -380871062550922402L
-
Serialized Fields
-
join_set
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
class JoinPart extends Object implements Serializable- serialVersionUID:
- -1664565759669808084L
-
Serialized Fields
-
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. -
type
int type
The type of join. Either LEFT_OUTER_JOIN, RIGHT_OUTER_JOIN, FULL_OUTER_JOIN, INNER_JOIN.
-
-
Class com.mckoi.database.Operator
class Operator extends Object implements Serializable- serialVersionUID:
- 516615288995154064L
-
Serialized Fields
-
op
String op
A string that represents this operator. -
precedence
int precedence
The precedence of 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.
-
-
Class com.mckoi.database.ParameterSubstitution
class ParameterSubstitution extends 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.
-
-
Exception com.mckoi.database.ProcedureException
class ProcedureException extends RuntimeException implements Serializable -
Class com.mckoi.database.QueryPlan.BranchQueryPlanNode
class BranchQueryPlanNode extends 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
class 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
class CompositeNode extends QueryPlan.BranchQueryPlanNode implements Serializable- serialVersionUID:
- -560587816928425857L
-
Serialized Fields
-
all_op
boolean all_op
If this is true, the composite includes all results from both children, otherwise removes deplicates. -
composite_op
int composite_op
The composite operation (either CompositeTable.UNION, EXCEPT, INTERSECT).
-
-
Class com.mckoi.database.QueryPlan.ConstantSelectNode
class ConstantSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable- serialVersionUID:
- -4435336817396073146L
-
Serialized Fields
-
expression
Expression expression
The search expression.
-
-
Class com.mckoi.database.QueryPlan.CreateFunctionsNode
class CreateFunctionsNode extends QueryPlan.SingleQueryPlanNode implements Serializable- serialVersionUID:
- -181012844247626327L
-
Serialized Fields
-
function_list
Expression[] function_list
The list of functions to create. -
name_list
String[] name_list
The list of names to give each function table.
-
-
Class com.mckoi.database.QueryPlan.DistinctNode
class 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
class EquiJoinNode extends QueryPlan.BranchQueryPlanNode implements Serializable- serialVersionUID:
- 113332589582049607L
-
Class com.mckoi.database.QueryPlan.ExhaustiveSelectNode
class ExhaustiveSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable- serialVersionUID:
- -2005551680157574172L
-
Serialized Fields
-
expression
Expression expression
The search expression.
-
-
Class com.mckoi.database.QueryPlan.FetchTableNode
class FetchTableNode extends Object implements Serializable- serialVersionUID:
- 7545493568015241717L
-
Class com.mckoi.database.QueryPlan.FetchViewNode
class FetchViewNode extends Object implements Serializable- serialVersionUID:
- -6557333346211179284L
-
Class com.mckoi.database.QueryPlan.FunctionalSelectNode
class 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
class GroupNode extends QueryPlan.SingleQueryPlanNode implements Serializable- serialVersionUID:
- 7140928678192396348L
-
Serialized Fields
-
columns
Variable[] columns
The columns to group by. -
function_list
Expression[] function_list
Any aggregate functions (or regular function columns) that are to be planned. -
group_max_column
Variable group_max_column
The group max column. -
name_list
String[] name_list
The list of names to give each function table.
-
-
Class com.mckoi.database.QueryPlan.JoinNode
class JoinNode extends QueryPlan.BranchQueryPlanNode implements Serializable- serialVersionUID:
- 4133205808616807832L
-
Serialized Fields
-
join_op
Operator join_op
The operator to join under (=, <>, >, <, >=, <=). -
left_var
Variable left_var
The variable in the left table to be joined. -
right_expression
Expression right_expression
The expression evaluated on the right table.
-
-
Class com.mckoi.database.QueryPlan.LeftOuterJoinNode
class LeftOuterJoinNode extends QueryPlan.SingleQueryPlanNode implements Serializable- serialVersionUID:
- 8908801499550863492L
-
Serialized Fields
-
complete_mark_name
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
class LogicalUnionNode extends QueryPlan.BranchQueryPlanNode implements Serializable- serialVersionUID:
- -7783166856668779902L
-
Class com.mckoi.database.QueryPlan.MarkerNode
class MarkerNode extends QueryPlan.SingleQueryPlanNode implements Serializable- serialVersionUID:
- -8321710589608765270L
-
Serialized Fields
-
mark_name
String mark_name
The name of this mark.
-
-
Class com.mckoi.database.QueryPlan.MultiColumnEquiSelectNode
class 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
class NaturalJoinNode extends QueryPlan.BranchQueryPlanNode implements Serializable- serialVersionUID:
- 942526205653132810L
-
Class com.mckoi.database.QueryPlan.RangeSelectNode
class 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
class SimplePatternSelectNode extends QueryPlan.SingleQueryPlanNode implements Serializable- serialVersionUID:
- -8247282157310682761L
-
Serialized Fields
-
expression
Expression expression
The search expression.
-
-
Class com.mckoi.database.QueryPlan.SimpleSelectNode
class 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
class SingleQueryPlanNode extends Object implements Serializable- serialVersionUID:
- -6753991881140638658L
-
Serialized Fields
-
child
QueryPlanNode child
The single child node.
-
-
Class com.mckoi.database.QueryPlan.SingleRowTableNode
class SingleRowTableNode extends Object implements Serializable- serialVersionUID:
- -7180494964138911604L
-
Class com.mckoi.database.QueryPlan.SortNode
class 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
class SubsetNode extends QueryPlan.SingleQueryPlanNode implements Serializable- serialVersionUID:
- 3784462788248510832L
-
Exception com.mckoi.database.StatementException
class StatementException extends RuntimeException implements Serializable -
Class com.mckoi.database.StatementTree
class StatementTree extends Object implements Serializable- serialVersionUID:
- -5907058730080713004L
-
Serialized Fields
-
map
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)
-
statement_class
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'.
-
-
Class com.mckoi.database.TableName
class TableName extends Object implements Serializable- serialVersionUID:
- 6527135256976754916L
-
Class com.mckoi.database.TArrayType
class TArrayType extends TType implements Serializable- serialVersionUID:
- 6551509064212831922L
-
Class com.mckoi.database.TBinaryType
class 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
class TBooleanType extends TType implements Serializable- serialVersionUID:
- 5602396246537490259L
-
Class com.mckoi.database.TDateType
class TDateType extends TType implements Serializable- serialVersionUID:
- 1494137367081481985L
-
Class com.mckoi.database.TJavaObjectType
class TJavaObjectType extends TType implements Serializable- serialVersionUID:
- -4413863997719593305L
-
Serialized Fields
-
class_type
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
class TNullType extends TType implements Serializable- serialVersionUID:
- -271824967935043427L
-
Class com.mckoi.database.TNumericType
class TNumericType extends TType implements Serializable- serialVersionUID:
- -5133489773377747175L
-
Serialized Fields
-
scale
int scale
The scale of the number. -
size
int size
The size of the number.
-
-
Class com.mckoi.database.TObject
class TObject extends Object implements Serializable- serialVersionUID:
- -5129157457207765079L
-
Serialization Methods
-
readObject
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:
IOException
ClassNotFoundException
-
writeObject
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:
IOException
-
-
Serialized Fields
-
Class com.mckoi.database.TQueryPlanType
class TQueryPlanType extends TType implements Serializable- serialVersionUID:
- -1122548450083929179L
-
Exception com.mckoi.database.TransactionException
class TransactionException extends Exception implements Serializable-
Serialized Fields
-
type
int type
The type of error.
-
-
-
Class com.mckoi.database.TStringType
class TStringType extends TType implements Serializable- serialVersionUID:
- -4189752898050725908L
-
Serialized Fields
-
decomposition
int decomposition
The decomposition mode of the collator for this string type (as defined in java.text.Collator). -
locale
Locale locale
The locale of the string. -
max_size
int max_size
The maximum allowed size for the string. -
strength
int strength
The strength of the collator for this string (as defined in java.text.Collator).
-
-
Class com.mckoi.database.TType
class TType extends Object implements Serializable- serialVersionUID:
- 5866230818579853961L
-
Serialized Fields
-
sql_type
int sql_type
The type as an SQL identifier from com.mckoi.database.global.SQLTypes.
-
-
Exception com.mckoi.database.UserAccessException
class UserAccessException extends DatabaseException implements Serializable -
Class com.mckoi.database.Variable
class Variable extends Object implements Serializable- serialVersionUID:
- -8772800465139383297L
-
-
Package com.mckoi.database.global
-
Class com.mckoi.database.global.ByteLongObject
class ByteLongObject extends Object implements Serializable- serialVersionUID:
- -6843780673892019530L
-
Serialized Fields
-
data
byte[] data
The binary data.
-
-
Class com.mckoi.database.global.NullObject
class NullObject extends Object implements Serializable- serialVersionUID:
- 8599490526855696529L
-
Class com.mckoi.database.global.StringObject
class StringObject extends Object implements Serializable- serialVersionUID:
- 6066215992031250481L
-
Serialized Fields
-
str
String str
The java.lang.String object.
-
-
-
Package com.mckoi.database.interpret
-
Class com.mckoi.database.interpret.AlterTableAction
class AlterTableAction extends Object implements Serializable- serialVersionUID:
- -3180332341627416727L
-
Class com.mckoi.database.interpret.ByColumn
class ByColumn extends Object implements Serializable- serialVersionUID:
- 8194415767416200855L
-
Serialized Fields
-
ascending
boolean ascending
If 'order by' then true if sort is ascending (default). -
exp
Expression exp
The expression that we are ordering by. -
name
Variable name
The name of the column in the 'by'.
-
-
Class com.mckoi.database.interpret.ColumnDef
class ColumnDef extends Object implements Serializable- serialVersionUID:
- 8347617136528650961L
-
Serialized Fields
-
default_expression
Expression default_expression
-
index_str
String index_str
-
name
String name
-
not_null
boolean not_null
-
original_default_expression
Expression original_default_expression
-
primary_key
boolean primary_key
-
type
TType type
-
unique
boolean unique
-
-
Class com.mckoi.database.interpret.ConstraintDef
class ConstraintDef extends Object implements Serializable- serialVersionUID:
- -6648793780645431100L
-
Serialized Fields
-
check_expression
Expression check_expression
-
column_list
ArrayList column_list
-
column_list2
ArrayList column_list2
-
deferred
short deferred
-
delete_rule
String delete_rule
-
name
String name
-
original_check_expression
Expression original_check_expression
-
reference_table_name
String reference_table_name
-
type
int type
-
update_rule
String update_rule
-
-
Class com.mckoi.database.interpret.FromClause
class FromClause extends Object implements Serializable- serialVersionUID:
- 565726601314503609L
-
Serialized Fields
-
all_table_names
ArrayList all_table_names
A list of all table names in this from clause. -
def_list
ArrayList def_list
A list of all FromTableDef objects in this clause in order of when they were specified. -
join_set
JoiningSet join_set
The JoiningSet object that we have created to represent the joins 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
class FromTableDef extends 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, ....
-
subselect_table
TableSelectExpression subselect_table
The TableSelectExpression if this is a subquery table. -
table_alias
String table_alias
The alias of the table or null if no alias was defined. -
table_name
String table_name
The name of the table this definition references. -
unique_key
String unique_key
The unique key name given to this table definition.
-
-
Class com.mckoi.database.interpret.SearchExpression
class SearchExpression extends Object implements Serializable- serialVersionUID:
- 2888486150597671440L
-
Serialized Fields
-
search_expression
Expression search_expression
The originating expression.
-
-
Class com.mckoi.database.interpret.SelectColumn
class SelectColumn extends Object implements Serializable- serialVersionUID:
- 2507375247510606004L
-
Serialized Fields
-
alias
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. -
glob_name
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. -
internal_name
Variable internal_name
The name of this column used internally to reference it. -
resolved_name
Variable resolved_name
The fully resolved name that this column is given in the resulting table.
-
-
Class com.mckoi.database.interpret.TableSelectExpression
class TableSelectExpression extends Object implements Serializable- serialVersionUID:
- 6946017316981412561L
-
Serialized Fields
-
columns
ArrayList columns
The list of columns to select from. (SelectColumn) -
composite_function
int composite_function
If there is a composite function this is set to the composite enumeration from CompositeTable. -
distinct
boolean distinct
True if we only search for distinct elements. -
from_clause
FromClause from_clause
The from clause. -
group_by
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. -
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. -
where_clause
SearchExpression where_clause
The where clause.
-
-
-
Package com.mckoi.database.jdbc
-
Exception com.mckoi.database.jdbc.MSQLException
class MSQLException extends SQLException implements Serializable -
Class com.mckoi.database.jdbc.ResultPart
class ResultPart extends Vector implements Serializable -
Exception com.mckoi.database.jdbc.SQLLoginException
class SQLLoginException extends SQLException implements Serializable
-
-
Package com.mckoi.database.sql
-
Exception com.mckoi.database.sql.ParseException
class ParseException extends Exception implements Serializable-
Serialized Fields
-
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. -
eol
String eol
The end of line string for this machine. -
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. -
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). -
tokenImage
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.
-
-
-
Error com.mckoi.database.sql.TokenMgrError
class TokenMgrError extends 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
class ResultSetTableModel extends AbstractTableModel implements Serializable-
Serialized Fields
-
meta_data
ResultSetMetaData meta_data
The ResultSetMetaData object for this 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. -
result_set
ResultSet result_set
The scrollable ResultSet source. -
row_count
int row_count
The number of rows in the result set.
-
-
-
-
Package com.mckoi.tools
-
Class com.mckoi.tools.JDBCQueryTool
class JDBCQueryTool extends JComponent implements Serializable-
Serialized Fields
-
auto_resize_result_table
JCheckBoxMenuItem auto_resize_result_table
Set to true if the table is auto resize (default). -
query_agent
QueryAgent query_agent
The agent used to make queries on the JDBC connection. -
query_text_area
JTextArea query_text_area
The JTextArea where the query is entered. -
query_time
int query_time
The time it took to execute the query in milliseconds. -
result_table
JTable result_table
The JTable where the query result is printed. -
status_text
JLabel status_text
The JLabel status bar at the bottom of the window. -
table_model
ResultSetTableModel table_model
The ResultSetTableModel for the table model that contains our result set. -
total_row_count
int total_row_count
Total number of rows in the result.
-
-
-
-
Package com.mckoi.util
-
Class com.mckoi.util.BigNumber
class BigNumber extends Number implements Serializable- serialVersionUID:
- -8681578742639638105L
-
Serialized Fields
-
big_decimal
BigDecimal big_decimal
The BigDecimal representation. -
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. -
long_representation
long long_representation
A 'long' representation of this number. -
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.
-
-
Class com.mckoi.util.IntegerVector
class IntegerVector extends Object implements Serializable-
Serialized Fields
-
index
int index
The index of the last value of the array. -
list
int[] list
The int array.
-
-
-