使用Spring jdbcTemplate时的ConnectionPooling配置

我正在开发一个需要在大型机上调用DB2函数以获得ID的应用程序.

在我的spring应用程序上下文中,我定义了jdbc模板,从而可以在zOS上查询DB2：

    <bean id="jdbcTemplateDB2"
       class="org.springframework.jdbc.core.JdbcTemplate">
         <property name="datasource" ref="datasourceDB2"/>
    </bean>

然后,我将数据源定义如下：

 <bean id="datasourceDB2" 
    class="com.ibm.db2.jcc.DB2Datasource">
        <property name="serverName" value="hostname" />
        <property name="portnumber" value="portno"/>
        <property name="databasename" value="dbname"/>
        <property name="driverType" value="4"/>
        <property name="user" value="userid"/>
        <property name="password" value="password"/>
 </bean>

以上作品.
但是,在ibm的db2jcc.jar文件中,我看到具有连接池的数据源类-com.ibm.db2.jcc.DB2ConnectionPoolDatasource.所以我试图用它代替上面的那个-像这样：

 <bean id="datasourceDB2"
    class="com.ibm.db2.jcc.DB2ConnectionPoolDatasource">
        <property name="serverName" value="hostname" />
        <property name="portnumber" value="portno"/>
        <property name="databasename" value="dbname"/>
        <property name="driverType" value="4"/>
        <property name="user" value="userid"/>
        <property name="password" value="password"/>
 </bean>

但是,使用DB2ConnectionPoolDatasource给我以下错误.

CAnnot convert value of type [com.ibm.db2.jcc.DB2ConnectionPoolDatasource] to required type [javax.sql.Datasource] for property 'datasource': no matching editors or conversion strategy found

完整的stackTrace如下

    Exception in thread "main" org.springframework.beans.factory.beanCreationException: Error creaTing bean with name 'classUniquEIDDaoImpl_v2': Injection of resource dependencies Failed; nested exception is org.springframework.beans.factory.beanCreationException: Error creaTing bean with name 'jdbcTemplateDB2' defined in class path resource [Meta-INF/spring/applicationContext-db2.xml]: Initialization of bean Failed; nested exception is org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'com.ibm.db2.jcc.DB2ConnectionPoolDatasource' to required type 'javax.sql.Datasource' for property 'datasource'; nested exception is java.lang.IllegalStateException: CAnnot convert value of type [com.ibm.db2.jcc.DB2ConnectionPoolDatasource] to required type [javax.sql.Datasource] for property 'datasource': no matching editors or conversion strategy found
        at org.springframework.context.Annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:307)
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.populateBean(AbstractAutowireCapablebeanfactory.java:1106)
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:517)
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
        at org.springframework.beans.factory.support.Abstractbeanfactory$1.getObject(Abstractbeanfactory.java:294)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
        at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:291)
        at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:193)
        at org.springframework.beans.factory.support.DefaultListablebeanfactory.preInstantiateSingletons(DefaultListablebeanfactory.java:609)
        at org.springframework.context.support.AbstractApplicationContext.finishbeanfactoryInitialization(AbstractApplicationContext.java:918)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469)
        at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
        at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
        at com.slma.euclid.core.dao.MainDB2.main(MainDB2.java:18)
    Caused by: org.springframework.beans.factory.beanCreationException: Error creaTing bean with name 'jdbcTemplateDB2' defined in class path resource [Meta-INF/spring/applicationContext-db2.xml]: Initialization of bean Failed; nested exception is org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'com.ibm.db2.jcc.DB2ConnectionPoolDatasource' to required type 'javax.sql.Datasource' for property 'datasource'; nested exception is java.lang.IllegalStateException: CAnnot convert value of type [com.ibm.db2.jcc.DB2ConnectionPoolDatasource] to required type [javax.sql.Datasource] for property 'datasource': no matching editors or conversion strategy found
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:527)
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.createBean(AbstractAutowireCapablebeanfactory.java:456)
        at org.springframework.beans.factory.support.Abstractbeanfactory$1.getObject(Abstractbeanfactory.java:294)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
        at org.springframework.beans.factory.support.Abstractbeanfactory.doGetBean(Abstractbeanfactory.java:291)
        at org.springframework.beans.factory.support.Abstractbeanfactory.getBean(Abstractbeanfactory.java:193)
        at org.springframework.beans.factory.support.DefaultListablebeanfactory.findAutowireCandidates(DefaultListablebeanfactory.java:876)
        at org.springframework.beans.factory.support.DefaultListablebeanfactory.doResolveDependency(DefaultListablebeanfactory.java:818)
        at org.springframework.beans.factory.support.DefaultListablebeanfactory.resolveDependency(DefaultListablebeanfactory.java:735)
        at org.springframework.context.Annotation.CommonAnnotationBeanPostProcessor.autowireresource(CommonAnnotationBeanPostProcessor.java:439)
        at org.springframework.context.Annotation.CommonAnnotationBeanPostProcessor.getresource(CommonAnnotationBeanPostProcessor.java:417)
        at org.springframework.context.Annotation.CommonAnnotationBeanPostProcessor$resourceElement.getresourceToInject(CommonAnnotationBeanPostProcessor.java:559)
        at org.springframework.beans.factory.Annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:150)
        at org.springframework.beans.factory.Annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
        at org.springframework.context.Annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:304)
        ... 13 more
    Caused by: org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'com.ibm.db2.jcc.DB2ConnectionPoolDatasource' to required type 'javax.sql.Datasource' for property 'datasource'; nested exception is java.lang.IllegalStateException: CAnnot convert value of type [com.ibm.db2.jcc.DB2ConnectionPoolDatasource] to required type [javax.sql.Datasource] for property 'datasource': no matching editors or conversion strategy found
        at org.springframework.beans.beanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:485)
        at org.springframework.beans.beanWrapperImpl.convertForProperty(BeanWrapperImpl.java:516)
        at org.springframework.beans.beanWrapperImpl.convertForProperty(BeanWrapperImpl.java:510)
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.convertForProperty(AbstractAutowireCapablebeanfactory.java:1406)
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.applyPropertyValues(AbstractAutowireCapablebeanfactory.java:1365)
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.populateBean(AbstractAutowireCapablebeanfactory.java:1118)
        at org.springframework.beans.factory.support.AbstractAutowireCapablebeanfactory.doCreateBean(AbstractAutowireCapablebeanfactory.java:517)
        ... 27 more
    Caused by: java.lang.IllegalStateException: CAnnot convert value of type [com.ibm.db2.jcc.DB2ConnectionPoolDatasource] to required type [javax.sql.Datasource] for property 'datasource': no matching editors or conversion strategy found
        at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:241)
        at org.springframework.beans.beanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:470)
        ... 33 more

我究竟做错了什么？在实例化Spring JdbcTemplate时使用连接池数据源的正确方法是什么？

任何帮助表示赞赏.

-SGB