A B C D E F G H I K L M N O P Q R S T U W

A

ACTIVITY_CHECK_INTERVAL - Static variable in class sqlg2.db.LocalConnectionFactory

Client activity check interval.

add(QueryPiece...) - Method in class sqlg2.db.QueryPiece

Concatenation of query pieces.

add(String) - Method in class sqlg2.db.QueryPiece

Concatenation of query piece and string.

ALL_KEYS - Static variable in class sqlg2.GBase

Use it for autoKeys parameter of GBase.prepareStatementKey(String[], String) to retrieve all generated columns.

allocConnection(boolean) - Method in interface sqlg2.db.ConnectionManager

Connection allocation.

allocConnection(boolean) - Method in class sqlg2.db.SingleConnectionManager

append(QueryPiece) - Method in class sqlg2.db.QueryBuilder

Appends query piece.

append(QueryBuilder) - Method in class sqlg2.db.QueryBuilder

Appends query builder.

append(String) - Method in class sqlg2.db.QueryBuilder

Appends string query piece.

appendLit(QueryPiece) - Method in class sqlg2.db.QueryBuilder

Appends query piece.

appendLit(String) - Method in class sqlg2.db.QueryBuilder

Appends string query piece.

appendLit(Number) - Method in class sqlg2.db.QueryBuilder

Appends numeric query piece.

AUTH_BAD_APP - Static variable in interface sqlg2.db.IConnectionFactory

Error message (Throwable.getMessage()) for "No access to chosen application"

AUTH_BAD_PASS - Static variable in interface sqlg2.db.IConnectionFactory

Error message (Throwable.getMessage()) for "Bad password"

AUTH_BAD_USER - Static variable in interface sqlg2.db.IConnectionFactory

Error message (Throwable.getMessage()) for "Bad username"

AUTH_FAILED - Static variable in interface sqlg2.db.IConnectionFactory

Error message (Throwable.getMessage()) for "Authentication failed (for unknown reason)"

authenticate(Connection, String, String) - Method in interface sqlg2.db.AuthenticationHelper

Authentication

authenticate(Connection, String, String) - Method in class sqlg2.db.DBAuthenticationImpl

Returns a String - user login.

AuthenticationHelper - Interface in sqlg2.db

Is used for client's connecting to DB.

B

background - Variable in class sqlg2.db.SessionInfo

true for background process.

Business - Annotation Type in sqlg2

Annotation for methods marking that given method is a business method and should be present at data access interface.

BusinessNoSql - Annotation Type in sqlg2

Annotation for methods marking that given method is a business method and should be present at data access interface.

C

Call - Annotation Type in sqlg2

Annotation for local variables marking that CallableStatement call should be generated.

callStoredBlock(String, Object...) - Method in class sqlg2.GBase

Executes PL/SQL block.

callStoredProc(String, Object...) - Method in class sqlg2.GBase

Calls stored procedure.

callStoredProc(String, boolean, Object...) - Method in class sqlg2.GBase

Executes stored procedure or PL/SQL block (depending of block parameter).

checkSequenceExists(Connection, String) - Method in interface sqlg2.checker.SqlChecker

Checks whether sequence generator exists in database.

checkSql(Connection, String) - Method in interface sqlg2.checker.SqlChecker

Checks SQL statement syntax.

checkStatement(PreparedStatement) - Method in interface sqlg2.checker.SqlChecker

Checks SQL statement syntax.

classes - Variable in class sqlg2.db.QueryPiece

close() - Method in class sqlg2.db.client.SafeDBInterface

close() - Method in interface sqlg2.db.ConnectionManager

Closing all connections and releasing all resources.

close() - Method in class sqlg2.db.DBInterface

close() - Method in class sqlg2.db.Debug

Releases all resources (open files etc).

close() - Method in interface sqlg2.db.IDBInterface

Closes DB connection.

close() - Method in class sqlg2.db.SimpleDebug

close() - Method in class sqlg2.db.SingleConnectionManager

close() - Method in class sqlg2.db.TraceDebug

close(Statement) - Method in class sqlg2.GBase

Closes statement.

close(ResultSet, Statement) - Method in class sqlg2.GBase

Closes result set and statement.

closeStatements() - Method in class sqlg2.GBase

Closes all open statements (usually this method is called by wrappers automatically).

cls - Variable in class sqlg2.db.TypedList

ColumnInfo - Class in sqlg2

Description of DB-to-Java mapping for one column of a result set.

ColumnInfo(Class<?>, String, String, boolean) - Constructor for class sqlg2.ColumnInfo

Constructor.

columnOf(Class<T>, PreparedStatement) - Method in class sqlg2.GBase

Executes select query returning single column of T.

columnOfDouble(PreparedStatement) - Method in class sqlg2.GBase

Executes select query returning single column of double.

columnOfInt(PreparedStatement) - Method in class sqlg2.GBase

Executes select query returning single column of int.

columnOfLong(PreparedStatement) - Method in class sqlg2.GBase

Executes select query returning single column of long.

columnOfObject(PreparedStatement) - Method in class sqlg2.GBase

Executes select query returning single column of Object.

columnOfString(PreparedStatement) - Method in class sqlg2.GBase

Executes select query returning single column of String.

commit() - Method in interface sqlg2.db.ITransaction

Commits transaction.

commit() - Method in class sqlg2.db.Transaction

commit() - Method in class sqlg2.db.TransactionRunnable

Commits transaction

commitImmediate() - Method in class sqlg2.db.FakeInternalTransaction

commitImmediate() - Method in interface sqlg2.db.InternalTransaction

ConnectionFactory - Class in sqlg2.db

RMI wrapper for IConnectionFactory.

ConnectionFactory(AuthenticationHelper, DBSpecific) - Constructor for class sqlg2.db.ConnectionFactory

Constructor of the root object for RMI.

ConnectionManager - Interface in sqlg2.db

Connection pool interface.

create(int, Object) - Static method in class sqlg2.db.OutParameter

createProcess(IDBInterface) - Method in interface sqlg2.db.ProcessFactory

Creates background process.

createQueryPiece(String) - Static method in class sqlg2.GBase

Creates piece of SQL query consisting only of text.

createQueryPiece(QueryPiece) - Static method in class sqlg2.GBase

This is for preprocessor-generated QueryPieces (see Query).

createQueryPiece(String, Object[], Class<?>[]) - Static method in class sqlg2.GBase

This is for preprocessor-generated QueryPieces (see Query).

createQueryPiece(String, Object[], String) - Static method in class sqlg2.GBase

This is for preprocessor-generated QueryPieces (see Query).

createResultSet(int, Object) - Static method in class sqlg2.db.OutParameter

createStatement() - Method in class sqlg2.GBase

Creates Statement.

D

data - Variable in class sqlg2.db.GBlob

Always not null.

data - Variable in class sqlg2.db.GClob

Always not null.

data - Variable in class sqlg2.db.QueryPiece

DBAuthenticationImpl - Class in sqlg2.db

Example of AuthenticationHelper implementation for authentication on DB level.

DBAuthenticationImpl(String, String, Properties) - Constructor for class sqlg2.db.DBAuthenticationImpl

Constructor.

DBAuthenticationImpl(String, String) - Constructor for class sqlg2.db.DBAuthenticationImpl

DBCommon - Class in sqlg2.db

RMI wrapper for IDBCommon.

DBCommon(InternalTransaction) - Constructor for class sqlg2.db.DBCommon

DBCommon(LocalWrapperBase) - Constructor for class sqlg2.db.DBCommon

DBInterface - Class in sqlg2.db

RMI wrapper for IDBInterface.

DBInterface(LocalDBInterface) - Constructor for class sqlg2.db.DBInterface

DBSpecific - Interface in sqlg2.db

Database-specific operations interface.

Debug - Class in sqlg2.db

Debug output.

Debug() - Constructor for class sqlg2.db.Debug

DEFAULT_TRACE - Static variable in class sqlg2.db.LocalConnectionFactory

dispatch(String, ObjectInputStream, ObjectOutputStream) - Method in class sqlg2.db.HttpDispatcher

Dispatch of HTTP PUT request.

doError(String) - Method in class sqlg2.db.Debug

Outputs error message.

doError(String) - Method in class sqlg2.db.SimpleDebug

doError(String) - Method in class sqlg2.db.TraceDebug

doGetWriter() - Method in class sqlg2.db.Debug

doGetWriter() - Method in class sqlg2.db.SimpleDebug

doGetWriter() - Method in class sqlg2.db.TraceDebug

doPrintStackTrace(Throwable) - Method in class sqlg2.db.Debug

Outputs error stacktrace.

doPrintStackTrace(Throwable) - Method in class sqlg2.db.SimpleDebug

doPrintStackTrace(Throwable) - Method in class sqlg2.db.TraceDebug

doTrace(String) - Method in class sqlg2.db.Debug

Outputs debug trace.

doTrace(String) - Method in class sqlg2.db.SimpleDebug

doTrace(String) - Method in class sqlg2.db.TraceDebug

driver - Variable in class sqlg2.db.DBAuthenticationImpl

DRIVER_NOT_FOUND - Static variable in interface sqlg2.db.IConnectionFactory

Error message (Throwable.getMessage()) for "JDBC driver not found"

E

EditableRowType - Annotation Type in sqlg2

Annotation marking that preprocessor should also generate setter methods for annotated class (see also RowType).

endCall(CallableStatement) - Method in class sqlg2.GBase

Closes CallableStatement.

endTransaction(boolean) - Method in class sqlg2.LocalWrapperBase

Transaction finish.

err - Static variable in class sqlg2.db.Debug

error(String) - Static method in class sqlg2.db.Debug

Outputs error message.

executeCall(QueryPiece) - Method in class sqlg2.GBase

Executes PL/SQL block constructed from pieces.

executeCall(String, Object[], Class<?>[]) - Method in class sqlg2.GBase

This is for preprocessor-generated CallableStatements.

executeCall(String, Object[], String) - Method in class sqlg2.GBase

This is for preprocessor-generated CallableStatements.

executeCall(String, Object...) - Method in class sqlg2.GBase

Executes CallableStatement.

executeCall(CallableStatement) - Method in class sqlg2.GBase

Executes stored procedure or PL/SQL block.

executeSql(String) - Method in class sqlg2.GBase

Executes SQL statement.

executeUpdate(PreparedStatement) - Method in class sqlg2.GBase

Executes update/delete/insert SQL statement.

executeUpdate(PreparedStatement, boolean) - Method in class sqlg2.GBase

Same as GBase.executeUpdate(java.sql.PreparedStatement) but closes statement when reuse=false.

F

FakeInternalTransaction - Class in sqlg2.db

This class can be used to call SQLG code from JDBC code.

FakeInternalTransaction(Connection, DBSpecific) - Constructor for class sqlg2.db.FakeInternalTransaction

FakeInternalTransaction(Connection, DBSpecific, SqlTrace) - Constructor for class sqlg2.db.FakeInternalTransaction

finalize() - Method in class sqlg2.db.TraceDebug

freeBlob(Connection, Blob) - Method in interface sqlg2.db.DBSpecific

Frees BLOB data after return from stored procedure.

freeBlob(Connection, Blob) - Method in class sqlg2.db.NoDBSpecific

freeBlob(Connection, Blob) - Method in class sqlg2.db.OracleDBSpecific

freeClob(Connection, Clob) - Method in interface sqlg2.db.DBSpecific

Frees CLOB data after return from stored procedure.

freeClob(Connection, Clob) - Method in class sqlg2.db.NoDBSpecific

freeClob(Connection, Clob) - Method in class sqlg2.db.OracleDBSpecific

G

GBase - Class in sqlg2

Base class for all classes which are processed by preprocessor.

GBase(LocalWrapperBase) - Constructor for class sqlg2.GBase

Constructor.

GBlob - Class in sqlg2.db

BLOB values are mapped to this class by default implementation of Mapper

GBlob(byte[]) - Constructor for class sqlg2.db.GBlob

GClob - Class in sqlg2.db

CLOB values are mapped to this class by default implementation of Mapper

GClob(String) - Constructor for class sqlg2.db.GClob

get(K) - Method in class sqlg2.db.client.SoftCache

getActiveSessions() - Method in class sqlg2.db.client.HttpConnectionFactory

getActiveSessions() - Method in class sqlg2.db.client.SafeDBInterface

getActiveSessions() - Method in class sqlg2.db.ConnectionFactory

getActiveSessions() - Method in class sqlg2.db.DBInterface

getActiveSessions() - Method in interface sqlg2.db.IConnectionFactory

Returns active sessions descriptors

getActiveSessions() - Method in interface sqlg2.db.IDBInterface

Returns active sessions descriptors.

getActiveSessions() - Method in class sqlg2.db.LocalConnectionFactory

getBigDecimal(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as BigDecimal.

getBlobOutputStream(Blob) - Method in interface sqlg2.db.DBSpecific

Retrieves stream to write BLOB contents

getBlobOutputStream(Blob) - Method in class sqlg2.db.NoDBSpecific

getBlobOutputStream(Blob) - Method in class sqlg2.db.OracleDBSpecific

getBytes(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as byte[].

getCheckerClass() - Method in interface sqlg2.db.DBSpecific

Returns checker of SQL statements for this DB.

getCheckerClass() - Method in class sqlg2.db.NoDBSpecific

getCheckerClass() - Method in class sqlg2.db.OracleDBSpecific

getClassName(Class<?>, String[]) - Method in interface sqlg2.Mapper

Converts class to its name regarding import lists.

getClobWriter(Clob) - Method in interface sqlg2.db.DBSpecific

Retrieves stream to write CLOB contents

getClobWriter(Clob) - Method in class sqlg2.db.NoDBSpecific

getClobWriter(Clob) - Method in class sqlg2.db.OracleDBSpecific

getConnection() - Method in class sqlg2.db.FakeInternalTransaction

getConnection() - Method in interface sqlg2.db.InternalTransaction

getConnectionManager(String, String) - Method in interface sqlg2.db.AuthenticationHelper

DB connection pool creation.

getConnectionManager(String, String) - Method in class sqlg2.db.DBAuthenticationImpl

getCurrentSchema(DatabaseMetaData) - Method in interface sqlg2.checker.SqlChecker

Returns current schema name (for stored proc search).

getCurrentSession() - Method in class sqlg2.db.client.SafeDBInterface

getCurrentSession() - Method in class sqlg2.db.DBInterface

getCurrentSession() - Method in interface sqlg2.db.IDBInterface

Returns calling session descriptor

getDate(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as Date.

getDateColumnClass(int) - Method in interface sqlg2.checker.SqlChecker

Determines which Java Date subclass to use for given Types type code.

getDateSqlType(Class<? extends Date>) - Method in interface sqlg2.checker.SqlChecker

Determines which of SQL date types to use for given Java Date subclass - Types.DATE, Types.TIME or Types.TIMESTAMP.

getDateSqlType(Class<? extends Date>) - Method in interface sqlg2.db.DBSpecific

Determines which of SQL date types to use for given Java Date subclass - Types.DATE, Types.TIME or Types.TIMESTAMP.

getDateSqlType(Class<? extends Date>) - Method in class sqlg2.db.NoDBSpecific

getDateSqlType(Class<? extends Date>) - Method in class sqlg2.db.OracleDBSpecific

getDateSqlTypeStatic(Class<? extends Date>) - Static method in class sqlg2.db.NoDBSpecific

getDateSqlTypeStatic(Class<? extends Date>) - Static method in class sqlg2.db.OracleDBSpecific

getDebug() - Static method in class sqlg2.db.Debug

getDouble(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as Double.

getFields(ResultSetMetaData, String, String, SqlChecker) - Method in interface sqlg2.Mapper

Retrieves column info from ResultSet.

getGeneratedKeys(PreparedStatement) - Method in class sqlg2.GBase

Returns array of auto-generated keys for insert/update statement.

getImplMap() - Method in class sqlg2.db.FakeInternalTransaction

getImplMap() - Method in interface sqlg2.db.InternalTransaction

getInlineInterface(Class<T>) - Method in class sqlg2.db.ImplMapper

Returns local business interface implementation for current transaction

getInput() - Method in class sqlg2.db.OutParameter

getInt(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as Integer.

getInterface(Class<T>) - Method in interface sqlg2.db.ISimpleTransaction

Returns data access interface generated by preprocessor.

getInterface(Class<T>) - Method in interface sqlg2.db.ITransaction

getInterface(Class<T>) - Method in class sqlg2.db.SimpleTransaction

getInterface(Class<T>) - Method in class sqlg2.db.Transaction

getInterface(Class<T>) - Method in class sqlg2.db.TransactionRunnable

Returns data access interface generated by preprocessor running in the transaction.

getInterface(Class<T>) - Method in class sqlg2.GBase

Returns data access interface generated by preprocessor.

getJdbcConnection() - Method in class sqlg2.GBase

Access to raw JDBC connection.

getLong(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as Long.

getMethodMap() - Method in class sqlg2.db.FakeInternalTransaction

getMethodMap() - Method in interface sqlg2.db.InternalTransaction

getNextId(Connection, String) - Method in interface sqlg2.db.DBSpecific

Gets next number from sequence

getNextId(Connection, String) - Method in class sqlg2.db.NoDBSpecific

getNextId(Connection, String) - Method in class sqlg2.db.OracleDBSpecific

getNextId(String) - Method in class sqlg2.GBase

Returns next number in sequence.

getNextSeqSql(String) - Static method in class sqlg2.db.OracleDBSpecific

getObject(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as Object.

getOutput() - Method in class sqlg2.db.OutParameter

getRemoteMap(ImplMode) - Method in class sqlg2.db.FakeInternalTransaction

getRemoteMap(ImplMode) - Method in interface sqlg2.db.InternalTransaction

getResultSetType() - Method in interface sqlg2.db.DBSpecific

Returns type code to use for CallableStatement.registerOutParameter(int, int) for cursor OUT parameters.

getResultSetType() - Method in class sqlg2.db.NoDBSpecific

getResultSetType() - Method in class sqlg2.db.OracleDBSpecific

getServerDate(Connection) - Method in interface sqlg2.db.DBSpecific

Returns DB server local time.

getServerDate(Connection) - Method in class sqlg2.db.NoDBSpecific

getServerDate(Connection) - Method in class sqlg2.db.OracleDBSpecific

getSimpleTransaction() - Method in class sqlg2.db.client.SafeDBInterface

getSimpleTransaction() - Method in class sqlg2.db.DBInterface

getSimpleTransaction() - Method in interface sqlg2.db.IDBInterface

Creates "simple" transaction.

getSpecific() - Method in class sqlg2.db.FakeInternalTransaction

getSpecific() - Method in interface sqlg2.db.InternalTransaction

getSqlTrace() - Method in class sqlg2.db.FakeInternalTransaction

getSqlTrace() - Method in interface sqlg2.db.InternalTransaction

getString(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as String.

getTestObject(Class<?>, SqlChecker) - Method in interface sqlg2.Mapper

Creates test object used as a parameter for business method during preprocess.

getTime() - Method in class sqlg2.db.DBCommon

getTime() - Method in interface sqlg2.db.IDBCommon

Returns DB server local time.

getTime() - Method in interface sqlg2.db.LIDBCommon

getTime(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as Time.

getTime() - Method in class sqlg2.LocalWrapperBase

getTimestamp(CallableStatement, int) - Static method in class sqlg2.GBase

Returns OUT parameter of stored procedure with index i (from 1) as Timestamp.

getTraceMessage(boolean, long) - Method in interface sqlg2.db.SqlTrace

getTransaction() - Method in class sqlg2.db.client.SafeDBInterface

getTransaction() - Method in class sqlg2.db.DBInterface

getTransaction() - Method in interface sqlg2.db.IDBInterface

Creates transaction.

getType() - Method in class sqlg2.db.OutParameter

getUrl() - Method in class sqlg2.db.client.HttpConnectionFactory

getUserHost() - Method in class sqlg2.db.client.SafeDBInterface

getUserHost() - Method in class sqlg2.db.DBInterface

getUserHost() - Method in interface sqlg2.db.IDBInterface

User host name.

getUserLogin() - Method in class sqlg2.db.client.SafeDBInterface

getUserLogin() - Method in class sqlg2.db.DBInterface

getUserLogin() - Method in interface sqlg2.db.IDBInterface

Returns user login (which was passed to IConnectionFactory.openConnection(java.lang.String, java.lang.String)).

getUserObject() - Method in class sqlg2.db.client.SafeDBInterface

getUserObject() - Method in class sqlg2.db.DBInterface

getUserObject() - Method in interface sqlg2.db.IDBInterface

Returns user identifier object which was returned from AuthenticationHelper.authenticate(java.sql.Connection,String,String) (null in case of direct authentication).

getWrapperNameFromInterface(Class<? extends IDBCommon>, ImplMode) - Static method in class sqlg2.LocalWrapperBase

Returns implementation class name for data access interface of given type.

getWriter() - Static method in class sqlg2.db.Debug

H

host - Variable in class sqlg2.db.SessionInfo

User host name (null for local connection).

HttpConnectionFactory - Class in sqlg2.db.client

HttpConnectionFactory(String, Proxy, String) - Constructor for class sqlg2.db.client.HttpConnectionFactory

HttpDispatcher - Class in sqlg2.db

Server-side object for HTTP access to business interfaces.

HttpDispatcher(String, AuthenticationHelper, DBSpecific) - Constructor for class sqlg2.db.HttpDispatcher

I

IConnectionFactory - Interface in sqlg2.db

Root interface for DB objects hierarchy - all other objects are produced by IConnectionFactory.

IDBCommon - Interface in sqlg2.db

Common DB interface accessible for all applications.

IDBInterface - Interface in sqlg2.db

Main DB interface class - DB connection abstraction.

ImplMapper - Class in sqlg2.db

Retrieves business interface implementation.

ImplMapper(InternalTransaction) - Constructor for class sqlg2.db.ImplMapper

InformationException - Exception in sqlg2.db

This is "informational" exception.

InformationException() - Constructor for exception sqlg2.db.InformationException

InformationException(String) - Constructor for exception sqlg2.db.InformationException

InternalTransaction - Interface in sqlg2.db

For internal use.

isError() - Method in exception sqlg2.db.InformationException

Defaults to true.

ISimpleTransaction - Interface in sqlg2.db

"Simple" transaction.

isResultSet() - Method in class sqlg2.db.OutParameter

isTesting() - Static method in class sqlg2.GBase

Returns true if method is called at preprocessing time (false at application run time).

ITransaction - Interface in sqlg2.db

Adds transaction control methods to ISimpleTransaction - ITransaction.commit() and ITransaction.rollback().

K

killSession(long) - Method in class sqlg2.db.client.SafeDBInterface

killSession(long) - Method in class sqlg2.db.DBInterface

killSession(long) - Method in interface sqlg2.db.IDBInterface

L

length() - Method in class sqlg2.db.GClob

LIDBCommon - Interface in sqlg2.db

Base interface for locally-accessible business interfaces (with SQLG.inline() = true).

list - Variable in class sqlg2.db.TypedList

loadDriver() - Method in class sqlg2.db.DBAuthenticationImpl

LocalConnectionFactory - Class in sqlg2.db

IConnectionFactory implementation for local connection.

LocalConnectionFactory(AuthenticationHelper, DBSpecific) - Constructor for class sqlg2.db.LocalConnectionFactory

Constructor.

LocalWrapperBase - Class in sqlg2

For internal use.

LocalWrapperBase(InternalTransaction, boolean) - Constructor for class sqlg2.LocalWrapperBase

Constructor.

M

MappedType - Interface in sqlg2.db

Interface to be implemented by custom-mapped classes.

Mapper - Interface in sqlg2

Preprocessor mapper interface.

metaRowQuery(PreparedStatement, Class<T>) - Method in class sqlg2.GBase

Returns result set metadata as RowType object.

migrateTo(IConnectionFactory) - Method in class sqlg2.db.client.SafeDBInterface

migrateTo(IConnectionFactory) - Method in class sqlg2.db.DBInterface

migrateTo(IConnectionFactory) - Method in interface sqlg2.db.IDBInterface

Opens new DB connection to another application with same login and password.

multiRowQuery(PreparedStatement, Class<T>) - Method in class sqlg2.GBase

Executes select query returning multiple (zero or more) rows.

N

newLocalOracleInstance(String, String) - Static method in class sqlg2.db.LocalConnectionFactory

newRow(Class<T>) - Method in class sqlg2.GBase

Create row instance by row type class; class should have EditableRowType annotation.

NoDBSpecific - Class in sqlg2.db

DBSpecific implementation for generic JDBC database.

NoDBSpecific() - Constructor for class sqlg2.db.NoDBSpecific

NullSetter - Interface in sqlg2.db

Interface which is used when custom-mapped parameters have null value.

O

openConnection(String, String) - Method in class sqlg2.db.client.HttpConnectionFactory

openConnection(IDBInterface, String) - Method in class sqlg2.db.client.HttpConnectionFactory

openConnection(String, String) - Method in class sqlg2.db.ConnectionFactory

openConnection(IDBInterface, String) - Method in class sqlg2.db.ConnectionFactory

openConnection(String, String) - Method in interface sqlg2.db.IConnectionFactory

Connecting to DB using external authentication (server must support that) - connection properties are taken from AuthenticationHelper.

openConnection(IDBInterface, String) - Method in interface sqlg2.db.IConnectionFactory

This method is rarely used directly, it is intended for use by IDBInterface.migrateTo(IConnectionFactory).

openConnection(String, String) - Method in class sqlg2.db.LocalConnectionFactory

openConnection(IDBInterface, String) - Method in class sqlg2.db.LocalConnectionFactory

optionalRowQuery(PreparedStatement, Class<T>) - Method in class sqlg2.GBase

Same as GBase.singleRowQuery(java.sql.PreparedStatement, Class) but returns null when no rows found.

optionalRowQueryReturning(Class<T>, PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturning(Class, java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningBigDecimal(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningBigDecimal(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningBlob(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningBlob(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningBytes(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningBytes(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningClob(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningClob(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningDate(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningDate(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningDouble(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningDouble(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningInt(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningInt(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningLong(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningLong(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningObject(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningObject(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningString(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningString(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningTime(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningTime(java.sql.PreparedStatement) but returns null when no rows found.

optionalRowQueryReturningTimestamp(PreparedStatement) - Method in class sqlg2.GBase

Same as GBase.singleRowQueryReturningTimestamp(java.sql.PreparedStatement) but returns null when no rows found.

OracleDBSpecific - Class in sqlg2.db

DBSpecific implementation for Oracle.

OracleDBSpecific() - Constructor for class sqlg2.db.OracleDBSpecific

out - Static variable in class sqlg2.db.Debug

out(Object) - Method in class sqlg2.GBase

This is for preprocessor-generated CallableStatements.

OutParameter - Class in sqlg2.db

OUT or IN/OUT parameter for stored proc or PL/SQL block.

OutParameter(int, Object) - Constructor for class sqlg2.db.OutParameter

Constructor.

OutParameter(int) - Constructor for class sqlg2.db.OutParameter

Constructor.

outResultSet(Class<T>) - Static method in class sqlg2.GBase

Creates OUT parameter for cursor parameters.

P

ping() - Method in class sqlg2.db.client.SafeDBInterface

ping() - Method in class sqlg2.db.DBInterface

ping() - Method in interface sqlg2.db.IDBInterface

Checks server for availability and signal that client is alive.

Prepare - Annotation Type in sqlg2

Annotation for local variables marking PreparedStatement to be generated.

prepareCall(String) - Method in class sqlg2.GBase

Creates CallableStatement for stored procedure (or PL/SQL block) call.

PrepareKey - Annotation Type in sqlg2

Annotation for local variables marking PreparedStatement to be generated.

prepareStatement(String) - Method in class sqlg2.GBase

Creates PreparedStatement for further execution.

prepareStatement(String, Object[], Class<?>[]) - Method in class sqlg2.GBase

This is for preprocessor-generated PreparedStatements (see Prepare).

prepareStatement(QueryPiece) - Method in class sqlg2.GBase

Creates PreparedStatement for further execution.

prepareStatement(String, Object[], String) - Method in class sqlg2.GBase

This is for preprocessor-generated PreparedStatements (see Prepare).

prepareStatement(String, Object...) - Method in class sqlg2.GBase

Creates PreparedStatement for further execution.

prepareStatementKey(String[], String) - Method in class sqlg2.GBase

Creates PreparedStatement with auto-generated keys for further execution.

prepareStatementKey(String[], String, Object[], Class<?>[]) - Method in class sqlg2.GBase

This is for preprocessor-generated PreparedStatements with auto-generated keys (see PrepareKey).

prepareStatementKey(String[], QueryPiece) - Method in class sqlg2.GBase

Creates PreparedStatement with auto-generated keys for further execution.

prepareStatementKey(String[], String, Object[], String) - Method in class sqlg2.GBase

This is for preprocessor-generated PreparedStatements with auto-generated keys (see PrepareKey).

prepareStatementKey(String[], String, Object...) - Method in class sqlg2.GBase

Creates PreparedStatement with auto-generated keys for further execution.

printStackTrace(Throwable) - Static method in class sqlg2.db.Debug

Outputs error stacktrace.

printStackTrace(Throwable) - Method in class sqlg2.db.FakeInternalTransaction

printStackTrace(Throwable) - Method in interface sqlg2.db.InternalTransaction

printStackTrace(Throwable) - Method in class sqlg2.LocalWrapperBase

Error trace.

ProcessFactory - Interface in sqlg2.db

Factory for background processes.

props - Variable in class sqlg2.db.DBAuthenticationImpl

put(K, V) - Method in class sqlg2.db.client.SoftCache

Q

Query - Annotation Type in sqlg2

Annotation for local variables marking QueryPiece to be generated.

QueryBuilder - Class in sqlg2.db

Query builder (used to concatenate multiple QueryPieces effectively, just as StringBuilder for Strings).

QueryBuilder(String) - Constructor for class sqlg2.db.QueryBuilder

QueryBuilder(QueryPiece) - Constructor for class sqlg2.db.QueryBuilder

QueryPiece - Class in sqlg2.db

Query piece encapsulating query text and query parameters.

QueryPiece(String, Object[], Class<?>[]) - Constructor for class sqlg2.db.QueryPiece

Constructor.

R

releaseConnection(Connection) - Method in interface sqlg2.db.ConnectionManager

Connection release.

releaseConnection(Connection) - Method in class sqlg2.db.SingleConnectionManager

remove(K) - Method in class sqlg2.db.client.SoftCache

rollback() - Method in interface sqlg2.db.ITransaction

Rolls back transaction.

rollback() - Method in class sqlg2.db.Transaction

rollback() - Method in class sqlg2.db.TransactionRunnable

Rolls back transaction

rollbackImmediate() - Method in class sqlg2.db.FakeInternalTransaction

rollbackImmediate() - Method in interface sqlg2.db.InternalTransaction

RowType - Annotation Type in sqlg2

Annotation marking that annotated class is a Java representation of a database row (analogous of %ROWTYPE in PL/SQL).

run() - Method in class sqlg2.db.TransactionRunnable

Implement this method to define which block to run in transaction.

runInTransaction(IDBInterface, TransactionRunnable<T>) - Static method in class sqlg2.db.TransactionRunnable

Run block in transaction atomically: block is either committed or rolled back.

runProcess(ProcessFactory) - Method in class sqlg2.db.client.SafeDBInterface

runProcess(ProcessFactory) - Method in class sqlg2.db.DBInterface

runProcess(ProcessFactory) - Method in interface sqlg2.db.IDBInterface

Creates background process on the server.

S

SafeDBInterface - Class in sqlg2.db.client

Wrapper for IDBInterface on the client side.

SafeDBInterface(IDBInterface) - Constructor for class sqlg2.db.client.SafeDBInterface

Constructor.

sessionId - Variable in class sqlg2.db.SessionInfo

Unique session identifier.

SessionInfo - Class in sqlg2.db

Client session descriptor.

SessionInfo(String, String, long, long, Object, boolean) - Constructor for class sqlg2.db.SessionInfo

setBlob(PreparedStatement, byte[]) - Method in class sqlg2.GBase

Writes bytes to BLOB.

setClob(PreparedStatement, String) - Method in class sqlg2.GBase

Writes text to CLOB.

setDebug(Debug) - Static method in class sqlg2.db.Debug

Sets new debug output object.

setError(boolean) - Method in exception sqlg2.db.InformationException

setNull(PreparedStatement, int, Class<?>) - Method in interface sqlg2.db.NullSetter

setParameter(PreparedStatement, int, Object, Class<?>) - Method in class sqlg2.GBase

setParameter(PreparedStatement, int, Object) - Method in class sqlg2.GBase

setParameters(PreparedStatement, Object...) - Method in class sqlg2.GBase

Binds prepared statement parameters to specific values.

setSqlTrace(SqlTrace) - Method in class sqlg2.db.ConnectionFactory

setSqlTrace(SqlTrace) - Method in class sqlg2.db.LocalConnectionFactory

setStdStreams(PrintWriter, PrintWriter) - Static method in class sqlg2.db.Debug

shutdown() - Method in class sqlg2.db.ConnectionFactory

Server shutdown.

shutdown() - Method in class sqlg2.db.HttpDispatcher

Server shutdown

SimpleDebug - Class in sqlg2.db

Simple implementation for Debug - outputs to console.

SimpleDebug() - Constructor for class sqlg2.db.SimpleDebug

SimpleTransaction - Class in sqlg2.db

RMI wrapper for ISimpleTransaction.

SimpleTransaction(ConnectionManager, LocalConnectionFactory, Debug) - Constructor for class sqlg2.db.SimpleTransaction

SingleConnectionManager - Class in sqlg2.db

Single-connection implementation of ConnectionManager.

SingleConnectionManager(Connection) - Constructor for class sqlg2.db.SingleConnectionManager

singleRowQuery(PreparedStatement, Class<T>) - Method in class sqlg2.GBase

Executes select query, which should return one row (more or less than one rows raises runtime exception).

singleRowQueryReturning(Class<T>, PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningBigDecimal(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningBlob(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningBytes(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningClob(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningDate(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningDouble(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningDOUBLE(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningInt(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningINT(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningLong(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningLONG(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningObject(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningString(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningTime(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

singleRowQueryReturningTimestamp(PreparedStatement) - Method in class sqlg2.GBase

Executes select query, which should return one row and one column (more or less than one rows raises runtime exception, more or less than one column raises preprocess-time exception).

SoftCache<K,V> - Class in sqlg2.db.client

Cache using soft references (GC can collect its keys).

SoftCache() - Constructor for class sqlg2.db.client.SoftCache

sql - Variable in class sqlg2.db.QueryPiece

Sql - Annotation Type in sqlg2

Annotation for local variables marking that variable's value should be taken from comments (as a string).

SqlChecker - Interface in sqlg2.checker

Used to check validity of SQL queries during preprocess.

SQLG - Annotation Type in sqlg2

Annotation for upper level class marking that this class should be processed by preprocessor.

sqlg2 - package sqlg2

sqlg2.checker - package sqlg2.checker

sqlg2.db - package sqlg2.db

sqlg2.db.client - package sqlg2.db.client

SQLGException - Exception in sqlg2

SQLG runtime exception - is raised in case of internal errors.

SQLGException(String) - Constructor for exception sqlg2.SQLGException

SQLGException(String, Throwable) - Constructor for exception sqlg2.SQLGException

SqlTrace - Interface in sqlg2.db

Tracing of SQL statements.

T

toQuery() - Method in class sqlg2.db.QueryBuilder

Returns built query

toSql(Connection) - Method in interface sqlg2.db.MappedType

toString() - Method in class sqlg2.ColumnInfo

toString() - Method in class sqlg2.db.GClob

toString() - Method in class sqlg2.db.OutParameter

toString() - Method in class sqlg2.db.QueryBuilder

toString() - Method in class sqlg2.db.QueryPiece

trace(String) - Static method in class sqlg2.db.Debug

Debug trace.

trace(String) - Method in class sqlg2.db.FakeInternalTransaction

trace(String) - Method in interface sqlg2.db.InternalTransaction

trace(String) - Method in class sqlg2.LocalWrapperBase

Debug trace.

TraceDebug - Class in sqlg2.db

Implementation for Debug - outputs to log file.

TraceDebug(String) - Constructor for class sqlg2.db.TraceDebug

TraceDebug(File) - Constructor for class sqlg2.db.TraceDebug

traceSql(boolean) - Method in class sqlg2.GBase

SQL tracing.

traceSql(boolean, long) - Method in class sqlg2.GBase

SQL tracing.

Transaction - Class in sqlg2.db

RMI wrapper for ITransaction.

Transaction(ConnectionManager, LocalConnectionFactory, Debug) - Constructor for class sqlg2.db.Transaction

TransactionRunnable<R> - Class in sqlg2.db

Utility class to run ITransactions safely.

TransactionRunnable() - Constructor for class sqlg2.db.TransactionRunnable

TypedList<T> - Class in sqlg2.db

This class used for OUT parameters of cursor types.

TypedList(Class<T>) - Constructor for class sqlg2.db.TypedList

TypeNullSetter - Annotation Type in sqlg2.db

Annotation for MappedType-implementing classes to make link to NullSetter implementation for this custom-mapped class.

U

url - Variable in class sqlg2.db.DBAuthenticationImpl

user - Variable in class sqlg2.db.SessionInfo

User login.

userObject - Variable in class sqlg2.db.SessionInfo

User identifier object.

W

workingTime - Variable in class sqlg2.db.SessionInfo

Session working time.

writeResponse(ObjectOutputStream, Object, Throwable) - Static method in class sqlg2.db.HttpDispatcher

A B C D E F G H I K L M N O P Q R S T U W