Skip to content

Instantly share code, notes, and snippets.

@cschneider
Created September 30, 2016 16:44
Show Gist options
  • Save cschneider/388309bcf3a3f6cd708b5af59411665b to your computer and use it in GitHub Desktop.
Save cschneider/388309bcf3a3f6cd708b5af59411665b to your computer and use it in GitHub Desktop.
HTTP ERROR 500
Problem accessing /tasklist. Reason:
Server Error
Caused by:
<openjpa-3.0.0-SNAPSHOT-rUnversioned directory fatal general error> org.apache.openjpa.persistence.PersistenceException: Table "TASK" not found; SQL statement:
SELECT t0.id, t0.description, t0.dueDate, t0.finished, t0.title FROM Task t0 [42102-172] {SELECT t0.id, t0.description, t0.dueDate, t0.finished, t0.title FROM Task t0} [code=42102, state=42S02]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5038)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4998)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:154)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2121)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:39)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1262)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1015)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:871)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:802)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:541)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:274)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:290)
at net.lr.tasklist.persistence.impl.TaskServiceImpl.lambda$2(TaskServiceImpl.java:41)
at org.apache.aries.jpa.support.impl.XAJpaTemplate.txExpr(XAJpaTemplate.java:61)
at org.apache.aries.jpa.support.impl.AbstractJpaTemplate.txExpr(AbstractJpaTemplate.java:43)
at net.lr.tasklist.persistence.impl.TaskServiceImpl.getTasks(TaskServiceImpl.java:39)
at net.lr.tasklist.ui.TaskListServlet.showTaskList(TaskListServlet.java:68)
at net.lr.tasklist.ui.TaskListServlet.doGet(TaskListServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:71)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:287)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:80)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table "TASK" not found; SQL statement:
SELECT t0.id, t0.description, t0.dueDate, t0.finished, t0.title FROM Task t0 [42102-172] {SELECT t0.id, t0.description, t0.dueDate, t0.finished, t0.title FROM Task t0} [code=42102, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:198)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:58)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:250)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:139)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1645)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:513)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:493)
at org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:480)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:421)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:392)
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:93)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2080)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:33)
... 36 more
NestedThrowables:
org.h2.jdbc.JdbcSQLException: Table "TASK" not found; SQL statement:
SELECT t0.id, t0.description, t0.dueDate, t0.finished, t0.title FROM Task t0 [42102-172]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.command.Parser.readTableOrView(Parser.java:4824)
at org.h2.command.Parser.readTableFilter(Parser.java:1099)
at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1705)
at org.h2.command.Parser.parseSelectSimple(Parser.java:1813)
at org.h2.command.Parser.parseSelectSub(Parser.java:1699)
at org.h2.command.Parser.parseSelectUnion(Parser.java:1542)
at org.h2.command.Parser.parseSelect(Parser.java:1530)
at org.h2.command.Parser.parsePrepared(Parser.java:405)
at org.h2.command.Parser.parse(Parser.java:279)
at org.h2.command.Parser.parse(Parser.java:251)
at org.h2.command.Parser.prepareCommand(Parser.java:218)
at org.h2.engine.Session.prepareLocal(Session.java:425)
at org.h2.engine.Session.prepareCommand(Session.java:374)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:70)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:644)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:305)
at org.apache.commons.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:305)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:135)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:247)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:139)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1645)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:513)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:493)
at org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:480)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:421)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:392)
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:93)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2080)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:33)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1262)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1015)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:871)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:802)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:541)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:274)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:290)
at net.lr.tasklist.persistence.impl.TaskServiceImpl.lambda$2(TaskServiceImpl.java:41)
at org.apache.aries.jpa.support.impl.XAJpaTemplate.txExpr(XAJpaTemplate.java:61)
at org.apache.aries.jpa.support.impl.AbstractJpaTemplate.txExpr(AbstractJpaTemplate.java:43)
at net.lr.tasklist.persistence.impl.TaskServiceImpl.getTasks(TaskServiceImpl.java:39)
at net.lr.tasklist.ui.TaskListServlet.showTaskList(TaskListServlet.java:68)
at net.lr.tasklist.ui.TaskListServlet.doGet(TaskListServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:71)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:287)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:80)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
Caused by:
org.apache.openjpa.lib.jdbc.ReportingSQLException: Table "TASK" not found; SQL statement:
SELECT t0.id, t0.description, t0.dueDate, t0.finished, t0.title FROM Task t0 [42102-172] {SELECT t0.id, t0.description, t0.dueDate, t0.finished, t0.title FROM Task t0} [code=42102, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:198)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$000(LoggingConnectionDecorator.java:58)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection.prepareStatement(LoggingConnectionDecorator.java:250)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
at org.apache.openjpa.lib.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.prepareStatement(ConfiguringConnectionDecorator.java:139)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:133)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$RefCountConnection.prepareStatement(JDBCStoreManager.java:1645)
at org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareStatement(DelegatingConnection.java:122)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:513)
at org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement(SQLBuffer.java:493)
at org.apache.openjpa.jdbc.sql.SelectImpl.prepareStatement(SelectImpl.java:480)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:421)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:392)
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:93)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2080)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:33)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1262)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1015)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:871)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:802)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:541)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:274)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:290)
at net.lr.tasklist.persistence.impl.TaskServiceImpl.lambda$2(TaskServiceImpl.java:41)
at org.apache.aries.jpa.support.impl.XAJpaTemplate.txExpr(XAJpaTemplate.java:61)
at org.apache.aries.jpa.support.impl.AbstractJpaTemplate.txExpr(AbstractJpaTemplate.java:43)
at net.lr.tasklist.persistence.impl.TaskServiceImpl.getTasks(TaskServiceImpl.java:39)
at net.lr.tasklist.ui.TaskListServlet.showTaskList(TaskListServlet.java:68)
at net.lr.tasklist.ui.TaskListServlet.doGet(TaskListServlet.java:55)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHandler.doHandle(HttpServiceServletHandler.java:71)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:287)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:80)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
Powered by Jetty://
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment