我的日常

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

动态微博

查看: 1454|回复: 1

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

[复制链接]

7

主题

3

听众

383

金钱

版主

该用户从未签到

跳转到指定楼层
楼主
发表于 2016-07-03 12:39:09 |只看该作者 |倒序浏览
2016-07-03 09:47:26 -3906 [main] ERROR   - init datasource error
; u! E- f! f1 l9 C- [9 w& `* d+ Ajava.sql.SQLException: Could not retrieve transation read-only status server
  z( c6 b7 A5 h* `% b    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)7 ^2 n# X5 {1 s- @- M
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)+ {% f( T! A/ A( }* v& z6 B% w4 @
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
8 c/ O  T! Y& j; ?7 E    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)
6 I9 U# e/ h0 {- h0 c+ s8 L    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:902)/ ~1 b& D6 h/ J% `
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:892)
$ B1 E: }: `, h; l  p2 U: I% p    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3607)+ F, l' g. H! U8 c# [3 B6 B' W0 r
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3576)
# G) c# ^5 I' w% d; ^! S    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:383)
# h7 a/ G9 U2 Q' X& h$ Z    at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:892)1 \, x& g: u2 Y; r( ]
    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:380)# A* v0 U2 k% a" x! C- E4 F9 n4 j
    at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.isReadOnly(ConnectionProxyImpl.java:292)2 G5 R2 L! w7 J) [
    at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:96)
+ F$ ]! ^9 F1 y7 H& d    at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:619)0 b: s/ u6 v, s5 ^* Y
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)6 Q4 Q/ c' ^. [
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)8 [4 \8 l6 t) n' d0 a
    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
! Z8 N" O9 z; g1 ]5 [( {7 @. ?2 s    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76), q# h, X; h4 j" l
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61)
2 e  @" ^" ]1 s9 @% J# c    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49)2 l" L9 @5 v' E6 a% n4 R/ f
    at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445)7 e% o) A6 ~: Y8 L# u# m5 F
    at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336)+ H& l1 d  M  N4 Q$ M2 X6 K* |
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612)2 V- X6 G. ~2 V2 ^  S% h
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)3 A/ P9 A" u- D0 J
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)% ^) b, \- I* A( z
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)' d* g2 w! K4 R' M
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)0 |3 Q. x5 t  Y2 }1 K
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
- p2 F8 p0 I/ l' T7 a% O1 v    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)5 r% q( g' |, B% H
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)2 S5 l. o, ~6 O0 d8 ^) |4 v& U
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328); t5 I$ p# Z& y
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
" g/ e1 I, B( s9 W, a# X6 f    at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:646)
2 C( n' c- ~0 J6 `5 B/ S    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)7 Y" p4 N$ O7 [' Y4 G, x. p
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1114)* B0 Q5 j. k# V8 Z
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1017)
2 R6 K; ~$ z8 j* p3 P3 G3 F- `    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
- a/ f0 Q4 s8 }$ a* K. h    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)& v! x8 Z' e4 C2 `4 {
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)* q* \2 o- q) Y+ Q4 x
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)+ b+ d% \+ |  O& _0 L9 I! w8 [
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
8 U5 b$ P' f6 \    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)8 H) `9 l, g4 M  m7 s8 O% F
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:446)
# I6 `8 {. R% Y    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:420)
$ l  ~* {/ K- \- B    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:545)
6 o6 x: }  e7 s. d    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:155)
  T6 C: A4 l8 `8 e    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87): c2 T* y$ C( m) ^* l; M8 E" h
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:305)
$ n; r$ W7 k% i    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185)9 |, x9 A- |5 m( ^
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)- p$ u3 h) y- L0 ^4 ]' G6 |! ?0 D) T6 F
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)4 D6 o0 C/ `' n# t1 ?; {( b
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
; G; s  |/ I: h) E- m6 T0 L- V    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228); V: d9 r' ~6 x) B. ?4 T
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300): M& F% Y/ c  ?$ d9 {2 S/ R$ C
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
& T* [) ^4 P% e, t    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)
$ `0 b6 J6 ?2 p; \4 f: d$ V    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)' \7 J/ W5 B1 I: J( n! H
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
# n9 \2 W/ T5 \6 P( R% ~) X% p    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)9 Z, ]1 b' G3 _
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)  P9 N8 b" i7 @5 u: G* R
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)! z, K# h0 O! }4 W* n/ v' }
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
% Y1 {( o, a& c. x4 \# M    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
1 U9 |. i( N/ t  n; B/ @- s    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
6 C. p# T, M* T; t  B/ v    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
6 H$ e$ [7 g8 V# J  I1 g$ c% n    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
2 K8 a$ f5 l' n8 _0 X2 E: c8 I! I    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)5 s& m* v6 A6 N* E, R
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
  r5 w# j) b1 Y& _. M! l    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
# @0 n- A! n! M! f1 w4 c# U2 L    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)/ |( O) F4 E, U- }
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
4 H8 l$ G, U6 I, j: v    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
) r7 A; ~% K/ n) p  }; O+ c4 j2 S    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
* a  @; Y/ f3 ~8 d    at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
. l) O6 V# z: o, B  B    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)" M- d" {1 z7 `( W9 i
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)3 [$ X* G2 N0 Y( f& `: z3 r5 v+ A# W
    at org.apache.catalina.core.StandardService.start(StandardService.java:516)4 o! D4 ]$ L4 o% d
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
' H, c+ a  y7 a5 S: S$ J! O& M    at org.apache.catalina.startup.Catalina.start(Catalina.java:566); I6 H8 D/ j# v+ p
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)+ D/ k3 v8 h, |+ U$ W3 n
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
$ E0 d$ b, {0 |- @1 D) x    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)- C: c' {. Y9 M, p
    at java.lang.reflect.Method.invoke(Method.java:601)
; v6 d( I3 d$ j* I2 v    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)# L# {4 s, [0 k+ u/ W# y8 |
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)+ Q' w8 t0 I$ o0 Q
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure0 ?9 G( e" C& w# n3 {
, [0 C+ t% C( t2 b' q$ V- f8 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.
6 j+ Z) P# c7 q" `    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
8 h* o( r9 i0 N7 z; g/ C    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
# Q" j/ x6 Q* m0 t    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)" p7 L3 C! d3 L  N" i  X1 {1 A/ K
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
0 c7 X( u0 J$ H8 q6 t# |7 t' o5 N    at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)5 J. H1 Y$ ]; Q: m
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)# s2 i$ y( O$ c; l6 L
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427)  F  _  d2 w5 a6 j5 H1 E" w: j
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327)
) E7 R8 F/ D" V5 S    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)& C! i: p9 U; z) ?5 o' {+ W
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
' I6 F( F4 r* z5 O    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
  I, K# [4 \! ?! V" D: P    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)6 _3 E6 N2 ^* J; A
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
, l& e3 u( H: j! d" g    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
1 c8 I5 F# g7 P% N    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3601)
/ C* h4 \- q: O; H* C4 t    ... 78 more! {, `6 P, i# K, j( d
Caused by: java.net.SocketException: Connection reset
0 t$ h6 n; z/ }; Q* Z    at java.net.SocketInputStream.read(SocketInputStream.java:189)
) @6 d! p' d8 J- @6 K$ F    at java.net.SocketInputStream.read(SocketInputStream.java:121)7 i' f( _" [$ h6 z# @5 C6 s
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100)
, W2 H& F7 S/ ]  {2 D* I    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143)
8 f% B. k% n5 H3 A% n- @* I$ a    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173)
6 G( @- L' H* v2 B  f+ M    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911): I  Y9 b0 L( b
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3337); X- v+ F/ i, b$ \3 w
    ... 86 more8 X6 T+ i2 y& c6 k

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