Hi,
I had a problem and it took me about five hours to find and fix it. I though
it could be useful for everybody to know and maybe it's a bug in Orion.
When you have a CMP Entity bean which maps to a table with a certain
condition as I explain here, the remove method fails with a message which
says the object is being used and is locked by another active connection.
This happens when you have a table with one, two or more fields and the
primary key is a multi field key, consist of all the fields in the table. It
also happens when there is only one field in the table which is the primary
key. To resolve this issue you need to add at least a field to the table
which is not part of the primary key!
I'm using SQL server with ODBC/JDBC connection.
Regards,
Amir
