Java Client API 1.4 (November 2023)
 
Loading...
Searching...
No Matches
com.dbSpaces.jdb.Connection Class Reference

Inherits com.dbSpaces.jdb.Base.

Public Member Functions

void begin () throws DatabaseException
 
dtRtnStatus close () throws DatabaseException
 
void commit () throws DatabaseException
 
dtRtnStatus connect (String dataSourceName) throws DatabaseException
 
dtRtnStatus connect (String dataSourceName, String userID, String password, String purposeName, String recipientID) throws DatabaseException
 
dtRtnStatus connect (String hostAddress, int portNumber, String namespace, String catalogName, String userID, String password, String purposeName, String recipientID) throws DatabaseException
 
Statement createStatement () throws DatabaseException
 
Statement createStatement (String name) throws DatabaseException
 
String getDataSourceName ()
 
String getCatalogName ()
 
int getConnectionOption (int option) throws DatabaseException
 
DatabaseMetaData getDatabaseMetaData () throws DatabaseException
 
String getClientInfo (String name) throws DatabaseException
 
Properties getClientInfo () throws DatabaseException
 
int getFetchSize ()
 
String getHostAddress ()
 
Navigation getNavigationObject () throws DatabaseException
 
int getPortNo ()
 
String getPurpose ()
 
String getRecipientID ()
 
String getSchemaName ()
 
String getUserID ()
 
String getUserPassword ()
 
String getServerName () throws DatabaseException
 
String getServiceName ()
 
Statement getStatement (int statementHandle) throws DatabaseException
 
Statement getStatement (String statementName) throws DatabaseException
 
dtRtnStatus setAutoStartTransact (boolean enable) throws DatabaseException
 
boolean setFetchSize (int size) throws DatabaseException
 
void setPurposeName (String name)
 
void setRecepientID (String recipientID)
 
void setTimeout (int period) throws DatabaseException
 
dtRtnStatus setCatalog (String catalogName) throws DatabaseException
 
dtRtnStatus setClientInfo (Properties cliInfo) throws DatabaseException
 
dtRtnStatus setClientInfo (String name, String value) throws DatabaseException
 
dtRtnStatus setSchema (String schemaName) throws DatabaseException
 
dtRtnStatus setEnableAutoCommit (boolean enable) throws DatabaseException
 
dtRtnStatus setEnableDefaultSynonyms (boolean enable) throws DatabaseException
 
dtRtnStatus setEnableFlatDefinitions (boolean enable) throws DatabaseException
 
dtRtnStatus setEnableReadOnly (boolean enable) throws DatabaseException
 
void setProgramName (String name)
 
dtRtnStatus reconnect () throws DatabaseException
 
dtRtnStatus rollback () throws DatabaseException
 
boolean isAutoCommitEnabled () throws DatabaseException
 
boolean isClosed ()
 
boolean isCompressionEnabled ()
 
boolean isDefaultSynonymsEnabled ()
 
boolean isNetworkTypesEnabled ()
 
boolean isReadOnly () throws DatabaseException
 
boolean isTransactionInProgress ()
 
boolean isValid ()
 

Static Public Attributes

static final int TRANSACTION_NONE = 0
 
static final int TRANSACTION_READ_UNCOMMITTED = 1
 
static final int TRANSACTION_READ_COMMITTED = 2
 
static final int TRANSACTION_REPEATABLE_READ = 4
 
static final int TRANSACTION_SERIALIZABLE = 8
 

Detailed Description

A Connection represents a session with a specific database.

Within the context of a Connection, SQL statements can be executed with potentially result sets being returned, or Navigational (NO-SQL) requests can be executed for retrieving, inserting, deleting and updating rows.

A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc. This information is obtained with the getDatabaseMetaData method.

Note: By default the Connection automatically commits changes after executing each statement. If auto commit has been disabled, an explicit commit must be done or database changes will not be saved.

A DatabaseException will be thrown if a database error occurs and exceptions are enabled. If exceptions are not enabled the following error methods can be used to get information about the error;

  • GetErrorStatus()
  • GetErrorCode()
  • GetErrorMessage()
Since
Version 1.0

Member Function Documentation

◆ begin()

void com.dbSpaces.jdb.Connection.begin ( ) throws DatabaseException

Start a new transaction.

See also
commit(), rollback().
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ close()

dtRtnStatus com.dbSpaces.jdb.Connection.close ( ) throws DatabaseException

Close the connection to the server. Close will also close any open Statements, ResultSet and Navigation objects. If there are any active transactions they will be rolled back if they have not been already committed.

Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
See also
reconnect().
Since
Version 1.0
Here is the caller graph for this function:

◆ commit()

void com.dbSpaces.jdb.Connection.commit ( ) throws DatabaseException

Commit makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection. This method should only be used when auto commit has been disabled.

Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
See also
#setEnableAutoCommit, #begin.
Since
Version 1.0

◆ connect() [1/3]

dtRtnStatus com.dbSpaces.jdb.Connection.connect ( String  dataSourceName) throws DatabaseException

For more information on Data sources and Network Services see the dbSpaces Config program.

Parameters
dataSourceNameData source name.
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException
Since
Version 1.0
Here is the call graph for this function:
Here is the caller graph for this function:

◆ connect() [2/3]

dtRtnStatus com.dbSpaces.jdb.Connection.connect ( String  dataSourceName,
String  userID,
String  password,
String  purposeName,
String  recipientID 
) throws DatabaseException

Make a connection to the database server using a Data source name.

The connection credentials are made up of; userID, password, Purpose name, and Recipient ID.

For more information on Data sources and Network Services see the dbSpaces Config program.

Parameters
dataSourceNameData source name.
userIDUser ID to use.
passwordUser password to use.
purposeNamePurpose name to use (if not provided defaults to 'ANY').
recipientIDRecipient ID to to (if not provided defaults to 'ANY').
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0
Here is the call graph for this function:

◆ connect() [3/3]

dtRtnStatus com.dbSpaces.jdb.Connection.connect ( String  hostAddress,
int  portNumber,
String  namespace,
String  catalogName,
String  userID,
String  password,
String  purposeName,
String  recipientID 
) throws DatabaseException

Make a connection to the database server using the Host address and Port number.

The connection credentials are made up of; userID, password, Purpose name, and Recipient ID.

Parameters
hostAddressThe host address for the database server.
portNumberThe port number for the database server.
namespaceThe namespace to connect to.
catalogNameCatalog name.
userIDUser ID to use.
passwordUser password to use.
purposeNamePurpose name to use (if not provided defaults to 'ANY').
recipientIDRecipient ID to to (if not provided defaults to 'ANY').
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ createStatement() [1/2]

Statement com.dbSpaces.jdb.Connection.createStatement ( ) throws DatabaseException

Creates an unamed Statement object for executing SQL statements.

Returns
New Statement object.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
See also
Statement.
Since
Version 1.0
Here is the caller graph for this function:

◆ createStatement() [2/2]

Statement com.dbSpaces.jdb.Connection.createStatement ( String  name) throws DatabaseException

Creates a named Statement object for executing SQL statements.

Parameters
nameUnique name for the statement.
Returns
New Statement object.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
See also
Statement.
Since
Version 1.0

◆ getCatalogName()

String com.dbSpaces.jdb.Connection.getCatalogName ( )

Get the current Catalog name for the connection.

Returns
Catalog name.
Since
Version 1.0

◆ getClientInfo() [1/2]

Properties com.dbSpaces.jdb.Connection.getClientInfo ( ) throws DatabaseException

Returns a list containing the name and current value of each client info property. The value of a client info property may be null if the property has not been set and does not have a default value.

Returns
A Properties object that contains the name and current value of each of the client info properties supported by the driver.
Exceptions
DatabaseExceptionif the database server returns an error when fetching the client info values from the database or this method is called on a closed connection
Since
Version 1.0

◆ getClientInfo() [2/2]

String com.dbSpaces.jdb.Connection.getClientInfo ( String  name) throws DatabaseException

Returns the value of the client info property specified by name. This method may return null if the specified client info property has not been set, does not have a default value or is an invalid property.

Applications may use the DatabaseMetaData.getClientInfoProperties method to determine the client info properties supported by the driver.

Parameters
nameThe name of the client info property to retrieve
Returns
The value of the client info property specified
Exceptions
DatabaseExceptionif the database server returns an error when fetching the client info value from the database or this method is called on a closed connection
See also
DatabaseMetaData.getClientInfoProperties
Since
Version 1.0

◆ getConnectionOption()

int com.dbSpaces.jdb.Connection.getConnectionOption ( int  option) throws DatabaseException

Get the value of the connection option provided.

Parameters
optionConnection option
Returns
Connection value or -1 if an error occurred.
Exceptions
DatabaseException
Since
Version 1.0
Here is the caller graph for this function:

◆ getDatabaseMetaData()

DatabaseMetaData com.dbSpaces.jdb.Connection.getDatabaseMetaData ( ) throws DatabaseException

Get the DatabaseMetaData object for the connection.

Returns
DatabaseMetaData object
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ getDataSourceName()

String com.dbSpaces.jdb.Connection.getDataSourceName ( )

Get the data source name used for the connection.

Returns
Data source name if used, otherwise null.
Since
Version 1.0

◆ getFetchSize()

int com.dbSpaces.jdb.Connection.getFetchSize ( )

Get the fetch size for returning rows with the ResultSet object.

Returns
The fetch size.
See also
SetFetchSize.
Since
Version 1.0

◆ getHostAddress()

String com.dbSpaces.jdb.Connection.getHostAddress ( )

Get the host address that was used to connect to the server with.

Returns
host address.
Since
Version 1.0

◆ getNavigationObject()

Navigation com.dbSpaces.jdb.Connection.getNavigationObject ( ) throws DatabaseException

Get the Navigation object for the Connection. The Navigation object allows NO-SQL access to the tables in the database.

Returns
the Navigation object.
See also
Navigation.
Since
Version 1.0

◆ getPortNo()

int com.dbSpaces.jdb.Connection.getPortNo ( )

Get the port number used to connect to the server with.

Returns
port number.
Since
Version 1.0

◆ getPurpose()

String com.dbSpaces.jdb.Connection.getPurpose ( )

Get the Purpose name for the connection.

Returns
The purpose name.
Since
Version 1.0

◆ getRecipientID()

String com.dbSpaces.jdb.Connection.getRecipientID ( )

Get the Recipient ID for the connection.

Returns
The recipient ID.
Since
Version 1.0

◆ getSchemaName()

String com.dbSpaces.jdb.Connection.getSchemaName ( )

Get the current schema name for the connection.

Returns
Schema name.
Since
Version 1.0

◆ getServerName()

String com.dbSpaces.jdb.Connection.getServerName ( ) throws DatabaseException

Get the local server name for the connection.

Returns
the server name
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0
Here is the call graph for this function:

◆ getServiceName()

String com.dbSpaces.jdb.Connection.getServiceName ( )

Get the name of the Service used by the connection. Services are used to define the method of communicating with the server.

Since
Version 1.0
Returns
The service name.

◆ getStatement() [1/2]

Statement com.dbSpaces.jdb.Connection.getStatement ( int  statementHandle) throws DatabaseException

Get an existing Statement object using the statement handle.

Parameters
statementHandleThe statement handle to find.
Returns
The Statement object.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0
Here is the call graph for this function:

◆ getStatement() [2/2]

Statement com.dbSpaces.jdb.Connection.getStatement ( String  statementName) throws DatabaseException

Get an existing Statement object using the statement name.

Parameters
statementNameThe statement name to find.
Returns
The Statement object.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0
Here is the call graph for this function:

◆ getUserID()

String com.dbSpaces.jdb.Connection.getUserID ( )

Get the User ID that was used to connect to the server.

Returns
The User ID.
Since
Version 1.0

◆ getUserPassword()

String com.dbSpaces.jdb.Connection.getUserPassword ( )

Get the user Password that was used to connect to the server.

Returns
The user password.
Since
Version 1.0

◆ isAutoCommitEnabled()

boolean com.dbSpaces.jdb.Connection.isAutoCommitEnabled ( ) throws DatabaseException

Check if auto-commit is enabled.

Returns
true if auto-commit is enabled; false if otherwise.
Since
Version 1.0
Here is the call graph for this function:

◆ isClosed()

boolean com.dbSpaces.jdb.Connection.isClosed ( )

Check if the connection to the server is closed.

Returns
true if closed; false if otherwise.
Since
Version 1.0

◆ isCompressionEnabled()

boolean com.dbSpaces.jdb.Connection.isCompressionEnabled ( )

Check if compression is enabled? If compression is enabled then size of data packets sent to the server is reduced.

Returns
true if compression is enabled; false if otherwise.
Since
Version 1.0

◆ isDefaultSynonymsEnabled()

boolean com.dbSpaces.jdb.Connection.isDefaultSynonymsEnabled ( )

Check if default synonyms is enabled? If default synonyms are enabled then they will be used instead of column names.

Returns
true if default synonyms are enabled; false if otherwise.
Since
Version 1.0

◆ isNetworkTypesEnabled()

boolean com.dbSpaces.jdb.Connection.isNetworkTypesEnabled ( )

Check if network data types are enabled. The standard for sending data across the network is high-low endian. If your client is of the same byte order as the server network data types do not need to be enabled which helps with performance.

Returns
true if network data types are enabled; false if otherwise.
Since
Version 1.0

◆ isReadOnly()

boolean com.dbSpaces.jdb.Connection.isReadOnly ( ) throws DatabaseException

Check if the connection is read-only. If the connection has been set to read-only then any m_request other then a read will produce an error.

Returns
true if read-only; false if otherwise.
Since
Version 1.0
Here is the call graph for this function:

◆ isTransactionInProgress()

boolean com.dbSpaces.jdb.Connection.isTransactionInProgress ( )

Is there an active transaction in progress?

Returns
true if transaction is active; false if otherwise.
Since
Version 1.0

◆ isValid()

boolean com.dbSpaces.jdb.Connection.isValid ( )

Is the connection still valid?

Returns
true if connection is valid; false if otherwise.
Since
Version 1.0
Here is the call graph for this function:
Here is the caller graph for this function:

◆ reconnect()

dtRtnStatus com.dbSpaces.jdb.Connection.reconnect ( ) throws DatabaseException

Reconnect if the connection has been closed.

Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs
See also
Close.
Since
Version 1.0

◆ rollback()

dtRtnStatus com.dbSpaces.jdb.Connection.rollback ( ) throws DatabaseException

Rolls back the work of an existing transaction.

Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs
See also
begin().
Since
Version 1.0

◆ setAutoStartTransact()

dtRtnStatus com.dbSpaces.jdb.Connection.setAutoStartTransact ( boolean  enable) throws DatabaseException

Set auto start a transaction state.

Parameters
enabletrue auto start is on, false auto start is off (default).
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setCatalog()

dtRtnStatus com.dbSpaces.jdb.Connection.setCatalog ( String  catalogName) throws DatabaseException

Set the active Catalog for the connection.

Parameters
catalogNameThe name of the catalog to use.
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setClientInfo() [1/2]

dtRtnStatus com.dbSpaces.jdb.Connection.setClientInfo ( Properties  cliInfo) throws DatabaseException

Sets the value of the connection's client info properties. The Properties object contains the names and values of the client info properties to be set. The set of client info properties contained in the properties list replaces the current set of client info properties on the connection. If a property that is currently set on the connection is not present in the properties list, that property is cleared. Specifying an empty properties list will clear all of the properties on the connection.

Parameters
clientInfoClient info properties
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setClientInfo() [2/2]

dtRtnStatus com.dbSpaces.jdb.Connection.setClientInfo ( String  name,
String  value 
) throws DatabaseException

Sets the value of the client info property specified by name to the value specified by value.

Parameters
nameName of the client info property.
valueNew property value, if null the current value is cleared.
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setEnableAutoCommit()

dtRtnStatus com.dbSpaces.jdb.Connection.setEnableAutoCommit ( boolean  enable) throws DatabaseException

If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements/Navigation requests are grouped into transactions that are terminated by either commit() or rollback(). By default, new connections are in auto-commit mode.

The commit occurs when the statement completes or the next execute occurs, whichever comes first. In the case of statements returning a ResultSet, the statement completes when the last row of the ResultSet has been retrieved or the ResultSet has been closed. In advanced cases, a single statement may return multiple results as well as output parameter values. Here the commit occurs when all results and output param values have been retrieved.

If caching has been enabled then any outstanding Navigation requests are flushed to the database and then the commit occurs.

Parameters
enabletrue enables auto-commit; false disables auto-commit (default).
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setEnableDefaultSynonyms()

dtRtnStatus com.dbSpaces.jdb.Connection.setEnableDefaultSynonyms ( boolean  enable) throws DatabaseException

Set use default synonyms if they exist and not the table's column names.

Parameters
enabletrue, use default synonyms; false do not use default synonyms (default).
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setEnableFlatDefinitions()

dtRtnStatus com.dbSpaces.jdb.Connection.setEnableFlatDefinitions ( boolean  enable) throws DatabaseException

Set use flat definitions for tables and views.

Parameters
enabletrue, use flat definitions; false do not use flat definitions (default).
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setEnableReadOnly()

dtRtnStatus com.dbSpaces.jdb.Connection.setEnableReadOnly ( boolean  enable) throws DatabaseException

You can put a connection in read-only mode as a hint to enable database optimizations.

Note: setEnableReadOnly cannot be called while in the middle of a transaction.

Parameters
enabletrue enables read-only mode; false disables read-only mode (default).
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setFetchSize()

boolean com.dbSpaces.jdb.Connection.setFetchSize ( int  size) throws DatabaseException

Set the fetch size for the number of rows returned from a ResultSet or NavigationTable.

Parameters
sizeThe new fetch size.
Returns
true if successful; false if otherwise.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs;
Since
Version 1.0

◆ setProgramName()

void com.dbSpaces.jdb.Connection.setProgramName ( String  name)

Set the program name to identify the connection by in the server.

Parameters
nameThe Program name.
Since
Version 1.0

◆ setPurposeName()

void com.dbSpaces.jdb.Connection.setPurposeName ( String  name)

Set the Purpose name for the connection.

Setting the Purpose name should be set before a connection, reconnection or the set catalog call.

If the Hippocratic Security addon is not licensed or not enabled for the database, the Purpose name is ignored.

Parameters
nameThe Purpose name.
See also
connect, reconnect
Since
Version 1.0

◆ setRecepientID()

void com.dbSpaces.jdb.Connection.setRecepientID ( String  recipientID)

Set the Recipient ID for the connection.

Setting the Recipient ID should be set before a connection, reconnection or the set catalog call.

If the Hippocratic Security addon is not licensed or not enabled for the database, the Recipient ID is ignored.

Parameters
recipientIDThe Recipient ID.
Since
Version 1.0

◆ setSchema()

dtRtnStatus com.dbSpaces.jdb.Connection.setSchema ( String  schemaName) throws DatabaseException

Set the active schema for the connection.

Parameters
schemaNameThe name of the schema to use.
Returns
dtRtnStatus.RTN_STATUS_SUCCESS or dtRtnStatus.RTN_STATUS_ERROR.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

◆ setTimeout()

void com.dbSpaces.jdb.Connection.setTimeout ( int  period) throws DatabaseException

Set the time out period when connecting to the server.

Parameters
periodThe number of seconds before timing out.
Exceptions
DatabaseException(if exceptions are enabled) when a database error occurs.
Since
Version 1.0

Member Data Documentation

◆ TRANSACTION_NONE

final int com.dbSpaces.jdb.Connection.TRANSACTION_NONE = 0
static

Transactions are not supported.

Since
Version 1.0

◆ TRANSACTION_READ_COMMITTED

final int com.dbSpaces.jdb.Connection.TRANSACTION_READ_COMMITTED = 2
static

Dirty reads are prevented; non-repeatable reads and phantom reads can occur. This level only prohibits a transaction from reading a row with uncommitted changes in it.

Since
Version 1.0

◆ TRANSACTION_READ_UNCOMMITTED

final int com.dbSpaces.jdb.Connection.TRANSACTION_READ_UNCOMMITTED = 1
static

Dirty reads, non-repeatable reads and phantom reads can occur. This level allows a row changed by one transaction to be read by another transaction before any changes in that row have been committed (a "dirty read"). If any of the changes are rolled back, the second transaction will have retrieved an invalid row.

Since
Version 1.0

◆ TRANSACTION_REPEATABLE_READ

final int com.dbSpaces.jdb.Connection.TRANSACTION_REPEATABLE_READ = 4
static

Dirty reads and non-repeatable reads are prevented; phantom reads can occur. This level prohibits a transaction from reading a row with uncommitted changes in it, and it also prohibits the situation where one transaction reads a row, a second transaction alters the row, and the first transaction rereads the row, getting different values the second time (a "non-repeatable read").

Since
Version 1.0

◆ TRANSACTION_SERIALIZABLE

final int com.dbSpaces.jdb.Connection.TRANSACTION_SERIALIZABLE = 8
static

Dirty reads, non-repeatable reads and phantom reads are prevented. This level includes the prohibitions in TRANSACTION_REPEATABLE_READ and further prohibits the situation where one transaction reads all rows that satisfy a WHERE condition, a second transaction inserts a row that satisfies that WHERE condition, and the first transaction rereads for the same condition, retrieving the additional "phantom" row in the second read.

Since
Version 1.0