Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.0 |  CUBRID 8.4.1 | 



cubrid_set_db_parameter

Description

The cubrid_set_db_parameter function sets the CUBRID system parameters. It can set the following CUBRID system parameters:

  • CUBRID_PARAM_ISOLATION_LEVEL : Transaction isolation level. For more information, see "CUBRID SQL Guide > Transaction and Lock > Transaction Isolation Level > SET TRANSACTION ISOLATION LEVEL."
  • CUBRID_PARAM_LOCK_TIMEOUT : Lock timeout. Time when transaction lock is held.
Syntax

bool cubrid_set_db_parameter ( resource $conn_identifier, int $param_type, int $param_value)

  • conn_identifier : Connection identifier
  • param_type : System parameter type
  • param_value : System parameter value
Return Value
  • Success : TRUE
  • Failure : FALSE
Example

<?php

$conn = cubrid_connect("localhost", 33000, "demodb");

 

$params = cubrid_get_db_parameter($conn);

var_dump($params);

 

cubrid_set_autocommit($conn, CUBRID_AUTOCOMMIT_TRUE);

cubrid_set_db_parameter($conn, CUBRID_PARAM_ISOLATION_LEVEL, 2);

 

$params_new = cubrid_get_db_parameter($conn);

var_dump($params_new);

 

cubrid_disconnect($conn);

?>

 

The above example will output:

 

array(4) {

  ["PARAM_ISOLATION_LEVEL"]=>

  int(3)

  ["PARAM_LOCK_TIMEOUT"]=>

  int(-1)

  ["PARAM_MAX_STRING_LENGTH"]=>

  int(1073741823)

  ["PARAM_AUTO_COMMIT"]=>

  int(0)

}

array(4) {

  ["PARAM_ISOLATION_LEVEL"]=>

  int(2)

  ["PARAM_LOCK_TIMEOUT"]=>

  int(-1)

  ["PARAM_MAX_STRING_LENGTH"]=>

  int(1073741823)

  ["PARAM_AUTO_COMMIT"]=>

  int(1)

}

See Also