（100）郁闷死！struts+spring+hibernate整合！

Question

如下配置又问题吗？ 提示我dataSource的类型不正确！有错么？郁闷<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" value="dataSource">
</property>
<property name="mappingResources">
<list>
<value>com/yourber/bank/model/Accounts.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
</props>
</property>
</bean>

Answer 1

<bean id="datasource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>net.sourceforge.jtds.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:jtds:sqlserver://192.168.1.8:1433/callcenterj_sy;tds=8.0;lastupdatecount=true</value>
</property>
<property name="username">
<value>callcenterj_sy</value>
</property>
<property name="password">
<value>callcenterj_sy</value>
</property>
</bean> <bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
destroy-method="destroy">
<property name="hibernateProperties">
<props>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.dialect">
<!--org.hibernate.dialect.MySQLDialect-->
org.hibernate.dialect.SQLServerDialect
<!--org.hibernate.dialect.SybaseDialect-->
<!--org.hibernate.dialect.Oracle9Dialect-->
</prop>
<prop key="connection.characterEncoding">UTF-8</prop>
</props>
</property> <property name="configLocation">
<value>
classpath:/et/config/hibernate/hibernate.cfg.xml
</value>
</property>
<property name="dataSource">
<ref bean="datasource" />
</property>
</bean>

Answer 2

第一段应该是
<property name="dataSource" ref="dataSource" />

Answer 3

<property name="dataSource" value="dataSource">    
</property>
应该是
<property name="dataSource" ref="dataSource">    
</property>
吧

Answer 4

XML code <property name="dataSource" value="dataSource">     
</property> 
应该是  XML code
 <property name="dataSource">     
   <ref="dataSource" />
</property> 

Answer 5

- <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
  <property name="driverClass" value="com.mysql.jdbc.Driver" /> 
  <property name="autoCommitOnClose" value="false" /> 
  <property name="maxIdleTime" value="1800" /> 
- <!--  最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃 
  --> 
  <property name="maxPoolSize" value="50" /> 
  <property name="initialPoolSize" value="5" /> 
  <property name="jdbcUrl" value="jdbc:mysql://192.168.3.100:3306/db_bbs" /> 
  <property name="user" value="root" /> 
  <property name="password" value="" /> 
  </bean>
- <!--  SessionFactory   
  --> 
- <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource" ref="dataSource" /> 
- <property name="hibernateProperties">
- <props>
  <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> 
  </props>
  </property>
- <property name="mappingResources">
- <list>
  <value>com/handson/springlogin/model/LeaveWord.hbm.xml</value> 
  <value>com/handson/springlogin/model/Panel.hbm.xml</value> 
  <value>com/handson/springlogin/model/Release.hbm.xml</value> 
  <value>com/handson/springlogin/model/User.hbm.xml</value> 
  <value>com/handson/springlogin/model/Review.hbm.xml</value> 
  <value>com/handson/springlogin/model/Bulletin.hbm.xml</value> 
  </list>
  </property>
  </bean>

Answer 6

XML code <property name="dataSource" value="dataSource">     
</property> 
应该是  XML code <property name="dataSource" ref="dataSource">     
</property> 

Answer 7

<property name="dataSource" ref="dataSource">    
</property>因为你在这是引用另一个 bean 啊
bena 的 id 是 dataSource

Answer 8

有问题,你可以去看看我总节的spring的多种配置,

Answer 9

<bean><property name="dataSource">      
    <ref="dataSource" /> 
</property>
</bean>
 <bean id="datasource"
        class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName">
            <value>net.sourceforge.jtds.jdbc.Driver</value>
        </property>
        <property name="url">
            <value>jdbc:jtds:sqlserver://192.168.1.8:1433/callcenterj_sy;tds=8.0;lastupdatecount=true</value>
        </property>
        <property name="username">
            <value>callcenterj_sy</value>
        </property>
        <property name="password">
            <value>callcenterj_sy</value>
        </property>
    </bean>