spring jdbc 如此配置为何提示错误？

Question

应该是oracle.jdbc.pool.OracleConnectionPoolDataSource这里不对。谁告诉你datasourse要用这个类的啊？？？

Answer 1

原因很简单，就是OracleConnectionPoolDataSource这个类压根就没有'driverClassName' 这个属性。你根本就不应该使用这样的方式来创建DataSource的。建议你使用apache-common-dbcp的实现。 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="maxActive" value="80" />
<property name="maxIdle" value="30" />
<property name="maxWait" value="10000" />
</bean>

Answer 2

例子
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.ibm.db2.jcc.DB2Driver</value>
</property>
<property name="url">
<value>jdbc:db2://172.XX.XX.XXX:50001/mlt</value>
</property>
<property name="username">
<value>mlt</value>
</property>
<property name="password">
<value>mlt</value>
</property>
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref bean="dataSource" />
</property>
</bean>

Answer 3

按照上边的配置。但是提示下边的session有错误了，怎么弄，我的配置如下：     <bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
                <property name="mappingResources"> 
                        <list> 
                                <value>com/abc/coreobject/query.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcprincipal.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcidentity.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcuserauthnticn.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcmenu.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcprincipalgrp.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcgrant.hbm.xml</value>
                                <value>com/abc/coreobject/Arcgroup.hbm.xml</value>  
                                <value>com/abc/coreobject/Corperson.hbm.xml</value>
                                <value>com/abc/coreobject/Cororg.hbm.xml</value> 
                                <value>com/abc/coreobject/Corpersonorg.hbm.xml</value>
                                <value>com/abc/coreobject/Cororgorg.hbm.xml</value>
                                <value>com/abc/coreobject/Arcenum.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpi.hbm.xml</value> 
                                <value>com/abc/coreobject/Corgs.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpiprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluationseg.hbm.xml</value>
                                <value>com/abc/coreobject/Corppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpippa.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpigrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluatorgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluator.hbm.xml</value>
                                <value>com/abc/coreobject/Arcnote.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsevaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpievaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusevaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Aplyrule.hbm.xml</value>
                                <value>com/abc/coreobject/Corruleprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpiorg.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpipsn.hbm.xml</value>
                                <value>com/abc/coreobject/Coresprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Performrule.hbm.xml</value>
                                <value>com/abc/coreobject/Personscore.hbm.xml</value>
                                <value>com/abc/coreobject/Scoreppamap.hbm.xml</value>
                                <value>com/abc/coreobject/Personscoreaply.hbm.xml</value>
                                <value>com/abc/coreobject/Newppa.hbm.xml</value>
                                <value>com/abc/coreobject/Newtaskppa.hbm.xml</value>
                                <value>com/abc/coreobject/Newkpippa.hbm.xml</value>
                                <value>com/abc/coreobject/Newbonusppa.hbm.xml</value>
                                <value>com/abc/coreobject/Destribpam.hbm.xml</value>
                                <value>com/abc/coreobject/Aplymoneypam.hbm.xml</value>
                                <value>com/abc/coreobject/Personmoney.hbm.xml</value>
                        </list> 
                </property>                
                
                <property name="hibernateProperties"> 
                        <props> 
                                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop> 
                                <prop key="hibernate.show_sql">true</prop> 
                                <prop key="hibernate.jdbc.fetch_size">50</prop>
           <prop key="hibernate.jdbc.batch_size">0</prop>
                                <prop key="hibernate.cglib.use_reflection_optimizer">true</prop> 
                        </props> 
                </property>                        <property name="dataSource"><ref bean="DataSource"/></property> 
        </bean> 提示错误：2008-04-18 11:13:12,986 ERROR [org.springframework.web.context.ContextLoader] - <Context initialization failed>
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mySessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Can't resolve reference to bean 'DataSource' while setting property 'dataSource'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'DataSource' is defined: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,mySessionFactory,myTransactionManager,userService,PPAService,NEWService,userServiceSpring,PPAServiceSpring,NEWServiceSpring,userDao,basDao,AplyService,AplyServiceSpring,TaskService,TaskServiceSpring,menu]; root of BeanFactory hierarchy
org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'DataSource' is defined: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,mySessionFactory,myTransactionManager,userService,PPAService,NEWService,userServiceSpring,PPAServiceSpring,NEWServiceSpring,userDao,basDao,AplyService,AplyServiceSpring,TaskService,TaskServiceSpring,menu]; root of BeanFactory hierarchy
at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:349)
at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedBeanDefinition(AbstractBeanFactory.java:671)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:198)

Answer 4

用3楼的配置修改提示如下错误：2008-04-18 11:20:31,189 INFO [org.hibernate.connection.ConnectionProviderFactory] - <Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider>
2008-04-18 11:20:31,252 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: 17067, SQLState: null>
2008-04-18 11:20:31,252 ERROR [org.hibernate.util.JDBCExceptionReporter] - <指定了无效的 Oracle URL>
2008-04-18 11:20:31,252 WARN [org.hibernate.cfg.SettingsFactory] - <Could not obtain connection metadata>
java.sql.SQLException: 指定了无效的 Oracle URL
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

Answer 5

bean的属性是大小写敏感的<property name="dataSource"> <ref bean="DataSource"/> </property>  你这里用的是DataSource，应该是dataSource。注意保持一致。

Answer 6

至于三楼的做法，三楼并没有错，错的是你。你注意要使用正确的oracle连接url来替换三楼的：jdbc:db2://172.XX.XX.XXX:50001/mlt 这一行

Answer 7

按照3楼的做法，我的配置文件：
 <bean id="DataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
                <property name="driverClassName"> 
                        <value>oracle.jdbc.driver.OracleDriver</value> 
                </property> 
                <property name="url"> 
                        <value>jdbc:oracle:[email protected]:1521:perfmana</value> 
                </property> 
                <property name="username"> 
                        <value>perfmana</value> 
                </property> 
                <property name="password"> 
                        <value>perfmana</value> 
                </property> 
        </bean> 
        <bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
                <property name="mappingResources"> 
                        <list> 
                                <value>com/abc/coreobject/query.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcprincipal.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcidentity.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcuserauthnticn.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcmenu.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcprincipalgrp.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcgrant.hbm.xml</value>
                                <value>com/abc/coreobject/Arcgroup.hbm.xml</value>  
                                <value>com/abc/coreobject/Corperson.hbm.xml</value>
                                <value>com/abc/coreobject/Cororg.hbm.xml</value> 
                                <value>com/abc/coreobject/Corpersonorg.hbm.xml</value>
                                <value>com/abc/coreobject/Cororgorg.hbm.xml</value>
                                <value>com/abc/coreobject/Arcenum.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpi.hbm.xml</value> 
                                <value>com/abc/coreobject/Corgs.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpiprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluationseg.hbm.xml</value>
                                <value>com/abc/coreobject/Corppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpippa.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpigrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluatorgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluator.hbm.xml</value>
                                <value>com/abc/coreobject/Arcnote.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsevaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpievaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusevaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Aplyrule.hbm.xml</value>
                                <value>com/abc/coreobject/Corruleprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpiorg.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpipsn.hbm.xml</value>
                                <value>com/abc/coreobject/Coresprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Performrule.hbm.xml</value>
                                <value>com/abc/coreobject/Personscore.hbm.xml</value>
                                <value>com/abc/coreobject/Scoreppamap.hbm.xml</value>
                                <value>com/abc/coreobject/Personscoreaply.hbm.xml</value>
                                <value>com/abc/coreobject/Newppa.hbm.xml</value>
                                <value>com/abc/coreobject/Newtaskppa.hbm.xml</value>
                                <value>com/abc/coreobject/Newkpippa.hbm.xml</value>
                                <value>com/abc/coreobject/Newbonusppa.hbm.xml</value>
                                <value>com/abc/coreobject/Destribpam.hbm.xml</value>
                                <value>com/abc/coreobject/Aplymoneypam.hbm.xml</value>
                                <value>com/abc/coreobject/Personmoney.hbm.xml</value>
                        </list> 
                </property>                
                
                <property name="hibernateProperties"> 
                        <props> 
                                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop> 
                                <prop key="hibernate.show_sql">true</prop> 
                                <prop key="hibernate.jdbc.fetch_size">50</prop>
           <prop key="hibernate.jdbc.batch_size">0</prop>
                                <prop key="hibernate.cglib.use_reflection_optimizer">true</prop> 
                        </props> 
                </property>                        <property name="DataSource"><ref bean="DataSource"/></property> 
        </bean> 提示错误：008-4-18 11:28:37 org.apache.catalina.core.ApplicationContext log
严重: StandardWrapper.Throwable
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mySessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'DataSource' of bean class [org.springframework.orm.hibernate3.LocalSessionFactoryBean]: Bean property 'DataSource' is not writable or has an invalid setter method: Does the parameter type of the setter match the return type of the getter?
org.springframework.beans.NotWritablePropertyException: Invalid property 'DataSource' of bean class [org.springframework.orm.hibernate3.LocalSessionFactoryBean]: Bean property 'DataSource' is not writable or has an invalid setter method: Does the parameter type of the setter match the return type of the getter?
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:827)
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:734)
at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:886)
at org.springframework.beans.BeanWrapperImpl.setPropertyValues(BeanWrapperImpl.java:913)
at org.springframework.beans.BeanWrapperImpl.setPropertyValues(BeanWrapperImpl.java:902)

Answer 8

按照如下配置：
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
        <property name="url" value="jdbc:oracle:[email protected]:1521:perfmana" />
        <property name="username" value="perfmana" />
        <property name="password" value="perfmana" />
        <property name="maxActive" value="80" />
        <property name="maxIdle" value="30" />
        <property name="maxWait" value="10000" />
    </bean>
<!-- 
         
        <bean id="DataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
                <property name="driverClassName"> 
                        <value>oracle.jdbc.driver.OracleDriver</value> 
                </property> 
                <property name="url"> 
                        <value>jdbc:oracle:[email protected]:1521:perfmana</value> 
                </property> 
                <property name="username"> 
                        <value>perfmana</value> 
                </property> 
                <property name="password"> 
                        <value>perfmana</value> 
                </property> 
        </bean>  -->
       <!-- 
        <bean id="DataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> 
                <property name="jndiName"><value>XQBD_DataSource</value></property>
</bean>
        -->
        <bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> 
                <property name="mappingResources"> 
                        <list> 
                                <value>com/abc/coreobject/query.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcprincipal.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcidentity.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcuserauthnticn.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcmenu.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcprincipalgrp.hbm.xml</value> 
                                <value>com/abc/coreobject/Arcgrant.hbm.xml</value>
                                <value>com/abc/coreobject/Arcgroup.hbm.xml</value>  
                                <value>com/abc/coreobject/Corperson.hbm.xml</value>
                                <value>com/abc/coreobject/Cororg.hbm.xml</value> 
                                <value>com/abc/coreobject/Corpersonorg.hbm.xml</value>
                                <value>com/abc/coreobject/Cororgorg.hbm.xml</value>
                                <value>com/abc/coreobject/Arcenum.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpi.hbm.xml</value> 
                                <value>com/abc/coreobject/Corgs.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpiprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluationseg.hbm.xml</value>
                                <value>com/abc/coreobject/Corppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpippa.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusppa.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpigrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluatorgrp.hbm.xml</value>
                                <value>com/abc/coreobject/Corevaluator.hbm.xml</value>
                                <value>com/abc/coreobject/Arcnote.hbm.xml</value>
                                <value>com/abc/coreobject/Corgsevaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpievaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Corbonusevaluated.hbm.xml</value>
                                <value>com/abc/coreobject/Aplyrule.hbm.xml</value>
                                <value>com/abc/coreobject/Corruleprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpiorg.hbm.xml</value>
                                <value>com/abc/coreobject/Corkpipsn.hbm.xml</value>
                                <value>com/abc/coreobject/Coresprincipal.hbm.xml</value>
                                <value>com/abc/coreobject/Performrule.hbm.xml</value>
                                <value>com/abc/coreobject/Personscore.hbm.xml</value>
                                <value>com/abc/coreobject/Scoreppamap.hbm.xml</value>
                                <value>com/abc/coreobject/Personscoreaply.hbm.xml</value>
                                <value>com/abc/coreobject/Newppa.hbm.xml</value>
                                <value>com/abc/coreobject/Newtaskppa.hbm.xml</value>
                                <value>com/abc/coreobject/Newkpippa.hbm.xml</value>
                                <value>com/abc/coreobject/Newbonusppa.hbm.xml</value>
                                <value>com/abc/coreobject/Destribpam.hbm.xml</value>
                                <value>com/abc/coreobject/Aplymoneypam.hbm.xml</value>
                                <value>com/abc/coreobject/Personmoney.hbm.xml</value>
                        </list> 
                </property>                
                
                <property name="hibernateProperties"> 
                        <props> 
                                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop> 
                                <prop key="hibernate.show_sql">true</prop> 
                                <prop key="hibernate.jdbc.fetch_size">50</prop>
           <prop key="hibernate.jdbc.batch_size">0</prop>
                                <prop key="hibernate.cglib.use_reflection_optimizer">true</prop> 
                        </props> 
                </property>                        <property name="dataSource"><ref bean="dataSource"/></property> 
        </bean> 如下错误：008-04-18 11:37:22,267 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: 0, SQLState: null>
2008-04-18 11:37:22,267 ERROR [org.hibernate.util.JDBCExceptionReporter] - <Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:oracle:[email protected]:1521:perfmana'>
2008-04-18 11:37:22,267 WARN [org.hibernate.cfg.SettingsFactory] - <Could not obtain connection metadata>
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:oracle:[email protected]:1521:perfmana'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1463)

Answer 9

对于三楼的做法，我已经说得很清楚了。你的属性名字是dataSource，可是你的配置确实写的<property name="DataSource"> <ref bean="DataSource"/> </property> 你把name="DataSource"改成name="dataSource"就好了。
对于我的那个写法，明显是你用得url有问题啊<Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:oracle:[email protected]:1521:perfmana'> 你先确认一下这个url是否正确吧

Answer 10

多谢FredWorks得帮忙，已经改正，thin后边少了“：”  所以不对。但是改过来后：2008-04-18 12:04:04,296 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL Error: 0, SQLState: null>
2008-04-18 12:04:04,296 ERROR [org.hibernate.util.JDBCExceptionReporter] - <Cannot create PoolableConnectionFactory (Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))))>
2008-04-18 12:04:04,296 WARN [org.hibernate.cfg.SettingsFactory] - <Could not obtain connection metadata>
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))))
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) 数据库连接不上，是我oracle安装得有问题么？

Answer 11

检查三个东西：
1. ip是否正确
2. sid是否正确
3. schema是否正确
4. 安装oracle的时候，它的port你没有修改吧？你可以使用其他工具（比如plsql developer）来连接一下，以确认连接是否正确。

Answer 12

我估计是你的sid写错误，你确认一下。

Answer 13

ip对。
我用plsql develop连接是可以连接上得。sid在那里配置呢？可否给我你得qq，我在线请教会比较好，147516852 我得QQ