Unable to add data in multi-user mode

User 259df256ea

22-01-2008 17:21:16

We are recently unable to add new rows in any table when connected in multi-user mode to an Oracle IJC database. When connected as admin in single-user mode, we can add new rows, but not always edit fields in existing ones.

When trying to add a new row as admin in multi-user mode, the following error is generated:


Caused: com.im.df.api.support.ObjectOwnedByOtherUserException: Cannot perform "insert data". You have insufficient access rights to modify database model.

at com.im.df.impl.db.AlwaysLockedLockable.obtainLock(AlwaysLockedLockable.java:30)

at com.im.df.impl.db.InsertionHandler.lockParticipatingEntities(InsertionHandler.java:119)

at com.im.df.impl.db.InsertionHandler.doInTransaction(InsertionHandler.java:218)

at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)

at com.im.df.impl.db.DBSchemaDataProviderImpl.insert(DBSchemaDataProviderImpl.java:147)

at com.im.ijc.core.api.actions.InsertRowAction$3.phase1InRequestProcessor(InsertRowAction.java:328)

at com.im.df.util.BackgroundRunner.processTheTask(BackgroundRunner.java:112)

at com.im.df.util.BackgroundRunner$1.run(BackgroundRunner.java:79)

at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)

[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)

ChemAxon fa971619eb

22-01-2008 17:35:13

Can you check that your admin user has the ROLE_EDIT_DATA role.

As you seem able to add rows I assume this is probably be the case, but it the obvious first thing to check.



ChemAxon e189db4705

22-01-2008 17:38:21


I can reproduce and it looks like a bug. We are working on it, so it will be fixed in 2.2.1.

Thanks for bug report.


User 259df256ea

22-01-2008 17:41:41

Thanks for the instantaneous replies.

Tim: Yes, the admin account has the proper priviledges as checked in both the pull-down menu and the Oracle IJC permissions table.


User d329696e7a

25-01-2008 18:31:10

I'm seeing the exact same error with a MySQL database using either the Mac or Windows client.

ChemAxon fa971619eb

25-01-2008 18:34:26

We have this problem fixed.

It will be in the next update that should be out soon.


ChemAxon fa971619eb

14-02-2008 18:51:17

This bug is now fixed in IJC 2.2.1

User 259df256ea

14-02-2008 20:27:57

Thanks! This seems to fix the problem.