shi592852892 2016-05-16 01:54 采纳率: 0%
浏览 7415

spring-mvc和mybatis整合DruidDataSource配置连接池报错

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dynamicDatasourceAspect' defined in file [D:\workspace.metadata.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\dm_job\WEB-INF\classes\com\creditease\job\aop\DynamicDatasourceAspect.class]: Initialization of bean failed; nested exception is org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'com.alibaba.druid.pool.DruidDataSource' to required type 'org.aspectj.lang.JoinPoint' for property 'dbmsDataSource'; nested exception is java.lang.IllegalStateException: Cannot convert value of type [com.alibaba.druid.pool.DruidDataSource] to required type [org.aspectj.lang.JoinPoint] for property 'dbmsDataSource': no matching editors or conversion strategy found
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:547)
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.aop.aspectj.annotation.BeanFactoryAspectInstanceFactory.getAspectInstance(BeanFactoryAspectInstanceFactory.java:77)
at org.springframework.aop.aspectj.annotation.LazySingletonAspectInstanceFactoryDecorator.getAspectInstance(LazySingletonAspectInstanceFactoryDecorator.java:50)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:603)
at org.springframework.aop.aspectj.AspectJMethodBeforeAdvice.before(AspectJMethodBeforeAdvice.java:40)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:51)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
at com.creditease.job.service.impl.CityServiceImpl$$EnhancerBySpringCGLIB$$23f19862.getAllCityCodeAndName()
at com.creditease.job.base.InitDataListener.contextInitialized(InitDataListener.java:48)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4994)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5492)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'com.alibaba.druid.pool.DruidDataSource' to required type 'org.aspectj.lang.JoinPoint' for property 'dbmsDataSource'; nested exception is java.lang.IllegalStateException: Cannot convert value of type [com.alibaba.druid.pool.DruidDataSource] to required type [org.aspectj.lang.JoinPoint] for property 'dbmsDataSource': no matching editors or conversion strategy found
at org.springframework.beans.BeanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:476)
at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:512)
at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:506)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.convertForProperty(AbstractAutowireCapableBeanFactory.java:1523)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1482)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1222)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
... 26 more
Caused by: java.lang.IllegalStateException: Cannot convert value of type [com.alibaba.druid.pool.DruidDataSource] to required type [org.aspectj.lang.JoinPoint] for property 'dbmsDataSource': no matching editors or conversion strategy found
at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:287)
at org.springframework.beans.BeanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:461)

  • ... 32 more

配置文件如下:

<bean id="baseDataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
    <!-- 配置初始化大小、最小、最大 -->  
    <property name="initialSize" value="10" />  
    <property name="minIdle" value="10" />  
    <property name="maxActive" value="50" />  

    <!-- 配置获取连接等待超时的时间 -->  
    <property name="maxWait" value="60000" />  

    <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 -->  
    <property name="timeBetweenEvictionRunsMillis" value="60000" />  

    <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 -->  
    <property name="minEvictableIdleTimeMillis" value="300000" />  
    <property name="validationQuery" value="SELECT * FROM CREDIT_CHANNEL LIMT 1" />
    <property name="testWhileIdle" value="true" />  
    <property name="testOnBorrow" value="false" />  
    <property name="testOnReturn" value="false" />  

    <!-- 打开PSCache,并且指定每个连接上PSCache的大小 -->  
    <property name="poolPreparedStatements" value="true" />  
    <property name="maxPoolPreparedStatementPerConnectionSize"  
        value="20" />  

    <!-- 配置监控统计拦截的filters -->  
    <property name="filters" value="wall,stat" /> 
</bean>
<!-- kls数据源 -->  
<bean id="klsDataSource" parent="baseDataSource">  
    <!-- 基本属性 url、user、password -->  
    <property name="url" value="${kls.jdbc.url}" />  
    <property name="username" value="${kls.jdbc.username}" />  
    <property name="password" value="${kls.jdbc.password}" />  
</bean>
<!-- dbms数据源 -->
<bean id="dbmsDataSource" parent="baseDataSource">  
    <!-- 基本属性 url、user、password -->  
    <property name="url" value="${dbms.jdbc.url}" />  
    <property name="username" value="${dbms.jdbc.username}" />  
    <property name="password" value="${dbms.jdbc.password}" />  
</bean>  

<!-- 设置spring 配置文件的配置多数源映射关系 -->
<bean id="dataSource" class="com.creditease.job.datasource.DynamicDataSource">
    <property name="targetDataSources">
        <map>
            <entry value-ref="klsDataSource" key="kls"></entry>
            <entry value-ref="dbmsDataSource" key="dbms"></entry>
        </map>
    </property>
    <property name="defaultTargetDataSource" ref="klsDataSource" />
</bean>
<bean id="dataSourceProxy"
    class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
    <property name="targetDataSource" ref="dataSource" />
</bean>

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    <constructor-arg ref="dataSourceProxy" />
</bean>

<!--事务管理器配置 -->
<bean id="transactionManager"
    class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSourceProxy" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
    <tx:attributes>
        <tx:method name="*" propagation="REQUIRED" />
    </tx:attributes>
</tx:advice>

<bean class="com.creditease.job.util.SpringUtils" />

<!-- 数据库工厂 -->
<!-- mySqlSessionFactory配置 -->
<bean id="mySqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>  

![图片说明](https://img-ask.csdn.net/upload/201605/16/1463363631_18856.png)
  • 写回答

2条回答

  • shi592852892 2016-05-16 01:55
    关注

    aop切面类:
    @Aspect
    @Component
    public class DynamicDatasourceAspect {

    private static final Logger logger = Logger.getLogger(DynamicDatasourceAspect.class);
    
    @Pointcut("execution(* com.creditease.job.service..*.*(..))")
    public void serviceMainDaoExecution() {
    
    }
    
    /**
     * dbms切入点
     */
    @Pointcut("execution(* com.creditease.job.dbms.service..*.*(..))")
    public void serviceDbmsExecution() {
    
    }
    
    @Before("serviceMainDaoExecution()")
    public void setMainDaoDynamicDataSource(JoinPoint jp) {
        // 在切面执行之前切换成KLS主数据源
        String dataSourceType = DataSourceContextHolder.getDataSourceType();
        if (!DataSourceKey.KLS.equals(dataSourceType)) {
            logger.info("数据源切换===>kls数据库");
            DataSourceContextHolder.setDataSourceType(DataSourceKey.KLS);
        }
    }
    
    @Before("serviceDbmsExecution()")
    public void setDbmsDataSource(JoinPoint jp) {
    
        logger.info("数据源切换===>dbms数据库");
        String dataSourceType = DataSourceContextHolder.getDataSourceType();
        if (!DataSourceKey.DBMS.equals(dataSourceType)) {
            logger.info("数据源切换===>dbms数据库");
            DataSourceContextHolder.setDataSourceType(DataSourceKey.DBMS);
        }
    }
    

    }

    评论

报告相同问题?

悬赏问题

  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)