java创建informix连接池,informix使用odbc连接池操作

#include void main()

{

SQLHENV   henv;

SQLHDBC   hdbc;

int       i=0;

/*这里用ESQL先连接数据库，即让当前进程环境已经存在一个数据库连接*/

if (!SQL_SUCCEEDED(SQLSetEnvAttr(

NULL,  // make process level cursor pooling

SQL_ATTR_CONNECTION_POOLING,

(SQLPOINTER)SQL_CP_ONE_PER_DRIVER,

SQL_IS_INTEGER)))

printf("SQLSetEnvAttr/SQL_ATTR_CONNECTION_POOLING errorn");

if (!SQL_SUCCEEDED(SQLAllocHandle(SQL_HANDLE_ENV, NULL, &henv)))

printf("SQLAllocHandle errorn");

// set the ODBC behavior version.

if (!SQL_SUCCEEDED(SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,

(SQLPOINTER) SQL_OV_ODBC2, SQL_IS_INTEGER)))

printf("SQLSetEnvAttr/SQL_ATTR_ODBC_VERSION errorn");

//set the matching condition for using an existing connection in the pool

if (!SQL_SUCCEEDED(SQLSetEnvAttr(henv, SQL_ATTR_CP_MATCH,

(SQLPOINTER) SQL_CP_RELAXED_MATCH, SQL_IS_INTEGER)))

printf("SQLSetEnvAttr/SQL_ATTR_CP_MATCH errorn");

while (i < 10) {

if (!SQL_SUCCEEDED(SQLAllocHandle(SQL_HANDLE_DBC,

henv, &hdbc)))

printf("SQLAllocHandle errorn");

if (!SQL_SUCCEEDED(SQLConnect(hdbc,

(unsigned char*)"testing ", SQL_NTS,

(unsigned char*)"sa ", SQL_NTS,

(unsigned char*)" ", SQL_NTS)))

printf("SQLConnect errorn");

else

printf("Connect successfully %d timesn", i);

//the first time, the application calls SQLDisconenct, it will return

//the connection to the //pool

SQLDisconnect(hdbc);

if (!SQL_SUCCEEDED(SQLFreeHandle(SQL_HANDLE_DBC, hdbc)))

printf("SQLFreeHandle errorn");

i++;

}

SQLFreeHandle(SQL_HANDLE_ENV, henv);

}