Locking

We are having locking problems with our Oracle 7.3.4 server. It seems to be related to one table (as seen by looking at the v$locked_objects and user_objects tables). The table is accessed from a java application, but do not appear to be any obvious exceptions thrown or caught from the application side of things. We do not rollback within the stored procedure but use the java Connection object to rollback or commit.

Can anyone shed any light on why this may be occurring? I thought that the rollback or commit should have solved the problem.

Thanks

--
Sonia Gillespie
E-mail: sonia_gillespie_at_lagan.com