我的日常

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

动态微博

查看: 1446|回复: 1

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

[复制链接]

7

主题

3

听众

383

金钱

版主

该用户从未签到

跳转到指定楼层
楼主
发表于 2016-07-03 12:39:09 |只看该作者 |倒序浏览
2016-07-03 09:47:26 -3906 [main] ERROR   - init datasource error
3 u3 J$ u3 o! Kjava.sql.SQLException: Could not retrieve transation read-only status server
: r( l. I5 j% G( e" V    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)3 {# k, N7 w! G+ C9 o( E
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
; P" ^4 D* h) F& S+ F& ^    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
6 L/ h7 @5 M1 \0 E    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
( T) z& }/ T/ [3 q3 i4 O# _) R. d    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:902)
7 J( v$ b+ O) J! X$ t& W    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:892)
2 W: u. F' L% a, f    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3607)
, u* n  @, W$ ^* R3 z) [    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3576)
$ x$ X4 R8 a) F7 N! G/ ?: e8 a    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:383)
+ |$ g. f$ U# M% @; E1 ~0 b    at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:892)
  `0 L7 r8 [- f: }    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:380)7 a7 F! H; @. N9 n& {' A$ c
    at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.isReadOnly(ConnectionProxyImpl.java:292)
5 b' Z- `  r5 Z3 o# W& H    at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:96)
. S* g3 \# s! o6 Q3 X3 W    at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:619)
" D# H# o5 z0 u5 w. K+ q( ?) n    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)  D* M1 E% }4 P5 o% u
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
! Q+ u1 @* K+ M6 G4 y4 {) H    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
) U5 [* g5 V0 f, I& t# V/ c) y) U    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76)/ I1 c) K5 H8 ~1 E
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61)
# B  m, R# L" o$ n    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49)
9 t1 ]. ~, T- C; n: `6 Y- @* c    at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445)
- ~+ |2 `# N2 T+ M$ ?" C9 Q% W    at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336)! G& b% t% o' ~+ l' [- P, H- m
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612)  L6 @* |4 G; r
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)
4 i+ J; J  @2 ^+ k8 x& v    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)0 x2 t7 q, X# t( q* G: _
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)5 ~8 @( ?3 P5 L" j7 u
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
5 l, w& p! V- L) [  g9 v    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
( l* B" |! z8 K3 ~7 V    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
0 x3 x$ i& ]' r% `    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
: ?3 [& g3 z5 M% p( O" k    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)* A9 n9 v' f) u( T, w5 Q* U: b% U
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)7 B' H9 M5 [2 A! Y2 X
    at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:646)
+ J$ q% g; i' K7 z9 N5 o    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)) i1 r2 ^- o. x' {! L! @8 y
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1114)7 j7 R% I. z) A. _
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1017)3 @$ u2 @2 U* |: r
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)1 c3 A% T, l; E
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
5 o) e9 M, S9 G" Z, {: @$ l3 j+ K    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
. C3 g) z- m( ~! |2 P6 c    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
5 {$ |" H& Z6 F    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
0 ]* {. _* y2 x" l2 S    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)& l4 u) z( y: k5 J) _9 C
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:446)
- l. t0 }9 l/ W* @* e5 Z    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:420)8 q- u& H+ Y& e
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:545)
; o; f+ j* s. l6 }, j' z2 p    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:155)& \6 m: h( d8 Y8 o: Q
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
& h- }1 V/ H$ |1 n    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:305)( }* j3 f- n6 s" _
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185)
/ Q: u. C. L2 P; G: N' g$ `/ W; x* X% j    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)" P, q+ }" ]0 M+ u9 Z' x, M# U
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
, f! u0 z5 @6 A    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
$ e9 W3 K4 N6 g. W- @; t    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228), `. ]! ^5 V- J, i, Q
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
4 [: j( x; d# |6 N# g    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
3 ?: A3 l% b$ j5 O  E    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)
1 n2 O* r; m. W/ t( ?; k. b    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)
" ~4 [% S6 f: V    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)) W" M& ]* _8 C
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
4 |2 @+ y6 G( S, K2 g, X    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
& u; y$ E$ p  R8 j& k    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
$ Z7 y0 ~4 x* n& D  w3 y    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)6 n  \( m$ f4 G6 Z, m
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
7 \5 J; A9 p% k$ V    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)" J; Y6 _- h7 a
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
9 l: C- b) \) s( Z- V7 ~3 H) E    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
- A7 N; b' }+ |! [% ?* }. V) V2 A    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
& n0 Q8 ~- v$ z    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883): ]- F" E" r* j' D: i
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
7 U/ g2 y" B" H8 M/ o    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
& @" K* q( q2 i    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
% `! U% p: y& b$ z5 y3 D# v' `    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
$ p- I( N& o- a( O    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)- q$ L6 y! U- I: s4 r
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
6 O/ P) w' Y. w1 J1 k- s    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)' R1 P$ ]) C) q4 `
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443): F3 p5 o) |. u1 f  R
    at org.apache.catalina.core.StandardService.start(StandardService.java:516)
4 D6 |6 W# C( D  X% m! K. z1 z4 l% J    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
- g8 y) R- c( D( r    at org.apache.catalina.startup.Catalina.start(Catalina.java:566): K# T4 a. h& O- Z! _2 V  n, T
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)* O  G1 T/ }' K, p( C: Y( U
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
. s) _4 ~4 {) {  i( }/ O$ m2 e    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- ]+ n5 E6 r. l2 Y1 j6 ~    at java.lang.reflect.Method.invoke(Method.java:601)
# F; m4 i+ E0 x" D    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
2 X% X  W6 f3 V    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
7 y+ x/ |0 ^- E( z2 h9 K9 eCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
& g2 |+ @. |8 \, S4 F
; E# S' ^8 q1 m$ x2 IThe last packet successfully received from the server was 31 milliseconds ago.  The last packet sent successfully to the server was 31 milliseconds ago.6 J8 ^9 u, Q& x6 U6 o
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
8 l! K8 |2 P% B7 `! G+ L    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
2 f7 R' u8 H( d; l( i5 _    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)* {: X! H4 J; B  ?$ h
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)* N3 g# b# |- ?" y, V% H
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)  Q9 z9 t8 N) K
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)
) x. E7 @" e1 d1 `    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427)! z, O! j* x* l- f! _, K5 R
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327)
) X% F# L& s# C    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
! E  z/ @! |2 b" k- n    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)2 G1 s; ]* a! `) y# J: n4 L! Y
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
) x2 R0 T9 {. g) C9 P, x; v# J    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
3 ^2 Q: Y4 ^  K' _" r, [. Y    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)7 q. S3 w7 f3 B5 k! O
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446); \8 G# \5 F3 r& M( @
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3601)% @% Y3 x. |0 q6 C$ a* Y
    ... 78 more3 J+ L, z3 W/ z) h7 ?) E
Caused by: java.net.SocketException: Connection reset6 J+ ]# K/ H! M% M7 Q
    at java.net.SocketInputStream.read(SocketInputStream.java:189)1 d0 t, t8 @4 @7 V
    at java.net.SocketInputStream.read(SocketInputStream.java:121)
2 D. @8 [* G% M; `& K* {8 h. O$ l  c    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100)
1 X( b6 [: k9 R    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143)* |& I; m9 X! R6 i4 {+ I0 F2 r( V5 b1 i
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173)1 B5 U3 q" l7 e6 S
    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911)7 V+ L" p0 b: V- C; t; }
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3337)
( J3 m4 _( l& _8 y  W3 B6 V    ... 86 more
8 J# U. ~/ B, Y6 B; b! u

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