Annotation - SQL problem

[Alex McLean]

Hi all,

I was overjoyed to find VARS, thanks for making it available, just the ticket for quick annotation of video.. However, half an hour into annotating a 1.5 hour video I started getting database errors.

Now whenever I start the annotation app it shows the splash screen and then an error appears, I've pasted the details below. The app no longer loads. Is there a way to fix this?

I'm using linux (the latest mint) and the latest java 8 downloaded from oracle as per the install instructions.

All the best,

alex

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150916-55dc7c3): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Schema 'VARSUSER' does not exist Error Code: 30000 Call: SELECT id, Affiliation, Email, FirstName, LastName, Password, Role, LAST_UPDATED_TIME, UserName FROM UserAccount Query: ReadAllQuery(name="UserAccount.findAll" referenceClass=UserAccountImpl sql="SELECT id, Affiliation, Email, FirstName, LastName, Password, Role, LAST_UPDATED_TIME, UserName FROM UserAccount")
org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:382) org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260) org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473) vars.jpa.DAO.findByNamedQuery(DAO.java:174) vars.jpa.UserAccountDAOImpl.findAll(UserAccountDAOImpl.java:44) vars.annotation.ui.App. (App.java:113) vars.annotation.ui.App.lambda$main$0(App.java:232) java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) java.awt.EventQueue.access$500(EventQueue.java:97) java.awt.EventQueue$3.run(EventQueue.java:709) java.awt.EventQueue$3.run(EventQueue.java:703) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) java.awt.EventQueue.dispatchEvent(EventQueue.java:726) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150916-55dc7c3): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: Schema 'VARSUSER' does not exist Error Code: 30000 Call: SELECT id, Affiliation, Email, FirstName, LastName, Password, Role, LAST_UPDATED_TIME, UserName FROM UserAccount Query: ReadAllQuery(name="UserAccount.findAll" referenceClass=UserAccountImpl sql="SELECT id, Affiliation, Email, FirstName, LastName, Password, Role, LAST_UPDATED_TIME, UserName FROM UserAccount")
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:684) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560) org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055) org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570) org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:258) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694) org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740) org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693) org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:559) org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1175) org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904) org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134) org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460) org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222) org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804) org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258) org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473) vars.jpa.DAO.findByNamedQuery(DAO.java:174) vars.jpa.UserAccountDAOImpl.findAll(UserAccountDAOImpl.java:44) vars.annotation.ui.App. (App.java:113) vars.annotation.ui.App.lambda$main$0(App.java:232) java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) java.awt.EventQueue.access$500(EventQueue.java:97) java.awt.EventQueue$3.run(EventQueue.java:709) java.awt.EventQueue$3.run(EventQueue.java:703) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) java.awt.EventQueue.dispatchEvent(EventQueue.java:726) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.sql.SQLSyntaxErrorException: Schema 'VARSUSER' does not exist
org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source) org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) org.apache.derby.client.am.ClientConnection.prepareStatement(Unknown Source) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1565) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1514) org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:778) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:621) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560) org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055) org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570) org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:258) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694) org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740) org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693) org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:559) org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1175) org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904) org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134) org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460) org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222) org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804) org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258) org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473) vars.jpa.DAO.findByNamedQuery(DAO.java:174) vars.jpa.UserAccountDAOImpl.findAll(UserAccountDAOImpl.java:44) vars.annotation.ui.App. (App.java:113) vars.annotation.ui.App.lambda$main$0(App.java:232) java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) java.awt.EventQueue.access$500(EventQueue.java:97) java.awt.EventQueue$3.run(EventQueue.java:709) java.awt.EventQueue$3.run(EventQueue.java:703) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) java.awt.EventQueue.dispatchEvent(EventQueue.java:726) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: ERROR 42Y07: Schema 'VARSUSER' does not exist
org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown Source) org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source) org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source) org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source) org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source) org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source) org.apache.derby.client.am.ClientStatement.readPrepareDescribeOutput(Unknown Source) org.apache.derby.client.am.ClientPreparedStatement.readPrepareDescribeInputOutput(Unknown Source) org.apache.derby.client.am.ClientPreparedStatement.flowPrepareDescribeInputOutput(Unknown Source) org.apache.derby.client.am.ClientPreparedStatement.prepare(Unknown Source) org.apache.derby.client.am.ClientConnection.prepareStatementX(Unknown Source) org.apache.derby.client.am.ClientConnection.prepareStatement(Unknown Source) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1565) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1514) org.eclipse.persistence.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:778) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:621) org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560) org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055) org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570) org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:258) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299) org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694) org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740) org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2693) org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:559) org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:1175) org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904) org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134) org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460) org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222) org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839) org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804) org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258) org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473) vars.jpa.DAO.findByNamedQuery(DAO.java:174) vars.jpa.UserAccountDAOImpl.findAll(UserAccountDAOImpl.java:44) vars.annotation.ui.App. (App.java:113) vars.annotation.ui.App.lambda$main$0(App.java:232) java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311) java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756) java.awt.EventQueue.access$500(EventQueue.java:97) java.awt.EventQueue$3.run(EventQueue.java:709) java.awt.EventQueue$3.run(EventQueue.java:703) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76) java.awt.EventQueue.dispatchEvent(EventQueue.java:726) java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

[Brian Schlining]

Hi Alex,

I was overjoyed to find VARS, thanks for making it available, just the ticket for quick annotation of video.. However, half an hour into annotating a 1.5 hour video I started getting database errors.

Now whenever I start the annotation app it shows the splash screen and then an error appears, I've pasted the details below. The app no longer loads. Is there a way to fix this?

I’ve never seen that error before. You could try bouncing the derby database (run derbystop, then derby start). If the doesn’t take care of the issue you could zip up the database directory and put it somewhere where I can grab it and I can run a couple of quick tests to see what’s going on.

--
You received this message because you are subscribed to the Google Groups "mbari-vars" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mbari-vars+...@googlegroups.com.
To post to this group, send email to mbari...@googlegroups.com.
Visit this group at https://groups.google.com/group/mbari-vars.
For more options, visit https://groups.google.com/d/optout.

-- 
Brian Schlining

[Alex McLean]

On 13 January 2016 at 16:24, Brian Schlining <bschl...@gmail.com> wrote:
> I’ve never seen that error before. You could try bouncing the derby database
> (run derbystop, then derby start). If the doesn’t take care of the issue you
> could zip up the database directory and put it somewhere where I can grab it
> and I can run a couple of quick tests to see what’s going on.

Thanks Brian, that's done the trick!

Another problem is that I can't find out how to edit the
knowledgebase. I'm coding up a music video and it's actually very
entertaining finding the most appropriate marine behaviours to apply
to musicians, so not really a problem.. But wonder why this might be.
I'm logged in as an admin user (via the padlock icon), but the 'new'
'update' and 'delete' buttons are always greyed out, as are the 'add
concept', 'remove concept' and 'edit concept' menus when I right
click.

Best wishes

alex