A C D E F G H I L M O P R S T

A

addColumn(ColumnModel) - Method in class org.brains2b.sql.meta.ConstraintModel

add a ColumnModel as a part of this ConstraintModel

addColumn(ColumnModel) - Method in class org.brains2b.sql.meta.IndexModel

add a ColumnModel as a part of this IndexModel

C

CHECK - Static variable in class org.brains2b.sql.meta.ConstraintModel

constant for a check constraint

clone() - Method in interface org.brains2b.sql.Connector

clone the connector object, not copying the connection itself.

clone() - Method in class org.brains2b.sql.LocalConnector

clone the connector object, not copying the connection itself.

clone() - Method in class org.brains2b.sql.RemoteConnector

clone the connector object, not copying the connection itself.

clone() - Method in class org.brains2b.sql.SQLRecord

cloneDefinition() - Method in class org.brains2b.sql.SQLRecord

clone the definition of this record, but not the values set for any of the columns

close() - Method in interface org.brains2b.sql.Connector

close this connector and the contained connection

close() - Method in class org.brains2b.sql.LocalConnector

close this connector and the contained connection

close() - Method in class org.brains2b.sql.RemoteConnector

close this connector and the contained connection

ColumnModel - Class in org.brains2b.sql.meta

Wrapper around column definition from DatabaseMetaData

ColumnModel() - Constructor for class org.brains2b.sql.meta.ColumnModel

Constructor only used by ColumnDDL

ColumnModel(SQLRecord) - Constructor for class org.brains2b.sql.meta.ColumnModel

Create a ColumnModel on the basis of this SQLRecord

Connector - Interface in org.brains2b.sql

Interface to describe a connection to a JDBC source

ConstraintModel - Class in org.brains2b.sql.meta

Wrapper around the constraint definition from DatabaseMetaData

ConstraintModel() - Constructor for class org.brains2b.sql.meta.ConstraintModel

Constructor only used by ConstraintDDL

ConstraintModel(String, SQLRecord) - Constructor for class org.brains2b.sql.meta.ConstraintModel

Create a ConstriantModel of this specific type on the basis of the provided SQLRecord

createEmptyRecord(ResultSetMetaData) - Static method in class org.brains2b.sql.SQLRecord

automatically create a new SQLRecord structure from ResultSetMeta

createRecord(ResultSet) - Static method in class org.brains2b.sql.SQLRecord

automatically create a new SQLRecord from a ResultSet

D

DynamicClassLoader - Class in org.brains2b.loader

Loads classes dynamically from a directory or jar/zip file being passed in.

DynamicClassLoader() - Constructor for class org.brains2b.loader.DynamicClassLoader

E

encode(String) - Static method in class org.brains2b.sql.SQLHelper

encode a String so it can be inserted into an SQL database by replacing every quote with two quotes

equals(Object) - Method in class org.brains2b.sql.meta.ColumnModel

equals(Object) - Method in class org.brains2b.sql.meta.ConstraintModel

equals(Object) - Method in class org.brains2b.sql.meta.IndexModel

equals(Object) - Method in class org.brains2b.sql.meta.ProcedureModel

equals(Object) - Method in class org.brains2b.sql.meta.TableModel

equals(Object) - Method in class org.brains2b.sql.SQLRecord

determines if two objects are equal by comparing their hashCodes

F

findImplementation(Class, URL[]) - Static method in class org.brains2b.loader.DynamicClassLoader

find an implementation of an interface or class in the classpath supplied by the URLs

FOREIGN_KEY - Static variable in class org.brains2b.sql.meta.ConstraintModel

constant for a foreign key constraint

FUNCTION - Static variable in class org.brains2b.sql.meta.ProcedureModel

constant for a model defined as function

G

getBoolValue(String) - Method in class org.brains2b.sql.SQLRecord

get the boolean value belonging to the column identified by name

getBoolValue(int) - Method in class org.brains2b.sql.SQLRecord

get the value of the column at the given index as a boolean.

getCatalog() - Method in class org.brains2b.sql.meta.ProcedureModel

get the Catalog for this ProcedureModel

getCatalog() - Method in class org.brains2b.sql.meta.TableModel

get the Catalog for this TableModel

getCatalogs() - Method in class org.brains2b.sql.meta.SQLMetaData

get the catalog names which can be retrieved for this database

getColumn(int) - Method in class org.brains2b.sql.SQLRecord

get the column identifier for the column at the given index

getColumnCount() - Method in class org.brains2b.sql.SQLRecord

get the number of fields in this cursor data object

getColumns() - Method in class org.brains2b.sql.meta.ConstraintModel

get the Columns referenced by this constraint

getColumns() - Method in class org.brains2b.sql.meta.IndexModel

get the columns involved in this Index

getColumns() - Method in class org.brains2b.sql.meta.SelectDescriptor

get a comma-seperated list of columns for this select statement

getColumns(String, String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData

get a List of SqlColumModels for each colum that can be found for the parameters supplied.

getColumns() - Method in class org.brains2b.sql.meta.TableModel

get the columns for this Table

getColumnSize() - Method in class org.brains2b.sql.meta.ColumnModel

get the size of the column for non-numeric types or the precision for numeric types

getColumnType(String) - Method in class org.brains2b.sql.SQLRecord

get the column type for the column identified by name

getColumnType(int) - Method in class org.brains2b.sql.SQLRecord

get the column type for the column given by the specified index

getConnection() - Method in interface org.brains2b.sql.Connector

get the JDBC connection for this Connector

getConnection() - Method in class org.brains2b.sql.LocalConnector

get the JDBC connection for this Connector

getConnection() - Method in class org.brains2b.sql.meta.SQLMetaData

get the connection to the Database

getConnection() - Method in class org.brains2b.sql.RemoteConnector

get the JDBC connection for this Connector

getConstraints(String, String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData

get a List of Constraints (Primary | Foreign ) defined in this database for the given catalog,schema and pattern.

getDataType() - Method in class org.brains2b.sql.meta.ColumnModel

get the datatype as defined in java.sql.Type

getDataType() - Method in class org.brains2b.sql.meta.ParameterModel

get the datatype as defined in java.sql.Type

getDataType(Class) - Method in class org.brains2b.sql.meta.TypesInfo

get the java.sql.Types value for a given class

getDbName() - Method in class org.brains2b.sql.LocalConnector

get the database name this connection uses.

getDecimalDigits() - Method in class org.brains2b.sql.meta.ColumnModel

get the number of decimal places for a numeric field.

getDefault() - Method in class org.brains2b.sql.meta.ColumnModel

get the column default value

getDoubleValue(int) - Method in class org.brains2b.sql.SQLRecord

get the value of the column at the given index as a double.

getDoubleValue(String) - Method in class org.brains2b.sql.SQLRecord

get the double value belonging to the column identified by name

getFrom() - Method in class org.brains2b.sql.meta.SelectDescriptor

get a comma-seperated list of tables from the FROM-part of this select statement

getGroupBy() - Method in class org.brains2b.sql.meta.SelectDescriptor

get a comma-seperated list of columns from the GROUP BY-part of this select statement

getHaving() - Method in class org.brains2b.sql.meta.SelectDescriptor

get the HAVING clause of this select statement

getIndex(String) - Method in class org.brains2b.sql.SQLRecord

get the index of the column identified by name

getIndices(String, String, String, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData

get a list of Indices for the given parameters.

getIndices() - Method in class org.brains2b.sql.meta.TableModel

get the indices for this Table

getInputStream() - Method in interface org.brains2b.sql.meta.types.Stream

get the input stream

getIntValue(int) - Method in class org.brains2b.sql.SQLRecord

get the value of the column at the given index as an integer.

getIntValue(String) - Method in class org.brains2b.sql.SQLRecord

get the intValue belonging to the column identified by name

getJavaType(int, int, int) - Method in class org.brains2b.sql.meta.TypesInfo

gets a Class as a valid java type on the basis of JDBC column information

getJavaTypeName(int, int, int) - Method in class org.brains2b.sql.meta.TypesInfo

gets a String representation of a valid java type on the basis of JDBC column information

getLimitRows(int) - Method in class org.brains2b.sql.meta.TypesInfo

getLongValue(int) - Method in class org.brains2b.sql.SQLRecord

get the value of the column at the given index as a long.

getLongValue(String) - Method in class org.brains2b.sql.SQLRecord

get the longValue belonging to the column identified by name

getMetaData() - Method in class org.brains2b.sql.meta.SQLMetaData

get the DatabaseMetaData object associated with the connection used

getName() - Method in class org.brains2b.sql.meta.ColumnModel

get the name for this model's instance

getName() - Method in class org.brains2b.sql.meta.ConstraintModel

get the name for this model's instance

getName() - Method in class org.brains2b.sql.meta.IndexModel

get the name for this model's instance

getName() - Method in class org.brains2b.sql.meta.ParameterModel

get the name for this model's instance

getName() - Method in class org.brains2b.sql.meta.ProcedureModel

get the name for this model's instance

getName() - Method in interface org.brains2b.sql.meta.SQLMetaModel

get the name for this model's instance

getName() - Method in class org.brains2b.sql.meta.TableModel

get the name for this model's instance

getOrderBy() - Method in class org.brains2b.sql.meta.SelectDescriptor

get a comma-seperated list of columns from the ORDER BY-part of this select statement

getOutputStream() - Method in interface org.brains2b.sql.meta.types.Stream

get the output stream

getParameters() - Method in class org.brains2b.sql.meta.ProcedureModel

get the parameters for this ProcedureModel

getParameters(String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData

get the parameters belonging to the procedure

getParamType() - Method in class org.brains2b.sql.meta.ParameterModel

get the datatype as defined in java.sql.Type

getPrimaryKey() - Method in class org.brains2b.sql.meta.TableModel

get the primary key for this table in the form of a ConstraintModel of type ConstraintModel.PRIMARY_KEY

getProcedures(String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData

get a List of Procedures defined in this database without possible parameters for the given catalog,schema and pattern.

getProcedures(String, String, String, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData

get a List of Procedures defined in this database for the given catalog,schema and pattern.

getRecord() - Method in class org.brains2b.sql.meta.ColumnModel

the record which defines all the values for the model

getRecord() - Method in class org.brains2b.sql.meta.ConstraintModel

the record which defines all the values for the model

getRecord() - Method in class org.brains2b.sql.meta.IndexModel

the record which defines all the values for the model

getRecord() - Method in class org.brains2b.sql.meta.ParameterModel

the record which defines all the values for the model

getRecord() - Method in class org.brains2b.sql.meta.ProcedureModel

the record which defines all the values for the model

getRecord() - Method in interface org.brains2b.sql.meta.SQLMetaModel

the record which defines all the values for the model

getRecord() - Method in class org.brains2b.sql.meta.TableModel

the record which defines all the values for the model

getRemarks() - Method in class org.brains2b.sql.meta.ColumnModel

get optional remarks for a column

getRemarks() - Method in class org.brains2b.sql.meta.TableModel

get optional remarks for this table

getReturnValue() - Method in class org.brains2b.sql.meta.ProcedureModel

get the return value for this ProcedureModel

getSchema() - Method in class org.brains2b.sql.meta.ProcedureModel

get the Schema for this ProcedureModel

getSchema() - Method in class org.brains2b.sql.meta.TableModel

get the Schema for this TableModel

getSchemas() - Method in class org.brains2b.sql.meta.SQLMetaData

get the schema names which can be retrieved for this database

getSequence() - Method in class org.brains2b.sql.meta.ColumnModel

get the sequence of this column within the object it is contained in such as a TableModel, IndexModel or ConstraintModel

getServerName() - Method in class org.brains2b.sql.LocalConnector

get the name of the server this connection uses.

getSQLType(int) - Method in class org.brains2b.sql.meta.TypesInfo

getString(String) - Method in class org.brains2b.sql.SQLRecord

getString(int) - Method in class org.brains2b.sql.SQLRecord

getTableName() - Method in class org.brains2b.sql.meta.ColumnModel

get the table name

getTableName() - Method in class org.brains2b.sql.meta.ConstraintModel

get the table name for this Constraint

getTableName() - Method in class org.brains2b.sql.meta.IndexModel

get the table for this index

getTables(String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData

get a List of TableModel objects, without their columns dependant on the parameters supplied.

getTables(String, String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData

get a List of TableModel objects for a specific type, without their columns dependant on the parameters supplied.

getTablesWithColumns(String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData

get a List of TableModel objects, including their columns dependant on the parameters supplied.

getTableTypes() - Method in class org.brains2b.sql.meta.SQLMetaData

get the table types supported by the database

getType() - Method in class org.brains2b.sql.meta.ColumnModel

get the type of Object defined by the meta model

getType() - Method in class org.brains2b.sql.meta.ConstraintModel

get the type of Object defined by the meta model

getType() - Method in class org.brains2b.sql.meta.IndexModel

get the type of Object defined by the meta model

getType() - Method in class org.brains2b.sql.meta.ParameterModel

get the type of Object defined by the meta model

getType() - Method in class org.brains2b.sql.meta.ProcedureModel

get the type of Object defined by the meta model

getType() - Method in interface org.brains2b.sql.meta.SQLMetaModel

get the type of Object defined by the meta model

getType() - Method in class org.brains2b.sql.meta.TableModel

get the type of Object defined by the meta model

getTypeInfo() - Method in class org.brains2b.sql.meta.SQLMetaData

get a Types2Java object for transforming types between the database and Java

getTypeName() - Method in class org.brains2b.sql.meta.ColumnModel

get the type description for the column type

getTypeNames() - Method in class org.brains2b.sql.meta.TypesInfo

getTypes() - Method in class org.brains2b.sql.meta.TypesInfo

getUser() - Method in interface org.brains2b.sql.Connector

get the user which is connected to the database

getUser() - Method in class org.brains2b.sql.LocalConnector

Returns the name of the user this connection is using

getUser() - Method in class org.brains2b.sql.RemoteConnector

get the user which is connected to the database

getValue() - Method in class org.brains2b.sql.meta.ParameterModel

get the value for this parameter

getValue(int) - Method in class org.brains2b.sql.SQLRecord

get the value of the column at the given index as an Object

getValue(String) - Method in class org.brains2b.sql.SQLRecord

get the value of the column identified by name as an Object

getWhere() - Method in class org.brains2b.sql.meta.SelectDescriptor

get the WHERE clause of this select statement

H

hashCode() - Method in class org.brains2b.sql.SQLRecord

I

IndexModel - Class in org.brains2b.sql.meta

Wrapper around the index definition from DatabaseMetaData

IndexModel() - Constructor for class org.brains2b.sql.meta.IndexModel

Constructor only used by IndexDDL

IndexModel(SQLRecord) - Constructor for class org.brains2b.sql.meta.IndexModel

Create an IndexModel on the basis of this SQLRecord

init(String, String, String, String, String) - Method in class org.brains2b.sql.LocalConnector

Initializes the parameters needed to make a connection.

isAccessed() - Method in interface org.brains2b.sql.meta.types.Stream

check if the input or output was ever used to prevent unecessary reading and writing for streams that were never accessed.

isNullable() - Method in class org.brains2b.sql.meta.ColumnModel

get an indication if the field is nullable

isPrimitive(int) - Method in class org.brains2b.sql.meta.TypesInfo

get the JavaType for a specific dataType as defined in java.sql.Types

isReserved(String) - Static method in class org.brains2b.sql.meta.SQLKeyWords

check if a String is a Java reserved word/keyword

isUnique() - Method in class org.brains2b.sql.meta.IndexModel

check if this is an unique index

L

LARGE - Static variable in class org.brains2b.sql.meta.TypesInfo

limitIdentifier(String, int) - Static method in class org.brains2b.sql.SQLHelper

limit the identifier given by String to the length given.

loadClass(String, URL[]) - Static method in class org.brains2b.loader.DynamicClassLoader

load a specific class identified by it's fully qualified name from the passed URLs

loadClasses(URL[]) - Static method in class org.brains2b.loader.DynamicClassLoader

load all the classes from the classpath supplied by the URLs

LocalConnector - Class in org.brains2b.sql

Implementation of Connector to connect to a local JDBC source, defined by the parameters passed in the constructor

LocalConnector() - Constructor for class org.brains2b.sql.LocalConnector

Constructor which does not initialize the connection properties.

LocalConnector(String, String, String, String) - Constructor for class org.brains2b.sql.LocalConnector

Constructor

LocalConnector(String, String, String, String, String) - Constructor for class org.brains2b.sql.LocalConnector

Constructor

M

m_driver - Variable in class org.brains2b.sql.LocalConnector

m_info - Variable in class org.brains2b.sql.LocalConnector

m_url - Variable in class org.brains2b.sql.LocalConnector

O

OPTIMIZE - Static variable in class org.brains2b.sql.meta.TypesInfo

org.brains2b.loader - package org.brains2b.loader

org.brains2b.sql - package org.brains2b.sql

org.brains2b.sql.meta - package org.brains2b.sql.meta

org.brains2b.sql.meta.types - package org.brains2b.sql.meta.types

P

PACKAGE - Static variable in class org.brains2b.sql.meta.ProcedureModel

constant for a model defined as package

PACKAGE_BODY - Static variable in class org.brains2b.sql.meta.ProcedureModel

constant for a model defined as package body

ParameterModel - Class in org.brains2b.sql.meta

Wrapper around the parameter definition from DatabaseMetaData

ParameterModel(SQLRecord) - Constructor for class org.brains2b.sql.meta.ParameterModel

Create an ParameterModel on the basis of this SQLRecord

PRIMARY_KEY - Static variable in class org.brains2b.sql.meta.ConstraintModel

constant for a primary key constraint

PROCEDURE - Static variable in class org.brains2b.sql.meta.ProcedureModel

constant for a model defined as procedure

ProcedureModel - Class in org.brains2b.sql.meta

Wrapper around a procedure definition from DatabaseMetaData

ProcedureModel() - Constructor for class org.brains2b.sql.meta.ProcedureModel

Constructor only used by ProcedureDDL

ProcedureModel(SQLRecord) - Constructor for class org.brains2b.sql.meta.ProcedureModel

Create a ProcedureModel on the basis of this SQLRecord

R

RemoteConnector - Class in org.brains2b.sql

Implementation of Connector to connect to a remote JDBC source, given by a lookup name accessable through an InitialContext

RemoteConnector(String) - Constructor for class org.brains2b.sql.RemoteConnector

Constructor taking a lookupName for an InitialContext to create a connection to a database

S

SelectDescriptor - Class in org.brains2b.sql.meta

Describe a select statement in terms of the different keywords which makes it up

SelectDescriptor(String) - Constructor for class org.brains2b.sql.meta.SelectDescriptor

Create an SelectDescriptor on the basis of an select-statement

setColumn(int, String) - Method in class org.brains2b.sql.SQLRecord

set a column identified by name at the specified position

setColumn(int, String, Class, Object) - Method in class org.brains2b.sql.SQLRecord

convinience method to set the column name,class and value at once at a given index

setColumn(int, String, Class) - Method in class org.brains2b.sql.SQLRecord

convinience method to set the column name,class and value at once at a given index

setColumns(List) - Method in class org.brains2b.sql.meta.ConstraintModel

set the columns for this Model

setColumns(List) - Method in class org.brains2b.sql.meta.IndexModel

set the columns for this Model

setColumns(TableModel) - Method in class org.brains2b.sql.meta.SQLMetaData

set the columns for this table

setColumns(List) - Method in class org.brains2b.sql.meta.TableModel

set the columns for this TableModel

setColumnType(int, Class) - Method in class org.brains2b.sql.SQLRecord

set the Class identifying the type of content for this column by index.

setConnection(Connection) - Method in class org.brains2b.sql.meta.SQLMetaData

set the connection to the Database to use for the MetaData

setDataModel(int) - Method in class org.brains2b.sql.meta.TypesInfo

setIndices(TableModel, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData

set the Indexes for this table

setIndices(List) - Method in class org.brains2b.sql.meta.TableModel

set the indices for this Model

setParameters(List) - Method in class org.brains2b.sql.meta.ProcedureModel

set the parameters for this ProcedureModel

setParameters(ProcedureModel) - Method in class org.brains2b.sql.meta.SQLMetaData

set the parameters for this procedure

setPrimaryKey(TableModel) - Method in class org.brains2b.sql.meta.SQLMetaData

set the primary key belonging to a table

setPrimaryKey(TableModel, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData

set the primary key belonging to a table

setPrimaryKey(ConstraintModel) - Method in class org.brains2b.sql.meta.TableModel

set the primary key for this table

setRecord(SQLRecord) - Method in class org.brains2b.sql.meta.ColumnModel

set the record for this Model

setRecord(SQLRecord) - Method in class org.brains2b.sql.meta.ConstraintModel

set the record for this Model

setRecord(SQLRecord) - Method in class org.brains2b.sql.meta.IndexModel

set the record for this Model

setRecord(SQLRecord) - Method in class org.brains2b.sql.meta.TableModel

set the record for this Model

setReturnValue(ParameterModel) - Method in class org.brains2b.sql.meta.ProcedureModel

set the return value for this ProcedureModel

setValue(Object) - Method in class org.brains2b.sql.meta.ParameterModel

set the value for this parameter

setValue(int, Object) - Method in class org.brains2b.sql.SQLRecord

set the content value for the specified index

setValue(String, Object) - Method in class org.brains2b.sql.SQLRecord

set the content value for the column identified by name

SMALLEST - Static variable in class org.brains2b.sql.meta.TypesInfo

SQLHelper - Class in org.brains2b.sql

[Short description] [Long description]

SQLHelper() - Constructor for class org.brains2b.sql.SQLHelper

SQLKeyWords - Class in org.brains2b.sql.meta

Class that implements one single static function isReserved which checks if a String is a SQL reserved word.

SQLMetaData - Class in org.brains2b.sql.meta

Main DatabaseMetaData class for describing database, table and column properties on the basis of a supplied connection

SQLMetaData() - Constructor for class org.brains2b.sql.meta.SQLMetaData

Default Constructor

SQLMetaData(Connection) - Constructor for class org.brains2b.sql.meta.SQLMetaData

Constructor for SqlMetadata

SQLMetaModel - Interface in org.brains2b.sql.meta

Interface that defines general information for the wrapper of the database meta models on the basis of SQLRecord

SQLRecord - Class in org.brains2b.sql

Object for containing results from a Select statement

SQLRecord() - Constructor for class org.brains2b.sql.SQLRecord

Constructor for SQLRecord.

SQLRecord(int) - Constructor for class org.brains2b.sql.SQLRecord

Constructor for SQLRecord.

Stream - Interface in org.brains2b.sql.meta.types

Simple interface that defines a data-type as stream and supplies both an output as input stream for the datatype.

stripQuotes(String) - Static method in class org.brains2b.sql.SQLHelper

strip quotes from the beginning and end of a String from an SQL database

T

TableModel - Class in org.brains2b.sql.meta

Wrapper around table definition from DatabaseMetaData

TableModel() - Constructor for class org.brains2b.sql.meta.TableModel

Constructor only used by TableDDL

TableModel(SQLRecord) - Constructor for class org.brains2b.sql.meta.TableModel

Create a TableModel on the basis of this SQLRecord

toString() - Method in class org.brains2b.sql.meta.ColumnModel

a String representation of this column as tablename.name

toString() - Method in class org.brains2b.sql.meta.SelectDescriptor

get the complete statement equals to the select statement which was passed in

TypesInfo - Class in org.brains2b.sql.meta

Types to Java Static class to translate java.sql.Types into appropriate Java types At the moment only primitives, String and java.sql.Date,Time,Timestamp are used

TypesInfo(Connection) - Constructor for class org.brains2b.sql.meta.TypesInfo

A C D E F G H I L M O P R S T