我的日常

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

动态微博

查看: 1447|回复: 1

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

[复制链接]

7

主题

3

听众

383

金钱

版主

该用户从未签到

跳转到指定楼层
楼主
发表于 2016-07-03 12:39:09 |只看该作者 |倒序浏览
2016-07-03 09:47:26 -3906 [main] ERROR   - init datasource error3 r2 d8 p. Q0 s9 s
java.sql.SQLException: Could not retrieve transation read-only status server# ?* P' x5 O' _
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
+ u& A" d0 |6 B2 z- h- R% m; K    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)
/ d4 l) }5 I6 R& r) ]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
8 b( T5 H, @( R) x% k" A2 P    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)" ?3 d9 S" p" Z, {+ ?) x
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:902)
8 i; ?) G* @# ]7 D5 W    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:892)( E2 H- e7 s$ b
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3607)
% d5 N+ x& C8 N$ N1 J6 c    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3576)
7 G+ H1 C% ?! b2 R( g4 X) a4 `0 j    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:383), D! a/ ^5 `- W, }$ }/ \# R) w1 x
    at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:892)6 F2 c: [6 K1 X! r
    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:380), q2 J1 }' {" c( H! c
    at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.isReadOnly(ConnectionProxyImpl.java:292)
- s+ l6 G# n, w8 a( y6 p    at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:96)8 t; h1 _6 \) Z0 L
    at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:619)3 V! W9 ]7 T3 {- m' n! n
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
% W, ^& H$ J4 p6 H! D, T0 K    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
; a$ z5 G/ p: f8 o8 c    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)9 P+ T2 @5 \2 U$ B, z+ E
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76)
$ Y6 P' v7 e9 {3 k    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61)4 K7 c: z3 v/ j
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49)
9 L5 C) M3 N" Z/ ?8 b    at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445)  E# [+ m+ G  J
    at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336)/ l9 A7 x7 u# Y7 z; Z/ T
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612): H7 m) m1 x9 f4 I1 X
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)2 p' A* n6 l8 ~6 ?7 [
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)% {/ j! y, }8 i9 t, @7 W" o5 T  D! [
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
+ T& B% |1 N- y1 K! ]& z. H    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
" B' b- ]$ @: s) O    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
5 A8 C* Y% f) d    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
" j3 |2 h; z5 ^' l* Z+ W  X" I: C    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)0 ^' j# O5 V. f# U# U" X/ Q6 E$ m
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
0 W0 @6 I. b, Q5 ]    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
" Y" m+ O9 B. l% z# w% m    at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:646)5 f# ?# q  e6 z
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)9 f6 B% t7 \) l* F/ S
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1114)
2 e* ~& x! ^$ K+ G    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1017)8 w* h6 p/ ?5 r: H( k
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504): O* c* w. E  A7 W$ q" W
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
2 M# p. a. w2 V& H& a    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)! ]% r3 Z; K: t. @) D
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
6 M& Q" q4 O" L1 D8 f) P    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
7 |% t- d: _) ?3 |- {# c) m0 s    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
! f  m) T( J' k/ R( M    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:446)8 b% ~# S7 i0 K. m2 U' d1 E
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:420)& K$ X+ _8 P$ t8 s
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:545)3 }" X0 s: d( [' R
    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:155)
6 I8 x7 [" u, }% I1 H    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
* D& B6 E4 }. M    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:305)
& W& Q2 g. V' k' z9 R* \    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185)( U, [2 M7 @7 B/ y6 C
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
5 |1 D0 s# V  L! y. j    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
: R) L1 T9 x0 b2 F/ z    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304), A! i' b- ], \/ Y/ Z" @0 I
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)/ M8 x" D3 ]2 s+ g# ?2 @
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
) q4 z! W9 l9 a    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
) T, H5 N( `3 y6 B! H8 w8 o    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)) O, o0 X# ?. C% \5 `7 @( |7 j. u
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)' _: n% K0 ?6 n% H: Q
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482). t# m9 n' ?+ \- u/ J/ o
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)5 E' {7 W9 v" ]
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
* N9 t+ g7 o7 X  S: i* m1 K4 i/ i    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
- m2 o8 d7 p& h2 T- E8 J: @    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)& |/ ^- q: i" v, f& a, V
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
) ~% j8 F, |0 O  Z% L$ Y    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
% o* @4 I, Q9 o" K; @8 H    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)7 @7 r  c) E! b! {0 N
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
+ ]$ U, ~! q' D    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)3 G4 X5 c6 l* C& l
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
1 j6 v* }4 S, ^& R9 L/ T5 G    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
& d& c, `% N# w    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
& b2 ?1 K3 {9 }3 \! N6 Q( q    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)6 T; o) E  Y) C* J! x" ]+ A: E$ m
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117); q" z4 a: Y* w9 N% g6 E* r1 U* e
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)- s( z1 W, g  r9 W
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)% }; T7 L, v6 b# q9 m
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)! A. `6 r" U. [2 I! L# b
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
- K# c6 l% w- p5 Z3 ]# m    at org.apache.catalina.core.StandardService.start(StandardService.java:516)3 A* F; }# _9 O- B3 o2 Q4 I, [4 _$ ~
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
7 Q  J3 Q. h* R: F    at org.apache.catalina.startup.Catalina.start(Catalina.java:566)' H$ e3 U* G2 k. U/ B! X6 n
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
* d. W( i* ]. U4 j5 ~$ o4 n$ x    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57); i0 [: G$ H4 j" v  U; h& y
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
6 v6 k' g+ @  X    at java.lang.reflect.Method.invoke(Method.java:601); O  X1 z* d  d* A2 q0 c+ X' f! \& b
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
$ j4 x& f9 Q1 Y! E    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413), x7 ?- ?' m5 R1 |
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure; Z/ {) t6 v' R7 A5 i, d. \

, o. d- |; I* B5 q0 b5 h7 ]' gThe last packet successfully received from the server was 31 milliseconds ago.  The last packet sent successfully to the server was 31 milliseconds ago.
  y+ i9 G; w9 `+ Z# O0 G    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
* J: ~' T  [" T# x. O- ~    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
5 u2 Z9 \* k' F4 q! i    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
9 R" h* r8 P& S2 p  S3 {1 C    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)) r8 q3 K! j0 v" W7 w
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
) m9 n: u+ C; Q$ L$ I7 N: Y    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)
9 k  Z/ C, W& ?' C/ V* h    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427)
9 X/ p. ~  C4 M  T    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327)
5 q/ K) e  o3 S3 k    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814); F4 I3 g* e! F0 L0 d6 y! a
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
, u$ S, S# Y  R/ y% v# A" p" N2 f    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)3 _3 O/ C. J/ N. h
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)- J- C: a0 Z3 G# J+ M
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  c' ^. A5 Q8 J+ Y' w    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
; |3 \# g' E1 ^8 P    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3601)  o) V" Y  e/ N5 P4 w- s# s' A
    ... 78 more$ n( G4 a* k! Z" O
Caused by: java.net.SocketException: Connection reset
6 c0 l& p! F4 D- C7 ~8 k# u    at java.net.SocketInputStream.read(SocketInputStream.java:189)% m2 `6 ^8 a, D! h! U2 ?! l
    at java.net.SocketInputStream.read(SocketInputStream.java:121)+ K4 b6 O% N  V  c' P# h
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100)
& m7 i5 J) _9 g, `& t    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143)* H# f0 i6 R% U/ D1 ~7 ]! h* `
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173)
- t" ^0 g4 {" i0 N    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911)( h" M" B, U+ s; n  u5 V
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3337)
4 i3 {1 X+ O9 A- ]; h. u    ... 86 more
+ D$ _4 j# k8 v

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