ReadOnly

Purpose

Specifies whether the connection has read-only access to the data source.

1 | 0

If set to 1, the connection has read-only access. The following commands are the only commands that you can use when a connection if read-only:

Call* (if the procedure does not update data)

Explain Plan

Select (except Select Into)

Set Database Collation

Set IgnoreCase

Set Maxrows

Set Schema

The driver generates an exception if any other command is executed.

If set to 0, the connection is opened for read/write access, and you can use all commands supported by the product.

You also can use the JDBC connection method setReadOnly to set a read-only state for a connection.