/************************************************************************ * name: SQLGetCursorNameW * arguments: * returns/side-effects: * description: * NOTE: ************************************************************************/ ODBC_INTERFACE RETCODE SQL_API SQLGetCursorNameW (SQLHSTMT hstmt, SQLWCHAR *cursor, SQLSMALLINT cursor_max, SQLSMALLINT *cursor_len) { RETCODE ret = ODBC_ERROR; char* cursor_name = NULL; SQLSMALLINT cursor_name_len = 0; ODBC_STATEMENT* stmt_handle = (ODBC_STATEMENT *) hstmt; OutputDebugString ("SQLGetCursorNameW called.\n"); cursor_name = UT_ALLOC (cursor_max); if (cursor_name == NULL && cursor_max > 0) { odbc_set_diag (stmt_handle->diag, "HY001", 0, "malloc failed"); return ODBC_ERROR; } memset (cursor_name, 0 , cursor_max); ret = SQLGetCursorName(hstmt, cursor_name, cursor_max, &cursor_name_len); if (ret == ODBC_ERROR) { UT_FREE (cursor_name); return ret; } bytes_to_wide_char (cursor_name, cursor_name_len, &cursor, cursor_max, (int*)cursor_len, NULL); UT_FREE(cursor_name); return ret; }
static int odbc_stmt_get_attr(pdo_stmt_t *stmt, zend_long attr, zval *val) { SQLRETURN rc; pdo_odbc_stmt *S = (pdo_odbc_stmt*)stmt->driver_data; switch (attr) { case PDO_ATTR_CURSOR_NAME: { char buf[256]; SQLSMALLINT len = 0; rc = SQLGetCursorName(S->stmt, buf, sizeof(buf), &len); if (rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO) { ZVAL_STRINGL(val, buf, len); return 1; } pdo_odbc_stmt_error("SQLGetCursorName"); return 0; } case PDO_ODBC_ATTR_ASSUME_UTF8: ZVAL_BOOL(val, S->assume_utf8 ? 1 : 0); return 0; default: strcpy(S->einfo.last_err_msg, "Unknown Attribute"); S->einfo.what = "getAttribute"; strcpy(S->einfo.last_state, "IM001"); return -1; } }
static int odbc_dispatch4(void) { unsigned long retval; PWord rval; int rtype; PWord arg1; int type1; PWord arg2; int type2; PWord arg3; int type3; PWord arg4; int type4; PWord arg5; int type5; PWord arg6; int type6; PI_getan(&arg1,&type1,1); if (type1 != PI_INT) if (!CI_get_integer((unsigned long *)&arg1,type1)) PI_FAIL; PI_getan(&arg2,&type2,2); if (type2 != PI_INT) if (!CI_get_integer((unsigned long *)&arg2,type2)) PI_FAIL; PI_getan(&arg3,&type3,3); if (type3 == PI_SYM) arg3 = (unsigned long) PI_getsymname(0,arg3,0); else if (!CI_get_integer((unsigned long *)&arg3,type3)) PI_FAIL; PI_getan(&arg4,&type4,4); if (type4 != PI_INT) if (!CI_get_integer((unsigned long *)&arg4,type4)) PI_FAIL; PI_getan(&arg5,&type5,5); if (type5 != PI_INT) if (!CI_get_integer((unsigned long *)&arg5,type5)) PI_FAIL; PI_getan(&arg6,&type6,6); switch(arg1) { case 0: retval = (unsigned long) SQLGetCursorName(((SQLHSTMT ) arg2),((SQLCHAR * ) arg3),((SQLSMALLINT ) arg4),((SQLSMALLINT * ) arg5)); break; default: PI_FAIL; } PI_makedouble(&rval,&rtype,(double) retval); if (PI_unify(arg6,type6,rval,rtype)) PI_SUCCEED; PI_FAIL; }
PassFail TestQueryID (TestInfo *pTestInfo) { TEST_DECLARE; char Heading[MAX_STRING_SIZE]; RETCODE returncode; SQLHANDLE henv, henv2; SQLHANDLE hdbc, hdbc2 = (SQLHANDLE)NULL; SQLHANDLE hstmt, hstmt2; int loop = 0; //char preparedStmt[1024]; char infoStatsStmt[ 1024 ]; SQLCHAR cursorName[ 1024 ]; CHAR jobid[SQL_MAX_SESSIONNAME_LEN]; CHAR queryID[256]; SQLINTEGER jobidlen; SQLLEN queryIDPtr; CHAR tempStr[256]; char *droptab = "DROP TABLE JOBID cascade"; char *createtab = "CREATE TABLE JOBID (C int) NO PARTITION"; char *inserttab = "INSERT INTO JOBID VALUES (10)"; char *selecttab = "SELECT * FROM JOBID"; struct { RETCODE returncode; CHAR *jobID; CHAR *jobIDExpected; } jobIDMatrix[] = { { SQL_SUCCESS, "1" , "1"}, { SQL_SUCCESS, "11" , "11"}, { SQL_SUCCESS, "" , "" }, { SQL_SUCCESS, "H" , "H" }, { SQL_SUCCESS, "hh" , "hh" }, { SQL_SUCCESS, "0" , "0" }, { SQL_SUCCESS, "_" , "_" }, { SQL_SUCCESS, "________________________" , "________________________" }, { SQL_SUCCESS, "odbcqa" , "odbcqa" }, { SQL_SUCCESS, "odbcqa00" , "odbcqa00" }, { SQL_SUCCESS, "00odbcqa" , "00odbcqa" }, { SQL_SUCCESS, "0123_HELLOKITTY" , "0123_HELLOKITTY" }, { SQL_SUCCESS, "_Hello_Kitty_123" , "_Hello_Kitty_123" }, { SQL_SUCCESS, "Hello_Kitty_Went_To_The_" , "Hello_Kitty_Went_To_The_" }, { SQL_SUCCESS, "Hello_Kitty_Went_To_The_" , "Hello_Kitty_Went_To_The_" }, { SQL_SUCCESS, "1234567890_1234567890" , "1234567890_1234567890" }, { SQL_SUCCESS, "123456789012345678901234" , "123456789012345678901234" }, { SQL_SUCCESS, "123456789012345678901234" , "123456789012345678901234" }, { SQL_SUCCESS, "1234567890123456789012345" , "123456789012345678901234" }, { SQL_SUCCESS, "Hello_Kitty_Went_To_The_Store_To_Buy" , "Hello_Kitty_Went_To_The_" }, { SQL_SUCCESS_WITH_INFO, " " , "" }, { SQL_SUCCESS_WITH_INFO, " HelloKitty" , "" }, { SQL_SUCCESS_WITH_INFO, "Hello Kitty" , "" }, { SQL_SUCCESS_WITH_INFO, "HelloKitty " , "" }, { SQL_SUCCESS_WITH_INFO, "1 2" , "" }, { SQL_SUCCESS_WITH_INFO, "12345.67890.123456789012" , "" }, { SQL_SUCCESS_WITH_INFO, "Hello$Kitty" , "" }, { SQL_SUCCESS_WITH_INFO, "\"HelloKitty\"" , "" }, { SQL_SUCCESS_WITH_INFO, "'HelloKitty'" , "" }, { SQL_SUCCESS_WITH_INFO, "\" \"" , "" }, { SQL_SUCCESS_WITH_INFO, "\"\"" , "" }, { SQL_SUCCESS_WITH_INFO, "\"#@*()-_=+[]{}|:;'<>,.?\"" , "" }, { -101 , "" , "" } }; //struct //{ // RETCODE rtc; // CHAR *queryID; // CHAR *queryIDExpected; //} queryIDMatrix[] = { // { SQL_SUCCESS, "HELLOKITTY" , "HELLOKITTY" }, // { SQL_SUCCESS, "H" , "H" }, // { SQL_SUCCESS, "HELLOKITTYWENTTOTHESTORETOBUYDRI" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" }, // { SQL_SUCCESS, "HELLOKITTYWENTTOTHESTORETOBUYDRINKSFORTHEPARTY" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" }, // { SQL_SUCCESS, "HelloKitty" , "HELLOKITTY" }, // { SQL_SUCCESS, "h" , "H" }, // { SQL_SUCCESS, "HelloKittyWentToTheStoreToBuyDri" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" }, // { SQL_SUCCESS, "HelloKittyWentToTheStoreToBuyDrinksForTheParty" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" }, // { SQL_SUCCESS, "H_1" , "H_1" }, // { SQL_SUCCESS, "HELLO_KITTY_1234" , "HELLO_KITTY_1234" }, // { SQL_SUCCESS, "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" }, // { SQL_SUCCESS, "HELLO_KITTY_1234_ABCDEFGHIJKLMNOPQRSTUVWXYZ" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" }, // { SQL_SUCCESS, "Hello_Kitty_1234" , "HELLO_KITTY_1234" }, // { SQL_SUCCESS, "Hello_Kitty_1234_abcdefghijklmno" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" }, // { SQL_SUCCESS, "Hello_Kitty_1234_abcdefghijklmnopqrstuvwxyz" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" }, // { SQL_SUCCESS, "\"HELLOKITTY\"" , "HELLOKITTY" }, // { SQL_SUCCESS, "\"H\"" , "H" }, // { SQL_SUCCESS, "\"HELLOKITTYWENTTOTHESTORETOBUYDRI\"" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" }, // { SQL_SUCCESS, "\"HELLOKITTYWENTTOTHESTORETOBUYDRINKSFORTHEPARTY\"" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" }, // { SQL_SUCCESS, "\"HelloKitty\"" , "HelloKitty" }, // { SQL_SUCCESS, "\"h\"" , "h" }, // { SQL_SUCCESS, "\"HelloKittyWentToTheStoreToBuyDri\"" , "HelloKittyWentToTheStoreToBuyDri" }, // { SQL_SUCCESS, "\"HelloKittyWentToTheStoreToBuyDrinksForTheParty\"" , "HelloKittyWentToTheStoreToBuyDri" }, // { SQL_SUCCESS, "\"H_1\"" , "H_1" }, // { SQL_SUCCESS, "\"HELLO_KITTY_1234\"" , "HELLO_KITTY_1234" }, // { SQL_SUCCESS, "\"HELLO_KITTY_1234_ABCDEFGHIJKLMNO\"" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" }, // { SQL_SUCCESS, "\"HELLO_KITTY_1234_ABCDEFGHIJKLMNOPQRSTUVWXYZ\"" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" }, // { SQL_SUCCESS, "\"Hello_Kitty_1234\"" , "Hello_Kitty_1234" }, // { SQL_SUCCESS, "\"Hello_Kitty_1234_abcdefghijklmno\"" , "Hello_Kitty_1234_abcdefghijklmno" }, // { SQL_SUCCESS, "\"Hello_Kitty_1234_abcdefghijklmnopqrstuvwxyz\"" , "Hello_Kitty_1234_abcdefghijklmno" }, // { SQL_SUCCESS, "\"Hello Kitty\"" , "Hello Kitty" }, // { SQL_SUCCESS, "\"Hello Kitty says \"\"MEOW!\"\"\"" , "Hello Kitty says \"MEOW\"" }, // { SQL_SUCCESS, "\"Hello Kitty's Pruse\"" , "Hello Kitty's Purse" }, // { SQL_SUCCESS, "\"CREATE\"" , "CREATE" }, // { SQL_SUCCESS, "\"SELECT * FROM T1\"" , "SELECT * FROM T1" }, // { SQL_ERROR , "" , "" }, // { SQL_ERROR , " " , "" }, // { SQL_ERROR , "1HelloKitty" , "" }, // { SQL_ERROR , "_A" , "" }, // { SQL_ERROR , "Hello Kitty" , "" }, // { SQL_ERROR , "Hello$Kitty" , "" }, // { SQL_ERROR , "\"\\HelloKitty\"" , "" }, // { SQL_ERROR , "\"$HelloKitty\"" , "" }, // { SQL_ERROR , "\" \"" , "" }, // { SQL_ERROR , "\"\"" , "" }, // { SQL_ERROR , "\"@*()-_=+[]{}|:;'<>,.?\"" , "" }, // { SQL_ERROR , "CREATE" , "" }, // { -101 , "" , "" } //}; //struct //{ // char* sqlStmt; //} sqlPrepareMatrix[] = { // { "CREATE CATALOG STMNT" }, // { "CREATE SCHEMA STMNT.TEST" }, // { "CREATE TABLE T2 ( C1 INTEGER NOT NULL NOT DROPPABLE, C2 INTEGER, PRIMARY KEY( C1 ) )" }, // { "CREATE INDEX T2_INDEX ON T2 ( C1 ) NO POPULATE" }, // { "CREATE PROCEDURE T2_PROC (IN IN1 TIME) EXTERNAL NAME 'Procs.N4210' EXTERNAL PATH '/usr/spjqa/Testware/Class' LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL NO ISOLATE" }, // { "CREATE VIEW T2_VIEW AS SELECT C1 FROM T2" }, // { "INSERT INTO T2 VALUES ( 1 , 1) " }, // { "SELECT C1 FROM T2" }, // { "UPDATE T2 SET C2 = 2 WHERE C1 = 1" }, // { "DELETE FROM T2" }, // { "ALTER INDEX T2_INDEX ON T2 ( C2 ) NO POPULATE" }, // { "ALTER TABLE T2 ( C1 INTEGER NOT NULL NOT DROPPABLE, C2 INTEGER NOT NULL, PRIMARY KEY( C1 ) )" }, // { "ALTER TRIGGER" }, // { "DROP SCHEMA STMT.TEST" }, // { "DROP CATALOG STMT" }, // { "DROP INDEX T2_INDEX" }, // { "DROP VIEW T2_VIEW" }, // { "DROP PROCEDURE T2_PROC" }, // { "DROP TABLE T2" }, // { "STOP" } //}; //====================================================================================================== LogMsg(LINEBEFORE+SHORTTIMESTAMP,"Begin testing API => JobID | QueryID | QueryID.cpp\n"); TEST_INIT; TESTCASE_BEGIN("Setup for JobID tests\n"); if(!FullConnectWithOptions(pTestInfo, CONNECT_ODBC_VERSION_3)) { LogMsg(NONE,"Unable to connect as ODBC3.0 application.\n"); TEST_FAILED; TEST_RETURN; } henv = pTestInfo->henv; hdbc = pTestInfo->hdbc; hstmt = (SQLHANDLE)pTestInfo->hstmt; returncode = SQLAllocStmt((SQLHANDLE)hdbc, &hstmt); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; TEST_RETURN; } returncode = SQLExecDirect(hstmt, (SQLCHAR*)droptab,SQL_NTS); returncode = SQLExecDirect(hstmt, (SQLCHAR*)createtab,SQL_NTS); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLExecDirect")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; TEST_RETURN; } returncode = SQLExecDirect(hstmt, (SQLCHAR*)inserttab,SQL_NTS); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLExecDirect")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; TEST_RETURN; } FullDisconnect(pTestInfo); TESTCASE_END; //====================================================================================================== sprintf(Heading,"Test positive functionality of SessionName, single connection\n"); TESTCASE_BEGIN( Heading); // Allocate Environment Handle returncode = SQLAllocEnv(&henv); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocEnv")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; TEST_RETURN; } returncode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetEnvAttr")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } // Allocate Connection handle returncode = SQLAllocConnect(henv,&hdbc); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocConnect")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } TESTCASE_END; loop = 0; while( jobIDMatrix[ loop ].returncode != -101 ) { sprintf(Heading,"Test #%d: Testing for jobID: %s\n", loop, jobIDMatrix[ loop ].jobID); TESTCASE_BEGIN( Heading); returncode = SQLSetConnectAttr(hdbc, (SQLINTEGER)SQL_ATTR_SESSIONNAME,(SQLCHAR*) jobIDMatrix[ loop ].jobID, SQL_NTS); if (jobIDMatrix[ loop ].returncode == SQL_SUCCESS) { if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetConnectAttr")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; loop++; continue; } } else { #ifdef unixcli if(returncode != SQL_ERROR) { #else if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetConnectAttr")) { #endif LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; loop++; continue; } } returncode = SQLGetConnectAttr(hdbc, (SQLINTEGER)SQL_ATTR_SESSIONNAME, jobid, SQL_MAX_SESSIONNAME_LEN, &jobidlen); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; loop++; continue; } if (jobIDMatrix[ loop ].returncode == SQL_SUCCESS) { if (strcmp(jobIDMatrix[ loop ].jobIDExpected, jobid) == 0) { LogMsg(NONE, "JobIDs are matched. Expected: \"%s\", Actual: \"%s\" for SQLGetConnectAttr\n", jobIDMatrix[ loop ].jobIDExpected, jobid); TESTCASE_END; } else { LogMsg(ERRMSG, "JobIDs are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for SQLGetConnectAttr\n", jobIDMatrix[ loop ].jobIDExpected, jobid, __LINE__); TEST_FAILED; } } else { #ifdef unixcli if (strcmp(jobIDMatrix[ loop ].jobIDExpected, jobid) == 0) { #else if (strcmp(jobIDMatrix[ loop ].jobID, jobid) == 0) { #endif LogMsg(NONE, "JobIDs are matched. Expected: \"%s\", Actual: \"%s\" for SQLGetConnectAttr\n", jobIDMatrix[ loop ].jobID, jobid); TESTCASE_END; } else { LogMsg(ERRMSG, "JobIDs are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for SQLGetConnectAttr\n", jobIDMatrix[ loop ].jobID, jobid, __LINE__); TEST_FAILED; } } returncode = SQLConnect(hdbc, (SQLCHAR*)pTestInfo->DataSource,(SWORD)strlen(pTestInfo->DataSource), (SQLCHAR*)pTestInfo->UserID,(SWORD)strlen(pTestInfo->UserID), (SQLCHAR*)pTestInfo->Password,(SWORD)strlen(pTestInfo->Password) ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLConnect")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } #ifndef unixcli if (jobIDMatrix[ loop ].returncode == SQL_SUCCESS_WITH_INFO) { if (returncode != jobIDMatrix[ loop ].returncode) { LogMsg(ERRMSG, "The retcode has to be SQL_SUCCESS_WITH_INFO, with the error message \"Driver's SQLSetConnectAttr failed.\" in it, at line=%d\n", __LINE__); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } // LogAllErrors(henv,hdbc,NULL); if (!FindError("IM006",henv,hdbc,NULL)) { LogMsg(ERRMSG, "Couldn't find state error IM006, with the error message \"Driver's SQLSetConnectAttr failed.\", at line=%d\n", __LINE__); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } } #endif returncode = SQLAllocStmt(hdbc,&hstmt); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLAllocStmt(hdbc,&hstmt2); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLPrepare( hstmt, (SQLCHAR *)selecttab, SQL_NTS ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLPrepare")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLGetCursorName(hstmt, cursorName, sizeof(cursorName), NULL ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLPrepare")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } //Get queryID sprintf( infoStatsStmt, "INFOSTATS %s", (char*)cursorName ); returncode = SQLBindCol( hstmt2, 1, SQL_C_CHAR, &queryID, 256, &queryIDPtr ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLExecDirect( hstmt2, (SQLCHAR *)infoStatsStmt, SQL_NTS ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLFetch( hstmt2 ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } LogMsg(NONE, "queryID: \"%s\"\n", queryID); SQLFreeStmt(hstmt2,SQL_CLOSE); SQLFreeStmt(hstmt2,SQL_UNBIND); //Get Jobid if(isCharSet || isUCS2) sprintf( infoStatsStmt, "SELECT queryid_extract( _ISO88591'%s',_ISO88591'SESSIONNAME') FROM JOBID", (char*)queryID ); else sprintf( infoStatsStmt, "SELECT queryid_extract('%s','SESSIONNAME') FROM JOBID", (char*)queryID ); returncode = SQLBindCol( hstmt2, 1, SQL_C_CHAR, &queryID, 256, &queryIDPtr ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLExecDirect( hstmt2, (SQLCHAR *)infoStatsStmt, SQL_NTS ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLFetch( hstmt2 ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } LogMsg(NONE, "JobID: \"%s\"\n", queryID); if (strcmp(jobIDMatrix[ loop ].jobIDExpected, queryID) == 0) { LogMsg(NONE, "JobIDs are matched. Expected: \"%s\", Actual: \"%s\" for after queryid_extract\n", jobIDMatrix[ loop ].jobIDExpected, queryID); TESTCASE_END; } else { LogMsg(ERRMSG, "JobIDs are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for after queryid_extract\n", jobIDMatrix[ loop ].jobIDExpected, queryID, __LINE__); TEST_FAILED; } SQLFreeStmt(hstmt,SQL_CLOSE); SQLFreeStmt(hstmt,SQL_UNBIND); SQLFreeStmt(hstmt2,SQL_CLOSE); SQLFreeStmt(hstmt2,SQL_UNBIND); returncode = SQLDisconnect(hdbc); if (returncode != SQL_SUCCESS) { LogAllErrors(henv,hdbc,hstmt); SQLDisconnect(hdbc); SQLFreeConnect(hdbc); SQLFreeEnv(henv); } loop++; } returncode = SQLFreeConnect(hdbc); if (returncode != SQL_SUCCESS) { LogAllErrors(henv,hdbc,hstmt); SQLDisconnect(hdbc); SQLFreeConnect(hdbc); SQLFreeEnv(henv); } returncode = SQLFreeEnv(henv); if (returncode != SQL_SUCCESS) { LogAllErrors(henv,hdbc,hstmt); SQLDisconnect(hdbc); SQLFreeConnect(hdbc); SQLFreeEnv(henv); } //====================================================================================================== sprintf(Heading,"Test positive functionality of SessionName, mutiple connection using the same session name\n"); TESTCASE_BEGIN( Heading); // Allocate Environment Handle returncode = SQLAllocEnv(&henv); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocEnv")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; TEST_RETURN; } returncode = SQLAllocEnv(&henv2); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocEnv2")) { LogAllErrors(henv2,hdbc2,hstmt2); TEST_FAILED; TEST_RETURN; } returncode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetEnvAttr")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLSetEnvAttr(henv2, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetEnvAttr2")) { LogAllErrors(henv2,hdbc2,hstmt2); SQLFreeEnv(henv2); TEST_FAILED; TEST_RETURN; } // Allocate Connection handle returncode = SQLAllocConnect(henv,&hdbc); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocConnect")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLAllocConnect(henv2,&hdbc2); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocConnect2")) { LogAllErrors(henv2,hdbc2,hstmt2); SQLFreeEnv(henv2); TEST_FAILED; TEST_RETURN; } TESTCASE_END; strcpy(tempStr,"123456789012345678901234"); sprintf(Heading,"Testing for jobID: %s\n", tempStr); TESTCASE_BEGIN( Heading); returncode = SQLSetConnectAttr(hdbc, (SQLINTEGER)SQL_ATTR_SESSIONNAME,(SQLCHAR*) tempStr, SQL_NTS); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; TEST_RETURN; } returncode = SQLSetConnectAttr(hdbc2, (SQLINTEGER)SQL_ATTR_SESSIONNAME,(SQLCHAR*) tempStr, SQL_NTS); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr2")) { LogAllErrors(henv2,hdbc2,hstmt2); TEST_FAILED; TEST_RETURN; } returncode = SQLGetConnectAttr(hdbc, (SQLINTEGER)SQL_ATTR_SESSIONNAME, jobid, SQL_MAX_SESSIONNAME_LEN, &jobidlen); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr")) { LogAllErrors(henv,hdbc,hstmt); TEST_FAILED; } if (strcmp(tempStr, jobid) == 0) { LogMsg(NONE, "JobID1 are matched. Expected: \"%s\", Actual: \"%s\" for hdbc\n", tempStr, jobid); } else { LogMsg(ERRMSG, "JobID1 are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for hdbc\n", tempStr, jobid, __LINE__); TEST_FAILED; TEST_RETURN; } returncode = SQLGetConnectAttr(hdbc2, (SQLINTEGER)SQL_ATTR_SESSIONNAME, jobid, SQL_MAX_SESSIONNAME_LEN, &jobidlen); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr2")) { LogAllErrors(henv2,hdbc2,hstmt2); TEST_FAILED; TEST_RETURN; } if (strcmp(tempStr, jobid) == 0) { LogMsg(NONE, "JobID2 are matched. Expected: \"%s\", Actual: \"%s\" for hdbc2\n", tempStr, jobid); } else { LogMsg(ERRMSG, "JobID2 are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for hdbc2\n", tempStr, jobid, __LINE__); TEST_FAILED; TEST_RETURN; } returncode = SQLConnect(hdbc, (SQLCHAR*)pTestInfo->DataSource,(SWORD)strlen(pTestInfo->DataSource), (SQLCHAR*)pTestInfo->UserID,(SWORD)strlen(pTestInfo->UserID), (SQLCHAR*)pTestInfo->Password,(SWORD)strlen(pTestInfo->Password) ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLConnect")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLConnect(hdbc2, (SQLCHAR*)pTestInfo->DataSource,(SWORD)strlen(pTestInfo->DataSource), (SQLCHAR*)pTestInfo->UserID,(SWORD)strlen(pTestInfo->UserID), (SQLCHAR*)pTestInfo->Password,(SWORD)strlen(pTestInfo->Password) ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLConnect2")) { LogAllErrors(henv2,hdbc2,hstmt2); SQLFreeConnect(hdbc2); SQLFreeEnv(henv2); TEST_FAILED; TEST_RETURN; } for (loop=0; loop<2; loop++) { if (loop == 0) { returncode = SQLAllocStmt(hdbc,&hstmt); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLAllocStmt(hdbc,&hstmt2); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt3")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } } else { returncode = SQLAllocStmt(hdbc2,&hstmt); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) { LogAllErrors(henv2,hdbc2,hstmt); SQLFreeConnect(hdbc2); SQLFreeEnv(henv2); TEST_FAILED; TEST_RETURN; } returncode = SQLAllocStmt(hdbc2,&hstmt2); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt3")) { LogAllErrors(henv2,hdbc2,hstmt2); SQLFreeConnect(hdbc2); SQLFreeEnv(henv2); TEST_FAILED; TEST_RETURN; } } returncode = SQLPrepare( hstmt, (SQLCHAR *)selecttab, SQL_NTS ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLPrepare")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLGetCursorName(hstmt, cursorName, sizeof(cursorName), NULL ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLPrepare")) { LogAllErrors(henv,hdbc,hstmt); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } //Get queryID sprintf( infoStatsStmt, "INFOSTATS %s", (char*)cursorName ); returncode = SQLBindCol( hstmt2, 1, SQL_C_CHAR, &queryID, 256, &queryIDPtr ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLExecDirect( hstmt2, (SQLCHAR *)infoStatsStmt, SQL_NTS ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLFetch( hstmt2 ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } LogMsg(NONE, "queryID%d: \"%s\"\n", loop, queryID); SQLFreeStmt(hstmt2,SQL_CLOSE); SQLFreeStmt(hstmt2,SQL_UNBIND); //Get Jobid if(isCharSet || isUCS2) sprintf( infoStatsStmt, "SELECT queryid_extract( _ISO88591'%s', _ISO88591'SESSIONNAME') FROM JOBID", (char*)queryID ); else sprintf( infoStatsStmt, "SELECT queryid_extract('%s','SESSIONNAME') FROM JOBID", (char*)queryID ); returncode = SQLBindCol( hstmt2, 1, SQL_C_CHAR, &queryID, 256, &queryIDPtr ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLExecDirect( hstmt2, (SQLCHAR *)infoStatsStmt, SQL_NTS ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } returncode = SQLFetch( hstmt2 ); if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) { LogAllErrors(henv,hdbc,hstmt2); SQLFreeConnect(hdbc); SQLFreeEnv(henv); TEST_FAILED; TEST_RETURN; } LogMsg(NONE, "JobID%d: \"%s\"\n", loop, queryID); if (strcmp(tempStr, queryID) == 0) { LogMsg(NONE, "JobID%d are matched. Expected: \"%s\", Actual: \"%s\" for after queryid_extract\n", loop, tempStr, queryID); TESTCASE_END; } else { LogMsg(ERRMSG, "JobID%d are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for after queryid_extract\n", loop, tempStr, queryID, __LINE__); TEST_FAILED; } SQLFreeStmt(hstmt,SQL_CLOSE); SQLFreeStmt(hstmt,SQL_UNBIND); SQLFreeStmt(hstmt2,SQL_CLOSE); SQLFreeStmt(hstmt2,SQL_UNBIND); } returncode = SQLDisconnect(hdbc); if (returncode != SQL_SUCCESS) { LogAllErrors(henv,hdbc,hstmt); SQLDisconnect(hdbc); SQLFreeConnect(hdbc); SQLFreeEnv(henv); } returncode = SQLDisconnect(hdbc2); if (returncode != SQL_SUCCESS) { LogAllErrors(henv2,hdbc2,hstmt2); SQLDisconnect(hdbc2); SQLFreeConnect(hdbc2); SQLFreeEnv(henv2); } returncode = SQLFreeConnect(hdbc); if (returncode != SQL_SUCCESS) { LogAllErrors(henv,hdbc,hstmt); SQLDisconnect(hdbc); SQLFreeConnect(hdbc); SQLFreeEnv(henv); } returncode = SQLFreeConnect(hdbc2); if (returncode != SQL_SUCCESS) { LogAllErrors(henv2,hdbc2,hstmt2); SQLDisconnect(hdbc2); SQLFreeConnect(hdbc2); SQLFreeEnv(henv2); } returncode = SQLFreeEnv(henv); if (returncode != SQL_SUCCESS) { LogAllErrors(henv,hdbc,hstmt); SQLDisconnect(hdbc); SQLFreeConnect(hdbc); SQLFreeEnv(henv); } returncode = SQLFreeEnv(henv2); if (returncode != SQL_SUCCESS) { LogAllErrors(henv2,hdbc2,hstmt2); SQLDisconnect(hdbc2); SQLFreeConnect(hdbc2); SQLFreeEnv(henv2); } //========================================================================================= //FullDisconnect(pTestInfo); LogMsg(SHORTTIMESTAMP+LINEAFTER,"End testing API => JobID.\n"); TEST_RETURN; }
/* --------------------------------------------------------- TestSQLDrivers No negative tests since this functionality is done at driver manager level. --------------------------------------------------------- */ PassFail TestInfoStats(TestInfo *pTestInfo) { TEST_DECLARE; SQLHANDLE secHandle; SQLSMALLINT outLen = SQL_NTS; char tempStr[MAX_STR_LEN*2]; int i,j; char cursorName[MAX_STR_LEN] = ""; RETCODE returncode; char* strs[5]; struct _test_data { char front[2]; char back[MAX_SIZE]; RETCODE retcode; BOOL cursor; char *stmt; } testData[] = {{"", "", SQL_SUCCESS, TRUE, ""}, {"", "", SQL_SUCCESS, TRUE, ""}, {"", "", SQL_SUCCESS, TRUE, ""}, {"", "SQL_CUR_2", SQL_ERROR, FALSE, ""}, {"", "", SQL_ERROR, FALSE, ""}, // empty statement {"'", "'", SQL_SUCCESS, TRUE, ""}, {"\"", "\"", SQL_SUCCESS, TRUE, ""}, {"", "SQL_CUR_9 ",SQL_ERROR, FALSE, ""}, {"\"", "", SQL_ERROR, TRUE, ""}, {"\"", "\"", SQL_SUCCESS, FALSE, ""}, // strs[3].txt {"'", "'", SQL_SUCCESS, FALSE, ""}, // strs[3].txt {"'", "", SQL_ERROR, FALSE, ""}, // strs[3].txt {"\"", "", SQL_ERROR, FALSE, ""}, // strs[3].txt {"", "\"", SQL_ERROR, FALSE, ""}, // strs[3].txt {"", "'", SQL_ERROR, FALSE, ""}, // strs[3].txt {"'", "'", SQL_ERROR, FALSE, ""}, // strs[4].txt {"\"", "\"", SQL_ERROR, FALSE, ""}, // strs[4].txt {"", "end"} }; //=========================================================================================================== var_list_t *var_list; var_list = load_api_vars("InfoStats", charset_file); if (var_list == NULL) return FAILED; strs[0] = var_mapping("InfoStats_strs_0", var_list); strs[1] = var_mapping("InfoStats_strs_1", var_list); strs[2] = var_mapping("InfoStats_strs_2", var_list); strs[3] = var_mapping("InfoStats_strs_3", var_list); strs[4] = var_mapping("InfoStats_strs_4", var_list); strs[5] = var_mapping("InfoStats_strs_5", var_list); testData[9].stmt = strs[3]; testData[10].stmt = strs[3]; testData[11].stmt = strs[3]; testData[12].stmt = strs[3]; testData[13].stmt = strs[3]; testData[14].stmt = strs[3]; testData[15].stmt = strs[4]; testData[16].stmt = strs[4]; //=========================================================================================================== LogMsg(LINEBEFORE+SHORTTIMESTAMP,"Begin testing => InfoStats | InfoStats | infostats.cpp\n"); TEST_INIT; if(!FullConnectWithOptions(pTestInfo, CONNECT_ODBC_VERSION_3)) { LogMsg(NONE,"Unable to connect\n"); TEST_FAILED; TEST_RETURN; } returncode = SQLAllocStmt((SQLHANDLE)pTestInfo->hdbc, &(pTestInfo->hstmt)); if (returncode != SQL_SUCCESS) { TEST_FAILED; TEST_RETURN; } returncode = SQLAllocStmt((SQLHANDLE)pTestInfo->hdbc, &secHandle); if(returncode != SQL_SUCCESS) { TEST_FAILED; TEST_RETURN; } for(j = 0; j < 2; j++) { i = 0; while (strcmp(testData[i].back,"end")!=0) { if((j == 0) || (i==0)) { // setup table and data LogMsg(NONE,"Setting up table and data\n"); returncode = SQLExecDirect(pTestInfo->hstmt, (SQLCHAR*)strs[0], SQL_NTS); returncode = SQLExecDirect(pTestInfo->hstmt, (SQLCHAR*)strs[1], SQL_NTS); returncode = SQLExecDirect(pTestInfo->hstmt, (SQLCHAR*)strs[2], SQL_NTS); returncode = SQLEndTran(SQL_HANDLE_DBC, pTestInfo->hdbc, SQL_COMMIT); returncode = SQLFreeStmt(pTestInfo->hstmt, SQL_CLOSE); } returncode = SQLPrepare(pTestInfo->hstmt, (SQLCHAR*)strs[3], SQL_NTS); strcpy(cursorName, ""); returncode = SQLGetCursorName(pTestInfo->hstmt, (SQLCHAR*)cursorName, sizeof(cursorName), &outLen); if(returncode != SQL_SUCCESS) LogAllErrors(pTestInfo->henv, pTestInfo->hdbc, pTestInfo->hstmt); returncode = SQLExecute(pTestInfo->hstmt); sprintf(tempStr, "Starting test number %d\n", i); TESTCASE_BEGIN(tempStr); if(testData[i].cursor == TRUE) sprintf(tempStr, "INFOSTATS %s%s%s", testData[i].front, cursorName, testData[i].back); else sprintf(tempStr, "INFOSTATS %s%s%s", testData[i].front, testData[i].stmt, testData[i].back); returncode = execute(pTestInfo, secHandle, tempStr, testData[i].retcode); if(returncode == FALSE) TEST_FAILED; returncode = SQLFreeStmt(secHandle, SQL_CLOSE); returncode = SQLFreeStmt(pTestInfo->hstmt,SQL_CLOSE); TESTCASE_END; i++; } returncode = SQLExecDirect(pTestInfo->hstmt, (SQLCHAR*)strs[0], SQL_NTS); } //========================================================================================== FullDisconnect3(pTestInfo); free_list(var_list); LogMsg(SHORTTIMESTAMP+LINEAFTER,"End testing => InfoStats.\n"); TEST_RETURN; }