org.hibernate.exception.JDBCConnectionException: could not prepare statement

Google Groups | Jeff Runningen | 3 months ago
  1. 0

    Upgraded from 2.6.1 to 2.6.9, now Rundeck sometimes fails with "MySQLNonTransientConnectionException: Too many connections"

    Google Groups | 3 months ago | Jeff Runningen
    org.hibernate.exception.JDBCConnectionException: could not prepare statement
  2. 0

    Connection error Android app and MySQL

    Stack Overflow | 1 year ago | Vasilis Gogos
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at java.lang.reflect.Constructor.constructNative(Native Method) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.Util.getInstance(Util.java:383) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:958) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2326) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at java.lang.reflect.Constructor.constructNative(Native Method) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
  3. 0

    jdbc4 Archives - BlogoSfera

    co.uk | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at java.lang.reflect.Constructor.constructNative(Native Method) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.Util.getInstance(Util.java:383) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:958) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:937) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:872) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2326) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2079) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at java.lang.reflect.Constructor.constructNative(Native Method) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) 10-06 14:57:30.073 31737-31737/com.example.kostasvasilis.barpda W/System.err﹕ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can´t create a project, get stuck on "choose a team"!

    GitHub | 1 year ago | eduardosanzb
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot $
  6. 0

    Tomcat, java, mysql. Centos 6.2. HELP ... / Java / Sql.ru

    sql.ru | 9 months ago
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server. Attempted reconnect 3 times. Giving up.)

    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. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException

      Too many connections

      at com.mysql.jdbc.Util.handleNewInstance()
    2. MySQL jdbc
      NonRegisteringDriver.connect
      1. com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
      2. com.mysql.jdbc.Util.getInstance(Util.java:372)
      3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:958)
      4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
      5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
      6. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
      7. com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)
      8. com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1206)
      9. com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2239)
      10. com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2270)
      11. com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)
      12. com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
      13. com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
      14. com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
      15. com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
      16. com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
      16 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:571)
      2. java.sql.DriverManager.getConnection(DriverManager.java:187)
      2 frames
    4. rundeck.services
      DbStorageService.listDirectory
      1. rundeck.services.DbStorageService.listDirectory(DbStorageService.groovy:183)
      1 frame
    5. com.dtolabs.rundeck
      ResolvedExtTree.listDirectory
      1. com.dtolabs.rundeck.core.storage.ResolvedExtTree.listDirectory(ResolvedExtTree.java:62)
      1 frame
    6. org.rundeck.storage
      StringToPathTree.listDirectory
      1. org.rundeck.storage.impl.DelegateTree.listDirectory(DelegateTree.java:55)
      2. org.rundeck.storage.impl.DelegateTree.listDirectory(DelegateTree.java:55)
      3. org.rundeck.storage.conf.ListenerTree.listDirectory(ListenerTree.java:81)
      4. org.rundeck.storage.impl.DelegateTree.listDirectory(DelegateTree.java:55)
      5. org.rundeck.storage.impl.DelegateTree.listDirectory(DelegateTree.java:55)
      6. org.rundeck.storage.impl.StringToPathTree.listDirectory(StringToPathTree.java:50)
      6 frames
    7. rundeck.services
      FrameworkService.getFrameworkRoles
      1. rundeck.services.ConfigStorageService.$tt__listDirPaths(ConfigStorageService.groovy:55)
      2. rundeck.services.AuthorizationService.loadStoredPolicies(AuthorizationService.groovy:133)
      3. rundeck.services.AuthorizationService.getStoredPolicies(AuthorizationService.groovy:116)
      4. rundeck.services.AuthorizationService.getRoleList(AuthorizationService.groovy:66)
      5. rundeck.services.FrameworkService.getFrameworkRoles(FrameworkService.groovy:654)
      5 frames
    8. org.rundeck.web
      ContainerRoleSource.getUserRoles
      1. org.rundeck.web.infosec.ContainerRoleSource.getUserRoles(ContainerRoleSource.groovy:19)
      1 frame
    9. rundeck.filters
      AuthorizationFilters$_closure1_closure4_closure7.doCall
      1. rundeck.filters.AuthorizationFilters$_createAuthSubject_closure2.doCall(AuthorizationFilters.groovy:166)
      2. rundeck.filters.AuthorizationFilters.createAuthSubject(AuthorizationFilters.groovy:164)
      3. rundeck.filters.AuthorizationFilters$_closure1_closure4_closure7.doCall(AuthorizationFilters.groovy:63)
      3 frames
    10. Jetty
      ServletHandler$CachedChain.doFilter
      1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)
      2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1360)
      2 frames
    11. grails.plugin.cache
      AbstractFilter.doFilter
      1. grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:198)
      2. grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63)
      2 frames
    12. Jetty
      ServletHandler$CachedChain.doFilter
      1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      3. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      4. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      5. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)
      6. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
      7. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:539)
      8. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
      9. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)
      10. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
      11. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
      12. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)
      13. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
      14. org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:288)
      15. org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:115)
      16. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      17. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      18. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      18 frames
    13. com.codahale.metrics
      AbstractInstrumentedFilter.doFilter
      1. com.codahale.metrics.servlet.AbstractInstrumentedFilter.doFilter(AbstractInstrumentedFilter.java:97)
      1 frame
    14. Jetty
      ServletHandler$CachedChain.doFilter
      1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      2 frames
    15. com.google.servlet
      AbstractHttpFilter.doFilter
      1. com.google.servlet.GoogleSsoFilter.doFilter(GoogleSsoFilter.java:106)
      2. com.google.servlet.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:30)
      2 frames
    16. Jetty
      AsyncHttpConnection.handle
      1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
      2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)
      3. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
      4. org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:521)
      5. org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
      6. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)
      7. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
      8. org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
      9. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)
      10. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
      11. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)
      12. org.eclipse.jetty.server.Server.handle(Server.java:349)
      13. org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:449)
      14. org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:910)
      15. org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:634)
      16. org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230)
      17. org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76)
      17 frames
    17. GWT dev
      SelectChannelEndPoint$1.run
      1. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609)
      2. org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45)
      2 frames
    18. Jetty
      QueuedThreadPool$3.run
      1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599)
      2. org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534)
      2 frames
    19. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame