org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1364]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement

GitHub | jluc2808 | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    error adding path to player

    GitHub | 6 months ago | jluc2808
    org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1364]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
  2. 0

    error while processing series Game of Thrones

    GitHub | 10 months ago | jluc2808
    org.hibernate.exception.GenericJDBCException: could not execute statement
  3. 0

    error default field language doesn't have a default value

    GitHub | 10 months ago | jluc2808
    org.hibernate.exception.GenericJDBCException: could not execute statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Data truncated for column

    Stack Overflow | 6 months ago | User1v0
    org.hibernate.exception.GenericJDBCException: could not execute statement
  6. 0

    SQL Error: 1364 - Field 'status' doesn't have a default value

    GitHub | 3 years ago | jluc2808
    org.hibernate.exception.GenericJDBCException: could not execute statement
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Field 'device_name' doesn't have a default value

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
    7. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
    8. com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
    9. com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
    10. com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)
    11. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
    11 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeUpdate
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    3. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    3 frames
  4. Hibernate
    ResultSetReturnImpl.executeUpdate
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
    1 frame
  5. org.hibernate.dialect
    GetGeneratedKeysDelegate.executeAndExtract
    1. org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:57)
    1 frame
  6. Hibernate
    JdbcCoordinatorImpl.beforeTransactionCompletion
    1. org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42)
    2. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2827)
    3. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3398)
    4. org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
    5. org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:597)
    6. org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:232)
    7. org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:213)
    8. org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:256)
    9. org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:318)
    10. org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:275)
    11. org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:182)
    12. org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:113)
    13. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
    14. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
    15. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:97)
    16. org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
    17. org.hibernate.internal.SessionImpl.fireSaveOrUpdate(SessionImpl.java:651)
    18. org.hibernate.internal.SessionImpl.saveOrUpdate(SessionImpl.java:643)
    19. org.hibernate.engine.spi.CascadingActions$5.cascade(CascadingActions.java:218)
    20. org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.java:391)
    21. org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:316)
    22. org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:155)
    23. org.hibernate.engine.internal.Cascade.cascadeCollectionElements(Cascade.java:424)
    24. org.hibernate.engine.internal.Cascade.cascadeCollection(Cascade.java:356)
    25. org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:319)
    26. org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:155)
    27. org.hibernate.engine.internal.Cascade.cascade(Cascade.java:104)
    28. org.hibernate.event.internal.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:150)
    29. org.hibernate.event.internal.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:141)
    30. org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:74)
    31. org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:38)
    32. org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)
    33. org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468)
    34. org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3135)
    35. org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352)
    36. org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
    36 frames
  7. org.hibernate.resource
    JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit
    1. org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
    2. org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
    3. org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
    3 frames
  8. Hibernate
    TransactionImpl.commit
    1. org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
    1 frame
  9. org.springframework.orm
    HibernateTransactionManager.doCommit
    1. org.springframework.orm.hibernate5.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:581)
    1 frame
  10. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
    2. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
    3. org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
    4. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
    5. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    5 frames
  11. Spring AOP
    CglibAopProxy$DynamicAdvisedInterceptor.intercept
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    2. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)
    2 frames
  12. org.yamj.core
    PlayerPagesController.playerAddPath
    1. org.yamj.core.database.service.JsonApiStorageService$$EnhancerBySpringCGLIB$$925ccdf4.storePlayerPath(<generated>)
    2. org.yamj.core.pages.PlayerPagesController.playerAddPath(PlayerPagesController.java:149)
    2 frames
  13. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  14. Spring
    InvocableHandlerMethod.invokeForRequest
    1. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
    2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
    2 frames
  15. Spring MVC
    FrameworkServlet.doPost
    1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
    2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
    3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
    4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
    6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
    7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
    8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
    8 frames
  16. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
    1 frame
  17. Spring MVC
    FrameworkServlet.service
    1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
    1 frame
  18. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
    1 frame
  19. Jetty
    ServletHandler$CachedChain.doFilter
    1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)
    2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496)
    2 frames
  20. Spring
    OncePerRequestFilter.doFilter
    1. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
    2. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    2 frames
  21. Jetty
    AsyncHttpConnection.handle
    1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1476)
    2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)
    3. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
    4. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)
    5. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
    6. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)
    7. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429)
    8. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
    9. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)
    10. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
    11. org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
    12. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
    13. org.eclipse.jetty.server.Server.handle(Server.java:370)
    14. org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)
    15. org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:982)
    16. org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043)
    17. org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865)
    18. org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
    19. org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
    19 frames
  22. GWT dev
    SelectChannelEndPoint$1.run
    1. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696)
    2. org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53)
    2 frames
  23. Jetty
    QueuedThreadPool$3.run
    1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
    2. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
    2 frames
  24. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame