Unix and Linux Discussions Tagged with experience |
|
Thread / Thread Starter |
Last Post |
Replies |
Views |
Forum |
|
|
|
0 |
24,726 |
UNIX for Advanced & Expert Users |
|
|
|
6 |
2,935 |
What is on Your Mind? |
|
|
|
0 |
2,338 |
Oracle Updates (RSS) |
|
|
|
0 |
1,219 |
Complex Event Processing RSS News |
|
|
|
0 |
2,239 |
Solaris BigAdmin RSS |
|
|
|
3 |
9,810 |
Programming |
|
|
|
9 |
3,630 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
3,354 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
3,197 |
UNIX for Dummies Questions & Answers |
|
|
|
2 |
2,483 |
Programming |
|
|
|
5 |
6,965 |
UNIX for Dummies Questions & Answers |
|
|
|
5 |
3,354 |
UNIX for Dummies Questions & Answers |
|
|
|
4 |
5,513 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
3,784 |
UNIX for Advanced & Expert Users |
|
|
|
1 |
3,517 |
Programming |
|
|
|
1 |
10,081 |
UNIX for Dummies Questions & Answers |
|
|
|
2 |
9,138 |
UNIX for Advanced & Expert Users |
|
|
|
2 |
3,819 |
UNIX for Dummies Questions & Answers |
|
|
|
2 |
5,461 |
Programming |
|
|
|
2 |
3,227 |
UNIX for Dummies Questions & Answers |
|
|
|
4 |
3,150 |
UNIX for Dummies Questions & Answers |
|
|
|
7 |
4,385 |
UNIX for Dummies Questions & Answers |
|
|
|
5 |
4,097 |
UNIX for Dummies Questions & Answers |
|
|
|
8 |
5,304 |
Post Here to Contact Site Administrators and Moderators |
|
|
|
3 |
5,922 |
UNIX for Dummies Questions & Answers |
|
|
|
10 |
10,802 |
HP-UX |
|
|
|
1 |
3,538 |
UNIX for Dummies Questions & Answers |
|
|
|
4 |
3,048 |
UNIX for Dummies Questions & Answers |
|
|
|
4 |
3,301 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
2,853 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
14,989 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
9,595 |
UNIX for Dummies Questions & Answers |
|
|
|
3 |
29,701 |
Where do I download LINUX & UNIX? |
|
|
|
9 |
5,430 |
UNIX for Dummies Questions & Answers |
|
|
|
2 |
3,639 |
UNIX for Dummies Questions & Answers |
|
|
|
7 |
5,037 |
UNIX for Dummies Questions & Answers |
|
|
|
4 |
5,400 |
UNIX for Dummies Questions & Answers |
|
|
|
2 |
4,913 |
UNIX for Dummies Questions & Answers |
|
|
|
4 |
5,891 |
UNIX for Dummies Questions & Answers |
|
|
|
3 |
4,590 |
UNIX for Dummies Questions & Answers |
CUBRID_GET_DB_PARAMETER(3) 1 CUBRID_GET_DB_PARAMETER(3)
cubrid_get_db_parameter - Returns the CUBRID database parameters
SYNOPSIS
array cubrid_get_db_parameter (resource $conn_identifier)
DESCRIPTION
This function returns the CUBRID database parameters or it returns FALSE on failure. It returns an associative array with the values for
the following parameters:
o PARAM_ISOLATION_LEVEL
o PARAM_LOCK_TIMEOUT
o PARAM_MAX_STRING_LENGTH
o PARAM_AUTO_COMMIT
Database parameters
+----------------------+---------------------------------------------------+
| Parameter | |
| | |
| | Description |
| | |
+----------------------+---------------------------------------------------+
|PARAM_ISOLATION_LEVEL | |
| | |
| | The transaction isolation level. |
| | |
| LOCK_TIMEOUT | |
| | |
| | CUBRID provides the lock timeout feature, which |
| | sets the waiting time (in seconds) for the lock |
| | until the transaction lock setting is allowed. |
| | The default value of the lock_timeout_in_secs |
| | parameter is -1, which means the application |
| | client will wait indefinitely until the transac- |
| | tion lock is allowed. |
| | |
| PARAM_AUTO_COMMIT | |
| | |
| | In CUBRID PHP, auto-commit mode is disabled by |
| | default for transaction management. It can be set |
| | by using cubrid_set_autocommit(3). |
| | |
+----------------------+---------------------------------------------------+
The following table shows the isolation levels from 1 to 6. It consists of table schema (row) and isolation level:
Levels of Isolation Supported by CUBRID
+--------------------------------------------------+---------------------------------------------------+
| Name | |
| | |
| | Description |
| | |
+--------------------------------------------------+---------------------------------------------------+
| SERIALIZABLE (6) | |
| | |
| | In this isolation level, problems concerning con- |
| | currency (e.g. dirty read, non-repeatable read, |
| | phantom read, etc.) do not occur. |
| | |
|REPEATABLE READ CLASS with REPEATABLE READ | |
|INSTANCES (5) | |
| | |
| | Another transaction T2 cannot update the schema |
| | of table A while transaction T1 is viewing table |
| | A. Transaction T1 may experience phantom read for |
| | the record R that was inserted by another trans- |
| | action T2 when it is repeatedly retrieving a spe- |
| | cific record. |
| | |
|REPEATABLE READ CLASS with READ COMMITTED | |
|INSTANCES (or CURSOR STABILITY) (4) | |
| | |
| | Another transaction T2 cannot update the schema |
| | of table A while transaction T1 is viewing table |
| | A. Transaction T1 may experience R read (non- |
| | repeatable read) that was updated and committed |
| | by another transaction T2 when it is repeatedly |
| | retrieving the record R. |
| | |
|REPEATABLE READ CLASS with READ UNCOMMITTED | |
|INSTANCES (3) | |
| | |
| | Default isolation level. Another transaction T2 |
| | cannot update the schema of table A while trans- |
| | action T1 is viewing table A. Transaction T1 may |
| | experience R' read (dirty read) for the record |
| | that was updated but not committed by another |
| | transaction T2. |
| | |
|READ COMMITTED CLASS with READ COMMITTED | |
|INSTANCES (2) | |
| | |
| | Transaction T1 may experience A' read (non- |
| | repeatable read) for the table that was updated |
| | and committed by another transaction T2 while it |
| | is viewing table A repeatedly. Transaction T1 may |
| | experience R' read (non-repeatable read) for the |
| | record that was updated and committed by another |
| | transaction T2 while it is retrieving the record |
| | R repeatedly. |
| | |
|READ COMMITTED CLASS with READ UNCOMMITTED | |
|INSTANCES (1) | |
| | |
| | Transaction T1 may experience A' read (non- |
| | repeatable read) for the table that was updated |
| | and committed by another transaction T2 while it |
| | is repeatedly viewing table A. Transaction T1 may |
| | experience R' read (dirty read) for the record |
| | that was updated but not committed by another |
| | transaction T2. |
| | |
+--------------------------------------------------+---------------------------------------------------+
PARAMETERS
o $conn_identifier
- The CUBRID connection. If the connection identifier is not specified, the last link opened by cubrid_connect(3) is assumed.
RETURN VALUES
An associative array with CUBRID database parameters; on success.
FALSE on failure.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 8.4.0 | |
| | |
| | Change LOCK_TIMEOUT to PARAM_LOCK_TIMEOUT, and |
| | MAX_STRING_LENGTH to PARAM_MAX_STRING_LENGTH in |
| | result. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
cubrid_get_db_parameter(3) example
<?php
printf("%-30s %s
", "CUBRID PHP Version:", cubrid_version());
printf("
");
$conn = cubrid_connect("localhost", 33088, "demodb");
if (!$conn) {
die('Connect Error ('. cubrid_error_code() .')' . cubrid_error_msg());
}
$db_params = cubrid_get_db_parameter($conn);
while (list($param_name, $param_value) = each($db_params)) {
printf("%-30s %s
", $param_name, $param_value);
}
printf("
");
$server_info = cubrid_get_server_info($conn);
$client_info = cubrid_get_client_info();
printf("%-30s %s
", "Server Info:", $server_info);
printf("%-30s %s
", "Client Info:", $client_info);
printf("
");
$charset = cubrid_get_charset($conn);
printf("%-30s %s
", "CUBRID Charset:", $charset);
cubrid_disconnect($conn);
?>
The above example will output:
CUBRID PHP Version: 9.1.0.0001
PARAM_ISOLATION_LEVEL 3
LOCK_TIMEOUT -1
MAX_STRING_LENGTH 1073741823
PARAM_AUTO_COMMIT 1
Server Info: 9.1.0.0212
Client Info: 9.1.0
CUBRID Charset: iso8859-1
SEE ALSO
cubrid_set_db_parameter(3), cubrid_get_autocommit(3).
PHP Documentation Group CUBRID_GET_DB_PARAMETER(3)