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问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
数据库方言 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
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]
not available
新建文档,保存后,再进入修改数据。rn存盘退出后重新进去看,发现值没有变。刷新文档时,值有所改变。rn但是一存盘回到阅读的状态时,发现内容还是旧的。rn请指教:
wcf客户端报错--Insufficient winsock resources available to complete socket connection
Insufficient winsock resources available to complete socket connection initiation.--rnrnServer stack trace: rn at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)rn at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)rn at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)rn at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)rn at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)rnrnException rethrown at [0]: rn at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)rn at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)rn at PLANCK.DbServices.IDbServices.DataReader(DataReaderRequest request)rn at PLANCK.DbServices.DbServicesClient.PLANCK.DbServices.IDbServices.DataReader(DataReaderRequest request)rn at PLANCK.DbServices.DbServicesClient.DataReader(PKDatainfo data)rn at PLANCK.WCF.DbServer.DBHelper.GetCmdPerson(String imsi)rn at PLANCK.GPRS.SentCmd.SentCmdInfo.GetPersonCmd(String imsi)rn at PLANCK.GPRS.Sockets.PkSockets.ReceiveSocktes(Object sockets)rnrn---目前我还没找到好的解决办法,我只有重启wcf(windowsServices服务托管的wcf) 才能正常工作。rnrn请问我有什么好的解决办法呀?
springboot报错Connection is not available, request timed out after 30001ms.
这个报错我看网上没有明确的答案啊rn 环境springboot2.0 jdk1.8 数据库连接spring.datasource
No ADV available
我打开我的Android SDK and ADV Manager,里面的Visual devices中为什么没有任何ADV的条目呢?rn [img=G:\学习\XZ5OKZ4P3Y@ALH8CVVY7.jpg][/img]
oracle not available
我对init.ora文件做了一些改动,还有其他别的一些操作。不过,好象没有什么致命的操作呀。rn在DB没出现问题前,在SVRMGR里用INTERNAL登陆,怎么还需要口令吗?rnrnsvrmgr>connect internalrn口令:rn是不是有人给加口令了。rn进都进不去。
ORACLE not available
每次重启机器提示ORACLE not available !服务中数据库的状态处于启动状态在rnsvrmgrl 中运行 :connect internalrn shuntdownrn 提示我:ORACLE not availablern 运行:alter database open rn 数据库启动起来没有问题可是每次重新启动都这么麻烦也不好呀!请教高手如何解决 rn
No ManagedConnects Available!;
05:30,156 INFO [STDOUT] org.jboss.util.NestedSQLException: No ManagedConnects Available!; - nested throwable: (javax.resource.ResourceException: No Managrnonnections Available!)rn小弟请教一下这是个什么异常?怎么解决?
Feature is not available
VFP6+SQL2000用的是远程视图rn表单新增数据,存盘的时候,提示:Feature is not available错误,但存盘成功,单步跟踪时,没有错误,生成exe执行就出现此错误,哪位有遇见过类似问题?请指点rn
No target available
环境:rnmyeclipse10.0rnsdk21.0.1rnadt21.0.1rnadtookit21.0.1rnrn更新了以后,rn点击启动android虚拟机,总是:rnLocation of the Android SDK has not been setup in the preferencesrn[color=#FF0000]进入android preference中,显示No target available[/color]rn点了 “应用”和“确定”也不管用rnrn[color=#FF0000]一定要我在SDK Location路径后面加一个“\”,斜杠才可以,rn下一次启动myeclipse又不可以了,再加一个“\”,……[/color]rnrnrn似乎myeclipse总是在启动之后 不去加载SDK Locationrn总之,路径要有所变化,但是又必须还是正确的路径,就可以。rn这个问题怎么解决??rnrn思考之后:rn仔细查看myeclipse启动时的情况,似乎没有调用android sdk content loader。rn而每次我改变了路径之后,才会去调用android sdk content loaderrnrn[color=#FF0000]有什么办法启动myeclipse的时候调用android sdk content loaderrn或者有什么其他办法可以解决问题么?[/color]rnrnrn感谢大家!rnrnrn
那些搞不懂的数据库连接异常
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30010ms. 原因:请求数据库连接时长时间未获取到时,会报这个错误 修改配置项:datasource.primary.connection-timeo...
connection
连接数据载图
no socket available
我正在学习尚学堂的HIBERNATE视频,我把它的项目导入到My Eclipse中,然后在导入JUNIT3的包然后运行测试,My Eclipse就提示no socket available了,怎么会事啊???
Connection
Sql数据库连接资料Connection
connection timed out: connection
请教一个问题:rn我做了个探测局域网用户的程序,对方能收到我的udp广播数据报,但用tcp连接总是会超时是什么原因呢·?rnrnclass detector extends Thread //主动探测主机信息发送端rn rn String userIp;rn public detector(String userIp)rn rn this.userIp=userIp;rn rn public void run()rn rn tryrn rn System.out.println("start to connect "+userIp+" ......"); //可以运行到这里rn Socket s = new Socket(InetAddress.getByName(userIp),5001);rn InputStream is = s.getInputStream();rn OutputStream os = s.getOutputStream();rn os.write(InetAddress.getLocalHost().getHostName().getBytes());//写入用户名rn os.write(System.getProperty("user.name").getBytes()); //写入登录名rn os.write(InetAddress.getLocalHost().toString().getBytes()); //写入ip地址rnrn String userName,loginName,userIp;rn byte[] buf=new byte[100];rn int len=is.read(buf);rn if(len!=-1)rn rn userName=new String(buf,0,len);rn len=is.read(buf);rn if(len!=-1)rn rn loginName=new String(buf,0,len);rn len=is.read(buf);rn if(len!=-1)rn rn userIp=new String(buf,0,len);rn al.add(new user(userName,loginName,userIp));rn tableInit();rn rn rn rn is.close();rn os.close();rn s.close();rn rn catch (Exception ex)rn rn ex.printStackTrace();rn rn rn
Connection[] cons = new Connection[threads];?
这样就可以是connection使用多线程吗?rnrn这个概念有什么意义呢?rnrn我在JDK的文档里找不到相关的资料啊。rnrn
missing connection of connection string 得错
我用了一个 data module 窗体,可程序在调试到创建data module窗体的时候报出 missing connection of connection string 得错。是什么原因呢?即在工程单元里的rnApplication.CreateForm(TfrmData, frmData); 语句出错,其中frmdata是我对data module 的命名,这个里面只有一个adoconnection 控件,这个控件的连接语句是直接build的。但接着运行,也能对数据库进行操作。 rn
socket no buffer available
socket no buffer available,using delphi ICS and java socket
database transaction infomation not available
我用openwithparm()打开一个窗口,但是我在按下按钮后出现对话框 database transaction information not available call settrans or settransobject function ,之后窗口可以正常进入,这是为什么 请各位专家解决rn 附代码:rnif ddlb_1.text="" thenrn messagebox("注意","请选择您要查看的部门")rn return;rnend ifrnrnstring parmrnparm=ddlb_1.textrnrnconnect using sqlca;rndw_department.settrans(sqlca)rndw_department.retrieve()rnopenwithparm(w_dview,parm)rn
Scalable & Available Patterns for Success
作者是Cloud Foundry的前任内核架构师Derek Collison,117页PPT,详细讲解了可扩展性和高可用应用的成功模式。几个关键字:消息驱动架构,负载平衡,平行计算,Master Record,Replication
“KVM is not available”的相应解决方案
目录 kvm简介 kvm操作工具介绍 kvm安装 kvm使用实操 kvm简介 kvm操作工具介绍 KVM管理工具基本有三套。 qemu: qemu-kvm qemu-img libvirt: GUI:virt-manager CLI:virsh, virt-install kvm安装 #yum install ...
No projects are available for deployment to this server
我把自己用Eclipse写的一个项目移到到MyEclipse上,总是出上面那个错,都不知道上面原因,谁遇到过告诉我一下?十分感谢,没照出来原因都快把我郁闷死了!
The requested resource (/strutstest) is not available
web.xmlrnrnrnrnrn actionrn org.apache.struts.action.ActionServletrn rn configrn /WEB-INF/struts-config.xmlrn rn rn 0rnrnrnrn actionrn *.dornrnrnrnrnstruts-config.xmlrnrnrnrnrn rn rn rn rn rn rn rn rn rnrnrnrnrnLogin.jsprnrn<%@ page language="java" contentType="text/html; charset=ISO-8859-1"rn pageEncoding="ISO-8859-1"%>rnrnrnrn rn Insert title herernrnrn rn username: rn password: rn rn rnrnrn
关于 InputStream 和 FileInputStream 的available()
今天写了一个小程序:从网上读取一个图片到一个字节数组中。rnrn代码大致如下:rnrnimport java.io.*;rnimport java.net.*;rnimport java.sql.*;rnrnpublic class FileTestrnrn public static void main(String[] args) rn rn String remoteFile = "http://192.168.2.242/haha.GIF";rn String localFileName = "HEHE.GIF";rn int bytesum=0;rn int byteread=0;rnrn tryrn rn URL url = new URL( remoteFile );rn HttpURLConnection conn = ( HttpURLConnection ) url.openConnection();rn conn.connect();rn InputStream inStream = conn.getInputStream();rn FileOutputStream fs = new FileOutputStream( localFileName );rn //byte[] data = new byte[(int)inStream.available()];rn byte[] buffer = new byte[1444];rn System.out.println( inStream.available() );rnrn while ((byteread=inStream.read(buffer))!=-1)rn rn bytesum+=byteread;rn fs.write(buffer,0,byteread);rn rn System.out.println( buffer.length + "|" + bytesum );rn fs.close();rn inStream.close();rn conn.disconnect();rnrn FileInputStream fin = new FileInputStream(localFileName);rn int count = -1, total = 0;rn byte[] data = new byte[(int)fin.available()];rn System.out.println( fin.available() );rn fin.read(data);rn System.out.println( data.length );rn fin.close();rn rn catch ( Exception e )rn rn e.printStackTrace();rn rn rnrnrnInputStream的available(),似乎总是9932,需要循环读取该文件到一个字节数组中。rnFileInputStream的available(),则和文件的大小完全一致,一次就read全部数据到字节数组中了。rnrn是这样的吗,有哪位朋友做过测试?
关于No source available for "__kernel_vsyscall()
很奇怪的错误No source available for "__kernel_vsyscall(),rn在这一句 h = gethostbyname(hostname);上下都没有释放资源,一到这一句就出这个错,检查hostname也没错,这是什么原因啊,求教。
关于 available()的问题
[code=java] public static Member[] readObjectsFromFile(String filename) throws IOExceptionrn rn FileInputStream fileinputstream = new FileInputStream(filename);rn ObjectInputStream inputstream = new ObjectInputStream(fileinputstream);rn List list = new ArrayList();rn int i = 0;rn System.out.println(fileinputstream.available());rn rn tryrn rn while(fileinputstream.available() > 0)rn //改成 while(inputstream.available() > 0) 则不行 rn rn list.add((Member)inputstream.readObject());rn i ++;rn rn rn catch(ClassNotFoundException e)rn rn e.printStackTrace();rn rn rn inputstream.close();rn Member[] members = new Member[i];rn members = list.toArray(members);rn return members; rn rn[/code]rn判断剩余字节数为什么用inputstream.available() > 0不行呢?实测时它就是返回0
document command is not available
下面代码是从organization.nsf中取员工编号为ygbh的照片,写入当前新建文档,并在当前文档即时更新,功能可以完成,但最后弹出一个出错提示: document command is not available,请高手指教。rnSub Click(Source As Button)rn rn Dim s As New NotesSession rn Dim wks As New notesuiworkspacern Dim doc As notesdocument 'doc in orginazation.nsfrn Dim curdoc As notesdocument 'doc currentrn Dim newDocument As notesdocumentrn Dim uidoc As notesuidocumentrn Dim newdoc As notesdocumentrn Dim item As Notesitem rn Dim keys(1 To 1) As Stringrn rn Set s=New notessessionrn Set uidoc=wks.currentdocumentrn Call uidoc.fieldsettext("saveoptions","1")rn Call uidoc.savern Set curdoc=uidoc.documentrn keys(1)=uidoc.fieldgettext("ygbh")rn Set db=s.getdatabase("","organization.nsf")rn Set view=db.getview("person")rn Set doc=view.getdocumentbykey(keys,True)rn rn If doc Is Nothing Thenrn Messagebox "Not find your name,check first please."rn Elsern Set item =doc.GetFirstItem("photo")rn Call curdoc.RemoveItem("photo")rn Call curdoc.CopyItem(item,"photo")rn curdoc.name=doc.name(0)rn curdoc.dept=doc.department(0)rn Call uidoc.fieldsettext("saveoptions","1")rn Call curdoc.save(True,False)rn Call uidoc.fieldsettext("saveoptions","0")rn rn 'Call uidoc.reloadrn 'Call uidoc.refreshrn rn strDocumentUNID=curdoc.UniversalIDrn Call uidoc.closern rn Set db=s.CurrentDatabasern Set newDocument=db.GetDocumentByUNID(strDocumentUNID)rn Call wks.EditDocument(True,newDocument)rn 'Call uidoc.fieldsettext("saveoptions","0")rn End Ifrn rnEnd Sub
求助--ORA-01034: ORACLE not available
ERROR:rnORA-01034: ORACLE not availablernORA-27101: shared memory realm does not exist
IP-Config: No network devices available
bootm 31000000后,出现IP-Config: No network devices available,以致于无法挂载根文件系统,该问题该怎么解决?求好心人帮忙
ora_01034:oracle not available
在命令行下 set ORACLE_SID=orcl 了 还是不行 怎么办啊 在线等啊 各位帮帮忙啊
Refactorying not available symbol
代码:rnCString str; rnCppSQLite3DB db; rnCppSQLite3Query q;rnrndb.open(L"\\Flash\\DataBase0.db3");rnstr.Format(_T("select name from Student WHERE bh=1"));//使用VA,Format底下出现红色波浪线,rn // 提示“Refactorying not available symbol”rnq=db.execQuery(str);rnCString Sname=q.fieldValue(0);rnq.finalize();rndb.close();rnrn请高手指点一下,这是什么原因?代码哪里出了问题?rn谢谢!rnrn
Servlet actionServlet is not available
strust系统运行时,提示“ Servlet actionServlet is not available”,啥原因,下面是struts-config配置: rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn 其中value="jdbc:oracle:thin:@192.168.0.12:1521:court" />中的court为数据库sid rn
Is CoCreateInstanceEx available in the CE.NET ?
Any advice is welcome and appreciatedrnrnthank you in advance!
问题Servlet action is not available
点了登入就报错啊...rnpublic class LoginAction extends Action rn rn public ActionForward execute(ActionMapping mapping, ActionForm form,rn HttpServletRequest request, HttpServletResponse response)rn throws Exception rn String id = null;rn String pwd = null;rn rn if (form != null) rn id = ((LoginActionForm)form).getId();rn pwd = ((LoginActionForm)form).getPwd();rn rn HttpSession httpSession = request.getSession();rn ActionForward actionForward = null;rn List list = HibernateSessionFactory.execQuery("from Employee where id="+id);rn List list2 = HibernateSessionFactory.execQuery("from Employee where pwd=" + pwd);rn List list3 = HibernateSessionFactory.execQuery("from Employee where id=" + id + " and pwd=" + pwd);rn if (list == null || list.size() == 0) rn ActionErrors errors = new ActionErrors();rn errors.add("idfalse", new ActionMessage("errors.login.id.notvalid"));rn this.saveErrors(request, errors);rn actionForward = new ActionForward(mapping.getInput());rn rn else if(list2 == null || list2.size() == 0)rn rn ActionErrors errors = new ActionErrors();rn errors.add("pwdfalse", new ActionMessage("errors.login.pwd.notvalid"));rn this.saveErrors(request, errors);rn actionForward = new ActionForward(mapping.getInput());rn rn else rn httpSession.setAttribute("employee", (Employee)list3.get(0));rn actionForward = mapping.findForward("success");rn rn rn rn return actionForward;rn rn
database available space = 0 ?
今天查一个服务器的数据库,右键点击某数据库属性rn发现写着 Database Size: 6108.07MB, 而Space Available: 0Mrnrn不知道怎么回事,这个数据库的Data和Log都是不限制大小自动增长的,而且磁盘空间也够rn不知道这个是什么意思,这样数据库有没有危险,要怎么解决?rnrn谢谢
struts+hibernate Servlet action is not available
web.xmlrnrnrnrnrn rn actionrn org.apache.struts.action.ActionServletrn rn configrn /WEB-INF/struts-config.xmlrn rn rn debugrn 3rn rn rn detailrn 3rn rn 0rn rn rn actionrn *.dorn rn rn index.jsprn rnrnrnjsp页面rnrn rnrnrnstruts-config.xmlrnrn rn rn rn rnrn为什么会出现Servlet action is not available异常?
No Java compiler available
我用swt做了个外壳程序来程序来运行tomcat中的bootstrap.jar类,用如下命令:rnjava -Dcatalina.home="C:\tomcat\bin" rn-Djava.endorsed.dirs="C:\tomcat\bin\common\endorsed" rn-Dcatalina.base="C:\tomcat\bin" rn-Djava.io.tmpdir="C:\tomcat\bin\temp" rn-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager rn-Djava.util.logging.config.file="C:\tomcat\conf\logging.properties" rn-classpath "D:\jdk1.5\lib\tools.jar;C:\tomcat\bin\bootstrap.jar;" rnorg.apache.catalina.startup.Bootstrap startrnrn能正常启动tomcat,但运行jsp的时候出错:rnrndescription The server encountered an internal error () that prevented it from fulfilling this request.rnrnexception rnrnorg.apache.jasper.JasperException: java.lang.IllegalStateException: No Java compiler availablern org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:532)rn org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:360)rn org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)rn org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:803)rn com.artton.accountant.sys.web.filter.AuthFilter.doFilter(Unknown Source)rn org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)rn org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)rnrnrnroot cause rnrnjava.lang.IllegalStateException: No Java compiler availablern org.apache.jasper.JspCompilationContext.createCompiler(JspCompilationContext.java:229)rn org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:561)rn org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)rn org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)rn org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)rn javax.servlet.http.HttpServlet.service(HttpServlet.java:803)rn com.artton.accountant.sys.web.filter.AuthFilter.doFilter(Unknown Source)rn org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)rn org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)rnrn不知为何,请有做过此方面工作的朋友帮帮忙!
ORA-01034: ORACLE not available
装上orcle 10g,用了几天之后,sqlplus启动后,输入用户名和密码后,提示:rnERROR:rnORA-01034: ORACLE not availablernORA-27101: shared memory realm does not existrnrn检查了服务,都是开启了的。也重启了的。rnrn但是在运行里面输入 sqpplus,输入用户名和密码后却能进入,但非得要以system/password as sysdba 才能进入。rnrn请问ora-27101 shared memory realm does not exist如何解决? 到底是哪儿出问题了呢?
相关热词 c#串口测试应用程序 c# 匹配 正则表达式 c#防止窗体重绘 c#读写txt文件 c#挖地雷源代码 c#弹框选项 c# 移除 队列 c# 密码写入配置文件 c# 获取可用内存大小 c# 嵌入excel编辑