MAVEN下 Spring和 Mybaits整合 DruidDataSource 数据源配置问题？ - ITeye问答
&div class="iteye-blog-content-contain" style="font-size: 14px"&
Spring+Mybaits+SpringMVC整合完毕，但是在写一个单元测试测试的时候，总是在数据源配置 ${jdbc_initalSize} 是字符串类型，不是int 类型，但是我已经使用
&context:property-placeholder location="classpath:sysconfig/sysConf.properties" /&
引入了属性文件，怎么会取不到呢？在把所有的${}换掉之后，就正常了
下面是工程目录以及配置文件：
本人配置maven+spring+mybatis&& 数据源是DruidDataSource
配置如下：
&context:property-placeholder location="classpath:jdbc.properties" /&
&!-- 配置数据源 --&
&beans:bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close" &
&beans:property name="url" value="${connection.url}" /&
&beans:property name="username" value="${connection.username}" /&
&beans:property name="password" value="${connection.password}" /&
&beans:property name="initialSize" value="${connection.initialSize}" /&
&beans:property name="minIdle" value="${connection.minIdle}" /&
&beans:property name="maxActive" value="${connection.maxActive}" /&
&!-- 配置获取连接等待超时的时间 --&
&beans:property name="maxWait" value="60000" /&
&!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 --&
&beans:property name="timeBetweenEvictionRunsMillis" value="60000" /&
&!-- 配置一个连接在池中最小生存的时间，单位是毫秒 --&
&beans:property name="minEvictableIdleTimeMillis" value="300000" /&
&beans:property name="validationQuery" value="SELECT 'x'" /&
&beans:property name="testWhileIdle" value="true" /&
&beans:property name="testOnBorrow" value="false" /&
&beans:property name="testOnReturn" value="false" /&
&!-- 配置监控统计拦截的filters --&
&beans:property name="filters" value="stat" /&
&/beans:bean&
&!-- 配置session工厂 --&
&beans:bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean"&
&beans:property name="dataSource" ref="dataSource" /&
&beans:property name="typeAliasesPackage" &
&beans:value&
com.lwlm.entertainment.sysmanager.domain
&/beans:value&
&/beans:property&
&!-- &beans:property name="configLocation"
value="classpath:sqlMapConfig.xml"/& --&
&/beans:bean&
&!-- 配置事务管理器 --&
&beans:bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"&
&beans:property name="dataSource" ref="dataSource" /&
&/beans:bean&
&!-- 配置方法事务规则 --&
&tx:annotation-driven transaction-manager="transactionManager"
&!-- scan for mappers and let them be autowired --&
&beans:bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"&
&beans:property name="basePackage" &
&beans:value&
com.lwlm.entertainment.sysmanager.mapper
&/beans:value&
&/beans:property&
&/beans:bean&
jdbc.properties
connection.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8
connection.username=root
connection.password=root
connection.initialSize=1
connection.minIdle=1
connection.maxActive=20
MapperScannerConfigurer部分的配置用sqlSessionFactoryBeanName来指定sessionfacroty
&bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"&
&property name="location" value="classpath:jdbc.properties" /&
&bean id="rdbmPropertiesPlacholder" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" lazy-init="false"&
&property name="locations"&
&value&classpath:jdbc_1.properties&/value&
&value&classpath:jdbc_2.properties&/value&
&/property&
已解决问题
未解决问题这几天一直在写自己的代码，碰到了事务问题，原本以为事务这块没什么可说得，结果这问题卡了两个晚上才解决，搜了一大堆材料，特此总结一下。
1、事务失效一般问题是配置问题，SpringMVC和SSH的配置不太一样，如果按照SSH的事务配置照搬过来，定会使事务失效。
先列一下昨天LOG4J报的信息。
& 00:12:29& &http-bio-8080-exec-4& org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)
&DEBUG& Fetching JDBC Connection from DataSource
& 00:12:29& &http-bio-8080-exec-4& org.apache.mons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)
&DEBUG& JDBC Connection [com.mysql.jdbc.JDBC4Connection@66c9f0e7] will not be managed by Spring
这一句JDBC连接未在Spring管理范围内，导致事务失效。下面来说一下原因：
由于采用的是SpringMVC、 MyBatis，故统一采用了标注来声明Service、Controller&
服务器启动时的加载配置文件的顺序为web.xml--applicationContext.xml--XXX-servlet.xml(SpringMVC的配置文件)，由于applicationContext.xml配置文件中Controller会先进行扫描装配，但是此时service还没有进行事务增强处理，得到的将是原样的Service（没有经过事务加强处理，故而没有事务处理能力），所以我们必须在applicationContext.xml中不扫描Controller，配置如下：
&!-- 自动扫描组件，&span style=&color: rgb(69, 69, 69); font-family: tahoma, helvetica, font-size: 14 line-height: 21&&在&span style=&font-family: Helvetica, Tahoma, Arial, sans-font-size:14 line-height: 25.1875&&applicationContext&/span&&span style=&font-family: Helvetica, Tahoma, Arial, sans-font-size:14 line-height: 25.1875&&.xml&/span&配置文件中将&span style=&font-family: Helvetica, Tahoma, Arial, sans-font-size:14 line-height: 25.1875&&Controller&/span&注解给去掉&/span&
&span style=&color: rgb(69, 69, 69); font-family: tahoma, helvetica, font-size: 14 line-height: 21&&&context:component-scan base-package=&com&&
  &context:exclude-filter type=&annotation& expression=&org.springframework.stereotype.Controller& /&
&/context:component-scan&&/span&&!--而在springMVC配置文件中将Service注解给去掉--&
&context:component-scan base-package=&com&&
&context:include-filter type=&annotation& expression=&org.springframework.stereotype.Controller& /&
&context:exclude-filter type=&annotation& expression=&org.springframework.stereotype.Service& /&
&/context:component-scan&
之后，可以根据事务的配置方法，如：声明式或注解形式去进行配置，这里不再赘述。
2、还有一种情况，虽然我没有遇到，但是还是提一下，如果使用的是Mysql，需要把Engine设置为InnoDb，自动创建表的是MyIsm（好像是这个名），不支持事务。
最后我采用的是声明式方法，利用SPRING AOP将事务织入代码，我把这块配置也贴一下，方便未来使用。。默认搜索com包及其所有子包下，名称为business的包，该包下以Business为名称结尾的接口的所有方法，如果方法名中包含_tx则开启事务，否则不开启事务，无法写入。。说的好拗口。。
&bean id=&transactionManager&
class=&org.springframework.orm.hibernate3.HibernateTransactionManager&&
&property name=&sessionFactory& ref=&sessionFactory& /&
&aop:config&
&aop:pointcut id=&pointcutServiceMethods&
expression=&execution(* com..*.business.*Business.*(..))& /&
&aop:advisor advice-ref=&txAdvice& pointcut-ref=&pointcutServiceMethods& /&
&/aop:config&
&tx:advice id=&txAdvice& transaction-manager=&transactionManager&&
&tx:attributes&
&tx:method name=&*_tx& /&
&tx:method name=&*& read-only=&true& /&
&/tx:attributes&
&/tx:advice&
本文已收录于以下专栏：
相关文章推荐
今天遇到个问题，折腾了我大约4个小时，好坑啊因为之前没遇到过
我的包是这么分的：com.工程名.模块名.service.impl     在spring 配置这个切面 ex...
1.最重要的spring配置文件
&bean id=&dataSource&
class=&org.springframework.jdbc.datasource.DriverMan...
在SpringMVC框架，事物管理杜绝出现 will not be managed by Spring  和was not registered for synchronization because...
Spring重复扫描导致事务失败的解决方案及深入分析
JDBC Connection [jdbc:mysql://127.0.0.1:3306/xiyuanhui?useUnicode=true&characterEncoding=UTF-8&zeroD...
主要原因就是两个配置文件：
SpringMVC.xml自身加载的时候，注意：
expression=&org.springfra...
一般我们在Spring的配置文件application.xml中对Service层代码配置事务管理，可以对Service的方法进行AOP增强或事务处理如事务回滚，但是遇到一个问题，在Controlle...
前文提到，最新换了框架，新项目用SpringMVC + Spring JdbcTemplate。搭框架时，发现了一个事务无法正常回归的问题，记录如下：
首先展示问题：
Spring applicati...
springmvc 事务配置时使用myP6DataSource导致事务失效
在主容器中（applicationContext.xml），将Controller的注解排除掉 
context:component-s...
他的最新文章
讲师：姜飞俊
您举报文章：
举报原因：
原文地址：
原因补充：
(最多只允许输入30个字)初学过程中遇到的问题，记录并分享一下，如果文中有错误，望指正，谢谢~
那么现在进入正题：
运行环境：
win8 mysql jdk1.8
maven+springmvc+mybatis
c3p0(druid)
最近在看慕课网一个秒杀课程的视频
跟着老师敲啊敲，当运行到第一个junit测试时，偏偏他运行就可以我运行就错了。
无独有偶的发现身边，windows的同事就可我一样报错，mac的就没事（我就是windows，视频中老师就是mac）
那么具体是什么情况呢？
spring-dao.xml配置完数据库连接池属性后（错误代码）
&context:property-placeholder location="classpath:jdbc.properties"/&
&bean id="dataSource" class="com.mchange.boPooledDataSource"&
&!-- 配置连接池属性 --&
&property name="driverClass" value="${driver}"/&
&property name="jdbcUrl" value="${url}"/&
&property name="user" value="${username}"/&
&property name="password" value="${password}"/&
&!-- c3p0连接池的私有属性 --&
&property name="maxPoolSize" value="30"/&
&property name="minPoolSize" value="10"/&
&!-- 关闭连接后不自动commit --&
&property name="autoCommitOnClose" value="false"/&
&!-- 获取连接超时时间 --&
&property name="checkoutTimeout" value="1000"/&
&!-- 当获取链接失败重试次数 --&
&property name="acquireRetryAttempts" value="2"/&
又填写了一个properties（错误代码）
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8
username=root
password=root
但是当运行测试的手死活也拿不到链接，c3p0、druid数据库连接池都试过就是拿不到连接。
（详细异常见文章最后）
An attempt by a client to checkout a Connection has timed out.
Access denied for user ‘zilong’@’localhost’ (using password: YES)
基本上就是连不上数据库的意思
（有些是网上找的，是这个病的现象，但不是我这个病的病理）
1. 填写连接池配置时value作为了标签且带了换行如：
&property name="driverClass"&
&/property&
&property name="driverClass" value="${driver}"/&
2.注意是不是这两段配置，书写时不小心多敲空格了，据说也会出现这种情况，基本上遇上一个问题属于一类（当然嘛，拿不到连接肯定也就这四个值的问题，多了空格回车肯定不行）
3.当然也有说，数据库版本与驱动版本不配的（我增加、减少版本都试了，不好使，可能是我没遇到这个病理，大家可以试试）
4.还有说与连接池的 max min init maxwait这些值有关，修改相关值试试。（教学视频的，练习demo的，一般不会是这个原因，毕竟现在就我一个线程测试。如果是实际项目开发中或者是之前可以后来突然不可以了的，可以试试这个。）
5.因为教学视频中用的c3p0，朋友说你试试druid呢。so，我试了，也不行。
6.最后发现把properties里的driver、url等等，都加上jdbc.，并在引用的地方也加上就好了，如：
&property name="driverClass" value="${jdbc.driver}"/&
&property name="jdbcUrl" value="${jdbc.url}"/&
&property name="user" value="${jdbc.username}"/&
&property name="password" value="${jdbc.password}"/&
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=root
使用c3p0时所报异常
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC C nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
### The error may exist in file [E:\workspace\seckill\target\classes\mapper\SeckillDao.xml]
### The error may involve org.seckill.dao.SeckillDao.queryById
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC C nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:76)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:399)
at com.sun.proxy.$Proxy13.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:165)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:69)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
at com.sun.proxy.$Proxy14.queryById(Unknown Source)
at org.seckill.dao.SeckillDaoTest.queryById(SeckillDaoTest.java:37)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:73)
at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:82)
at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:73)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:224)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:83)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:68)
at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:163)
at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:119)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:42)
at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:234)
at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:74)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.
Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC C nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
### The error may exist in file [E:\workspace\seckill\target\classes\mapper\SeckillDao.xml]
### The error may involve org.seckill.dao.SeckillDao.queryById
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC C nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:73)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
… 34 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC C nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:82)
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:68)
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:315)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:75)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:61)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120)
… 41 more
Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
… 51 more
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@d78795 – timeout at awaitAvailable()
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
… 54 more
使用druid时所报异常
java.lang.IllegalStateException: Failed to load ApplicationContext
at org.springframework.test.context.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:94)
at org.springframework.test.context.DefaultTestContext.getApplicationContext(DefaultTestContext.java:72)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117)
at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83)
at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:212)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:200)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:259)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:261)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:219)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:83)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:68)
at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:163)
at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:119)
at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:42)
at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:234)
at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:74)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [spring/spring-dao.xml]: Invocation o nested exception is java.sql.SQLException: Access denied for user 'zilong'@'localhost' (using password: YES)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:125)
at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60)
at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:109)
at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:261)
at org.springframework.test.context.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:68)
at org.springframework.test.context.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:86)
... 24 more
Caused by: java.sql.SQLException: Access denied for user 'zilong'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1206)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2239)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2270)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2069)
at com.mysql.jdbc.ConnectionImpl.&init&(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.&init&(JDBC4Connection.java:44)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:211)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1410)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1464)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:684)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1702)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1641)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1570)
... 39 more
本文已收录于以下专栏：
相关文章推荐
大神求助，下面贴上代码
这个是spring的配配置文件
context:property-placeholder location=&classpath:conf/db.properties&/...
这是我练习maven项目中发现的，先贴源码driver=com.mysql.jdbc.Driver
url=jdbc:mysql:///etoak
username=root
password=roo...
org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springfra...
各种数据库Hibernate链接配置
db driver maven dependency
dependency&
    ...
最近在复习ssm时，做了一个小demo。在这其中就遇到许多问题，而出现这些问题时，让自己最大的一个感受就是多翻阅官方文档。虽然现在市场有许多书籍和视频，这些资源用归用。但是当你跟着这些教程走下去，最会...
今天在一台配置很低的机器上运行批量更新的程序~~~
    大概跑了三十分钟~~~这配置~~~这程序~~~
    然后华丽丽的报异常了~~~
    具体异常是这样的,
DEBUG: (Ba...
网上很多评论说DBCP有很多BUG，但是都没有指明是什么BUG，只有一部分人说数据库如果因为某种原因断掉后再DBCP取道的连接都是失效的连接，而没有重新取。就此研读了一下DBCP的代码，共享之...
在报表开发工具FineReport中，mysql数据库连接通过数据连接编码转换进行编码的转换，在通过报表录入往数据库中录入中文数据的时候，会出现乱码的现象，本文具体分析了这一现象的可能形成原因及相关的...
他的最新文章
讲师：姜飞俊
您举报文章：
举报原因：
原文地址：
原因补充：
(最多只允许输入30个字)