Top Description Inners Fields Constructors Methods
org.hsqldb

public Class Session

extends Object
implements SessionInterface
Class Inheritance
All Implemented Interfaces
org.hsqldb.SessionInterface
Imports
java.text.SimpleDateFormat, java.util.Calendar, .GregorianCalendar, .Random, .TimeZone, org.hsqldb.HsqlNameManager.HsqlName, org.hsqldb.error.Error, .ErrorCode, org.hsqldb.jdbc.JDBCConnection, .JDBCDriver, org.hsqldb.lib.ArrayUtil, .CountUpDownLatch, .HashMap, .HsqlArrayList, .HsqlDeque, .Iterator, .OrderedHashSet, .SimpleLog, org.hsqldb.map.ValuePool, org.hsqldb.navigator.RowSetNavigator, .RowSetNavigatorClient, org.hsqldb.persist.HsqlDatabaseProperties, .HsqlProperties, .PersistentStore, org.hsqldb.result.Result, .ResultConstants, .ResultLob, .ResultProperties, org.hsqldb.rights.Grantee, .User, org.hsqldb.types.BlobDataID, .ClobDataID, .DateTimeType, .HsqlDateTime, .TimeData, .TimestampData, .Type, .TypedComparator
Implementation of SQL sessions.
Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.7.0
Version
2.7.3

Nested and Inner Type Summary

Modifier and TypeClass and Description
pack-priv class
Session.TimeoutManager

Field Summary

Modifier and TypeField and Description
pack-priv volatile boolean
abortAction

pack-priv volatile boolean
abortTransaction

pack-priv int
actionIndex

pack-priv long
actionSCN

pack-priv OrderedHashSet<RowActionBase>
actionSet

pack-priv long
actionStartSCN

private Calendar
calendar

private Calendar
calendarGMT

pack-priv HsqlProperties
clientProperties

private final TimestampData
connectTimestamp

private TimestampData
currentDate

public HsqlNameManager.HsqlName
currentSchema

private TimeData
currentTime

private TimestampData
currentTimestamp

pack-priv long
currentTimestampSCN

pack-priv TimeZone
currentTimeZone

public Database
database

private JDBCConnection
extConnection

private boolean
ignoreCase

private JDBCConnection
intConnection

pack-priv boolean
isBatch

private volatile boolean
isClosed

pack-priv boolean
isNetwork

pack-priv int
isolationLevel

pack-priv int
isolationLevelDefault

pack-priv volatile boolean
isPreTransaction

pack-priv boolean
isProcessingLog

pack-priv boolean
isProcessingScript

public boolean
isReadOnlyDefault

pack-priv boolean
isReadOnlyIsolation

pack-priv volatile boolean
isTransaction

public CountUpDownLatch
latch

private TimeData
localTime

private TimestampData
localTimestamp

public HsqlNameManager.HsqlName
loggedSchema

pack-priv ParserCommand
parser

pack-priv Random
randomGenerator

public final int
randomId

pack-priv volatile boolean
redoAction

pack-priv int
resultMaxMemoryRows

private Grantee
role

pack-priv HsqlArrayList<RowAction>
rowActionList

pack-priv Scanner
secondaryScanner

pack-priv long
seed

public SessionContext
sessionContext

public SessionData
sessionData

private final long
sessionId

private int
sessionMaxRows

pack-priv int
sessionOptimization

public int
sessionTxId

private final User
sessionUser

pack-priv SimpleDateFormat
simpleDateFormat

pack-priv SimpleDateFormat
simpleDateFormatGMT

public Object
special

pack-priv HsqlDeque<HsqlException>
sqlWarnings

public StatementManager
statementManager

pack-priv long
statementStartSCN

pack-priv OrderedHashSet<Session>
tempSet

pack-priv volatile boolean
tempUnlocked

pack-priv Session.TimeoutManager
timeoutManager

pack-priv final TimeZone
timeZone

pack-priv long
transactionEndSCN

pack-priv long
transactionSCN

private TimestampData
transactionUTC

pack-priv boolean
transactionUTCSet

pack-priv final boolean
txConflictRollback

pack-priv final boolean
txInterruptRollback

pack-priv TypedComparator
typedComparator

private User
user

public OrderedHashSet<Session>
waitedSessions

public OrderedHashSet<Session>
waitingSessions

pack-priv final String
zoneString

Constructor Summary

AccessConstructor and Description
pack-priv
Session(Database
the database to which this represents a connection
db, User
the initial user
user, boolean
the initial autocommit value
autocommit, boolean
the initial readonly value
readonly, long
the session identifier, as known to the database
id, TimeZone
the TimeZone
zone)

Constructs a new Session object.

Method Summary

Modifier and TypeMethod and Description
public void
addDeleteAction(Table
the table of the row
table, PersistentStore store, Row
the deleted row
row, int[] changedColumns)

Adds a delete action to the row and the transaction manager.

pack-priv void
addInsertAction(Table table, PersistentStore store, Row row, int[] changedColumns)

public void
addWarning(HsqlException warning)

Implements org.hsqldb.SessionInterface.addWarning.

public Result
allocateResultLob(ResultLob result)

Implements org.hsqldb.SessionInterface.allocateResultLob.

pack-priv static void
appendIsolationSQL(StringBuilder sb, int isolationLevel)

public void
beginAction(Statement cs)

public Result
cancel(Result result)

Implements org.hsqldb.SessionInterface.cancel.

pack-priv void
checkAdmin()

Checks whether this Session's current User has the privileges of the ADMIN role.

pack-priv void
checkDDLWrite()

This is used for creating new database objects such as tables.

pack-priv void
checkReadWrite()

This is used for reading - writing to existing tables.

public void
clearWarnings()

public synchronized void
close()

Implements org.hsqldb.SessionInterface.close.

Closes this Session.

public synchronized void
closeNavigator(long id)

Implements org.hsqldb.SessionInterface.closeNavigator.

public synchronized void
commit(boolean chain)

Implements org.hsqldb.SessionInterface.commit.

Commits any uncommitted transaction this Session may have open

public Statement
compileStatement(String sql, int props)

public Statement
compileStatement(String sql)

public BlobDataID
createBlob(long length)

Implements org.hsqldb.SessionInterface.createBlob.

public ClobDataID
createClob(long length)

Implements org.hsqldb.SessionInterface.createClob.

public void
endAction(Result result)

private void
endTransaction(boolean commit, boolean chain)

public synchronized Result

Returns:

the result of executing the command
execute(Result
the command to execute
cmd)

Implements org.hsqldb.SessionInterface.execute.

Executes the command encapsulated by the cmd argument.

private Result
executeCompiledBatchStatement(Result cmd)

public Result
executeCompiledStatement(Statement cs, Object[] pvals, int timeout)

private Result
executeDirectBatchStatement(Result cmd)

public Result
executeDirectStatement(Result cmd)

public Result
executeDirectStatement(String sql)

private Result

Returns:

the result of executing the statement
executeResultUpdate(Result cmd)

Retrieves the result of inserting, updating or deleting a row from an updatable result.

public long
getActionSCN()

public HsqlException[]
getAndClearWarnings()

public synchronized Object
getAttribute(int id)

Implements org.hsqldb.SessionInterface.getAttribute.

public Result
getAttributesResult(int id)

public Calendar
getCalendar()

Implements org.hsqldb.SessionInterface.getCalendar.

public Calendar
getCalendarGMT()

Implements org.hsqldb.SessionInterface.getCalendarGMT.

public HsqlProperties
getClientProperties()

Implements org.hsqldb.SessionInterface.getClientProperties.

public TypedComparator
getComparator()

public TimestampData

Returns:

the value
getConnectTimestamp()

Getter for connectTime attribute.

public synchronized TimestampData
getCurrentDate()

public HsqlNameManager.HsqlName
getCurrentSchemaHsqlName()

pack-priv synchronized TimeData
getCurrentTime()

Returns the current time, unchanged for the duration of the current execution unit (statement)

pack-priv synchronized TimestampData
getCurrentTimestamp()

Returns the current date/time, unchanged for the duration of the current execution unit (statement).

public Database

Returns:

the Database object to which this Session is connected
getDatabase()

Retrieves the Database instance to which this Session represents a connection.

public String
getDatabaseUniqueName()

Implements org.hsqldb.SessionInterface.getDatabaseUniqueName.

public Grantee
getGrantee()

public long

Returns:

the session identifier for this Session
getId()

Implements org.hsqldb.SessionInterface.getId.

Retrieves the session identifier for this Session.

pack-priv JDBCConnection

Returns:

internal connection.
getInternalConnection()

Retrieves an internal Connection object equivalent to the one that created this Session.

public String
getInternalConnectionURL()

Implements org.hsqldb.SessionInterface.getInternalConnectionURL.

public synchronized int
getIsolation()

Implements org.hsqldb.SessionInterface.getIsolation.

pack-priv static String
getIsolationString(int isolationLevel)

public JDBCConnection
getJDBCConnection()

Implements org.hsqldb.SessionInterface.getJDBCConnection.

Retrieves the external JDBC connection

public Number

Returns:

the current value
getLastIdentity()

Getter for iLastIdentity attribute.

public HsqlException
getLastWarning()

pack-priv synchronized TimeData
getLocalTime()

pack-priv synchronized TimestampData
getLocalTimestamp()

pack-priv int
getMaxRows()

public int
getRandomId()

Implements org.hsqldb.SessionInterface.getRandomId.

public int
getResultMemoryRowCount()

public Grantee
getRole()

public HsqlArrayList<RowAction>
getRowActionList()

public RowSetNavigatorClient
getRows(long navigatorId, int offset, int blockSize)

Implements org.hsqldb.SessionInterface.getRows.

public Scanner
getScanner()

Implements org.hsqldb.SessionInterface.getScanner.

pack-priv HsqlNameManager.HsqlName
getSchemaHsqlName(String name)

If schemaName is null, return the current schema name, else return the HsqlName object for the schema.

public String
getSchemaName(String name)

Same as above, but return string

pack-priv String
getSessionIsolationSQL()

public Result
getSetAttributeResult(int id)

pack-priv String
getSetSchemaStatement()

public SimpleDateFormat
getSimpleDateFormatGMT()

Implements org.hsqldb.SessionInterface.getSimpleDateFormatGMT.

pack-priv String
getStartTransactionSQL()

public synchronized int
getStreamBlockSize()

Implements org.hsqldb.SessionInterface.getStreamBlockSize.

public TimeZone
getTimeZone()

Implements org.hsqldb.SessionInterface.getTimeZone.

pack-priv String
getTransactionIsolationSQL()

public long
getTransactionSCN()

public int

Returns:

the current value
getTransactionSize()

Count of actions in current transaction.

pack-priv TimestampData
getTransactionUTC()

public User

Returns:

this Session's User object
getUser()

Retrieves the User object representing the user currently controlling this Session.

public String

Returns:

the name of the user currently connected within this Session
getUsername()

Retrieves the name, as known to the database, of the user currently controlling this Session.

public int
getZoneSeconds()

Implements org.hsqldb.SessionInterface.getZoneSeconds.

private Result
handleAbortTransaction()

public boolean

Returns:

the current value
isAdmin()

Getter for admin attribute.

public synchronized boolean

Returns:

the current value
isAutoCommit()

Implements org.hsqldb.SessionInterface.isAutoCommit.

Getter for autoCommit attribute.

public boolean

Returns:

true if this Session is closed
isClosed()

Implements org.hsqldb.SessionInterface.isClosed.

Retrieves whether this Session is closed.

public boolean
isIgnorecase()

public boolean
isInMidTransaction()

public boolean
isProcessingLog()

public boolean
isProcessingScript()

public boolean

Returns:

the current value
isReadOnly()

Getter for readonly attribute.

public synchronized boolean
isReadOnlyDefault()

Implements org.hsqldb.SessionInterface.isReadOnlyDefault.

pack-priv void
logSequences()

pack-priv Result
performLOBOperation(ResultLob cmd)

private Result
performPostExecute(Result command, Result result)

public synchronized void
prepareCommit()

Implements org.hsqldb.SessionInterface.prepareCommit.

public double
random(long seed)

public double
random()

public void
registerResultLobs(Result result)

pack-priv void
releaseInternalConnection()

public synchronized void
releaseSavepoint(String
name of savepoint
name)

Implements org.hsqldb.SessionInterface.releaseSavepoint.

Releases a savepoint

private void
resetCurrentTimestamp()

pack-priv void
resetSchema()

public synchronized void
resetSession()

Implements org.hsqldb.SessionInterface.resetSession.

Clear structures and reset variables to original.

public void
resetTimeZone()

public synchronized void
rollback(boolean chain)

Implements org.hsqldb.SessionInterface.rollback.

Rolls back any uncommitted transaction this Session may have open.

public synchronized void
rollbackAction(int start, long timestamp)

pack-priv synchronized void
rollbackNoCheck(boolean chain)

public synchronized void
rollbackToSavepoint(String
name of savepoint
name)

Implements org.hsqldb.SessionInterface.rollbackToSavepoint.

Performs a partial transaction ROLLBACK to savepoint.

public synchronized void
rollbackToSavepoint()

Performs a partial transaction ROLLBACK of current savepoint level.

public synchronized void
savepoint(String
name of the savepoint
name)

Implements org.hsqldb.SessionInterface.savepoint.

Registers a transaction SAVEPOINT.

public synchronized void
setAttribute(int id, Object object)

Implements org.hsqldb.SessionInterface.setAttribute.

public void
setAttributeFromResult(Result result)

Implements org.hsqldb.SessionInterface.setAttributeFromResult.

no-op, only for ClientConnection

private Result
setAttributes(Result r)

public synchronized void
setAutoCommit(boolean
the new value
autocommit)

Implements org.hsqldb.SessionInterface.setAutoCommit.

Setter for the autocommit attribute.

public void
setAutoCommitRows(int rows)

public void
setCatalog(String catalog)

public void
setCurrentSchemaHsqlName(HsqlNameManager.HsqlName name)

pack-priv void
setFeature(String feature, boolean value)

public void
setIgnoreCase(boolean mode)

public void
setIsolation(int level)

sets ISOLATION for the next transaction only

public synchronized void
setIsolationDefault(int level)

Implements org.hsqldb.SessionInterface.setIsolationDefault.

public void
setJDBCConnection(JDBCConnection connection)

Implements org.hsqldb.SessionInterface.setJDBCConnection.

pack-priv void
setLastIdentity(Number
the new value
i)

Setter for iLastIdentity attribute.

public void
setNoSQL()

public void
setReadOnly(boolean
the new value
readonly)

sets READ ONLY for next transaction / subtransaction only

public synchronized void
setReadOnlyDefault(boolean readonly)

Implements org.hsqldb.SessionInterface.setReadOnlyDefault.

public void
setResultMemoryRowCount(int count)

public void
setRole(Grantee role)

public void
setSchema(String schema)

pack-priv void
setSQLMaxRows(int rows)

The SQL command SET MAXROWS n will override the Statement.setMaxRows(n) for the next direct statement only NB this is dedicated to the SET MAXROWS sql statement and should not otherwise be called.

public void
setTimeZone(TimeZone zone)

public void
setUser(User
the new User object for this session
user)

Sets this Session's User object to the one specified by the user argument.

public synchronized void
startPhasedTransaction()

Implements org.hsqldb.SessionInterface.startPhasedTransaction.

public void
startTransaction()

Explicit start of transaction by user

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait