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 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 false, the connection is opened for read/write access, and you can use all commands supported by the product.

Notes

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

Default

false

Data Type

boolean