API tools faq
paste
Guest User

Untitled

a guest
Feb 20th, 2018
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.10 KB | None | 0 0
raw download clone embed print report
  1. HTTP Status 500 - JDBC rollback failed
  2.  
  3. type Exception report
  4.  
  5. message JDBC rollback failed
  6.  
  7. description The server encountered an internal error that prevented it from fulfilling this request.
  8.  
  9. exception
  10.  
  11. org.hibernate.TransactionException: JDBC rollback failed
  12. org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:200)
  13. com.javawebtutor.service.LoginService.getUserByUserId(LoginService.java:37)
  14. com.javawebtutor.service.LoginService.authenticateUser(LoginService.java:17)
  15. com.javawebtutor.controller.LoginServlet.doPost(LoginServlet.java:33)
  16. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  17. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  18. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  19. root cause
  20.  
  21. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
  22. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  23. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  24. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  25. java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  26. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  27. com.mysql.jdbc.Util.getInstance(Util.java:386)
  28. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
  29. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
  30. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
  31. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
  32. com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1251)
  33. com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1243)
  34. com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4723)
  35. org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:213)
  36. org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:192)
  37. com.javawebtutor.service.LoginService.getUserByUserId(LoginService.java:37)
  38. com.javawebtutor.service.LoginService.authenticateUser(LoginService.java:17)
  39. com.javawebtutor.controller.LoginServlet.doPost(LoginServlet.java:33)
  40. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  41. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  42. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  43. root cause
  44.  
  45. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  46.  
  47. The last packet successfully received from the server was 33,669,634 milliseconds ago. The last packet sent successfully to the server was 6 milliseconds ago.
  48. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  49. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  50. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  51. java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  52. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  53. com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
  54. com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)
  55. com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)
  56. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)
  57. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
  58. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
  59. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
  60. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
  61. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310)
  62. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  63. org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
  64. org.hibernate.loader.Loader.doQuery(Loader.java:802)
  65. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
  66. org.hibernate.loader.Loader.doList(Loader.java:2533)
  67. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  68. org.hibernate.loader.Loader.list(Loader.java:2271)
  69. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
  70. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
  71. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
  72. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
  73. org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
  74. org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
  75. com.javawebtutor.service.LoginService.getUserByUserId(LoginService.java:33)
  76. com.javawebtutor.service.LoginService.authenticateUser(LoginService.java:17)
  77. com.javawebtutor.controller.LoginServlet.doPost(LoginServlet.java:33)
  78. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  79. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  80. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  81. root cause
  82.  
  83. java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
  84. com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039)
  85. com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489)
  86. com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)
  87. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)
  88. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
  89. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
  90. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
  91. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
  92. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310)
  93. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  94. org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
  95. org.hibernate.loader.Loader.doQuery(Loader.java:802)
  96. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
  97. org.hibernate.loader.Loader.doList(Loader.java:2533)
  98. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
  99. org.hibernate.loader.Loader.list(Loader.java:2271)
  100. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
  101. org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
  102. org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
  103. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
  104. org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
  105. org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
  106. com.javawebtutor.service.LoginService.getUserByUserId(LoginService.java:33)
  107. com.javawebtutor.service.LoginService.authenticateUser(LoginService.java:17)
  108. com.javawebtutor.controller.LoginServlet.doPost(LoginServlet.java:33)
  109. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
  110. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
  111. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  112. note The full stack trace of the root cause is available in the Apache Tomcat/8.0.50 logs.
  113.  
  114. Apache Tomcat/8.0.50
  115.  
  116. <!DOCTYPE hibernate-configuration PUBLIC
  117. "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  118. "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
  119.  
  120. <hibernate-configuration>
  121. <session-factory>
  122. <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  123. <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  124. <property name="hibernate.connection.url">
  125. jdbc:mysql://localhost:3306/dbname?UseUnicode=true&characterEncoding=utf8
  126. </property>
  127. <property name="hibernate.connection.username">dbusername</property>
  128. <property name="hibernate.connection.password">dbpass</property>
  129. <property name="show_sql">true</property>
  130.  
  131.  
  132.  
  133. <property name="hbm2ddl.auto">update</property>
  134.  
  135.  
  136.  
  137.  
  138. <mapping class="com.javawebtutor.model.User" />
  139. <mapping class="com.javawebtutor.model.Questionaire" />
  140. </session-factory>
  141. </hibernate-configuration>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!