Can't change script for calculated fields and slow import

User 247c00dc1d

21-01-2015 15:06:36

Hello,


I have an empty DB, use it as template, but recently, after updating of IJC, when I try to change the script in calculated fields I get the error:


 com.im.df.api.support.ObjectOwnedByOtherUserException: Object is read-only as it is owned by other user
at com.im.df.impl.db.AlwaysLockedLockable.obtainLock(AlwaysLockedLockable.java:45)
at com.im.ijc.core.api.util.IJCCoreUtils.lock(IJCCoreUtils.java:243)
at com.im.ijc.core.api.util.IJCCoreUtils.applyChangesWithProgress(IJCCoreUtils.java:189)
at com.im.ijc.core.api.util.IJCCoreUtils.applyChangesWithProgress(IJCCoreUtils.java:183)
at com.im.ijc.core.api.ui.DFCustomizerEditor.applyButtonActionPerformed(DFCustomizerEditor.java:166)
at com.im.ijc.core.api.ui.DFCustomizerEditor.access$100(DFCustomizerEditor.java:39)
at com.im.ijc.core.api.ui.DFCustomizerEditor$2.actionPerformed(DFCustomizerEditor.java:108)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:162)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.RuntimeException
... 44 more 


Instant JChem Version: 15.1.12.0 (build: 201501141047-6091141fad09)     

Due to "Object is read-only as it is owned by other user" I've never set the password or user for this DB!


One more question: importing data into the DB from table file by fields merging is extremely slow, for example import into 100000 base from file with 100000 strings take about 2h while the same procedure in the very old program isis base take only several min... is way to make the import into IJC faster?


Please help to solve those problems.


Kind regards,

 Igor


ChemAxon 26d92e5dcd

29-01-2015 10:09:07

Dear Igor,


sorry for a delayed answer. We were investigating Regarding the error that you describe, could you please also provide us with the full logfile? Also in the ideal case, if you would provide us with the empty Derby DB template that you use, it would be really useful (for privacy reasons, you could use email, instead of the forum).


I will also investigate RDF import/export as a possible workaround for your template and calculated fields.


Regarding the import and merging, the performance depends on the data size. When merging, IJC also looks for duplicate values. What you could do is try to disable the duplicate values check (or make sure that is is not enabled). 


Best regards


David

User 247c00dc1d

29-01-2015 11:14:48

Dear David,


I had created the "example" DB on PC with old version of IJC (6.3.3) and opened it on the PC with new version of IJC (15.1.19.0 ), the schema was updated and after that I can't edit the script for calculated field: "New calculated field" in the "Pubchem demo" table - get the error I've reported before.


Best regards


Igor

ChemAxon 26d92e5dcd

02-02-2015 09:45:12

Dear Igor,


thank you for the example. We will work on a fix for this.


All the best


David