Skip site navigation (1) Skip section navigation (2)

Re: Memory Leak ?

From: zhaoxin <zhaox(at)necas(dot)nec(dot)com(dot)cn>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Memory Leak ?
Date: 2006-06-14 11:40:22
Message-ID: 448FF5A6.1060202@necas.nec.com.cn (view raw or flat)
Thread:
Lists: pgsql-odbc
to:Luf

Thanks for you response.
my test program is below ,and I expect for you help .

Table structure:
*************************************
   CREATE TABLE TestLeak
   ( c1 int4,
     c2 text,
     c3 int4
    )
*************************************

my program is like this:
*************************************
void testInsert(){
     char *sqlInsert="insert into TestLeak values(?,?)";
     char szTmp[STR_LEN];//STR_LEN = 132
     SQLINTEGER  sOrderID=0 ,cbValue = SQL_NTS;	
     SQLINTEGER  cbOrderID = 0 ;
     int i;

     //initialize
     memset(szTmp,0,STR_LEN);
     memset(szTmp,'a',STR_LEN-1);//insert 'a'

     //INSERT
     for(i = 0 ; i < count ; i++)
     {
         retcode = SQLPrepare(hstmt,(SQLCHAR*)sqlInsert,SQL_NTS);
         SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT,
                SQL_C_SLONG,SQL_INTEGER, 0, 0, &sOrderID, 0, &cbOrderID);
         SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR,
                SQL_CHAR,STR_LEN, 0, &szTmp, 0, &cbValue);
         SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_SLONG,
                SQL_INTEGER, 0, 0, &sOrderID, 0, &cbOrderID);
         sOrderID = i;
         retcode = SQLExecute(hstmt);
         if( RC_NOTSUCCESSFUL(retcode))
         {
         	exit_nicely();
         }
     }
     retcode = SQLFreeStmt(hstmt,SQL_RESET_PARAMS);
     SQLEndTran(SQL_HANDLE_DBC,(SQLHDBC)hdbc, SQL_COMMIT);
}
******************************************************************

thanks,
zhao

Ludek Finstrle wrote:
>>   SQLAllocHandle (SQL_HANDLE_ENV, NULL, &henv);
>>   SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
>>   SQLConnect (hDBC, szDSN, SQL_NTS, szUID, SQL_NTS, szPasswd, SQL_NTS);
>>   SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
>>   while( i < 10){
>>      SQLPrepare(hstmt,(SQLCHAR*)szSql, SQL_NTS);
>>      SQLBindParameter(......);
>>      ......
> 
> 
> Please could you send us the exact szSql and their BindParameters
> so we don't have to make steps into dark? BTW table structure and
> some sample data could help too.
> It speeds up finding the problem.
> 
> 
>>      SQLExecute(hstmt);
>>      SQLFreeStmt(hstmt,SQL_RESET_PARAMS);
>>   }
>>   SQLEndTran(SQL_HANDLE_DBC,(SQLHDBC)hdbc, SQL_COMMIT);
>>   SQLFreeStmt(hstmt, SQL_CLOSE);
>>   SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
>>   SQLDisconnect(hdbc);
>>   SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
> 
> 
> Regards,
> 
> Luf
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 

-- 

以上、よろしくお願いいたします。
*******************************************
NEC-CAS 基盤ソフトウェア開発本部 第二開発部
         趙 新
E-mail:zhaox(at)necas(dot)nec(dot)com(dot)cn
Telel :8-0086-22-425
外 線:(010)8233-4433-425
*******************************************

In response to

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-06-14 12:05:21
Subject: Re: Access97/odbcUnicode/pgsql : unable to map text field
Previous:From: Ludek FinstrleDate: 2006-06-14 08:09:34
Subject: Re: CVS and open cursor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group