Gbase8s database makes the current connection a dormant connection

stay SET CONNECTION connection DORMANT In the sentence ,connection Must represent the current connection . with

DORMANT Option SET CONNECTION Statement to make the specified current connection a dormant connection .

for example , The following SET CONNECTION Statement make connection con1 Sleep ：

SET CONNECTION ‘con1’ DORMANT;

If you specify a connection that is already dormant , With DORMANT Option SET CONNECTION Statement generation error

By mistake . for example , If connected con1 It is current. , And connect con2 It's dormant , Then SET CONNECTION sentence

Return error message ：

SET CONNECTION ‘con2’ DORMANT;

The following SET CONNECTION Statement successfully executed ：

SET CONNECTION ‘con1’ DORMANT;

Dormant connections in a single threaded environment

In single thread GBase 8s ESQL/C application （ Not using threads ） in ,DORMANT Option to make the current connection sleep

Of . Use this option to make single threaded GBase 8s ESQL/C Application and thread safe GBase 8s ESQL/C Application up and

Rong . However , When the program is executed , A single threaded environment can have only one active connection .

Dormant connections in a thread safe environment

In thread safe GBase 8s ESQL/C Application ,DORMANT Option to make active connections dormant . Now the other line

Process can be sent without DORMANT Option SET CONNECTION Statement to use the connection . In a GBase 8s

ESQL/C Application , A thread safe environment can have many threads （ The concurrent part of the work that performs a particular task ）, And every thread

Can there be an active connection .

Active connections are associated with specific threads . Two threads cannot share the same active connection . Once the thread makes the active connection

For dormant , Other threads can use that connection . Still establish a dormant connection , But the currently dormant connection is not connected to any thread

relation . for example , If it is named thread_1 In the thread named con1 The connection of is active , It is called thread_2

Thread of cannot make connection con1 Become its active connection , until thread_1 Connected con1 Become dormant for

stop .

The following are from thread safe GBase 8s ESQL/C Code snippets of the program are shown in thread safe applications , Specific threads

How to make the connection active , Perform work on the table through this connection , Then make the connection dormant , So that other lines

The program can use this connection ：

thread_2()

{ /* send con2 Become an active connection */

EXEC SQL connect to ‘db2’ as ‘con2’;

/Do insert on table t2 in db2/

EXEC SQL insert into table t2 values(10);

/* Make other threads available con2 */

EXEC SQL set connection ‘con2’ dormant;

}

If you use CONNECT . . . WITH CONCURRENT TRANSACTION Statement initializes the connection to the database environment

Pick up , Then any thread that then connects to that database environment can use the ongoing transaction . Besides , If an open cursor is associated with

Such connections are related , When the link becomes dormant , The cursor remains open .

In thread safe GBase 8s ESQL/C Threads within an application can use the same thread by making the associated connection current

mark , Even if only one thread can use the connection at any given time .