Hibernate更新数据库的诡异问题

Question

请问下我现在生产上有个诡异问题，更新数据库表记录时，大约2周-3周会出现一次数据更新不成功的情况，底层无任何异常抛出。

数据库：Oracle

Hibernate:3.2.5 GA

Spring: 2.5

<bean id="dataSource" class="com.ccb.cost.common.datasource.ProxDataSource">
		<property name="driver" value="oracle.jdbc.driver.OracleDriver" />
		<property name="driverUrl" value="jdbc:oracle:thin:@10.181.76.4:1521:esb" />
		<property name="user"      value="cost" />
		<property name="password"  value="cost" />
		<property name="maximumConnectionCount" value="20" />
		<property name="minimumConnectionCount" value="1" />
		<property name="alias" value="AutoServiceConnectionPool" />
		<property name="houseKeepingTestSql" value="SELECT sysdate FROM DUAL" />
	</bean>

<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.Oracle9Dialect
				</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">true</prop>
				<prop key="connection.characterEncoding">UTF-8</prop>
				<prop key="connection.useUnicode">true</prop>
				<!-- <prop key="hibernate.query.factory_class">
					org.hibernate.hql.classic.ClassicQueryTranslatorFactory
				</prop>-->
				<prop key="hibernate.query.factory_class">
					org.hibernate.hql.ast.ASTQueryTranslatorFactory
				</prop>
			</props>
		</property>
		<property name="mappingResources">
			<list>
			</list>
                </property>

</bean>

<!-- 事务定义 -->
	<bean id="transInterceptor"
		class="org.springframework.transaction.interceptor.TransactionInterceptor">
		<property name="transactionManager">
			<ref bean="transactionManager" />
		</property>
		<property name="transactionAttributes">
			<props>
				<prop key="obtainTask">
					PROPAGATION_REQUIRED,-BizException
				</prop>
				<prop key="submitTask">
					PROPAGATION_REQUIRED,-BizException
				</prop>
				<prop key="execute">
					PROPAGATION_REQUIRED,-BizException
				</prop>
				<prop key="*">PROPAGATION_REQUIRED,-BizException</prop>
			</props>
		</property>
	</bean>

	<bean
		class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
		<property name="beanNames">
			<value>*Service,*Loader,*Sampler</value>
		</property>
		<property name="interceptorNames">
			<list>
				<value>transInterceptor</value>
			</list>
		</property>
	</bean>

	<bean id="transactionManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>

Answer 1

有可能你某些地放catch异常后没抛出，或者就是逻辑问题~~~~~