SessionInterface

A local or remote session. A session represents a database connection.

Methods
void addTemporaryLob(Value v)
Add a temporary LOB, which is closed when the session commits.
void addTemporaryLob(Value v)
Add a temporary LOB, which is closed when the session commits.
Parameters:
v - the value
void afterWriting()
Called after writing has ended.
void afterWriting()
Called after writing has ended. It needs to be called after isReconnectNeeded(true) returned false.
void cancel()
Cancel the current or next command (called when closing a connection).
void cancel()
Cancel the current or next command (called when closing a connection).
void close()
Roll back pending transactions and close the session.
void close()
Roll back pending transactions and close the session.
boolean getAutoCommit()
Check if this session is in auto-commit mode.
boolean getAutoCommit()
Check if this session is in auto-commit mode.
Returns:
true if the session is in auto-commit mode
DataHandler getDataHandler()
Get the data handler object.
DataHandler getDataHandler()
Get the data handler object.
Returns:
the data handler
int getPowerOffCount()
Get the number of disk operations before power failure is simulated.
int getPowerOffCount()
Get the number of disk operations before power failure is simulated. This is used for testing. If not set, 0 is returned
Returns:
the number of operations, or 0
Trace getTrace()
Get the trace object
Trace getTrace()
Get the trace object
Returns:
the trace object
boolean hasPendingTransaction()
Check whether this session has a pending transaction.
boolean hasPendingTransaction()
Check whether this session has a pending transaction.
Returns:
true if it has
boolean isClosed()
Check if close was called.
boolean isClosed()
Check if close was called.
Returns:
if the session has been closed
boolean isReconnectNeeded(boolean write)
Check if the database changed and therefore reconnecting is required.
boolean isReconnectNeeded(boolean write)
Check if the database changed and therefore reconnecting is required.
Parameters:
write - if the next operation may be writing
Returns:
true if reconnecting is required
CommandInterface prepareCommand(String sql, int fetchSize)
Parse a command and prepare it for execution.
CommandInterface prepareCommand(String sql, int fetchSize)
Parse a command and prepare it for execution.
Parameters:
sql - the SQL statement
fetchSize - the number of rows to fetch in one step
Returns:
the prepared command
SessionInterface reconnect(boolean write)
Close the connection and open a new connection.
SessionInterface reconnect(boolean write)
Close the connection and open a new connection.
Parameters:
write - if the next operation may be writing
Returns:
the new connection
void setAutoCommit(boolean autoCommit)
Set the auto-commit mode.
void setAutoCommit(boolean autoCommit)
Set the auto-commit mode. This call doesn't commit the current transaction.
Parameters:
autoCommit - the new value
void setPowerOffCount(int i)
Set the number of disk operations before power failure is simulated.
void setPowerOffCount(int i)
Set the number of disk operations before power failure is simulated. To disable the countdown, use 0.
Parameters:
i - the number of operations