我的日常

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

动态微博

查看: 1496|回复: 1

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

[复制链接]

7

主题

3

听众

383

金钱

版主

该用户从未签到

跳转到指定楼层
楼主
发表于 2016-07-03 12:39:09 |只看该作者 |倒序浏览
2016-07-03 09:47:26 -3906 [main] ERROR   - init datasource error7 Q8 D/ ~  e2 I5 r/ e
java.sql.SQLException: Could not retrieve transation read-only status server* O( [1 f: Q/ e+ _$ g
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)* W3 R. S: ~  I
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935)1 I5 P1 p4 K3 ^2 ^- r/ F
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924)
( A) }( X# B7 ~6 o5 j7 u) h. A( |# G2 ?    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870)/ K3 C* ^+ t" }( l2 K4 l
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:902), B! O  z) f7 z1 G
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:892)' ~, b' b7 `5 S2 ^
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3607)
; }9 I- ]0 Y, V6 ^2 v1 T4 ^3 y/ G    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3576)) B6 f3 o+ W( C% M
    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:383): U+ f# c( K. J
    at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:892)
( F" A8 d! l2 h$ D2 i    at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:380)8 I: Y) r; z& k7 U
    at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.isReadOnly(ConnectionProxyImpl.java:292)
3 {; Z% J; k' |) Z% a    at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:96)7 @: l( U/ v/ a+ ^8 i$ M
    at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:619)
. Y* g0 A7 O. E: g  s8 k5 E    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
$ |' Y2 P4 c, m( l5 I- b7 R7 G    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
' D( m% G- h3 _  L5 [7 s    at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
2 Y  C: \5 \5 `" J# J1 u    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:76)6 I/ e# C* q1 L( ]+ g& _  d
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:61)5 m- N8 ^2 n4 Z8 l. I$ U
    at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:49)
5 d6 g% u. r/ x' W+ i- V- B    at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445)
# d9 E4 |7 }+ T+ t8 ~+ C0 F    at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336)" I$ @; n, h1 B
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612)
9 B+ }+ q# y' I# n    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549)
" y$ Y% M  J# _8 \8 ^9 r    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)$ w& {9 j5 [6 c  S/ u; y: U
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
3 D; ]. f! i, g$ k) U3 _* x! D) B    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
3 Z7 [. [) @$ V    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)5 M/ x+ v) H& m# X* X* l' y$ O
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
3 h! s" G3 \; E% x$ i* ]    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
- V9 a9 A9 U8 A' z! x$ _3 c, Y    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328); k! H9 @  r. L9 Z8 Q
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
! H7 d0 C% r5 e" D3 m: j    at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:646)% x9 q4 k8 ]$ T7 f  y
    at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:140)) I' E9 [  a4 J5 @
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1114); e8 l: d1 f. F1 e' h
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1017)' b6 W% ~2 B: E* d' N# ^
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)! s6 t. D) p+ F* T# Q2 B1 ~
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)( Q# ]) ~/ P; H0 @, T$ p+ e2 g; M
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
% w. j4 U- z" c: D3 w    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228): |1 j" p1 {# O0 I/ z  o5 [- G0 E
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
( W7 H! N" [. X' Q" U2 g9 c% W) c    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
( n# v; d% j6 x+ p6 R3 ~) p: L    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:446)  E* ?5 a; y) M7 v5 h( P
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:420); {% d0 I2 G8 ^) p4 C* r
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:545)
2 I- m& B' W( ]! L  h    at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:155)
+ z/ t& P7 [* }( v" Z, t0 A    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)9 r8 T8 c) D: {# U2 S
    at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:305)" ]' v' `8 h. V" b
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185)
* Q4 g0 ?) |4 x) }. O    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
0 F# m# {9 x. d# G; X/ `8 j7 p  S    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)( g4 f! c6 q* O7 _$ m
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)5 O4 l4 w0 f8 @* {+ n& a
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)2 _8 l! s1 O( C/ [- s; ]% z' R/ u
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
% `  Q: m! F, p9 Z! b    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
) k. Z0 w) v1 S( i, {    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)
- o; f. Z& f  F2 n) b0 K7 m    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)0 h- B' X- [' `6 d9 L; v* B. ~! L$ L
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
- ^1 c7 d0 C5 }' M1 R1 r( J% O, b    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403): {/ h& Z' j3 m! _; U( d8 X, V- z
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
$ G7 @% ]3 G7 q' r3 a. a1 j4 _    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)5 X4 g3 J! _/ a
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)" s) I+ F  S1 p: U2 K9 U
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
. P1 h* u! d% F% E/ S" i& f# ~. e* ^    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)7 }% I: v% V. C+ {
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
3 {0 v- l2 F6 o5 l& P, P5 ~    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)8 E2 y; g5 n. E& N+ B" m6 D4 F4 }
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)( n5 J8 ]2 |6 [' m& B
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
4 D, U/ t& {& l5 C. N# p    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
- o! C9 r8 v) A8 n3 G    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
* [+ T2 X! T/ u& ?    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)# O1 J7 f# ]: o2 f3 _5 U
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
/ q6 U7 T  t! @! G    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
' y5 y/ j; G% n$ F    at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
$ ?  u& \. F* c4 t5 X4 C9 T1 P+ y$ J    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
- N# |. }. o4 g( K8 R    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)8 R) s1 a) Q9 E
    at org.apache.catalina.core.StandardService.start(StandardService.java:516)" Y1 S2 x8 a  N/ o+ p
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710). i1 |' g: u$ o5 i
    at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
- \8 N, j: ?1 ~' K' e6 m1 Y! X  u    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)6 J' D, u9 q. J! F" F
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
: w+ K1 t/ j5 ~% s    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43). R+ V. N5 t; ~+ c' Q! c& o- Q2 h; ^
    at java.lang.reflect.Method.invoke(Method.java:601)
0 y3 k) p4 `6 f    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288), c* m, C1 K! q* J6 u) m
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
0 b5 k8 W- `% V0 ^" Y5 SCaused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
9 P" m- ?' I: ^% S* ]2 z7 O8 M- l6 j- b$ R7 {/ {  `
The last packet successfully received from the server was 31 milliseconds ago.  The last packet sent successfully to the server was 31 milliseconds ago.
9 a) r% E9 v' `" n! q. f& D0 k  }    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)3 K& n! a$ P8 c
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)% z+ A: X, a- `0 u' M* m# @; d! q
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)$ W  c# [- W4 B8 p: F4 H0 P
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
, H- g4 S0 B; h- N- T. k6 k) }3 p6 v: n    at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)& F5 s- c& p" P8 m
    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)
$ y( L. j5 i. U; e) [6 l9 w% V    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3427)4 g& X4 b* N4 ?5 `5 m6 v
    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327)
7 z4 h8 K4 U& o, J    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)6 Q$ @) K- f" P# g! w
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
' ?: L) S. s1 G    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582): l' e5 O2 u3 W$ n& s: V7 j
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
! s9 i2 K+ e- z" z& b    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)8 E: c3 P6 x8 G! X# r, a$ {
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)* @! h. W+ U; x! s
    at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3601)" u& j6 g! _8 G
    ... 78 more
; h) \  T* C, Q3 c9 ZCaused by: java.net.SocketException: Connection reset* c% ~2 s1 K  A; c
    at java.net.SocketInputStream.read(SocketInputStream.java:189)
+ I0 h0 `- x5 U1 ^1 d5 P8 }( T    at java.net.SocketInputStream.read(SocketInputStream.java:121)# @- Z8 O$ u6 }! A, i- H6 ]
    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100)5 D9 m* N, O2 O- @5 N/ E/ I- |
    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143)! V; x$ K2 @# u+ `1 m
    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173)
( d5 Z0 a$ D  d+ z' q    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911)
9 X* g+ H+ _. Q- t9 W    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3337)
- S% X+ {* P7 D, Q( @- }    ... 86 more
1 F) m& z6 w  S6 N% n7 a

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