User guide

When persona is used both the multi-process server and the pool server will need to have
read/execute/write access to the RDB$JDBC_COM directory and read/write access to the
RDB$JDBC_LOG directory.
By default the installation of the JDBC drivers will create these directories on your
installation destination directory and set the access to both these directories to world
READ/EXECUTE. You will have to alter the file protection on these directories and grant
WRITE access to the persona.
If you have redirected these logical names to another directory you must ensure that the
persona has the read/write access to these directories.
See File and Directory access Requirements
for more details.
8.4 Default Transaction
The type of transaction the Oracle JDBC for Rdb drivers start up when a transaction is
required depends on a number of conditions
• Whether autoCommit is enabled
• The verb of the SQL statement to be executed
• The default transaction type specified on connection using the connection switch
transaction
• The setting of the transaction types in the connection if changed by methods such as
Connection.setReadOnly() and Connection.setTransactionIsolation().
If no specific behaviour has been specified, by default the Oracle JDBC for Rdb drivers will
start in AUTOCOMMIT mode and will start up a READ_WRITE SERIALIZABLE
transaction if the SQL statement requires a read-write transaction, for example, INSERT or
UPDATE. If the statement does not require a read-write transaction, a READ_ONLY
transaction is started.
When AUTOCOMMIT is disabled, the type of transaction started will depend on whether the
connection has been set read-only and is a default transaction type has been specified on the
connection. By default, a READ_WRITE SERIALIZABLE transaction will be started if
autoCommit is turned off and no other method has been called to change the default
transaction type.
If the setting of the transaction type in the connection is MANUAL this default behaviour
changes. Setting transactions to MANUAL indicates that the client will take responsibility
for the starting of transactions. The drivers will no longer start transactions, however, if
autoCommit is enabled, the driver will still commit transactions appropriately.
When transactions are set to MANUAL, and the first operation after a connection or after a
transaction termination is not SET TRANSACTION, Oracle Rdb will start a transaction on
111