7.6. ODPI-C Structure dpiConnCreateParams
This structure is used for creating connections to the database, whether
standalone or acquired from a session pool. All members are initialized to
default values using the dpiContext_initConnCreateParams()
function.
Care should be taken to ensure a copy of this structure exists only as long as
needed to create the connection since it can contain a clear text copy of
credentials used for connecting to the database.
-
dpiAuthMode dpiConnCreateParams.authMode
Specifies the mode used for authorizing connections. It is expected to be one or more of the values from the enumeration dpiAuthMode, OR’ed together. The default value is DPI_MODE_AUTH_DEFAULT.
-
const char *dpiConnCreateParams.connectionClass
Specifies the connection class to use when connecting to the database. This is used with DRCP (database resident connection pooling) or to further subdivide a session pool. It is expected to be NULL (meaning that no connection class will be set) or a byte string in the encoding used for CHAR data. The default value is NULL.
-
uint32_t dpiConnCreateParams.connectionClassLength
Specifies the length of the
dpiConnCreateParams.connectionClass
member, in bytes. The default value is 0.
-
dpiPurity dpiConnCreateParams.purity
Specifies the level of purity required when creating a connection using a connection class. It is expected to be one of the values from the enumeration dpiPurity. The default value is DPI_PURITY_DEFAULT.
-
const char *dpiConnCreateParams.newPassword
Specifies the new password to set when creating a connection. This value is only used when creating a standalone connection. It is expected to be NULL or a byte string in the encoding used for CHAR data. The default value of this member is NULL. If specified, the password for the user is changed when the connection is created (useful when the password has expired and a session cannot be established without changing the password).
-
uint32_t dpiConnCreateParams.newPasswordLength
Specifies the length of the
dpiConnCreateParams.newPassword
member, in bytes. The default value is 0.
-
dpiAppContext *dpiConnCreateParams.appContext
Specifies the application context that will be set when the connection is created. This value is only used when creating standalone connections. It is expected to be NULL or an array of dpiAppContext structures. The context specified here can be used in logon triggers, for example. The default value is NULL.
-
uint32_t dpiConnCreateParams.numAppContext
Specifies the number of elements found in the
dpiConnCreateParams.appContext
member. The default value is 0.
-
int dpiConnCreateParams.externalAuth
Specifies whether external authentication should be used to create the connection. If this value is 0, the user name and password values must be specified in the call to
dpiConn_create()
; otherwise, the user name and password values must be zero length or NULL. The default value is 0.
-
void *dpiConnCreateParams.externalHandle
Specifies an OCI service context handle created externally that will be used instead of creating a connection from scratch. The default value is NULL. Note that this connection depends on the external handle remaining valid for the lifetime of this connection. It is also important to ensure that the last reference to this connection is released before the external service context handle and environment handle are destroyed. Unlike regular connections, no attempt is made to rollback any outstanding transactions or close any open statements, objects and LOBs when the last reference to this connection is released, since attempts to do so after the external service context handle and environment are destroyed may result in crashes and other undesirable behavior.
-
dpiPool *dpiConnCreateParams.pool
Specifies the session pool from which to acquire a connection or NULL if a standalone connection should be created. The default value is NULL. If the method
dpiPool_acquireConnection()
is being called, this value is ignored.
-
const char *dpiConnCreateParams.tag
Specifies the tag to use when acquiring a connection from a session pool. This member is ignored when creating a standalone connection. If specified, the tag restricts the type of session that can be returned to those with that tag or a NULL tag. If the member
dpiConnCreateParams.matchAnyTag
is set, however, any session can be returned if no matching sessions are found.The value is expected to be NULL (any session can be returned) or a byte string in the encoding used for CHAR data. The default value is NULL. If specified, the value should be one or more properties (specified in the form key=value) separated by semicolons.
-
uint32_t dpiConnCreateParams.tagLength
Specifies the length of the
dpiConnCreateParams.tag
member, in bytes. The default value is 0.
-
int dpiConnCreateParams.matchAnyTag
Specifies whether any tagged session should be accepted when acquiring a connection from a session pool, if no connection using the tag specified in the
dpiConnCreateParams.tag
is available. This value is only used when acquiring a connection from a session pool. The default value is 0.
-
const char *dpiConnCreateParams.outTag
Specifies the tag of the connection that was acquired from a session pool, or NULL if the session was not tagged. This member is left untouched when creating a standalone connection and is filled in only if the connection acquired from the session pool was tagged. If filled in, it is a byte string in the encoding used for CHAR data.
-
uint32_t dpiConnCreateParams.outTagLength
Specifies the length of the
dpiConnCreateParams.outTag
member, in bytes.
-
int dpiConnCreateParams.outTagFound
Specifies if the connection created used the tag specified by the
dpiConnCreateParams.tag
member. It is only filled in if the connection was acquired from a session pool and a tag was initially specified.
-
dpiShardingKeyColumn *dpiConnCreateParams.shardingKeyColumns
Specifies an array of dpiShardingKeyColumn structures which are used to identify which database shard should be connected to. The number of elements in the array is assumed to contain at least
dpiConnCreateParams.numShardingKeyColumns
elements.
-
uint8_t dpiConnCreateParams.numShardingKeyColumns
Specifies the number of elements in the array of sharding key columns found in the member
dpiConnCreateParams.shardingKeyColumns
.
-
dpiShardingKeyColumn *dpiConnCreateParams.superShardingKeyColumns
Specifies an array of dpiShardingKeyColumn structures which are used to identify which database shard should be connected to. The number of elements in the array is assumed to contain at least
dpiConnCreateParams.numSuperShardingKeyColumns
elements.
-
uint8_t dpiConnCreateParams.numSuperShardingKeyColumns
Specifies the number of elements in the array of sharding key columns found in the member
dpiConnCreateParams.superShardingKeyColumns
.
-
int dpiConnCreateParams.outNewSession
Specifies if the connection created was newly created by the session pool and has never been acquired from the pool (1) or not (0). It is only filled in if the connection was acquired from a session pool.