Hitachi

Hitachi Advanced Database Messages


KFAA31524-E

The SQL statement cannot be executed, because the transaction access mode is "READ_ONLY". (M+J+O)

The SQL statement could not be executed because the transaction access mode is read-only. <SQLSTATE: 25006>

S:

Ignores this SQL statement.

Action:

When the transaction access mode is read-only, the only SQL statements that can be executed are SELECT statements. Use one of the following methods to change the transaction access mode to read/write, and then re-execute the SQL statement.

  • For the setReadOnly method of the JDBC driver's Connection interface, specify false.

  • For the Attribute argument of the ODBC driver's SQLSetConnectAttr, specify SQL_ATTR_ACCESS_MODE, and for the ValuePtr argument, specify SQL_MODE_READ_WRITE.

  • For the JDBC driver's adb_clt_trn_access_mode property (system property, user property, or property for connection URL), specify READ_WRITE.

  • For the Attribute argument of the CLI function a_rdb_SQLSetConnectAttr(), specify a_rdb_SQL_ATTR_ACCESS_MODE, and for the Value argument, specify a_rdb_SQL_ACCESS_MODE_READ_WRITE.

  • For the client definition's adb_clt_trn_access_mode operand, specify READ_WRITE.