Purpose

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

Valid Values

true | false

Behavior

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

  • Explain Plan
  • Select (except Select Into)
  • Set Schema

The driver returns an error if any other command is used.

If set to false, the connection is opened for read/write access, and you can use all commands supported by the product.
CAUTION: Before disabling the ReadOnly connection property, it is critical to confirm that all values in the primary key column are unique. Executing write operations against data with duplicate primary keys can produce unpredictable and undesirable results. See Designating a Primary Key for more information.

Notes

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

Default

true

Data Type

Boolean

See also

Using Connection Properties