Jumping to different timecodes of videofiles
23 views
Skip to first unread message
Toni Popovic
Jul 15, 2011, 3:37:48 AM7/15/11
to mbari-vars
Hello Brian!
VARS is a surprisingly well-developed software so thank you for that!
I just can't find something that I would assume is already
implemented. The possibility to click an observation from the list
(say produced by a query) and jump to the specific point of that video
file. I can only see a jump button in the UI (binoculars) but you need
to manually input the timecode where you want to go instead of just
clicking from the list of observations.
In addition something that could be useful is to have endpoints of
annotations so you could play all the "ocean-shrimps" for example one
after the other (like a playlist generated by the query).
Some bug is also bugging me when operating the knowledgebase.bat. It
does not allow to delete concept "physical object" and produces the
following error:
Caused by: javax.persistence.RollbackException: Exception
[EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-
r8635): org.eclipse.persistence.exceptions.DatabaseException Internal
Exception: java.sql.SQLIntegrityConstraintViolationException: DELETE
on table 'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back. Error Code: -1 Call: DELETE FROM Concept WHERE ((id = ?)
AND (LAST_UPDATED_TIME = ?)) bind => [4939, 2011-07-15 10:31:47.822]
Query: DeleteObjectQuery(ConceptImpl ([id=4939]))
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:
102)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:
63) vars.jpa.DAO.endTransaction(DAO.java:92)
vars.knowledgebase.jpa.ConceptDAOImpl.cascadeRemove(ConceptDAOImpl.java:
157) vars.knowledgebase.ui.actions.ApproveHistoryTask
$ADeleteChildConceptTask.approve(ApproveHistoryTask.java:311)
vars.knowledgebase.ui.actions.ApproveHistoryTask.approve(ApproveHistoryTask.java:
138)
vars.knowledgebase.ui.actions.ApproveHistoryTask.doTask(ApproveHistoryTask.java:
159)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
54)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
29)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
980)
org.bushe.swing.event.SwingEventService.publish(SwingEventService.java:
78)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
920) org.bushe.swing.event.EventBus.publish(EventBus.java:65)
vars.knowledgebase.ui.EditConceptTreePopupMenu.triggerRemoveAction(EditConceptTreePopupMenu.java:
220) vars.knowledgebase.ui.EditConceptTreePopupMenu
$2.actionPerformed(EditConceptTreePopupMenu.java:86)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source) java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEventImpl(Unknown Source)
java.awt.EventQueue.access$000(Unknown Source) java.awt.EventQueue
$1.run(Unknown Source) java.awt.EventQueue$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.security.AccessControlContext
$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue
$2.run(Unknown Source) java.awt.EventQueue$2.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.awt.EventQueue.dispatchEvent(Unknown Source)
org.mbari.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:
86) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services
- 2.1.2.v20101206-r8635):
org.eclipse.persistence.exceptions.DatabaseException Internal
Exception: java.sql.SQLIntegrityConstraintViolationException: DELETE
on table 'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back. Error Code: -1 Call: DELETE FROM Concept WHERE ((id = ?)
AND (LAST_UPDATED_TIME = ?)) bind => [4939, 2011-07-15 10:31:47.822]
Query: DeleteObjectQuery(ConceptImpl ([id=4939]))
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:
324)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:
797)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:
863)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:
583)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:
526)
org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:
980)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
206)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
192)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:
183)
org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:
101)
org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:
168)
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:
740)
org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:
643)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:
108)
org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:
113)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:
85)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:
2908)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1291)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1273)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1233)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
329)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
288)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:
1425)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:
610)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:
1527)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:
264)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:
1148)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:
84)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:
63) vars.jpa.DAO.endTransaction(DAO.java:92)
vars.knowledgebase.jpa.ConceptDAOImpl.cascadeRemove(ConceptDAOImpl.java:
157) vars.knowledgebase.ui.actions.ApproveHistoryTask
$ADeleteChildConceptTask.approve(ApproveHistoryTask.java:311)
vars.knowledgebase.ui.actions.ApproveHistoryTask.approve(ApproveHistoryTask.java:
138)
vars.knowledgebase.ui.actions.ApproveHistoryTask.doTask(ApproveHistoryTask.java:
159)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
54)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
29)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
980)
org.bushe.swing.event.SwingEventService.publish(SwingEventService.java:
78)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
920) org.bushe.swing.event.EventBus.publish(EventBus.java:65)
vars.knowledgebase.ui.EditConceptTreePopupMenu.triggerRemoveAction(EditConceptTreePopupMenu.java:
220) vars.knowledgebase.ui.EditConceptTreePopupMenu
$2.actionPerformed(EditConceptTreePopupMenu.java:86)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source) java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEventImpl(Unknown Source)
java.awt.EventQueue.access$000(Unknown Source) java.awt.EventQueue
$1.run(Unknown Source) java.awt.EventQueue$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.security.AccessControlContext
$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue
$2.run(Unknown Source) java.awt.EventQueue$2.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.awt.EventQueue.dispatchEvent(Unknown Source)
org.mbari.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:
86) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLIntegrityConstraintViolationException: DELETE
on table 'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back.
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:
788)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:
863)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:
583)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:
526)
org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:
980)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
206)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
192)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:
183)
org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:
101)
org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:
168)
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:
740)
org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:
643)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:
108)
org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:
113)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:
85)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:
2908)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1291)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1273)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1233)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
329)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
288)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:
1425)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:
610)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:
1527)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:
264)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:
1148)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:
84)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:
63) vars.jpa.DAO.endTransaction(DAO.java:92)
vars.knowledgebase.jpa.ConceptDAOImpl.cascadeRemove(ConceptDAOImpl.java:
157) vars.knowledgebase.ui.actions.ApproveHistoryTask
$ADeleteChildConceptTask.approve(ApproveHistoryTask.java:311)
vars.knowledgebase.ui.actions.ApproveHistoryTask.approve(ApproveHistoryTask.java:
138)
vars.knowledgebase.ui.actions.ApproveHistoryTask.doTask(ApproveHistoryTask.java:
159)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
54)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
29)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
980)
org.bushe.swing.event.SwingEventService.publish(SwingEventService.java:
78)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
920) org.bushe.swing.event.EventBus.publish(EventBus.java:65)
vars.knowledgebase.ui.EditConceptTreePopupMenu.triggerRemoveAction(EditConceptTreePopupMenu.java:
220) vars.knowledgebase.ui.EditConceptTreePopupMenu
$2.actionPerformed(EditConceptTreePopupMenu.java:86)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source) java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEventImpl(Unknown Source)
java.awt.EventQueue.access$000(Unknown Source) java.awt.EventQueue
$1.run(Unknown Source) java.awt.EventQueue$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.security.AccessControlContext
$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue
$2.run(Unknown Source) java.awt.EventQueue$2.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.awt.EventQueue.dispatchEvent(Unknown Source)
org.mbari.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:
86) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.apache.derby.client.am.SqlException: DELETE on table
'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back.
org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
org.apache.derby.client.net.NetStatementReply.readExecute(Unknown
Source) org.apache.derby.client.net.StatementReply.readExecute(Unknown
Source)
org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.readExecute(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:
788)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:
863)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:
583)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:
526)
org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:
980)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
206)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
192)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:
183)
org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:
101)
org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:
168)
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:
740)
org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:
643)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:
108)
org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:
113)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:
85)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:
2908)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1291)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1273)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1233)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
329)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
288)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:
1425)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:
610)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:
1527)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:
264)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:
1148)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:
84)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:
63) vars.jpa.DAO.endTransaction(DAO.java:92)
vars.knowledgebase.jpa.ConceptDAOImpl.cascadeRemove(ConceptDAOImpl.java:
157) vars.knowledgebase.ui.actions.ApproveHistoryTask
$ADeleteChildConceptTask.approve(ApproveHistoryTask.java:311)
vars.knowledgebase.ui.actions.ApproveHistoryTask.approve(ApproveHistoryTask.java:
138)
vars.knowledgebase.ui.actions.ApproveHistoryTask.doTask(ApproveHistoryTask.java:
159)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
54)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
29)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
980)
org.bushe.swing.event.SwingEventService.publish(SwingEventService.java:
78)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
920) org.bushe.swing.event.EventBus.publish(EventBus.java:65)
vars.knowledgebase.ui.EditConceptTreePopupMenu.triggerRemoveAction(EditConceptTreePopupMenu.java:
220) vars.knowledgebase.ui.EditConceptTreePopupMenu
$2.actionPerformed(EditConceptTreePopupMenu.java:86)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source) java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEventImpl(Unknown Source)
java.awt.EventQueue.access$000(Unknown Source) java.awt.EventQueue
$1.run(Unknown Source) java.awt.EventQueue$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.security.AccessControlContext
$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue
$2.run(Unknown Source) java.awt.EventQueue$2.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.awt.EventQueue.dispatchEvent(Unknown Source)
org.mbari.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:
86) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)
VARS is a surprisingly well-developed software so thank you for that!
I just can't find something that I would assume is already
implemented. The possibility to click an observation from the list
(say produced by a query) and jump to the specific point of that video
file. I can only see a jump button in the UI (binoculars) but you need
to manually input the timecode where you want to go instead of just
clicking from the list of observations.
In addition something that could be useful is to have endpoints of
annotations so you could play all the "ocean-shrimps" for example one
after the other (like a playlist generated by the query).
Some bug is also bugging me when operating the knowledgebase.bat. It
does not allow to delete concept "physical object" and produces the
following error:
Caused by: javax.persistence.RollbackException: Exception
[EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-
r8635): org.eclipse.persistence.exceptions.DatabaseException Internal
Exception: java.sql.SQLIntegrityConstraintViolationException: DELETE
on table 'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back. Error Code: -1 Call: DELETE FROM Concept WHERE ((id = ?)
AND (LAST_UPDATED_TIME = ?)) bind => [4939, 2011-07-15 10:31:47.822]
Query: DeleteObjectQuery(ConceptImpl ([id=4939]))
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:
102)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:
63) vars.jpa.DAO.endTransaction(DAO.java:92)
vars.knowledgebase.jpa.ConceptDAOImpl.cascadeRemove(ConceptDAOImpl.java:
157) vars.knowledgebase.ui.actions.ApproveHistoryTask
$ADeleteChildConceptTask.approve(ApproveHistoryTask.java:311)
vars.knowledgebase.ui.actions.ApproveHistoryTask.approve(ApproveHistoryTask.java:
138)
vars.knowledgebase.ui.actions.ApproveHistoryTask.doTask(ApproveHistoryTask.java:
159)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
54)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
29)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
980)
org.bushe.swing.event.SwingEventService.publish(SwingEventService.java:
78)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
920) org.bushe.swing.event.EventBus.publish(EventBus.java:65)
vars.knowledgebase.ui.EditConceptTreePopupMenu.triggerRemoveAction(EditConceptTreePopupMenu.java:
220) vars.knowledgebase.ui.EditConceptTreePopupMenu
$2.actionPerformed(EditConceptTreePopupMenu.java:86)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source) java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEventImpl(Unknown Source)
java.awt.EventQueue.access$000(Unknown Source) java.awt.EventQueue
$1.run(Unknown Source) java.awt.EventQueue$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.security.AccessControlContext
$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue
$2.run(Unknown Source) java.awt.EventQueue$2.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.awt.EventQueue.dispatchEvent(Unknown Source)
org.mbari.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:
86) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services
- 2.1.2.v20101206-r8635):
org.eclipse.persistence.exceptions.DatabaseException Internal
Exception: java.sql.SQLIntegrityConstraintViolationException: DELETE
on table 'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back. Error Code: -1 Call: DELETE FROM Concept WHERE ((id = ?)
AND (LAST_UPDATED_TIME = ?)) bind => [4939, 2011-07-15 10:31:47.822]
Query: DeleteObjectQuery(ConceptImpl ([id=4939]))
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:
324)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:
797)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:
863)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:
583)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:
526)
org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:
980)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
206)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
192)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:
183)
org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:
101)
org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:
168)
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:
740)
org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:
643)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:
108)
org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:
113)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:
85)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:
2908)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1291)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1273)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1233)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
329)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
288)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:
1425)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:
610)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:
1527)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:
264)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:
1148)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:
84)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:
63) vars.jpa.DAO.endTransaction(DAO.java:92)
vars.knowledgebase.jpa.ConceptDAOImpl.cascadeRemove(ConceptDAOImpl.java:
157) vars.knowledgebase.ui.actions.ApproveHistoryTask
$ADeleteChildConceptTask.approve(ApproveHistoryTask.java:311)
vars.knowledgebase.ui.actions.ApproveHistoryTask.approve(ApproveHistoryTask.java:
138)
vars.knowledgebase.ui.actions.ApproveHistoryTask.doTask(ApproveHistoryTask.java:
159)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
54)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
29)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
980)
org.bushe.swing.event.SwingEventService.publish(SwingEventService.java:
78)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
920) org.bushe.swing.event.EventBus.publish(EventBus.java:65)
vars.knowledgebase.ui.EditConceptTreePopupMenu.triggerRemoveAction(EditConceptTreePopupMenu.java:
220) vars.knowledgebase.ui.EditConceptTreePopupMenu
$2.actionPerformed(EditConceptTreePopupMenu.java:86)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source) java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEventImpl(Unknown Source)
java.awt.EventQueue.access$000(Unknown Source) java.awt.EventQueue
$1.run(Unknown Source) java.awt.EventQueue$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.security.AccessControlContext
$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue
$2.run(Unknown Source) java.awt.EventQueue$2.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.awt.EventQueue.dispatchEvent(Unknown Source)
org.mbari.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:
86) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.SQLIntegrityConstraintViolationException: DELETE
on table 'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back.
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown
Source)
org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:
788)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:
863)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:
583)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:
526)
org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:
980)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
206)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
192)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:
183)
org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:
101)
org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:
168)
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:
740)
org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:
643)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:
108)
org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:
113)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:
85)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:
2908)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1291)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1273)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1233)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
329)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
288)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:
1425)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:
610)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:
1527)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:
264)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:
1148)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:
84)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:
63) vars.jpa.DAO.endTransaction(DAO.java:92)
vars.knowledgebase.jpa.ConceptDAOImpl.cascadeRemove(ConceptDAOImpl.java:
157) vars.knowledgebase.ui.actions.ApproveHistoryTask
$ADeleteChildConceptTask.approve(ApproveHistoryTask.java:311)
vars.knowledgebase.ui.actions.ApproveHistoryTask.approve(ApproveHistoryTask.java:
138)
vars.knowledgebase.ui.actions.ApproveHistoryTask.doTask(ApproveHistoryTask.java:
159)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
54)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
29)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
980)
org.bushe.swing.event.SwingEventService.publish(SwingEventService.java:
78)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
920) org.bushe.swing.event.EventBus.publish(EventBus.java:65)
vars.knowledgebase.ui.EditConceptTreePopupMenu.triggerRemoveAction(EditConceptTreePopupMenu.java:
220) vars.knowledgebase.ui.EditConceptTreePopupMenu
$2.actionPerformed(EditConceptTreePopupMenu.java:86)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source) java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEventImpl(Unknown Source)
java.awt.EventQueue.access$000(Unknown Source) java.awt.EventQueue
$1.run(Unknown Source) java.awt.EventQueue$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.security.AccessControlContext
$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue
$2.run(Unknown Source) java.awt.EventQueue$2.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.awt.EventQueue.dispatchEvent(Unknown Source)
org.mbari.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:
86) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.apache.derby.client.am.SqlException: DELETE on table
'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back.
org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
org.apache.derby.client.net.NetStatementReply.readExecute(Unknown
Source) org.apache.derby.client.net.StatementReply.readExecute(Unknown
Source)
org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.readExecute(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown
Source)
org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:
788)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:
863)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:
583)
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:
526)
org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:
980)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
206)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:
192)
org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:
183)
org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:
101)
org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:
168)
org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:
740)
org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:
643)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:
108)
org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:
113)
org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:
85)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:
2908)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1291)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1273)
org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:
1233)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
329)
org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:
288)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:
1425)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:
610)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:
1527)
org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:
264)
org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:
1148)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:
84)
org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:
63) vars.jpa.DAO.endTransaction(DAO.java:92)
vars.knowledgebase.jpa.ConceptDAOImpl.cascadeRemove(ConceptDAOImpl.java:
157) vars.knowledgebase.ui.actions.ApproveHistoryTask
$ADeleteChildConceptTask.approve(ApproveHistoryTask.java:311)
vars.knowledgebase.ui.actions.ApproveHistoryTask.approve(ApproveHistoryTask.java:
138)
vars.knowledgebase.ui.actions.ApproveHistoryTask.doTask(ApproveHistoryTask.java:
159)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
54)
vars.knowledgebase.ui.ApproveHistorySubscriber.onEvent(ApproveHistorySubscriber.java:
29)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
980)
org.bushe.swing.event.SwingEventService.publish(SwingEventService.java:
78)
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.java:
920) org.bushe.swing.event.EventBus.publish(EventBus.java:65)
vars.knowledgebase.ui.EditConceptTreePopupMenu.triggerRemoveAction(EditConceptTreePopupMenu.java:
220) vars.knowledgebase.ui.EditConceptTreePopupMenu
$2.actionPerformed(EditConceptTreePopupMenu.java:86)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.AbstractButton.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown
Source) java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEventImpl(Unknown Source)
java.awt.EventQueue.access$000(Unknown Source) java.awt.EventQueue
$1.run(Unknown Source) java.awt.EventQueue$1.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.security.AccessControlContext
$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue
$2.run(Unknown Source) java.awt.EventQueue$2.run(Unknown Source)
java.security.AccessController.doPrivileged(Native Method)
java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source) java.awt.EventQueue.dispatchEvent(Unknown Source)
org.mbari.awt.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:
86) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown
Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown
Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)
Brian Schlining
Jul 15, 2011, 11:31:25 AM7/15/11
to mbari...@googlegroups.com
Hi Toni,
--
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
Brian Schlining
bschl...@gmail.com
VARS is a surprisingly well-developed software so thank you for that!
Thanks. I hope you find it useful.
I just can't find something that I would assume is already
implemented. The possibility to click an observation from the list
(say produced by a query) and jump to the specific point of that video
file. I can only see a jump button in the UI (binoculars) but you need
to manually input the timecode where you want to go instead of just
clicking from the list of observations.
Sorry to say that that feature is not implemented. The issue we ran into was that, at MBARI, we use a timecode track to index into the file. The alternative to that is just to use the Runtime of the file. It's easy to jump to a point in the file based on runtime, but I was never able to figure out to do it using a timecode. I'm doing some work on VARS in a few weeks; I can look into adding the feature.
In addition something that could be useful is to have endpoints of
annotations so you could play all the "ocean-shrimps" for example one
after the other (like a playlist generated by the query).
Yah, that would be nice.
Some bug is also bugging me when operating the knowledgebase.bat. It
does not allow to delete concept "physical object" and produces the
following error:
Hmmm, I'd have to look into that. Deleting the physical object delete's nearly all the Knowledebase tree: Is that really what you want to do? Also, that may be a bug specific to Apache Derby with bigger branches. You can test this by deleting a smaller branch of the tree. Anyway I'll add it to my list to look into.
Caused by: javax.persistence.RollbackException: Exception
[EclipseLink-4002] (Eclipse Persistence Services - 2.1.2.v20101206-
r8635): org.eclipse.persistence.exceptions.DatabaseException Internal
Exception: java.sql.SQLIntegrityConstraintViolationException: DELETE
on table 'CONCEPT' caused a violation of foreign key constraint
'FK_CONCEPTNAME_TO_CONCEPT' for key (4939). The statement has been
rolled back. Error Code: -1 Call: DELETE FROM Concept WHERE ((id = ?)
AND (LAST_UPDATED_TIME = ?)) bind => [4939, 2011-07-15 10:31:47.822]
Query: DeleteObjectQuery(ConceptImpl ([id=4939]))
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
Brian Schlining
bschl...@gmail.com
Reply all
Reply to author
Forward
0 new messages