mdb2 oracle connection leak

[lui10e6]

Hi,

I am using MDB2 class for connecting to database. The server is windows 2003.

it is fine with mysql, but when using it with oracle 10g it wouldn't close the connection in this case:

$test = new object;

//create the condition

$test->condition($value);

//first sql

$first=$test->function1();

//second sql

$second=$test->function2();

 

if i have only one sql to execute it is fine, but with more then 1 the connection is not closed.

 

why?

 

this is how i connect to db:

$this->mdb2 =& MDB2::factory($dsn);

where dsn is defined as an array.

 

many thanks if anyone.