我的日常

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

动态微博

查看: 1479|回复: 1

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

[复制链接]

7

主题

3

听众

383

金钱

版主

该用户从未签到

跳转到指定楼层
楼主
发表于 2016-07-03 12:39:09 |只看该作者 |倒序浏览
2016-07-03 09:47:26 -3906 [main] ERROR   - init datasource error. a$ Q2 c; q, J! _! ]3 ]
java.sql.SQLException: Could not retrieve transation read-only status server, H, K. g1 |: r& a7 L* ^+ E
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)* O. b7 W1 ]# i+ X5 o; c
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
9 e$ W4 |3 N/ \! Y5 e    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
# F! l- n+ M. P    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
0 c+ S1 _2 m3 R1 z    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:902)2 z0 x3 ]2 x! t, Y6 u. N' Z
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:892)0 q" G4 d9 q# O! N
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3607)# N% `7 p2 F8 h# ~; {9 b. x
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3576)! y5 ]" q8 D9 l4 @5 v8 E# F
    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:383)5 \) V# H* V1 r. S
    at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:892)9 b+ J9 p+ u* p2 I1 R% m
    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:380); S( s: o4 q: |' @+ }
    at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.isReadOnly(ConnectionProxyImpl.java:292)
- m6 B5 e! }2 d' C! E! u    at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:96)
3 q, V0 J/ v- b% f- C) ~2 Z    at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:619)
! t9 [* K0 ~9 \( q7 G    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
$ F* J  m: A+ W8 A3 Z% I* }* Z    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
4 p- T3 ~+ s4 V% T& ^# P' C    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)& e4 J/ m( X- o( a; Z7 W8 E$ d" B. V6 o
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76)' x4 C# C) h* ^, A! I' ]
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61)# e2 Y1 P, `. P" C
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49)1 s# _: v% A  b2 F! K8 X
    at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445)/ ^, G4 l) L# o: m+ `- B
    at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336)
) h9 L7 _" }2 `3 K# U2 n3 [    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612)
7 s2 m' j7 f* J) \1 d    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)
7 U" J7 u- L$ w" @, P    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)) e( W7 H% }7 ^, U
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)+ x7 Q3 w% `8 h/ f+ w
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
9 l( n# O7 Z6 s# E    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
% a- C( Y: J! v: I# v    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
+ T/ J& U0 z& ?3 t    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)# s" o7 x; W  I& {+ e  w
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328); F& z9 D: ]9 ]3 {! f% G; e
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
- h, k6 [- x1 Q' R    at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:646)1 R- r' y( \; y% ^; l$ `
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)
) y, u# B0 u# z' M    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1114)/ W  x, l: ~3 O& F7 ], c
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1017)
, t' [- q9 k+ C0 H% B% J* W0 M    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
7 g3 M# x3 K! h9 B( t9 Q" V' w    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)( [0 t( F3 c- A
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)& B0 K5 T6 q+ g' [
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)9 \+ T$ m& X+ q( M
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
' L6 v- D3 y- K7 m. J    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)3 W% k0 g/ B1 ?) u8 H/ A) V, r0 q
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:446)# L" }4 R+ u) L! G- ~) A
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:420)5 o* h. V4 S- T& K5 s% G" S6 i" u
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:545)
$ L: S% d- j+ j2 }4 {! f4 W2 b    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:155)
" F' J; K, ^( _; Z! B    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
% E' L2 d) }7 G$ H    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:305)" t) V0 A6 J0 x3 s% I% a# k) S/ |
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185)) \0 p# n# j, Z8 s* g
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)2 n- f( ]( |0 l: H3 F
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
& X: g) T1 ~8 y- q    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)9 g2 }, A0 p" E* w5 a6 A
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
) D% O* b  ~. {) f1 ?    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)+ s) q. W% B. j7 }9 s8 w) ^
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
- o! O, ?4 c+ {. ]    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)3 p* m; \: H9 v) F7 E% Y
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)
  H9 F4 D6 x" {* L+ |8 Y& I    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
( g; F1 z: T& ]  k  j    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)  E+ j9 H& t/ B  n) x. e4 J
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)  n) v6 u' M6 m/ A0 K6 Y
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
! g, M; o! s: L    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
/ W8 Q0 P8 w5 [3 J1 Y+ u1 S  ^    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)! C+ ^9 e* N3 U+ s$ |- S
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
5 v8 @/ F$ k6 A* A$ Z# t9 K& i    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
0 v2 `8 r! {% C+ f    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)5 c; Q9 r9 v% K; N" f
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
$ ~  {7 `% {$ x; l6 S4 R    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
% q3 Q$ y1 B8 X& H# s: X+ |" h    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)* ~+ M  G* V# _  f0 _% R
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)1 ]2 m0 Q# l" W
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311); p: w' s  l, l4 G
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
$ [$ T9 `' d4 }- Z4 ~    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)2 p% ~: i! y. ?2 m9 I4 w" Z) |9 N
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)/ ~; [& U: B6 p1 m; o) ^: W8 E  l
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)  y1 v7 {. P  c
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)0 r2 X# C# }' P5 |3 v# L
    at org.apache.catalina.core.StandardService.start(StandardService.java:516)1 E& a) ^5 u+ z
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)# C( p+ o, O) C, A2 @
    at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
9 u$ z3 s1 z* R9 n    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
1 L# e9 C1 v$ [    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
9 f* v: d3 h1 }    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
0 A& q! I0 ]8 r5 y  K    at java.lang.reflect.Method.invoke(Method.java:601)
& X; E( t- @. a- ?9 e2 l3 O    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
0 d5 c# r9 j+ M    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
3 r5 A; ]  ^# v5 a2 D# UCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure+ U0 u* G" m' O; O" g4 j5 q6 j5 S
5 b7 [: B8 H9 _; S2 H
The last packet successfully received from the server was 31 milliseconds ago.  The last packet sent successfully to the server was 31 milliseconds ago.
$ e, [1 |8 `+ k2 p# J1 a+ Y    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)  c1 ]1 Y$ s8 H5 B- R
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
6 f7 f. R. v! Y    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)8 X% F# K0 u( Z% p( B
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)/ Z, k5 f) m0 a* m: }% Y
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)5 ]$ W3 y' W; S0 ^
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)
: o0 u! R: e& S* i. Z, V  R    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427)
4 A# o4 m- W  g; {# n+ ]    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327)& ?+ Y9 _6 q0 ?0 F
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)2 q+ o: H& ]1 J# ?9 N+ v0 [* V/ C
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435); A3 j" w! Y5 R
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
; C( n/ k+ w! ]& F3 N& p    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
3 _+ B8 v. K  o    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)5 m* w* a/ |5 |0 d+ k" O
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)' [) j8 f. W1 S" r& u
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3601)
7 d5 Z8 _$ P3 Q; v1 l4 k    ... 78 more
, s* o+ S& C9 ^3 K+ LCaused by: java.net.SocketException: Connection reset
! T& T- {6 Y2 H: D& z% z, o    at java.net.SocketInputStream.read(SocketInputStream.java:189)
" b$ m! g" a! w9 P1 y    at java.net.SocketInputStream.read(SocketInputStream.java:121)
1 e: w0 P) b. C    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100), f! R: Y- t, w. ~$ X+ T
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143): G* D3 |0 c, M6 s! t
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173)2 \+ I3 o. f6 X- p
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911)  f; W9 a" P2 }7 d& j
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3337)6 u6 I& a8 C1 j; \6 Q0 R
    ... 86 more
' D6 F0 V# t: W$ S; [

科帮网 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群 科帮网手机客户端
快速回复 返回顶部 返回列表