| Method Summary |
|
| boolean | addDeleteAction(Table table, Row row)
Adds a single-row deletion step to the transaction UNDO buffer. |
| boolean | addInsertAction(Table table, Row row)
Adds a single-row insertion step to the transaction UNDO buffer. |
| public void | addWarning(HsqlException warning)
|
| void | beginNestedTransaction()
Starts a nested transaction. |
| void | check(HsqlName object, int right)
Checks whether this Session's current User has the set of rights
specified by the right argument, in relation to the database
object identifier specified by the object argument. |
| void | check(String object)
|
| void | checkAdmin()
Checks whether this Session's current User has the privileges of
the ADMIN role. |
| void | checkDDLWrite()
This is used for creating new database objects such as tables. |
| void | checkReadWrite()
This is used for reading - writing to existing tables. |
| void | clearIndexRoots()
|
| void | clearIndexRootsKeep()
|
| public void | close()
Closes this Session. |
| public void | commit()
|
| void | dropIndex(HsqlName index, boolean preserve)
|
| void | endNestedTransaction(boolean rollback)
Ends a nested transaction. |
| void | endSchemaDefinition()
|
| public Result | execute(Result cmd)
Executes the command encapsulated by the cmd argument. |
| public HsqlException[] | getAndClearWarnings()
|
| Result | getAttributes()
|
| public String | getAutoCommitStatement()
|
| long | getConnectTime()
Getter for connectTime attribute. |
| Date | getCurrentDate()
Returns the current date, unchanged for the duration of the current
execution unit (statement).
SQL standards require that CURRENT_DATE, CURRENT_TIME and
CURRENT_TIMESTAMP are all evaluated at the same point of
time in the duration of each SQL statement, no matter how long the
SQL statement takes to complete.
When this method or a corresponding method for CURRENT_TIME or
CURRENT_TIMESTAMP is first called in the scope of a system change
number, currentMillis is set to the current system time. |
| Time | getCurrentTime()
|
| Timestamp | getCurrentTimestamp()
|
| Database | getDatabase()
Retrieves the Database instance to which this
Session represents a connection. |
| public int | getId()
Retrieves the session identifier for this Session. |
| Node | getIndexRoot(HsqlName index, boolean preserve)
|
| jdbcConnection | getInternalConnection()
Retrieves an internal Connection object equivalent to the one
that created this Session. |
| public String | getInternalConnectionURL()
|
| public int | getIsolation()
|
| Number | getLastIdentity()
Getter for iLastIdentity attribute. |
| int | getMaxRows()
|
| int | getSQLMaxRows()
|
| HsqlName | getSchemaHsqlName(String name)
If schemaName is null, return the current schema name, else return
the HsqlName object for the schema. |
| HsqlName | getSchemaHsqlNameForWrite(String name)
If schemaName is null, return the current schema name, else return
the HsqlName object for the schema. |
| public String | getSchemaName(String name)
|
| public String | getSchemaNameForWrite(String name)
|
| boolean | getScripting()
Getter for scripting attribute. |
| Session | getSession()
|
| int | getTransactionSize()
Getter for transactionSise attribute. |
| public User | getUser()
Retrieves the User object representing the user currently controlling
this Session. |
| String | getUsername()
Retrieves the name, as known to the database, of the
user currently controlling this Session. |
| boolean | isAccessible(String dbobject)
Retrieves whether the database object identifier by the dbobject
argument is accessible by the current Session User. |
| boolean | isAccessible(HsqlName dbobject)
|
| boolean | isAdmin()
Getter for admin attribute. |
| public boolean | isAutoCommit()
Getter for autoCommit attribute. |
| public boolean | isClosed()
Retrieves whether this Session is closed. |
| boolean | isNestedTransaction()
Getter for nestedTransaction attribute. |
| boolean | isProcessingLog()
|
| boolean | isProcessingScript()
|
| public boolean | isReadOnly()
Getter for readonly attribute. |
| boolean | isSchemaDefintion()
|
| public void | prepareCommit()
|
| void | releaseSavepoint(String name)
Implements release of named SAVEPOINT. |
| void | resetSchema()
|
| public void | resetSession()
|
| public void | rollback()
Rolls back any uncommited transaction this Session may have open. |
| void | rollbackToSavepoint(String name)
Implements a partial transaction ROLLBACK. |
| void | savepoint(String name)
Implements a transaction SAVEPOINT. |
| Result | setAttributes(Result r)
|
| public void | setAutoCommit(boolean autocommit)
Setter for the autocommit attribute. |
| void | setIndexRoot(HsqlName index, boolean preserve, Node root)
|
| public void | setIsolation(int level)
|
| void | setLastIdentity(Number i)
Setter for iLastIdentity attribute. |
| public void | setReadOnly(boolean readonly)
Setter for readonly attribute. |
| void | setSQLMaxRows(int rows)
The SQL command SET MAXROWS n will override the Statement.setMaxRows(n)
until SET MAXROWS 0 is issued.
NB this is dedicated to the SET MAXROWS sql statement and should not
otherwise be called. |
| public void | setSchema(String schema)
|
| void | setScripting(boolean script)
A switch to set scripting on the basis of type of statement executed.
A method in DatabaseCommandInterpreter.java sets this value to false
before other methods are called to act on an SQL statement, which may
set this to true. |
| void | setUser(User user)
Sets this Session's User object to the one specified by the
user argument. |
| CompiledStatement | sqlCompileStatement(String sql)
|
| Result | sqlExecuteCompiledNoPreChecks(CompiledStatement cs, Object[] pvals)
|
| public Result | sqlExecuteDirectNoPreChecks(String sql)
|
| public void | startPhasedTransaction()
|
| void | startSchemaDefinition(String schema)
|
