dropwizard-example 0.7.0 -- does it work when you post to /people

688 views
Skip to first unread message

Scott Maroney

unread,
May 3, 2013, 1:02:58 AM5/3/13
to dropwiz...@googlegroups.com
Hello.  New member here.  Just trying to get familiar with the framework.

(I apologize ahead of time if I'm violating some protocol here, but this is what I observed)
When I do this:

$ curl -H "Content-Type: application/json" -X POST -d '{"fullName":"Other Person","jobTitle":"Other Title"}'http://localhost:8080/people

I get this:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
<title>Error 500 There was an error processing your request. It has been logged (ID 6f462da6f876a279).
</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /people. Reason:
<pre>    There was an error processing your request. It has been logged (ID 6f462da6f876a279).
</pre></p><br/> 

And a nasty stack trace:
INFO  [2013-05-03 04:10:08,513] org.eclipse.jetty.server.AbstractConnector: StartedInstrumentedBlocki...@0.0.0.0:8080
INFO  [2013-05-03 04:10:08,518] org.eclipse.jetty.server.AbstractConnector: StartedSocketC...@0.0.0.0:8081
WARN  [2013-05-03 04:12:27,486] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 90036, SQLState: 90036
ERROR [2013-05-03 04:12:27,486] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
call next value for hibernate_sequence [90036-171]
ERROR [2013-05-03 04:12:27,504] com.yammer.dropwizard.jersey.LoggingExceptionMapper: Error handling a request: 3cfe46b7f63320d7
! org.hibernate.exception.GenericJDBCException: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
call next value for hibernate_sequence [90036-171]
! at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.proxy.$Proxy57.prepareStatement(Unknown Source) ~[na:na]
! at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:84) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:71) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:96) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.id.enhanced.OptimizerFactory$NoopOptimizer.generate(OptimizerFactory.java:252) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:369) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:118) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:114) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:727) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:719) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:715) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.hibernate.AbstractDAO.persist(AbstractDAO.java:149) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.example.helloworld.db.PersonDAO.create(PersonDAO.java:20) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.example.helloworld.resources.PeopleResource.createPerson(PeopleResource.java:27) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_45]
! at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_45]
! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_45]
! at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_45]
! at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.hibernate.UnitOfWorkRequestDispatcher.dispatch(UnitOfWorkRequestDispatcher.java:43) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.jersey.OptionalResourceMethodDispatchAdapter$OptionalRequestDispatcher.dispatch(OptionalResourceMethodDispatchAdapter.java:37) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.ResourceObjectRule.accept(ResourceObjectRule.java:100) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.jetty.NonblockingServletHolder.handle(NonblockingServletHolder.java:47) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1448) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:29) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1419) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.metrics.jetty.InstrumentedHandler.handle(InstrumentedHandler.java:200) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.GzipHandler.handle(GzipHandler.java:301) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.jetty.BiDiGzipHandler.handle(BiDiGzipHandler.java:123) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.Server.handle(Server.java:368) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.nio.BlockingChannelConnector$BlockingChannelEndPoint.run(BlockingChannelConnector.java:298) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at java.lang.Thread.run(Thread.java:680) [na:1.6.0_45]
Caused by: ! org.h2.jdbc.JdbcSQLException: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
call next value for hibernate_sequence [90036-171]
! at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.message.DbException.get(DbException.java:169) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.message.DbException.get(DbException.java:146) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readSequence(Parser.java:4829) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readTerm(Parser.java:2498) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readFactor(Parser.java:2053) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readSum(Parser.java:2040) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readConcat(Parser.java:2013) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readCondition(Parser.java:1878) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readAnd(Parser.java:1859) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readExpression(Parser.java:1851) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.parseCall(Parser.java:4010) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.parsePrepared(Parser.java:325) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.parse(Parser.java:278) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.parse(Parser.java:250) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.prepareCommand(Parser.java:217) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.engine.Session.prepareLocal(Session.java:417) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.engine.Session.prepareCommand(Session.java:366) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_45]
! at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_45]
! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_45]
! at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_45]
! at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
!... 67 common frames omitted
0:0:0:0:0:0:0:1%0 - - [03/May/2013:04:12:27 +0000] "POST /people HTTP/1.1" 500 1478 178 178
WARN  [2013-05-03 04:15:40,267] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 90036, SQLState: 90036
ERROR [2013-05-03 04:15:40,267] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
call next value for hibernate_sequence [90036-171]
ERROR [2013-05-03 04:15:40,269] com.yammer.dropwizard.jersey.LoggingExceptionMapper: Error handling a request: 6f462da6f876a279
! org.hibernate.exception.GenericJDBCException: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
call next value for hibernate_sequence [90036-171]
! at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.proxy.$Proxy57.prepareStatement(Unknown Source) ~[na:na]
! at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:84) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:71) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:96) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.id.enhanced.OptimizerFactory$NoopOptimizer.generate(OptimizerFactory.java:252) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:369) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:118) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:114) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:727) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:719) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:715) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.hibernate.AbstractDAO.persist(AbstractDAO.java:149) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.example.helloworld.db.PersonDAO.create(PersonDAO.java:20) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.example.helloworld.resources.PeopleResource.createPerson(PeopleResource.java:27) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_45]
! at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_45]
! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_45]
! at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_45]
! at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.hibernate.UnitOfWorkRequestDispatcher.dispatch(UnitOfWorkRequestDispatcher.java:43) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.jersey.OptionalResourceMethodDispatchAdapter$OptionalRequestDispatcher.dispatch(OptionalResourceMethodDispatchAdapter.java:37) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.ResourceObjectRule.accept(ResourceObjectRule.java:100) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.jetty.NonblockingServletHolder.handle(NonblockingServletHolder.java:47) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1448) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.servlets.ThreadNameFilter.doFilter(ThreadNameFilter.java:29) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1419) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:455) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.metrics.jetty.InstrumentedHandler.handle(InstrumentedHandler.java:200) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.GzipHandler.handle(GzipHandler.java:301) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at com.yammer.dropwizard.jetty.BiDiGzipHandler.handle(BiDiGzipHandler.java:123) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.Server.handle(Server.java:368) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:53) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:72) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.server.nio.BlockingChannelConnector$BlockingChannelEndPoint.run(BlockingChannelConnector.java:298) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) [dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at java.lang.Thread.run(Thread.java:680) [na:1.6.0_45]
Caused by: ! org.h2.jdbc.JdbcSQLException: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
call next value for hibernate_sequence [90036-171]
! at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.message.DbException.get(DbException.java:169) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.message.DbException.get(DbException.java:146) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readSequence(Parser.java:4829) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readTerm(Parser.java:2498) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readFactor(Parser.java:2053) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readSum(Parser.java:2040) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readConcat(Parser.java:2013) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readCondition(Parser.java:1878) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readAnd(Parser.java:1859) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.readExpression(Parser.java:1851) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.parseCall(Parser.java:4010) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.parsePrepared(Parser.java:325) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.parse(Parser.java:278) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.parse(Parser.java:250) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.command.Parser.prepareCommand(Parser.java:217) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.engine.Session.prepareLocal(Session.java:417) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.engine.Session.prepareCommand(Session.java:366) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
! at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_45]
! at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_45]
! at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_45]
! at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_45]
! at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138) ~[dropwizard-example-0.7.0-SNAPSHOT.jar:0.7.0-SNAPSHOT]
!... 67 common frames omitted
0:0:0:0:0:0:0:1%0 - - [03/May/2013:04:15:40 +0000] "POST /people HTTP/1.1" 500 1478 9 9
 

Coda Hale

unread,
May 3, 2013, 7:26:53 PM5/3/13
to dropwiz...@googlegroups.com
Interesting.

I just tried this out and I can replicate your problem. I suspect it's the relatively recent introduction in Dropwizard of USE_NEW_ID_GENERATOR_MAPPINGS defaulting to being true.

You can change the GenerationType on Person.id to GenerationType.IDENTITY and it'll work.

---
Coda Hale
http://codahale.com



--
You received this message because you are subscribed to the Google Groups "dropwizard-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dropwizard-us...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

Scott Maroney

unread,
May 3, 2013, 7:36:00 PM5/3/13
to dropwiz...@googlegroups.com
Cool.  I'll try that tonight.  Thanks a ton.

Do you recommend that I use 0.6.2 or 0.7.0?

Scott


--
You received this message because you are subscribed to a topic in the Google Groups "dropwizard-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dropwizard-user/mmAUf7YJEI8/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to dropwizard-us...@googlegroups.com.

Coda Hale

unread,
May 3, 2013, 7:49:11 PM5/3/13
to dropwiz...@googlegroups.com
0.6.2.

0.7.0's not released yet.

---
Coda Hale
http://codahale.com



Scott Maroney

unread,
May 3, 2013, 10:24:05 PM5/3/13
to dropwiz...@googlegroups.com
Confirmed.  Thanks.


You received this message because you are subscribed to a topic in the Google Groups "dropwizard-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dropwizard-user/mmAUf7YJEI8/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to dropwizard-us...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages