Hello, (Sorry my english)
I saw this words in my 'ps -Af'. JBOSS use jdbc driver for postgres. In java the Connection has a method: setAutoCommit(boolen). Those connections where autocommit=false, and after the last sql command (select, insert, update) NOT have rollback or commit, state will "idle in transaction". I'm sorry but I don't know how can you setup autocommit feature in the JBOSS. linimi On 7/19/05, FM <[EMAIL PROTECTED]> wrote: > Hello, > > We are using JBOSS and postgresql on 1 database (DB1). From time to time > the JBOSS process <idle in transaction>. > > What is strange is that users on all DB (not only DB1) are affected by > the JBOSS <idle in transaction>. > I understand that it locked DB1 but why it also locked users on others DB ? > > Thanks ! > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
