cubrid_set_db_parameter

Description

The cubrid_set_db_parameter() function is used to set the CUBRID system parameters. It can set the following CUBRID system parameters:

• CUBRID_PARAM_ISOLATION_LEVEL : Transaction isolation level. For more information, see 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

• cubrid_get_db_parameter