AMPS:Oracle数据库操作模块源码解读

最新推荐文章于 2021-04-13 00:34:22 发布
最新推荐文章于 2021-04-13 00:34:22 发布
阅读量3.3k 收藏 1
点赞数 1
分类专栏： C/C++ ORACLE 消息中间件 AMPS源码解读
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/dyx1024/article/details/8543688
版权

  本节看看AMPS中对Oracle数据库进行操作的方法，使用的是Oracle的C访问接口OCI，关于OCI各函数的中文说明可参考这篇文章http://www.cnblogs.com/joeblackzqq/archive/2011/04/24/2026461.html

 下面看看AMPS中Oracle操作各函数实现:

 AMPS_Oracle.h

#ifndef __HEADER_AMPS_DB_ORACLE_H
#define __HEADER_AMPS_DB_ORACLE_H

#ifdef __cplusplus
extern "C" {
#endif

#include "AMPS_Defines.h"
#include "AMPS_LinkList.h"
#include "AMPS_MemMgt.h"
#include "AMPS_EventSystem.h"
#include "AMPS_Core.h"
#include "AMPS_API.h"

typedef struct _OracleContext					t_OracleContext;
typedef struct _OracleColumnData				t_OracleColumnData; 

#define ORACLE_MAX_SELECT_COLUMN_LIST_SIZE		1024
#define ORACLE_MAX_DB_PATH_SIZE					2048
#define ORACLE_SELECT_COUNT_QUERY_SIZE			4096

struct _OracleColumnData 
{
	unsigned char*	puchValue;
	signed int		nValueLen;
};

#ifdef WIN32
struct _OracleContext
{
	OCIEnv*					hOCIEnv;
	OCIError*				hOCIError;
	OCIServer*				hOCIServer;
	OCISvcCtx*				hOCISvcCtx;
	OCISession*				hOCISession;

	t_OracleColumnData		poOracleColumnData[ORACLE_MAX_SELECT_COLUMN_LIST_SIZE];

	unsigned char			puchDBPath[ORACLE_MAX_DB_PATH_SIZE];

	unsigned char			puchSelectCountQuery[ORACLE_SELECT_COUNT_QUERY_SIZE];
};
#endif

int Oracle_Init(void* r_pvAMPSContext, void* r_pvBDEngineContext);
void Oracle_Cleanup(void* r_pvAMPSContext, void* r_pvBDEngineContext);
int Oracle_Query(void* r_pvAMPSContext, void* r_pvBDEngineContext, const char* r_pcchQueryStatement, unsigned long r_ulLengthOfQuery, t_AMPSDBEngineResult* r_poAMPSDBEngineResult);
void Oracle_FreeResults(void* r_pvAMPSContext, void* r_pvBDEngineContext, t_AMPSDBEngineResult* r_poAMPSDBEngineResult);

void Oracle_CheckError(void* r_pvAMPSContext, void* r_pvBDEngineContext, signed int r_nStatus);
int Oracle_GetNumberOfRecords(void* r_pvAMPSContext, void* r_pvBDEngineContext, const char* r_pcchQueryStatement, unsigned long r_ulLengthOfQuery);

#ifdef __cplusplus
}
#endif

#endif //__HEADER_AMPS_DB_ORACLE_H

AMPS_Oracle.c 

#include "AMPS_DBEngine.h"
#include "AMPS_Oracle.h"

/*****************************************************************
函数名称: Oracle_Init
功能描述: Oracle数据库访问初始化函数
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文

出参:
      
返回值:
    int

*****************************************************************/
int Oracle_Init(void* r_pvAMPSContext, void* r_pvBDEngineContext)
{
#ifdef WIN32
	signed int nReturnCode = 0;
	t_OracleContext* poOracleContext = NULL;
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;

	//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_INFO, "Entering.\n");

	poOracleContext = (t_OracleContext*)AMPS_InternalMalloc(sizeof(t_OracleContext));
	if(NULL == poOracleContext)
	{
		TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for poOracleContext.\n");
		return AMPS_ERROR_FAILURE;
	}

	poBDEngineContext->poDBHandle = poOracleContext;

    /*创建OCI环境*/
	//allocate an environment handle
	nReturnCode = OCIEnvCreate((OCIEnv**)&poOracleContext->hOCIEnv, OCI_DEFAULT, NULL, NULL, NULL, NULL, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		printf("OCIEnvCreate failed with nReturnCode = %d.\n", nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*分配错误句柄OCIError */
	//allocate an error handle
	nReturnCode = OCIHandleAlloc((void*)poOracleContext->hOCIEnv, (void**)&poOracleContext->hOCIError, OCI_HTYPE_ERROR, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		printf("OCIHandleAlloc failed with nReturnCode = %d.\n", nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*分配服务器句柄OCIServer*/
	//allocate a server handle
	nReturnCode = OCIHandleAlloc((void*)poOracleContext->hOCIEnv, (void**)&poOracleContext->hOCIServer, OCI_HTYPE_SERVER, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

	//"//192.168.0.4:1521/orcl"
	sprintf(poOracleContext->puchDBPath, "//%s:1521/%s", poBDEngineContext->pchHostName, poBDEngineContext->pchDataBaseName);

    /*创建多用户连接*/
	//create a server context
	nReturnCode = OCIServerAttach(poOracleContext->hOCIServer, poOracleContext->hOCIError, (unsigned char*)poOracleContext->puchDBPath, strlen(poOracleContext->puchDBPath), 0);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}	

    /*分配服务器环境句柄*/
	//allocate a service handle
	nReturnCode = OCIHandleAlloc((void*)poOracleContext->hOCIEnv, (void**)&poOracleContext->hOCISvcCtx, OCI_HTYPE_SVCCTX, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*设置句柄OCI_HTYPE_SVCCTX的属性*/
    //set the server attribute in the service context handle
	nReturnCode = OCIAttrSet((void*)poOracleContext->hOCISvcCtx, OCI_HTYPE_SVCCTX, (void*)poOracleContext->hOCIServer, 0, OCI_ATTR_SERVER, (OCIError*)poOracleContext->hOCIError);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*分配用户会话句柄*/
	//allocate a user session handle
	nReturnCode = OCIHandleAlloc((void*)poOracleContext->hOCIEnv, (void**)&poOracleContext->hOCISession, OCI_HTYPE_SESSION, 0, NULL);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}
    
    /*设置数据库访问用户名*/
	//set username and password attributes in user session handle
	nReturnCode = OCIAttrSet((void*)poOracleContext->hOCISession, OCI_HTYPE_SESSION, (void*)poBDEngineContext->pchUserName, strlen((char*)poBDEngineContext->pchUserName), OCI_ATTR_USERNAME, poOracleContext->hOCIError);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}
    
    /*设置数据库访问密码*/
	nReturnCode = OCIAttrSet((void*)poOracleContext->hOCISession, OCI_HTYPE_SESSION, (void*)poBDEngineContext->pchPassword, strlen((char*)poBDEngineContext->pchPassword), OCI_ATTR_PASSWORD, poOracleContext->hOCIError);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*认证用户并建立连接*/
	//start the session
	nReturnCode = OCISessionBegin (poOracleContext->hOCISvcCtx, poOracleContext->hOCIError, poOracleContext->hOCISession, OCI_CRED_RDBMS, OCI_DEFAULT);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*设置用户属性*/
	//set the user session attribute in the service context handle
	nReturnCode = OCIAttrSet(poOracleContext->hOCISvcCtx, OCI_HTYPE_SVCCTX, poOracleContext->hOCISession, sizeof(OCISession*), OCI_ATTR_SESSION, poOracleContext->hOCIError);
	if(OCI_SUCCESS != nReturnCode) 
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}
	return AMPS_SUCCESS;
#else
	return AMPS_ERROR_FAILURE;
#endif
}

/*****************************************************************
函数名称: Oracle_Cleanup
功能描述: Oracle数据库访问销毁函数
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文

出参:
      
返回值:
    int

*****************************************************************/
void Oracle_Cleanup(void* r_pvAMPSContext, void* r_pvBDEngineContext)
{
#ifdef WIN32
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;
	t_OracleContext* poOracleContext = poBDEngineContext->poDBHandle;

	if(poOracleContext->hOCIEnv)
	{
		(void)OCIHandleFree((void*)poOracleContext->hOCIEnv, OCI_HTYPE_ENV);
	}
#endif
}

/*****************************************************************
函数名称: Oracle_GetNumberOfRecords
功能描述: 获取记录条数
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文
      const char* r_pcchQueryStatement SQL查询语句
      unsigned long r_ulLengthOfQuery SQL查询语句长度

出参:
      
返回值:
    int

*****************************************************************/
int Oracle_GetNumberOfRecords(void* r_pvAMPSContext, void* r_pvBDEngineContext, const char* r_pcchQueryStatement, unsigned long r_ulLengthOfQuery)
{
#ifdef WIN32
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;
	t_OracleContext* poOracleContext = poBDEngineContext->poDBHandle;
	signed int nReturnCode = OCI_ERROR;
	OCIStmt* hOCIStmtSelectCount = NULL;
	unsigned long ulLengthOfSelectCountQuery = 0;
	const char* pchPosition = NULL;

	OCIDefine* hOCIDefine = NULL;
	OCIParam* hOCIParam = NULL;
	unsigned int unSize = 0;
	unsigned int unNoOfColumns = 0;
	unsigned int unColumnCount = 0;
	unsigned int unRowCount = 0;
	t_AMPSDBEngineResult oAMPSDBEngineResult;

    /*查看SQL语句中是否有FROM关键字*/
	pchPosition = SAPI_StrCaseStr(r_pcchQueryStatement, "FROM");
	if(NULL == pchPosition)
	{
		return AMPS_ERROR_FAILURE;
	}

	memset(poOracleContext->puchSelectCountQuery, 0, ORACLE_SELECT_COUNT_QUERY_SIZE);
	sprintf(poOracleContext->puchSelectCountQuery, "Select Count(*) %s", pchPosition);

    /*创建语句句柄*/
	//allocate statement handle
	nReturnCode = OCIHandleAlloc(poOracleContext->hOCIEnv, (void**)&hOCIStmtSelectCount, OCI_HTYPE_STMT, 0, NULL);
	if(nReturnCode == OCI_SUCCESS)
	{
		ulLengthOfSelectCountQuery = strlen(poOracleContext->puchSelectCountQuery);

        /*准备SQL语句*/
        nReturnCode = OCIStmtPrepare(hOCIStmtSelectCount, poOracleContext->hOCIError, (unsigned char*)poOracleContext->puchSelectCountQuery, ulLengthOfSelectCountQuery, OCI_NTV_SYNTAX, OCI_DEFAULT);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}
	}

	memset(poOracleContext->poOracleColumnData, 0, (sizeof(t_OracleColumnData) * ORACLE_MAX_SELECT_COLUMN_LIST_SIZE));

    /*执行SQL语句*/
	nReturnCode = OCIStmtExecute(poOracleContext->hOCISvcCtx, hOCIStmtSelectCount, poOracleContext->hOCIError, 0, 0, NULL, NULL, OCI_DEFAULT);
	if(nReturnCode != OCI_SUCCESS)
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

    /*获取属性*/
	nReturnCode = OCIAttrGet(hOCIStmtSelectCount, OCI_HTYPE_STMT, &unNoOfColumns, NULL, OCI_ATTR_PARAM_COUNT, poOracleContext->hOCIError);
	if(nReturnCode != OCI_SUCCESS)
	{
		Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
		return AMPS_ERROR_FAILURE;
	}

	//get next column info
	for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
	{
		nReturnCode = OCIParamGet(hOCIStmtSelectCount, OCI_HTYPE_STMT, poOracleContext->hOCIError, (void**)&hOCIParam, unColumnCount + 1);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}

		// maximum data size in bytes
		unSize = 0;
		nReturnCode = OCIAttrGet(hOCIParam, OCI_DTYPE_PARAM, &unSize, NULL, OCI_ATTR_DATA_SIZE, poOracleContext->hOCIError);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}

		poOracleContext->poOracleColumnData[unColumnCount].puchValue = AMPS_InternalMalloc(unSize + 1);
		poOracleContext->poOracleColumnData[unColumnCount].nValueLen = unSize;
		memset(poOracleContext->poOracleColumnData[unColumnCount].puchValue, 0, poOracleContext->poOracleColumnData[unColumnCount].nValueLen);

        /*定义输出变量*/
		nReturnCode = OCIDefineByPos(hOCIStmtSelectCount, &hOCIDefine, poOracleContext->hOCIError, unColumnCount + 1, poOracleContext->poOracleColumnData[unColumnCount].puchValue, unSize, STRING_TYPE, NULL, NULL, NULL, OCI_DEFAULT);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}
	}

	oAMPSDBEngineResult.ulNumberOfColumns = unNoOfColumns;
	oAMPSDBEngineResult.ulNumberOfRows = 100;
	oAMPSDBEngineResult.ulNumberOfResults = oAMPSDBEngineResult.ulNumberOfRows;

	if (0 < oAMPSDBEngineResult.ulNumberOfRows) 
	{
		oAMPSDBEngineResult.ppoAMPSDBEngineTable = (t_AMPSDBEngineTable**)AMPS_InternalMalloc(sizeof(t_AMPSDBEngineTable*) * oAMPSDBEngineResult.ulNumberOfRows);
		if(NULL == oAMPSDBEngineResult.ppoAMPSDBEngineTable)
		{
			//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for r_poBDEngineResult->ppoAMPSDBEngineTable.\n");
			return AMPS_ERROR_FAILURE;
		}

		//printf("\n\n r_poBDEngineResult->ulNumberOfRows is %ld  r_poBDEngineResult->ulNumberOfColumns %ld and r_poBDEngineResult->ppoAMPSDBEngineTable %p\n\n",r_poBDEngineResult->ulNumberOfRows, r_poBDEngineResult->ulNumberOfColumns, r_poBDEngineResult->ppoAMPSDBEngineTable);

		for(unRowCount = 0; unRowCount < oAMPSDBEngineResult.ulNumberOfRows; unRowCount++)
		{
            /*逐行提取结果*/
			nReturnCode = OCIStmtFetch(hOCIStmtSelectCount, poOracleContext->hOCIError, 1, OCI_FETCH_NEXT, OCI_DEFAULT);
			if(nReturnCode != OCI_SUCCESS)
			{
				Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
				break;
			}

			oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount] = (t_AMPSDBEngineTable*)AMPS_InternalMalloc(sizeof(t_AMPSDBEngineTable) * oAMPSDBEngineResult.ulNumberOfColumns);
			if(NULL == oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount])
			{
				//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter].\n");
				return AMPS_ERROR_FAILURE;
			}
			//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "Pointer = %p.\n",  r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter]);

			for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
			{
				//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Column %u is %lu bytes in length and value %s.\n", (ulColumnCounter + 1), pulLengthOfField[ulColumnCounter], oMYSQLRow[ulColumnCounter]);

				oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount][unColumnCount].pchField = AMPS_InternalMalloc(poOracleContext->poOracleColumnData[unColumnCount].nValueLen);
				oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount][unColumnCount].nLengthOfField = poOracleContext->poOracleColumnData[unColumnCount].nValueLen;
				//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Field Length = %d.\n", r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][ulColumnCounter].nLengthOfField);

				memcpy(oAMPSDBEngineResult.ppoAMPSDBEngineTable[unRowCount][unColumnCount].pchField, poOracleContext->poOracleColumnData[unColumnCount].puchValue, poOracleContext->poOracleColumnData[unColumnCount].nValueLen);
				//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Filed Value = %s.\n", r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][ulColumnCounter].pchField);
			}
		}

		oAMPSDBEngineResult.ulNumberOfRows = atoi(oAMPSDBEngineResult.ppoAMPSDBEngineTable[0][0].pchField);
	}
	if(hOCIParam)
	{
		//ignore result code
		OCIDescriptorFree(hOCIParam, OCI_DTYPE_PARAM);
	}
	for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
	{
		if(NULL != poOracleContext->poOracleColumnData[unColumnCount].puchValue)
		{
			AMPS_InternalFree(poOracleContext->poOracleColumnData[unColumnCount].puchValue);
			poOracleContext->poOracleColumnData[unColumnCount].nValueLen = 0;
		}
	}
	return(oAMPSDBEngineResult.ulNumberOfRows);
#endif
	return 0;
}

/*****************************************************************
函数名称: Oracle_Query
功能描述: 执行SQL查询语句
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文
      const char* r_pcchQueryStatement SQL查询语句
      unsigned long r_ulLengthOfQuery SQL查询语句长度
      t_AMPSDBEngineResult* r_poAMPSDBEngineResult 结果集

出参:
      
返回值:
    int

*****************************************************************/
int Oracle_Query(void* r_pvAMPSContext, void* r_pvBDEngineContext, const char* r_pcchQueryStatement, unsigned long r_ulLengthOfQuery, t_AMPSDBEngineResult* r_poAMPSDBEngineResult)
{
#ifdef WIN32
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;
	t_OracleContext* poOracleContext = poBDEngineContext->poDBHandle;
	OCIStmt* hOCIStmt = NULL;
	signed int nReturnCode = OCI_ERROR;

	//allocate statement handle
	nReturnCode = OCIHandleAlloc(poOracleContext->hOCIEnv, (void**)&hOCIStmt, OCI_HTYPE_STMT, 0, NULL);
	if(nReturnCode == OCI_SUCCESS)
	{
		if(r_ulLengthOfQuery == -1)
		{
			r_ulLengthOfQuery = strlen(r_pcchQueryStatement);
		}
		nReturnCode = OCIStmtPrepare(hOCIStmt, poOracleContext->hOCIError, (unsigned char*)r_pcchQueryStatement, r_ulLengthOfQuery, OCI_NTV_SYNTAX, OCI_DEFAULT);
		if(nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}
	}
	if(nReturnCode == OCI_SUCCESS)
	{
		unsigned short ushStmtType = 0;
		nReturnCode = OCIAttrGet(hOCIStmt, OCI_HTYPE_STMT, &ushStmtType, NULL, OCI_ATTR_STMT_TYPE, poOracleContext->hOCIError);
		if (nReturnCode != OCI_SUCCESS)
		{
			Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			return AMPS_ERROR_FAILURE;
		}
		// returns 0 (ST_UNKNOWN) if sql statement is wrong
		//TODO
		if(OCI_STMT_SELECT == ushStmtType)
		{
			//Define array of define structure
			//t_ColumnData poColumnDataDef[MAX_SELECT_LIST_SIZE];
			OCIDefine* hOCIDefine = NULL;
			OCIParam* hOCIParam = NULL;
			unsigned int unSize = 0;
			unsigned int unNoOfColumns = 0;
			unsigned int unColumnCount = 0;
			unsigned int unRowCount = 0;

			memset(poOracleContext->poOracleColumnData, 0, (sizeof(t_OracleColumnData) * ORACLE_MAX_SELECT_COLUMN_LIST_SIZE));

			unRowCount = (unsigned int)Oracle_GetNumberOfRecords(r_pvAMPSContext, r_pvBDEngineContext, r_pcchQueryStatement, r_ulLengthOfQuery);
			if(0 == unRowCount)
			{
				return AMPS_ERROR_FAILURE;
			}

			nReturnCode = OCIStmtExecute(poOracleContext->hOCISvcCtx, hOCIStmt, poOracleContext->hOCIError, 0, 0, NULL, NULL, OCI_DEFAULT);
			if(nReturnCode != OCI_SUCCESS)
			{
				Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
				return AMPS_ERROR_FAILURE;
			}

			nReturnCode = OCIAttrGet(hOCIStmt, OCI_HTYPE_STMT, &unNoOfColumns, NULL, OCI_ATTR_PARAM_COUNT, poOracleContext->hOCIError);
			if(nReturnCode != OCI_SUCCESS)
			{
				Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
				return AMPS_ERROR_FAILURE;
			}

			//get next column info
			for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
			{
				nReturnCode = OCIParamGet(hOCIStmt, OCI_HTYPE_STMT, poOracleContext->hOCIError, (void**)&hOCIParam, unColumnCount + 1);
				if(nReturnCode != OCI_SUCCESS)
				{
					Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
					return AMPS_ERROR_FAILURE;
				}

				// maximum data size in bytes
				unSize = 0;
				nReturnCode = OCIAttrGet(hOCIParam, OCI_DTYPE_PARAM, &unSize, NULL, OCI_ATTR_DATA_SIZE, poOracleContext->hOCIError);
				if(nReturnCode != OCI_SUCCESS)
				{
					Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
					return AMPS_ERROR_FAILURE;
				}

				poOracleContext->poOracleColumnData[unColumnCount].puchValue = AMPS_InternalMalloc(unSize + 1);
				poOracleContext->poOracleColumnData[unColumnCount].nValueLen = unSize;
				memset(poOracleContext->poOracleColumnData[unColumnCount].puchValue, 0, poOracleContext->poOracleColumnData[unColumnCount].nValueLen);

				nReturnCode = OCIDefineByPos(hOCIStmt, &hOCIDefine, poOracleContext->hOCIError, unColumnCount + 1, poOracleContext->poOracleColumnData[unColumnCount].puchValue, unSize, STRING_TYPE, NULL, NULL, NULL, OCI_DEFAULT);
				if(nReturnCode != OCI_SUCCESS)
				{
					Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
					return AMPS_ERROR_FAILURE;
				}
			}

			r_poAMPSDBEngineResult->ulNumberOfColumns = unNoOfColumns;
			r_poAMPSDBEngineResult->ulNumberOfRows = unRowCount;
			r_poAMPSDBEngineResult->ulNumberOfResults = r_poAMPSDBEngineResult->ulNumberOfRows;

			if (0 < r_poAMPSDBEngineResult->ulNumberOfRows) 
			{
				r_poAMPSDBEngineResult->ppoAMPSDBEngineTable = (t_AMPSDBEngineTable**)AMPS_InternalMalloc(sizeof(t_AMPSDBEngineTable*) * r_poAMPSDBEngineResult->ulNumberOfRows);
				if(NULL == r_poAMPSDBEngineResult->ppoAMPSDBEngineTable)
				{
					//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for r_poBDEngineResult->ppoAMPSDBEngineTable.\n");
					return AMPS_ERROR_FAILURE;
				}

				//printf("\n\n r_poBDEngineResult->ulNumberOfRows is %ld  r_poBDEngineResult->ulNumberOfColumns %ld and r_poBDEngineResult->ppoAMPSDBEngineTable %p\n\n",r_poBDEngineResult->ulNumberOfRows, r_poBDEngineResult->ulNumberOfColumns, r_poBDEngineResult->ppoAMPSDBEngineTable);

				for(unRowCount = 0; unRowCount < r_poAMPSDBEngineResult->ulNumberOfRows; unRowCount++)
				{
					nReturnCode = OCIStmtFetch(hOCIStmt, poOracleContext->hOCIError, 1, OCI_FETCH_NEXT, OCI_DEFAULT);
					if(nReturnCode != OCI_SUCCESS)
					{
						Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
						break;
					}

					r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount] = (t_AMPSDBEngineTable*)AMPS_InternalMalloc(sizeof(t_AMPSDBEngineTable) * r_poAMPSDBEngineResult->ulNumberOfColumns);
					if(NULL == r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount])
					{
						//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "AMPS_InternalMalloc failed for r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter].\n");
						return AMPS_ERROR_FAILURE;
					}
					//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "Pointer = %p.\n",  r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter]);

					for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
					{
						//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Column %u is %lu bytes in length and value %s.\n", (ulColumnCounter + 1), pulLengthOfField[ulColumnCounter], oMYSQLRow[ulColumnCounter]);

						r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount][unColumnCount].pchField = AMPS_InternalMalloc(poOracleContext->poOracleColumnData[unColumnCount].nValueLen);
						r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount][unColumnCount].nLengthOfField = poOracleContext->poOracleColumnData[unColumnCount].nValueLen;
						//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Field Length = %d.\n", r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][ulColumnCounter].nLengthOfField);

						memcpy(r_poAMPSDBEngineResult->ppoAMPSDBEngineTable[unRowCount][unColumnCount].pchField, poOracleContext->poOracleColumnData[unColumnCount].puchValue, poOracleContext->poOracleColumnData[unColumnCount].nValueLen);
						//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Filed Value = %s.\n", r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][ulColumnCounter].pchField);
					}
				}

				r_poAMPSDBEngineResult->ulNumberOfRows = unRowCount;
			}
			if(hOCIParam)
			{
				//ignore result code
				OCIDescriptorFree(hOCIParam, OCI_DTYPE_PARAM);
			}
			for(unColumnCount = 0; unColumnCount < unNoOfColumns; unColumnCount++)
			{
				if(NULL != poOracleContext->poOracleColumnData[unColumnCount].puchValue)
				{
					AMPS_InternalFree(poOracleContext->poOracleColumnData[unColumnCount].puchValue);
					poOracleContext->poOracleColumnData[unColumnCount].nValueLen = 0;
				}
			}
		}
		else
		{
			nReturnCode = OCIStmtExecute(poOracleContext->hOCISvcCtx, hOCIStmt, poOracleContext->hOCIError, 1, 0, NULL, NULL, OCI_COMMIT_ON_SUCCESS);
			if (nReturnCode != OCI_SUCCESS)
			{
				Oracle_CheckError(r_pvAMPSContext, r_pvBDEngineContext, nReturnCode);
			}
		}
	}

#endif
	return AMPS_SUCCESS;
}

/*****************************************************************
函数名称: Oracle_FreeResults
功能描述: 释放查询结果集
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文
      const char* r_pcchQueryStatement SQL查询语句
      unsigned long r_ulLengthOfQuery SQL查询语句长度

出参:
      
返回值:
    int

*****************************************************************/
void Oracle_FreeResults(void* r_pvAMPSContext, void* r_pvBDEngineContext, t_AMPSDBEngineResult* r_poBDEngineResult)
{
#ifdef WIN32
	unsigned long ulRowCounter = 0;
	unsigned long unColumnCounter = 0;

	//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_INFO, "Entering.\n");

	//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "No of Rows %lu.\n", r_poBDEngineResult->ulNumberOfRows);

	if (0 < r_poBDEngineResult->ulNumberOfRows) 
	{
		for(ulRowCounter = 0; ulRowCounter < r_poBDEngineResult->ulNumberOfRows; ulRowCounter++)
		{
			for(unColumnCounter = 0; unColumnCounter < r_poBDEngineResult->ulNumberOfColumns; unColumnCounter++)
			{
				AMPS_InternalFree(r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][unColumnCounter].pchField);
				r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter][unColumnCounter].nLengthOfField = 0;
			}
			//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_DEBUG, "Free Counter %lu.\n", ulRowCounter);
			//TRACE( DBE_TRACE_ID(r_pvAMPSContext), AMPS_TRACE_LEVEL_ERROR, "Pointer = %p.\n",  r_poBDEngineResult)->ppoAMPSDBEngineTable[ulRowCounter]);
			AMPS_InternalFree(r_poBDEngineResult->ppoAMPSDBEngineTable[ulRowCounter]);
		}

		r_poBDEngineResult->ulNumberOfColumns = 0;
		r_poBDEngineResult->ulNumberOfRows = 0;
		r_poBDEngineResult->ulNumberOfResults = 0;

		AMPS_InternalFree(r_poBDEngineResult->ppoAMPSDBEngineTable);
	}
	//mysql_free_result(r_poBDEngineResult->pvResultObj);
#endif
}

/*****************************************************************
函数名称: Oracle_CheckError
功能描述: 错误处理函数
入参::
      void* r_pvAMPSContext APMS应用上下文
      void* r_pvBDEngineContext  数据库应用上下文
      signed int r_nStatus 错误码


出参:
      
返回值:
    int

*****************************************************************/
void Oracle_CheckError(void* r_pvAMPSContext, void* r_pvBDEngineContext, signed int r_nStatus)
{
#ifdef WIN32
	t_BDEngineContext* poBDEngineContext = r_pvBDEngineContext;
	t_OracleContext* poOracleContext = poBDEngineContext->poDBHandle;
	unsigned char puchErrorBufer[512];
	signed int nErrorCode = 0;

	switch (r_nStatus)
	{
		case OCI_SUCCESS:
			break;
		case OCI_SUCCESS_WITH_INFO:
			printf("Error - OCI_SUCCESS_WITH_INFO\n");
			break;
		case OCI_NEED_DATA:
			printf("Error - OCI_NEED_DATA\n");
			break;
		case OCI_NO_DATA:
			printf("Error - OCI_NODATA\n");
			break;
		case OCI_ERROR:
			OCIErrorGet((void*)poOracleContext->hOCIError, 1, (unsigned char*) NULL, &nErrorCode, puchErrorBufer, sizeof(puchErrorBufer), OCI_HTYPE_ERROR);
			printf("Error - %.*s\n", 512, puchErrorBufer);
			break;
		case OCI_INVALID_HANDLE:
			printf("Error - OCI_INVALID_HANDLE\n");
			break;
		case OCI_STILL_EXECUTING:
			printf("Error - OCI_STILL_EXECUTE\n");
			break;
		case OCI_CONTINUE:
			printf("Error - OCI_CONTINUE\n");
			break;
		default:
			break;
	}
#endif
}


socrates
关注
专栏目录
OCIEnvCreate 失败,返回代码为 -1,但错误消息文本不可用 问题处理
weixin_30949361的博客
12-17 1872
OCIEnvCreate 失败,返回代码为 -1,但错误消息文本不可用 问题处理如下： 解决方法一：更换连接方式 config 文件配置： <add name="MASTER_DB" connectionString="Provider=MSDAORA;Data Source=jhemr;Password=jhemr;User ID=jhemr;" providerName="Sys...
java jdbc 连接oracle数据库连接报错ORA-12505,Listener refused the connection with the following error:
weixin_39172079的博客
06-14 1809
java.sql.SQLException:Listener refused the connection with the following error:ORA-12505错误日志问题分析最后强调：SID != SERVICE_NAME 错误日志 java.sql.SQLException:Listener refused the connection with the following...
C#中连接Oracle数据库时提示OCIEnvCreate 失败，返回代码为 -1，但错误消息文本不可用。
greatfeather的专栏
03-10 3956
本文讲述了在C#中当使用OracleClient连接数据库时提示“OCIEnvCreate 失败，返回代码为 -1，但错误消息文本不可用。”时的另类解决方案。
oracle ocienvcreate,OCIEnvCreate 失败，返回代码为 -1的解决方法
weixin_30466329的博客
04-13 3281
错误描述连接Oracle始终报这个错误:{System.Exception: OCIEnvCreate 失败，返回代码为 -1，但错误消息文本不可用本机环境是oracle10g客户端，以前也连过，但现在出了问题，同样的程序在其他电脑上没问题，所以排除代码、连接字符串等问题，本机上的数据库管理工具也能正常执行相关SQL语句。网上一般说有如下几种情况会导致此报错：(1)客户机上未安装oracle客户端...
ocienvcreate php 失败_OCI 学习笔记(转)
weixin_39880895的博客
01-28 327
这段自学 OCI 编程，感觉网上这方面的资料其实也不少，只是不是很容易找到。其实 OCI没有想象的那么复杂，如果你想深究，那应该就只是时间问题。我在网上看到有人这么写到，对于 C 高手来说 OCI编程只是简单的调用接口函数而已。我个人认为，学习 OCI 编程真的没那么难的，如果你想简单的会使用。那么接下来我就这段时间对 OCI 函数的学习及所收集的资料进行整合，用于帮助那些刚刚接触 OCI 编程的...
OCIEnvCreate 失败，返回代码为 -1，但错误消息文本不可用
清风专栏
08-19 2633
网上的提供的方法也是试了一遍，包括卸载重装Oracle客户端的，程序生成目标也改成 any cpu, 依然不行。 解决方法： 发现自己程序，前台部分用的是64位的，而后台是32位的，之前电脑上只有32位的Oracle客户端，把64位的客户端也装上，问题解决。 ...
AMPS:MySQL数据库操作模块源码解读
Socrates的专栏
01-25 3354
本节看看在AMPS中对MySQL数据库的访问操作，它使用MySQL提供的C API接口进行访问，具体各API的使用可参考http://dev.mysql.com/doc/refman/5.6/en/c-api-function-overview.html。  下面看看AMPS中的实现：   AMPS_MySQL.h #ifndef __HEADER_AMPS_MYSQL_ENGINE_H #
AMPS:数据库访问模块源码解读
Socrates的专栏
01-25 3128
AMPS做为一个中间件，也提供了访问数据库的接口，目前支持MySQL和Oracle（对我所喜爱PostgreSQL却默认不支持，看来我的爱好属于非主流哈~），下面要看的是DBEngine库，它只做一件事情，就是封装了不同数据库操作的差异，提供一个数据库统一访问接口。下节再看针对不同数据库的具体操作。 AMPS_DBEngine.h #ifndef __HEADER_AMPS_DB_ENGI
解决AMPS悖论：小戏剧性与黑洞互补性
"这篇论文探讨了AMPS悖论与黑洞互补性的关系，提出了一种名为'小戏剧性'的新解决方案，以解决信息守恒问题。文章指出，即使没有明显的戏剧性事件，信息仍然可能看似违反一夫一妻制原则进入黑洞内部。然而，通过分析...
第三版Op Amps设计指南：实用设计工具和解决方案
Op Amps for Everyone (第三版) - Operational Amplifier 设计指南 Op Amps for Everyone (第三版) 是一本关于运算放大器（Operational Amplifier，简称 Op Amp）设计的指南，由 Ron Mancini 和 Bruce Carter 编辑...
oracledb_exporter.linux-amd64
04-13
oracledb_exporter.linux-amd64 监控oracle 以防以后忘记
CMU200中文手册：全方位解读综合测试仪操作与应用
作为一款面向未来的模块化设计，CMU200主要应用于无线通信领域的RF开发、模块设计、生产测试等各个环节，支持多种通信标准，包括GSM、TDMA、AMPS、CDMA、WCDMA和CDMA2000等，这得益于其可根据需要加载不同版本的软件...
运算放大器权威指南：OpAmps for Everyone 第三版
运算放大器（Op-Amps）是电子电路中的核心元件，广泛应用于信号处理、滤波、放大、比较、电源管理等各种场景。本书详细讲解了Op-Amp的基础概念，包括基本电路配置如非反相和反相放大器、电压跟随器、差分放大器等。...
OCI释放句柄时应注意的问题
evilstar2015的专栏
03-16 1083
在项目开发过程中，遇到过这样的问题： 代码中，需要访问两个数据库（定为数据库A,和数据库B）。在从数据库A切换到数据库B的时候，要释放A所有申请的资源。 由于模型设计原因，在申请句柄时，在不同的地方申请了2个 错误 句柄。 在释放时，执行了如下语句：         if (srvhpt!=NULL)                 (void) OCIHandleFree((dvoid
AMPS:AES模块源码解读
Socrates的专栏
01-23 5710
AES(Advanced Encryption Standard，高级加密标准)是一个对称密钥加密算法，密钥长度则可以是128，192或256比特。  算法思路(详细信息请见维基百科)：   AES加密过程是在一个4×4的字节矩阵上运作，这个矩阵又称为“体（state）”，其初值就是一个明文区块（矩阵中一个元素大小就是明文区块中的一个Byte）。（Rijndael加密法因支持更大的区块
AMPS:哈希表源码解读
Socrates的专栏
01-21 3499
Hash表也是一种常用的数据结构，AMPS中的Hash表并不是给使用者提供一个散列函数，而是仅提供一个创建和维护Hash表这样一个结构的一组函数，针对不同的应用或者数据，由用户自己定义其要使用的散列函数，AMPS中，Hash表组成结构是如下的拉链式结构。 下面看看AMPS中对Hash操作的代码： AMPS_Hash.h #ifndef __HEADER_AMPS_HASH_H #
AMPS:内存管理模块源码解读（一）
Socrates的专栏
01-27 3254
在AMPS中，使用内存池来管理内存，具体机制见之前的文章《AMPS:内存管理（二）》，在代码中，使用了两种实现方式，第一种是数组+单链表。今天先看看这个方式下的内存池实现。 AMPS_MemoryMgt.h #ifndef __HEADER_AMPS_MEMORY_MGMT_H__ #define __HEADER_AMPS_MEMORY_MGMT_H__ #include "AMPS_
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值