我的日常

登录/注册
您现在的位置:论坛 盖世程序员(我猜到了开头 却没有猜到结局) 盖世程序员 > 程序启动 数据库访问失败问题
总共48087条微博

动态微博

查看: 1497|回复: 1

程序启动 数据库访问失败问题

[复制链接]

7

主题

3

听众

383

金钱

版主

该用户从未签到

跳转到指定楼层
楼主
发表于 2016-07-03 12:39:09 |只看该作者 |倒序浏览
2016-07-03 09:47:26 -3906 [main] ERROR   - init datasource error+ Y/ m! Q8 F4 [8 W! v: b
java.sql.SQLException: Could not retrieve transation read-only status server. f0 Q* M) ?- G' n% `# Y" I% G
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
+ ]" R% ]+ Y' _1 ^    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)3 p/ a/ h/ B8 ]/ V' T
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924). y2 B1 ^  M+ r4 t
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
  h. Z. K% f: i! i- j" P4 ]6 l    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:902)
! `  Q0 b6 t$ v. C2 L9 `    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:892). Z& N0 v) ]) ?( F) T0 G6 ~* _
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3607)
" r& a1 r0 n! Y- \, q$ L& `, C    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3576)
+ d+ c6 I& L  w/ F    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:383)
" r" k4 I) j2 `, T    at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:892)+ B2 e8 w) F  s$ @
    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:380)
: E2 l* q4 v2 t: C! C( }    at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.isReadOnly(ConnectionProxyImpl.java:292): u# T% v- S5 k$ u: p- |) i- C; w. X
    at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:96)
& J: L; X4 x8 P    at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:619)
% R0 T7 K* f7 R8 I& G) q    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
1 F0 h4 x4 A% r& I  z( m* q    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)( |+ [& L- `7 V9 s/ L6 Y
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)" t8 K8 H% T+ i4 ~$ T
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76)
% m4 V$ A4 X. z    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61)
' ^* `0 k$ X8 `" z    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49)/ V# z2 y& L7 X7 j
    at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445)
; m' L. p9 @9 X1 Q3 P3 L    at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336)
9 N) [" f1 f6 p% C, c; v' O    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612)1 E; P$ c. S7 c- d' K$ ~( F  A: M
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)
4 B: a5 p- Y- g3 A# `    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
8 |4 k/ Z  i& Y3 A# T! O- }    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
: e- g% b, i* @% S; p/ n: k& w) Q    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
# S. \( b3 O9 a! ~    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
! b/ D1 Y8 l# s. j$ F5 i    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)5 X% d: W- F+ S2 V
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)% m  f' d# a/ K- [7 y3 X1 R
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
( ^/ S, i8 F& O7 Z: V    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)& e$ n' B' x! N6 A! j; L( c2 K; G
    at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:646)
& m- B7 P0 b; l3 N- p) Z; f    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)# ~- _6 z$ A2 \7 H
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1114)
  d! A0 P: y! ]& b+ M% T# K! v3 r    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1017)
  \2 p& [- g. c/ r! I    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
1 e9 M' z8 \: E  ?- v; N    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)# k/ z1 Z8 P+ V1 X. P/ f5 Z( n  R$ a
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)$ T4 S. ?2 r, j0 @
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
5 H8 A0 f$ ]. z- b    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)0 R7 Z% |2 Q7 R2 ?  }  [
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
/ B2 x- v+ d8 X( ]& N- G+ q. V& X    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:446)+ M5 N" R/ Z9 D! d$ f4 Q/ C
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:420)! \7 U5 \3 O8 }* L& n: S' O$ u" w5 n
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:545)# |/ Y: \% }2 T5 E
    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:155)
! p0 H& a, H& Y2 ?1 S0 v# u' U' x    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
& u7 |" C8 ?" `, i/ u4 J- h    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:305)# R' r7 q" I3 B+ u3 I" L: X9 B
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185)+ r, u9 B& m$ L& g- M4 Q
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
+ e; q! o" s. S; @( o$ M    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)% p5 a) P6 R8 d, B
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
9 m0 l  Q4 F' ~! h: }8 L    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228). J" J, `9 D- S  i4 D4 V7 c
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
7 x! K+ n1 [. g0 h: v7 k" u& U    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
; e0 q! u6 I( Z- x% j/ w2 w    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)
+ ]0 M/ H& k3 W/ A  j) o    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)3 j: r( C* k: k1 L7 Q1 |
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)9 X' c# Y) N+ X1 I
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)9 e5 H9 w, J2 V% Y! E
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)% Y# i: z( c  T$ p/ v6 g
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
) j' ]( w: z0 f7 K    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)/ j) Z7 R1 @4 w/ k8 I& W8 z; M+ u9 g
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)9 o1 p# @+ o" d9 Y- @
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
- ], O  V6 U2 O( t. \    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
% N% t# X9 b3 q5 p9 a' M( D    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
! E% H: y( u% A6 v8 R# r8 u$ ~. {    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
  z# y, ?7 C& B: \+ y& h! J    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
  `9 i! s, M% ^    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
$ L8 U- |7 O' S' V    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)  T; e% D) A0 i6 ]+ o, F7 ^2 E
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)2 X2 g0 ~/ d% T
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
% O* Y+ p8 F. [+ I+ t, s    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)% w# o9 _! t; C/ W- y* L1 X1 V
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
% Y# r/ ~; S4 N2 i1 X( ?    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)& a' \1 _: o4 `- V: E' X5 H: l
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
) |, J! }3 B; Z4 P2 S    at org.apache.catalina.core.StandardService.start(StandardService.java:516)
+ w! X; D, Z' g9 q- x2 s0 |5 S    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
4 \* w# I! d* g0 y* p    at org.apache.catalina.startup.Catalina.start(Catalina.java:566)3 B( z" g' X3 Z8 P0 F" m" a
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
0 F: L! m  U$ T! l# u. ~    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)( d! |& a" Y5 P$ E6 ~  Y
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)0 B4 ^( I* m$ w$ d0 p3 Y1 O: U/ m
    at java.lang.reflect.Method.invoke(Method.java:601), e6 f! O7 Z+ L0 d
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288). Q& U8 P: U6 Y( ?* h' D
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413). \1 X- N% N+ A; D1 j+ H/ w
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- N  A3 E3 R; Y, I5 t( ~! F; w( [; |
The last packet successfully received from the server was 31 milliseconds ago.  The last packet sent successfully to the server was 31 milliseconds ago.8 l( p% I/ Z3 n8 `
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
) [# e; G; s" X8 @  D  {) f! z    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)( Y4 `0 }/ d' D
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)+ a: d* m( ^5 P$ Z4 X& N9 L7 g
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)3 _: Y& P, v) |5 L& Q& k( Z5 D9 d
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
$ S  t! P3 C2 P9 ~" X% c+ o    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)
: y3 _9 `( v  ^! D7 m2 f    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427)0 |4 y* T: c& N( j8 O* `
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327)
+ ?8 S! u: P( _5 X- h7 V    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
/ I% q3 T( U6 Z0 Y: A/ a, W" {    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)9 s- {2 q7 E& B" s* Q1 m
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
* @2 Y! l, X% ~$ c( ]' \  H8 @' l    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
( C7 v9 z: b. d# b    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)0 a# v+ P, K& m
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)1 {1 @9 D8 ~' C, t8 T; o$ ]
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3601)
& u  ]) O  K6 ~1 g! t, g: b    ... 78 more3 q2 P1 {# P+ G3 d0 ?
Caused by: java.net.SocketException: Connection reset5 h" z$ J; }8 z; M  E( ?- f: {
    at java.net.SocketInputStream.read(SocketInputStream.java:189)
% F/ [! y7 Y; r& N* \    at java.net.SocketInputStream.read(SocketInputStream.java:121)
: D2 V+ v" |5 I* J- V! S/ T    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100)+ |$ J4 G: J$ x$ O6 q, i
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143)! Q% O$ s6 \7 {. D3 i0 i% K
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173)3 Z: V. B" \! H( T  A# m8 V2 n
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911)
) H( U0 P" j/ C    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3337)3 l- }& t& w, P' E
    ... 86 more, ?( w& ~  _- U! u- O/ N" t

科帮网 1、本主题所有言论和图片纯属会员个人意见,与本社区立场无关
2、本站所有主题由该帖子作者发表,该帖子作者与科帮网享有帖子相关版权
3、其他单位或个人使用、转载或引用本文时必须同时征得该帖子作者和科帮网的同意
4、帖子作者须承担一切因本文发表而直接或间接导致的民事或刑事法律责任
5、本帖部分内容转载自其它媒体,但并不代表本站赞同其观点和对其真实性负责
6、如本帖侵犯到任何版权问题,请立即告知本站,本站将及时予与删除并致以最深的歉意
7、科帮网管理员和版主有权不事先通知发贴者而删除本文


JAVA爱好者①群:JAVA爱好者① JAVA爱好者②群:JAVA爱好者② JAVA爱好者③ : JAVA爱好者③

七总是个逗比

7

主题

3

听众

383

金钱

版主

该用户从未签到

沙发
发表于 2016-07-03 12:41:14 |只看该作者
解决办法:更新数据库连接 jar
回复

使用道具 举报

快速回复
您需要登录后才可以回帖 登录 | 立即注册

   

关闭

站长推荐上一条 /1 下一条

发布主题 快速回复 返回列表 联系我们 官方QQ群 科帮网手机客户端
快速回复 返回顶部 返回列表