Re: [PERFORM] data doesnt get saved in the database / idle in transaction

2006-03-21 Thread Jim C. Nasby
On Mon, Mar 20, 2006 at 08:03:14PM +0800, Qingqing Zhou wrote: > > ""Ksenia Marasanova"" <[EMAIL PROTECTED]> wrote > > > > The application uses persistant database connection, and when i check > > the status of the connection, it shows: "idle in transaction". I am > > pretty sure that every inser

Re: [PERFORM] data doesnt get saved in the database / idle in transaction

2006-03-20 Thread Qingqing Zhou
""Ksenia Marasanova"" <[EMAIL PROTECTED]> wrote > > The application uses persistant database connection, and when i check > the status of the connection, it shows: "idle in transaction". I am > pretty sure that every insert is being committed with explicit > "commit()" . It always worked before..