一个折磨我好几天的问题求大虾急救!!!

Question

我用的DAO类是继承HibernateDAOSupport的
用hibernate摸版进行数据库的操作按理说 不用我自己commit()啊...

Answer 1

配置log4j了...没有任何错误就是数据库里面没有记录...郁闷死我了...

Answer 2

事务没有提交，
配上spring 的事务代理，让其自动代理事务就ok了。<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="url">
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=springch3</value>
</property>
<property name="username">
<value>sa</value>
</property>
<property name="password">
<value></value>
</property>
<property name="driverClassName">
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</property>
</bean>

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource"/>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
<prop key="hibernate.connection.autocommit">false</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/xaccp/config/BrowRecoder.hbm.xml</value>
<value>com/xaccp/config/Customer.hbm.xml</value>
</list>
</property>
</bean>



<bean id="CustomerDAO" class="com.xaccp.database.dao.CustomerDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="BrowRecoderDAO"
class="com.xaccp.database.dao.BrowRecoderDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>

<bean id="BrowService" class="com.xaccp.service.Browservice">
<property name="browRecoderDAO">
<ref bean="BrowRecoderDAO"/>
</property>
<property name="customerDAO">
<ref bean="CustomerDAO"/>
</property>
</bean>


<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="sessionFactory"/>
</property>
</bean>
<!-- 绗竴绉嶄唬鐞嗘柟娉?-->
<bean id="BrowManagerProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="transactionAttributes">
<props>
<prop key="save*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="updata*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
</props>
</property>
<property name="proxyInterfaces">
<list>
<value>com.xaccp.business.BrowManager</value>
</list>
</property>
<property name="target">
<ref bean="BrowService"/>
</property>
</bean>


<!-- 绗簩绉嶈缃唬鐞嗙殑鏂规硶锛屽彲浠ユ妸姝や唬鐞嗚缃负涓€涓娊璞＄殑 -->
<bean id="trasactionProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="transactionAttributes">
<props>
<prop key="save*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
<prop key="updata*">PROPAGATION_REQUIRED,-java.lang.Exception</prop>
</props>
</property>

</bean>

Answer 3

昨天的hibernate失误我都配置了
可是还是不好用 我在看看...谢谢

Answer 4

log4j应该打印出insert 或update之类的语句，如果没有的话，就是配置问题，或是根本没执行到saveorupdate，调试一下。

Answer 5

PROXOOL.XML文件的内容...
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
  <proxool>
    <alias>dbPool</alias>
    <driver-url>jdbc:mysql://localhost/test</driver-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver-properties>
      <property name="user" value="root"/>
      <property name="password" value="root"/>
      <property name="useUnicode" value="true"/>
      <property name="characterEncoding" value="UTF-8"/>
    </driver-properties>applicationContext.xml文件....
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans> <bean id="SessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="hibernateProperties">
<props>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="show_sql">true</prop>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.proxool.xml">Proxool.xml</prop>
<prop key="hibernate.proxool.pool_alias">dbPool</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>bean/Person.hbm.xml</value></list>
</property></bean>
<bean id="PersonDAO" class="bean.PersonDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="baseService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
<property name="transactionManager" ref="transactionManager" />
<property name="proxyTargetClass" value="true"/>
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="save*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="update*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="del*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean>

<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
</beans>大家还是帮忙看看吧..
    
    <maximum-connection-count>100</maximum-connection-count>
    
<minimum-connection-count>10</minimum-connection-count>    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
      
    <house-keeping-sleep-time>90000</house-keeping-sleep-time>
 
  </proxool>
 </something-else-entirely>

Answer 6

PROXOOL.XML文件的内容...
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
  <proxool>
    <alias>dbPool</alias>
    <driver-url>jdbc:mysql://localhost/test</driver-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver-properties>
      <property name="user" value="root"/>
      <property name="password" value="root"/>
      <property name="useUnicode" value="true"/>
      <property name="characterEncoding" value="UTF-8"/>
    </driver-properties>
    
    <maximum-connection-count>100</maximum-connection-count>
    
<minimum-connection-count>10</minimum-connection-count>    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
      
    <house-keeping-sleep-time>90000</house-keeping-sleep-time>
 
  </proxool>
 </something-else-entirely>applicationContext.xml文件....
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans> <bean id="SessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="hibernateProperties">
<props>
<prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
<prop key="show_sql">true</prop>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.proxool.xml">Proxool.xml</prop>
<prop key="hibernate.proxool.pool_alias">dbPool</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>bean/Person.hbm.xml</value></list>
</property></bean>
<bean id="PersonDAO" class="bean.PersonDAO">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
<bean id="baseService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
<property name="transactionManager" ref="transactionManager" />
<property name="proxyTargetClass" value="true"/>
<property name="transactionAttributes">
<props>
<prop key="insert*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="save*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="update*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="del*">PROPAGATION_REQUIRED,-Exception</prop>
<prop key="*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean>

<bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="SessionFactory" />
</property>
</bean>
</beans>大家还是帮忙看看吧..