Client-Library example

The following example calls JagCmGetConnection to obtain a connection that has a user name of “myrtle,” has a password of “secret,” connects to the server “tsingtao,” and uses Client-Library:

#include <ctpublic.h>
#include <jagpublic.h>

CS_RETCODE ret;
CS_CONNECTION *connection;
JagCmCache cache;

/*
** Obtain a connection.
*/
cache = NULL;
ret = JagCmGetConnection (&cache, “myrtle”, “secret”,
   “tsingtao”, “CTLIB_110”,(SQLPOINTER *)&connection, 
   JAG_CM_FORCE);

if (ret != CS_SUCCEED)
{
   ... log the error ...
}

... code that uses the connection goes here ...

ret = JagCmReleaseConnection (&cache,
                         “myrtle”,“secret”,“tsingtao”,
                         “CTLIB_110”,
                         (SQLPOINTER)connection,
                         JAG_CM_UNUSED);

if (ret != CS_SUCCEED)
{
   ... log the error ...
}

In the example, the call to JagCmGetConnection looks for a cache that includes matching values for the user name (“myrtle”), password (“secret”), and server name (“tsingtao”) and that uses Client-Library. The last parameter, opt, is passed as JAG_CM_FORCE to indicate that the call should open a new, uncached connection if no cached connection is available. JagCmReleaseConnection releases control of the connection: a connection that was taken from a cache is returned to that cache; an uncached connection is closed and deallocated.

Note that JagCmGetConnection attempts to open a connection even when no matching cache is configured. In this case, JagCmGetConnection attempts to create a new, uncached connection using the specified values.

In this example, JagCmGetConnection and JagCmReleaseConnection return Client-Library return codes since both calls use “CTLIB_110” for the con_lib parameter.