API tools faq
paste
Guest User

Untitled

a guest
May 18th, 2018
123
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.02 KB | None | 0 0
raw download clone embed print report
  1. <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  2. <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/**********?useSSL=false</property>
  3. <property name="hibernate.connection.username">root</property>
  4. <property name="hibernate.connection.password">123456</property>
  5. <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
  6.  
  7. <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
  8. <property name="hibernate.c3p0.acquireIncrement">2</property>
  9. <property name="hibernate.c3p0.initialPoolSize">3</property>
  10. <property name="hibernate.c3p0.minPoolSize">2</property>
  11. <property name="hibernate.c3p0.maxPoolSize">8</property>
  12. <property name="hibernate.c3p0.maxIdleTime">1200</property>
  13. <property name="hibernate.c3p0.maxConnectionAge">1200</property>
  14. <property name="hibernate.c3p0.acquireRetryAttempts">1</property>
  15. <property name="hibernate.c3p0.acquireRetryDelay">250</property>
  16.  
  17. public class HibernateUtil {
  18.  
  19. private static SessionFactory sessionFactory;
  20. private static ServiceRegistry serviceRegistry;
  21.  
  22. public static Session getSession() {
  23. return HibernateUtil.getFactory().openSession();
  24. }
  25.  
  26. public static SessionFactory getFactory() {
  27. if (sessionFactory == null || sessionFactory.isClosed()) {
  28. sessionFactory = HibernateUtil.buildSessionFactory();
  29. }
  30.  
  31. return sessionFactory;
  32. }
  33.  
  34. public static void closeFactory() {
  35. sessionFactory.close();
  36. StandardServiceRegistryBuilder.destroy(serviceRegistry);
  37. }
  38.  
  39. private static SessionFactory buildSessionFactory() {
  40. try {
  41. Configuration configuration = new Configuration().configure();
  42. serviceRegistry = new StandardServiceRegistryBuilder().applySettings(configuration.getProperties()).build();
  43.  
  44. SessionFactory factory = configuration.buildSessionFactory(serviceRegistry);
  45. return factory;
  46.  
  47. } catch (HibernateException ex) {
  48. System.err.println("FALHA NA CRIACAO DA SESSION FACTORY = " + ex);
  49.  
  50. throw new ExceptionInInitializerError(ex);
  51. }
  52. }
  53. }
  54.  
  55. WARN: SQL Error: 0, SQLState: 08S01
  56. ERROR: Communications link failure
  57. The last packet successfully received from the server was 478,001 milliseconds ago. The last packet sent successfully to the server was 22,321 milliseconds ago.
  58. Grave: ==> ERRO ORIGINAL AO EXECUTAR A QUERY: org.hibernate.exception.JDBCConnectionException: Could not open connection
  59. Advertência: StandardWrapperValve[br.com.forcavendasweb.controller.ClientesFVController]: Servlet.service() for servlet br.com.forcavendasweb.controller.ClientesFVController threw exception
  60. org.hibernate.exception.JDBCConnectionException: Could not open connection
  61. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:132)
  62. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  63. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
  64. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
  65. at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235)
  66. at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)
  67. at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
  68. at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:162)
  69. at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1431)
  70. at br.com.portalserver.dao.ClienteDAO.listarClientesRepresentante(ClienteDAO.java:109)
  71. at br.com.forcavendasweb.controller.ClientesFVController.atualizarListaCliente(ClientesFVController.java:261)
  72. at br.com.forcavendasweb.controller.ClientesFVController.doGet(ClientesFVController.java:100)
  73. at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
  74. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  75. at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
  76. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
  77. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
  78. at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
  79. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
  80. at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
  81. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
  82. at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:416)
  83. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:283)
  84. at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)
  85. at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)
  86. at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:206)
  87. at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:180)
  88. at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)
  89. at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
  90. at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:283)
  91. at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:200)
  92. at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:132)
  93. at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:111)
  94. at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
  95. at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:536)
  96. at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
  97. at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
  98. at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
  99. at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
  100. at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:591)
  101. at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:571)
  102. at java.lang.Thread.run(Thread.java:748)
  103. Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  104. The last packet successfully received from the server was 478,001 milliseconds ago. The last packet sent successfully to the server was 22,321 milliseconds ago.
  105. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  106. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  107. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  108. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  109. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  110. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
  111. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3559)
  112. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3459)
  113. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3900)
  114. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  115. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  116. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483)
  117. at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4819)
  118. at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:912)
  119. at org.hibernate.c3p0.internal.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:94)
  120. at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)
  121. at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)
  122. ... 37 more
  123. Caused by: java.net.SocketException: Operation timed out (Read failed)
  124. at java.net.SocketInputStream.socketRead0(Native Method)
  125. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  126. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  127. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  128. at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101)
  129. at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144)
  130. at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174)
  131. at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3008)
  132. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3469)
  133. ... 47 more
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!