Gbase8s database set connection statement

Use SET CONNECTION Statement to re-establish the connection between the application and the database environment , And make the connection current

Connect . You can also accompany DORMANT Option uses this statement to put the current connection to sleep . Please use GBase 8s

ESQL/C Use this statement .

usage

You can use it. SET CONNECTION Make the dormant connection the current connection , Or hibernate the current connection .

SET CONNECTION Not a valid prepared statement .

Make the dormant connection the current connection

If you use without DORMANT Option SET CONNECTION sentence , be connection Must indicate sleep connection

Pick up . A dormant connection is a connection that has been established but is not the current connection .

No DOMANT Option SET CONNECTION Statement to make the specified dormant connection the current connection . Apply the specified

The connection must be dormant . When the statement executes , The current connection becomes dormant .

In the following example SET CONNECTION Statement make connection con1 Become the current connection , And make con2 Become a dormant company

Pick up ：

CONNECT TO ‘stores_demo’ AS ‘con1’;

…

CONNECT TO ‘demo’ AS ‘con2’;

…

SET CONNECTION ‘con1’;

A dormant connection has a connection context associated with it . When the application makes the dormant connection current , It is built into the database environment

The connection of , And restore its connection context .（ To get more information about connection context , Please refer to at CONNECT

sentence On the page CONNECT sentence sentence .） Re establishing the connection is comparable to establishing the initial connection , Except that it typically

Avoid re authenticating licenses for users , And it avoids reallocating resources other than those associated with the initial connection . for example , Applications don't need

Prepare any statements previously prepared in the connection , There is no need to redeclare any cursors .