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

Google Groups | Jeff Runningen | 8 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

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

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

    Connection error Android app and MySQL

    Stack Overflow | 2 years 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 | 2 years 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 | 2 years 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 | 1 year 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