Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

cci_property_set

Description

It configures a property value in T_CCI_PROPERTIES struct. The property names and its meanings that can be configured in the struct are as follows:

  • pool_size: Maximum number of connection (default value: 10)
  • max_wait: Maximum waiting time to get connection (default value: 1000 msec.)
  • pool_prepared_statement: Whether to enable statement pooling (default value: false)
  • login_timeout: Login timeout time (default value: 0 (unlimited))
  • query_timeout: Query timeout time (default value: 0 (unlimited))
  • disconnect_on_query_timeout: Whether to terminate connection when execution is discarded due to query execution timeout (default value: no)
  • default_autocommit: Auto-commit mode refreshed whenever cci_datasource_borrow is called; true or false
  • default_isolation: Transaction isolation level refreshed whenever cci_datasource_borrow is called
  • default_lock_timeout: lock_timeout refreshed whenever cci_datasource_borrow is called

If you configure default_autocommit, default_isolation, or default_lock_timeout value, connection for autocommit, isolation, or lock_timeout based on current configured value is returned when cci_datasource_borrow is called. If you do not configure it, connection for autocommit, isolation, or lock_timeout is returned with keeping the value that a user changed before.

default_isolation has one of the following configuration values. For details on isolation level, see "CUBRID SQL Guide > Transaction and Lock > Transaction Isolation Level."

isolation_level

Configuration Value

SERIALIZABLE

"TRAN_SERIALIZABLE"

REPEATABLE READ CLASS with
REPEATABLE READ INSTANCES

"TRAN_REP_CLASS_REP_INSTANCE"
or "TRAN_REP_READ"

REPEATABLE READ CLASS with
READ COMMITTED INSTANCES

"TRAN_REP_CLASS_COMMIT_INSTANCE"
or "TRAN_READ_COMMITTED"
or "TRAN_CURSOR_STABILITY"

REPEATABLE READ CLASS with
READ UNCOMMITTED INSTANCES

"TRAN_REP_CLASS_UNCOMMIT_INSTANCE"
or "TRAN_READ_UNCOMMITTED"

READ COMMITTED CLASS with
READ COMMITTED INSTANCES

"TRAN_COMMIT_CLASS_COMMIT_INSTANCE"

READ COMMITTED CLASS with
READ UNCOMMITTED INSTANCES

"TRAN_COMMIT_CLASS_UNCOMMIT_INSTANCE"

Syntax

int cci_property_set (T_CCI_PROPERTIES * properties, char * key, char * value)

  • properties: T_CCI_PROPERTIES struct pointer in which key and value are stored
  • key: String pointer of property name
  • value: String pointer of property value
Return Value
  • Success: 1
  • Failure: 0
See Also