java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available

项目中连续启动三天就会报此错误,重启后就好了,过几天又出现此问题,以下是配置和错误信息,求大牛们解答

spring.datasource.username=xxx 密码和连接ip...
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.platform=mysql
spring.datasource.initialize=false
spring.datasource.data=classpath:sql/data-init.sql
spring.datasource.schema=classpath:sql/schema-mysql.sql
spring.datasource.sqlScriptEncoding=UTF-8
spring.datasource.continueOnError=true
spring.datasource.test-while-idle=true
spring.datasource.validation-query=SELECT 1
spring.datasource.xa.data-source-class-name=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
spring.jpa.generate-ddl=false
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=false
spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImprovedNamingStrategy
spring.datasource.test-on-borrow=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.read-only=false
spring.datasource.hikari.connection-timeout=60000
spring.datasource.hikari.idle-timeout=60000
spring.datasource.hikari.validation-timeout=3000
spring.datasource.hikari.max-lifetime=60000
spring.datasource.hikari.login-timeout=5
spring.datasource.hikari.maximum-pool-size=60
spring.datasource.hikari.minimum-idle=10
2019-03-12 08:10:46,139 ERROR [https-jsse-nio-443-exec-9] o.s.b.w.s.s.ErrorPageFilter [ErrorPageFilter.java:190] Forwarding to error page from request [/api/storages/volumeType/findVolumeTypeByBo] due to exception [Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection]
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:450)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:378)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:474)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:289)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.sugon.cloudview.cmz.storage.serviceImpl.VolumeTypeServiceImpl$$EnhancerBySpringCGLIB$$ab504fe9.findVolumeTypeByBo(<generated>)
    at com.sugon.cloudview.cmz.storage.api.StorageApi.findVolumeTypeByBo(StorageApi.java:371)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130)
    at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
    at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:610)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getConnectionForTransactionManagement(LogicalConnectionManagedImpl.java:254)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.begin(LogicalConnectionManagedImpl.java:262)
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.begin(JdbcResourceLocalTransactionCoordinatorImpl.java:214)
    at org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:56)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:164)
    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:400)
    ... 70 common frames omitted
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60000ms.
    at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:669)
    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:183)
    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
    at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
    ... 77 common frames omitted
0

1个回答

https://blog.csdn.net/xingyunpi/article/details/7216599
你看看这篇博文,他和你遇到的问题大致一样。

1
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
那些搞不懂的数据库连接异常
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30010ms.nn原因:请求数据库连接时长时间未获取到时,会报这个错误 n修改配置项:datasource.primary.connection-timeo...
Hikaricp连接池问题
HiKari源于日语“光”的意思,HiKariCP顾名思义就是 和光速一样快,HiKariCP是数据库连接池的一个后起之秀,号称性能最好,稳定性也不错,完美地PK掉其他连接池。这里提供一篇文章介绍主流Java数据库连接池比较及前瞻,文中重点介绍了当前主流开源数据库连接池(比如C3P0、DBCP、Tomcat Jdbc Pool、Druid和Hikaricp)的性能分析和功能比较,有一定的参考价值。...
Java 8 LongAdder 使用问题记录
这次做一个数据拷贝的活,考虑数据量大,试着做多线程方式,碰到LongAdder的使用问题,记录之nn1.第一版拷贝,单线程,嵌套for循环插入数据库,保证数据正确性。由于数据量庞大,100多万条数据拆分成多张表记录,数据量超过1000万条,逐条插入效率低下,总计时间将近10小时。nn2.第二版拷贝,单线程,嵌套for循环整理数据,已最小分类为最小单元,批量插入数据库。时间提升将近50%。此时使用L...
mysql连接失败HikariPool错误_新的解决方式
异常nnncom.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.nn解决nn1. 由于操作系统与数据库不兼容导致的问题nn如果当前使用的服务器系统是ubuntu18.4, 则应当查看当前的mysql版本, 因为ubuntu默认安装的mysql版本是5.7, 而mysql5...
spring boot整合mybatis遇到问题记录
问题一:nn查询表数据,SQL语句正确,但是查询结果为null,结果报空指针异常nnn测试结果:nnlogbak: 2018-10-18 14:23:45.990 com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...nlogbak: 2018-10-18 14:23:46.541 com.zaxxer.hikari.Hika...
Redis集群密码设置
Redis集群密码设置nn1,如果是使用redis-trib.rb工具构建集群,集群构建完成前不要配置密码,集群构建完毕再通过config set + config rewrite命令逐个机器设置密码nn2,如果对集群设置密码,那么requirepass和masterauth都需要设置,否则发生主从切换时,就会遇到授权问题,可以模拟并观察日志nn3,各个节点的密码都必须一致,否则Redirecte...
深入理解Java虚拟机学习笔记-3.JVM性能监控及故障分析工具
JVM性能监控及故障分析工具1.概要JDK官方提供了不少好用的JAVA故障处理工具,JDK的命令行工具在JDK的bin目录下供用户使用。2.  jps2.1 简介  njps是jdk提供的查看当前java进程的工具,简单看作为JavaVirtual Machine Process Status Tool。 n命令格式:jps [options] [hostid] options 参数详解:n 参数
spring boot整合 mybatis 和 hikariCP
附件是spring boot整合mybatis和hikariCP的示例,本demo的spring boot是2.0以下版本,spring boot 2.0以上版本默认的数据库连接池就是hikariCP。
kafka相关操作及问题汇总
1. kafka查看队列的消费情况 n可以通过kafka-mamager来跟进。 n2 kafka常用命令nnnn#启动kafkancd /usr/hadoop/application/kafka/binn./kafka-server-start.sh -daemon ../config/server.propertiesn#创建Topicn./kafka-topics.sh --create -...
数据库的连接池的数量大于活跃中的线程数,即 size > busy, Unable to fetch a connection in 10 seconds
当数据库连接池被打满的时候,经常可以看到这样的报错:nnnTimeout: Pool empty. Unable to fetch a connection in 10 seconds, none available[size:100; busy:15; idle:0; lastwait:10000].nn在这里,我们可能有个疑问,为什么size是100而busy是15,这不是说还有 100 - ...
selenium安装及使用
项目说明nn为实现定时模拟用户上网的功能,并找出网页元素访问速度瓶颈,采用selenium 模拟浏览器方案测试网络情况。 n使用selenium需要依赖firefox(其他浏览器未尝试),以及Xvfb虚拟显示。nnnn安装nnnnseleniumnnnnxxx@ubuntu-svr:~$ pip install seleniumnnnngeckodrivernn下载地址为https://githu...
Springboot第六章 数据访问
Spring+jdbcnn使用idea 创建springboot项目的时候选中mysql 勾上mysql 和jdbc  然后我们进行演示nnnspring:n datasource:n driver-class-name: com.mysql.jdbc.Drivern url: jdbc:mysql://104.224.142.102:3306/testn username: ...
HikariCP连接池及其在springboot中的配置
        大家好,现在介绍一款非常强大,高效,并且号称“史上最快连接池”。由此可见他是有多受人喜欢,并且在springboot2.0之后,采用的默认数据库连接池就是Hikari。nn         我们知道的连接池有C3P0,DBCP,它们都比较成熟稳定,但性能不是十分好。 所以有了BoneCP这个连接池,它是一个高速、免费、开源的JAVA连接池,它的性能几乎是C3P0、DBCP的25倍,...
SpringBoot系列之Hikari连接池
springboot 2.0 中默认连接池是Hikari# jdbc_config   datasourcespring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.datasource.url=jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&amp;amp;characterEncod...
Spark 异常总结及解决办法
我的原创地址:https://dongkelun.com/2019/01/09/sparkExceptions/n前言n总结Spark开发中遇到的异常及解决办法,之前也写过几篇,之所以不再一个异常写一篇博客,是因为现在Spark用的比较熟悉了一些,觉得没必要把异常信息写那么详细了,所以就把异常总结在一篇博客里了,这样既能备忘也方便查找。n1、之前的几篇nnnspark-submit报错:Excep...
数据库方言 when no Connection available
今天启动tomcat时报错了,'hibernate.dialect' must be set when no Connection available,这个错误没有连接的时候需要数据库方言,感觉可奇怪,在单位的电脑没问题,放在家里就错了,前几天没问题,今天就错了rn2015-2-24 12:56:28 org.apache.catalina.core.AprLifecycleListener initrn信息: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: E:\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\bin;E:\Common\plugins\com.genuitec.eclipse.easie.tomcat.myeclipse_8.5.0.me201003121946\tomcat\binrn2015-2-24 12:56:28 org.apache.coyote.http11.Http11Protocol initrn信息: Initializing Coyote HTTP/1.1 on http-8080rn2015-2-24 12:56:28 org.apache.catalina.startup.Catalina loadrn信息: Initialization processed in 346 msrn2015-2-24 12:56:28 org.apache.catalina.core.StandardService startrn信息: Starting service Catalinarn2015-2-24 12:56:28 org.apache.catalina.core.StandardEngine startrn信息: Starting Servlet Engine: Apache Tomcat/6.0.13rn2015-2-24 12:56:29 org.apache.catalina.core.ApplicationContext logrn信息: Initializing Spring root WebApplicationContextrnlog4j:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader).rnlog4j:WARN Please initialize the log4j system properly.rnlog4j:WARN No appenders could be found for logger (org.springframework.core.CollectionFactory).rnlog4j:WARN Please initialize the log4j system properly.rn2015-2-24 12:56:32 org.apache.catalina.core.ApplicationContext logrn信息: Initializing Spring root WebApplicationContextrn2015-2-24 12:57:03 org.apache.catalina.core.StandardContext listenerStartrn严重: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListenerrn_org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [beans.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available_rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1337)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)rn at java.security.AccessController.doPrivileged(Native Method)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)rn at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)rn at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221)rn at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)rn at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)rn at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729)rn at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381)rn at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)rn at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)rn at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)rn at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)rn at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)rn at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)rn at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)rn at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)rn at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)rn at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)rn at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)rn at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)rn at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)rn at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)rn at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)rn at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)rn at org.apache.catalina.core.StandardService.start(StandardService.java:516)rn at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)rn at org.apache.catalina.startup.Catalina.start(Catalina.java:566)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:597)rn at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)rn at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)rn_Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available_rn at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:107)rn at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:138)rn at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)rn at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)rn at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)rn at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1368)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1334)rn ... 39 morern2015-2-24 12:57:03 org.apache.catalina.core.StandardContext startrn严重: Error listenerStartrn2015-2-24 12:57:03 org.apache.catalina.core.StandardContext startrn严重: Context [/Test20150223] startup failed due to previous errorsrn2015-2-24 12:57:03 org.apache.catalina.core.ApplicationContext logrn信息: Closing Spring root WebApplicationContextrnlog4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.rn2015-2-24 12:57:03 org.apache.coyote.http11.Http11Protocol startrn信息: Starting Coyote HTTP/1.1 on http-8080rn2015-2-24 12:57:03 org.apache.jk.common.ChannelSocket initrn信息: JK: ajp13 listening on /0.0.0.0:8009rn2015-2-24 12:57:03 org.apache.jk.server.JkMain startrn信息: Jk running ID=0 time=0/16 config=nullrn2015-2-24 12:57:03 org.apache.catalina.startup.Catalina startrn信息: Server startup in 34874 msrn
Hikari 数据库连接池配置详解
n&amp;lt;!-- Hikari Datasource --&amp;gt;n &amp;lt;bean id=&quot;dataSourceHikari&quot; class=&quot;com.zaxxer.hikari.HikariDataSource&quot;n destroy-method=&quot;shutdown&quot;&amp;gt;n &amp;lt;property name=&quot;driverClassName&quot; va
openstack搭建问题
1、yum install centos-release-openstack-mitakan问题:No package centos-release-openstack-mitaka available.Error: Nothing to don解决:本来想安装mitaka版本,但是CentOS阿里仓库停止openstack mitaka源服务n建议学习新版本n原因:https://www.cnb...
【Spring源码分析】38-RestTemplate详解
同步客户端执行HTTP请求,在底层HTTP客户端库(如JDK HttpURLConnection,Apache HttpComponents等)上公开简单的模板方法API。RestTemplate除了支持频率较低的情况的通用交换和执行方法之外,还通过HTTP方法提供常见方案的模板。注意:从5.0开始,非阻塞,反应式org.springframework.web.reactive.client.We...
使用 harbor 搭建 docker 私有镜像仓库
harbor 是由 vmware 中国团队开发并开源的企业级 docker registryn 服务,是对官方开源的 Docker Registry 的扩展,增加了一些企业需要的功能,如安全、复制和管理。harbor 主要用于搭建私有 registry,提供了企业需要的安全和控制功能。同时,它也帮助减少带宽使用量,这对提供生产能力和性能有帮助。nharbor 的强大之处在于,同时提供了 reg
正确认识Mysql通信错误与失效连接
对Mysql的aborted_client aborted_connections的分析:rn对于连接问题,服务器错误日志是有用的信息源。rn如果服务器是用“--log-warnings”选项启动的,在错误日志中可能会发现下述消息: rnrn010301 14:38:23 Aborted connection 854 to db: 'users' user: 'josh' rnrnrn如果“Abo...
SpringBoot系列十八:整合Hikari
 Hikari是一款非常强大,高效,并且号称“史上最快连接池”。并且在springboot2.0之后,采用的默认数据库连接池就是Hikari。不需要引入依赖,已经在SpringBoot中包含了。n GitHub地址:https://github.com/brettwooldridge/HikariCPn1、在yml中配置n# 数据库配置nspring:n datasource:n type: ...
VMvare桥接网络连接不上解决办法
记一次学习中的突发状况。由于本人的pc时长要在不同的网络中进行切换,ip地址一般都是不固定的,所以我使用虚拟机的时候一般使用的都是让VMvare自动识别网络环境。直到今天遇到一种突发情况,VMvare怎么都起不来了,一直报错,如下图所示。 nnnn错误代码nnnnnError: Connection activation failed:nIP configuration could not be ...
mysql进阶(二十五)解决数据库NO CONNECTION问题
解决数据库NO CONNECTION问题前言     数据库版本类型:Mysql5.5     在应用程序连接数据库时,提示数据库连接失败。打开数据库查看,显示如下。       究其原因,是因为mysql服务出现了问题,重启mysql服务,数据库成功连接。 参考文献      1.http://jingyan.baidu.com/album/0a52e3f4158211bf62ed72e6.ht
jemeter服务器性能测试实战总结
Table of Contentsnn服务器背景介绍nn性能测试方法nn测试结果和分析nn第一个问题:service crash重启的问题nn第二个问题:Tomcat JDBC Connection not enough的问题nn第三个问题:Postgresql too many clients 的问题nn本次测试是针对部署在云服务上的单个service的性能测试,此service是整个业务...
解决克隆RHEL7后网络无法启动问题
1、service network restart报错,具体报错如下:rnRestarting network (via systemctl):  Job for network.service failed because the control process exited with error code. See "systemctl status network.service"rn an
memcached客户端源码分析
memcached的java客户端有好几种,http://code.google.com/p/memcached/wiki/Clients 罗列了以下几种rnspymemcachedrnrn * http://www.couchbase.org/code/couchbase/javarn o An improved Java API maintained by Matt I...
No processor available, rejecting this connection是怎么回事啊?
在jbuider中启tomcat有时就会出现No processor available, rejecting this connection,这是为什么啊?原来没有,就是最近会经常出现。rn
Connection not available, Timed out waiting for 180000
[size=11px][b]亲们,我想请问这类问题是不是属于连接池设置有问题的?rn我的用户量有3000-4000,平均每天有2000-3000人同时在线,rn我的WEBSPHER的连接池设置的是rn连接超时:1800秒 rn最大连接数:180 rn最小连接数:80 rnWebContainer :最大是100,最小30。rn由于我对连接池设置数一直不清晰,所以请求亲们给矛帮助或者思路,让我知道是连接池上的问题还是需要从别的方向来解决 [/b][/size]
Mycat系列—Haproxy+Mycat实现负载均衡
Haproxy+Mycat实现负载均衡
分析weblogic数据库线程池无可用连接的问题
现象描述:n1、web页面访问异常慢,有部分页面如下错误:nnn2、日志报错:n2017-02-23 16:53:53 53 [filter.CheckMallCpDetailFilter]-[ERROR] - weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimi
Flutter工程显示“no devices”
使用androidstudio打开flutter工程,在真机已经连接USB的情况下,依然显示&quot;no devices&quot;.n解决方法,在flutter sdk目录输入命令:flutter config --android-sdk 自己的android sdk路径nn...
拜读:kubernetes权威指南(1)
总结一下今日的学习过程rn上午继续调试院里的机房机器,不论怎么改,镜像TensorFlow-GPU运行后,就是不能加载cuda。。。rn接着看书,看了20页。。。rn创建mysql-rc.yaml mysql pod怎么都不成功。。。rn崩溃  最后还来一个mysql   RC竟然不能删除,辛亏备份了系统,明天重来,rn错误总结如下rnrn错误rnError creating: No API to
No buffer space available 一次神奇的维护经历
前段时间在项目维护当中遇见一个问题,方便以后再次遇见类似的问题,可以参考解决问题的思路,记录如下:nn问题概述:nn维护项目当中,客户这边发来消息,称自己的网站登录不上去了,提示用户名密码错误,我就登录到服务器上查看系统日志和报错情况,如图:nnnn这个异常来源部署的一个jar包,用于读取数据存入mongodb,再看了Tomcat也报错了,错误是:java.net.SocketException。...
使用hMailServer搭建本地邮件服务器
使用hMailServer搭建本地邮件服务器
c#.net客户端与redis集群
最全的教程部署redis cluster方式集群,及c# 写的访问集群的源码,自己的下载分数快不够,赚2分,教程地址:http://www.cnblogs.com/uucode/p/6486395.html
开始搭建第一个zookeeper
首先需要下载zookeeper的tar包,地址为http://zookeeper.apache.org,然后再linux中解压并编译tar包。# tar-xvzf zookeeper-3.4.5.tar.gz如果你是使用的是window操作系统的话,需要找解压缩工具来解压上述jar包,并且需要配置JDK的java开发环境,要求JDK在1.6以上在解压完的目录中,bin目录包含了一些命令的脚本,例如
JOOQ实战(一)
package jooptest;nnimport com.panda.core.db.Dao;nimport com.panda.core.db.impl.DBService;nimport org.jooq.DSLContext;nimport org.jooq.Record;nimport org.jooq.Result;nimport org.jooq.impl.DSL;nimport o
使用cisco连接学校vpn出问题——VPN Service not available
我之前在家里是可以用电脑连上手机的热点,再访问学校的内网的。但是现在在宿舍,找到应用程序启动的文件夹,发现只有2kb的快捷方式,多次尝试都无法启动成功,百度后也是各种服务检查,防火墙查看啥的,最后还是直接卸载重装,然后就好了。nn使用远程桌面连接应用时,报错如下:nn提示说:远程桌面由于以下原因之一无法连接到远程计算机:nn1)未启用对服务器的远程访问nn2)远程计算机已关闭nn3)在网络上远程计...
org.springframework.mail在阿里云服务器发邮件失败,连接失败
概述:nnspring mail配置如下,以springboot整合spring mail为例:nnnnspring.mail.host=smtp.163.comnspring.mail.username=xxxxxxxxx@163.comnspring.mail.password=xxxxx //授权码,不是登录密码n# 开启验证nspring.mail.properties.mail.smtp...
文章热词 机器学习教程 Objective-C培训 交互设计视频教程 颜色模型 设计制作学习
相关热词 mysql关联查询两次本表 native底部 react extjs glyph 图标 怎么学习互联网大数据 村干部学习大数据心得