static void oci8_cpool_free(oci8_base_t *base)
{
OCIConnectionPoolDestroy(base->hp.poolhp, oci8_errhp, OCI_DEFAULT);
}
/* main */
int main(int argc, char* argv[])
{
double start, total;
sword status;
total = get_time();
printf("START\n");
get_command_line_arguments(argc, argv);
start = get_time();
OCIEnvCreate(&envhp, OCI_THREADED | OCI_OBJECT, (dvoid *)0, NULL, NULL, NULL, 0, (dvoid *)0);
elapsed_time("OCIEnvCreate", start);
start = get_time();
OCIHandleAlloc((dvoid *) envhp, (dvoid **) &errhp, OCI_HTYPE_ERROR, (size_t) 0, (dvoid **) 0);
OCIHandleAlloc((dvoid *) envhp, (dvoid **) &poolhp, OCI_HTYPE_CPOOL, (size_t) 0, (dvoid **) 0);
elapsed_time("OCIHandleAlloc", start);
if (!useConnectionPool)
{
/* CONNECT DIRECTLY TO THE SERVER */
start = get_time();
status = OCILogon2(
envhp, // envhp (IN) A pointer to the environment where the connection pool is to be created.
errhp, // errhp (IN/OUT) An error handle you can pass to OCIErrorGet() for diagnostic information in the event of an error.
&svchp, // svchp (IN/OUT) Address of an OCI service context pointer. This is filled with a server and session handle.
username, // username (IN) The user name used to authenticate the session. Must be in the encoding specified by the charset parameter of a previous call to OCIEnvNlsCreate().
olen(username), // uname_len (IN) The length of username, in number of bytes, regardless of the encoding.
password, // password (IN) The user's password. For connection pooling, if this parameter is NULL then OCILogon2() assumes that the logon is for a proxy user. It implicitly creates a proxy connection in such a case, using the pool user to authenticate the proxy user. Must be in the encoding specified by the charset parameter of a previous call to OCIEnvNlsCreate().
olen(password), // passwd_len (IN) The length of password, in number of bytes, regardless of the encoding.
database, // dbname (IN) For the default case, this indicates the connect string to use to connect to the Oracle Database.
olen(database), // dbname_len (IN) The length of dbname. For session pooling and connection pooling, this value is returned by the OCISessionPoolCreate() or OCIConnectionPoolCreate() call respectively.
OCI_DEFAULT // mode (IN) The values accepted are: OCI_DEFAULT, OCI_LOGON2_CPOOL, OCI_LOGON2_SPOOL, OCI_LOGON2_STMTCACHE, OCI_LOGON2_PROXY
);
elapsed_time("OCILogon2 to the server", start);
if (status)
{
checkerr(errhp, status);
exit(1);
}
/* DISCONNECT */
start = get_time();
checkerr(errhp, OCILogoff((dvoid *) svchp, errhp));
elapsed_time("OCILogoff from the server", start);
}
if (useConnectionPool)
{
/* CREATE THE CONNECTION POOL */
start = get_time();
status = OCIConnectionPoolCreate(
envhp, // envhp (IN) A pointer to the environment where the connection pool is to be created.
errhp, // errhp (IN/OUT) An error handle you can pass to OCIErrorGet() for diagnostic information in the event of an error.
poolhp, // poolhp (IN) An allocated pool handle.
&poolName, // poolName (OUT) The name of the connection pool connected to.
&poolNameLen, // poolNameLen (OUT) The length of the string pointed to by poolName.
database, // dblink (IN) Specifies the database (server) to connect to.
olen(database), // dblinkLen (IN) The length of the string pointed to by dblink.
conMin, // connMin (IN) Specifies the minimum number of connections in the connection pool. Valid values are 0 and above.
conMax, // connMax (IN) Specifies the maximum number of connections that can be opened to the database. Once this value is reached, no more connections are opened. Valid values are 1 and above.
conIncr, // connIncr (IN) Allows the application to set the next increment for connections to be opened to the database if the current number of connections are less than connMax. Valid values are 0 and above.
appusername, // poolUsername (IN) Connection pooling requires an implicit primary session and this attribute provides a username for that session.
olen(appusername), // poolUserLen (IN) The length of poolUsername.
apppassword, // poolPassword (IN) The password for the username poolUsername.
olen(apppassword), // poolPassLen (IN) The length of poolPassword.
OCI_DEFAULT // mode (IN) The modes supported are
);
elapsed_time("OCIConnectionPoolCreate", start);
if (status)
{
checkerr(errhp, status);
exit(1);
}
/* CONNECT USING THE CONNECTION POOL */
start = get_time();
status = OCILogon2(
envhp, // envhp (IN) A pointer to the environment where the connection pool is to be created.
errhp, // errhp (IN/OUT) An error handle you can pass to OCIErrorGet() for diagnostic information in the event of an error.
&svchp, // svchp (IN/OUT) Address of an OCI service context pointer. This is filled with a server and session handle.
username, // username (IN) The user name used to authenticate the session. Must be in the encoding specified by the charset parameter of a previous call to OCIEnvNlsCreate().
olen(username), // uname_len (IN) The length of username, in number of bytes, regardless of the encoding.
password, // password (IN) The user's password. For connection pooling, if this parameter is NULL then OCILogon2() assumes that the logon is for a proxy user. It implicitly creates a proxy connection in such a case, using the pool user to authenticate the proxy user. Must be in the encoding specified by the charset parameter of a previous call to OCIEnvNlsCreate().
olen(password), // passwd_len (IN) The length of password, in number of bytes, regardless of the encoding.
poolName, // dbname (IN) For the default case, this indicates the connect string to use to connect to the Oracle Database.
poolNameLen, // dbname_len (IN) The length of dbname. For session pooling and connection pooling, this value is returned by the OCISessionPoolCreate() or OCIConnectionPoolCreate() call respectively.
OCI_LOGON2_CPOOL // mode (IN) The values accepted are: OCI_DEFAULT, OCI_LOGON2_CPOOL, OCI_LOGON2_SPOOL, OCI_LOGON2_STMTCACHE, OCI_LOGON2_PROXY
);
elapsed_time("OCILogon2 using the connection pool", start);
if (status)
{
checkerr(errhp, status);
exit(1);
}
/* DISCONNECT */
start = get_time();
checkerr(errhp, OCILogoff((dvoid *) svchp, errhp));
elapsed_time("OCILogoff from the connection pool", start);
/* DESTROY THE CONNECTION POOL */
start = get_time();
checkerr(errhp, OCIConnectionPoolDestroy(poolhp, errhp, OCI_DEFAULT));
elapsed_time("OCIConnectionPoolDestroy", start);
}
/* FREE HANDLES */
start = get_time();
checkerr(errhp, OCIHandleFree((dvoid *)poolhp, OCI_HTYPE_CPOOL));
checkerr(errhp, OCIHandleFree((dvoid *)errhp, OCI_HTYPE_ERROR));
elapsed_time("OCIHandleFree", start);
printf("END\n");
elapsed_time("Total execution time", total);
return 0;
}
boolean OCI_PoolClose
(
OCI_Pool *pool
)
{
boolean res = TRUE;
OCI_CHECK_PTR(OCI_IPC_POOL, pool, FALSE);
/* free all connections */
OCI_ListForEach(pool->cons, (POCI_LIST_FOR_EACH) OCI_ConnectionClose);
OCI_ListClear(pool->cons);
OCI_ListFree(pool->cons);
pool->cons = NULL;
if (OCI_LIB_THREADED)
{
OCI_MutexFree(pool->mutex);
}
#if OCI_VERSION_COMPILE >= OCI_9_0
if (OCILib.version_runtime >= OCI_9_0)
{
/* close pool handle */
if (pool->handle != NULL)
{
if (pool->htype == OCI_HTYPE_CPOOL)
{
OCI_CALL0
(
res, pool->err,
OCIConnectionPoolDestroy(pool->handle, pool->err,
(ub4) OCI_DEFAULT)
)
}
#if OCI_VERSION_COMPILE >= OCI_9_2
else
{
OCI_CALL0
(
res, pool->err,
OCISessionPoolDestroy(pool->handle, pool->err,
(ub4) OCI_SPD_FORCE)
)
}
#endif
OCI_HandleFree((void *) pool->handle, (ub4) pool->htype);
}
#if OCI_VERSION_COMPILE >= OCI_9_2
/* close authentification handle */
if (pool->authp != NULL)
{
OCI_HandleFree((void *) pool->authp, (ub4) OCI_HTYPE_AUTHINFO);
}
#endif
/* close error handle */
if (pool->err != NULL)
{
OCI_HandleFree((void *) pool->err, (ub4) OCI_HTYPE_ERROR);
}
}
#endif
pool->err = NULL;
pool->handle = NULL;
pool->authp = NULL;
/* free strings */
OCI_FREE(pool->name);
OCI_FREE(pool->db);
OCI_FREE(pool->user);
OCI_FREE(pool->pwd);
return res;
}
