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 | 2 months ago
  1. 0

    error adding path to player

    GitHub | 2 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 | 6 months ago | jluc2808
    org.hibernate.exception.GenericJDBCException: could not execute statement
  3. 0

    error default field language doesn't have a default value

    GitHub | 6 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 | 2 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 | 2 years ago | jluc2808
    org.hibernate.exception.GenericJDBCException: could not execute statement

  1. kid 2 times, last 1 month ago
  2. kuldeep 4 times, last 2 months ago
  3. mortalman7 1 times, last 5 months ago
32 unregistered visitors
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