skip to main content
DataDirect Connect XE Drivers : Salesforce Driver : Connection Properties : ReadOnly
  
ReadOnly
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