Connection closing problem in ColdFusion4.5

hi,

Im developing an application using Java2.0 and ColdFusion 4.5. Im using the Java class to lock a record by using "select from table for update". My application is like lock the records the user has selected and use the same connection object to update the database when he makes a request again. If he updates or decides to close the browser i call a method that close the connection the user was assigned to. My problem is im able to create a connection, assign it to a particular user, use the same connection object when he makes a request again but im not able to close the connection. Im using the connection.close() method but still when i see using the database monitor i still see all the connections alive. Can anyone help me about this?

thanks,

senthil kumar

[804 byte] By [sisenthil] at [2007-9-26 7:06:46]