有人真个测试过spring事务中readonly吗

//其中， DataSourceUtils.prepareConnectionForTransaction(con, definition)中会设置con.setReadOnly(true)
protected void doBegin(Object transaction, TransactionDefinition definition) {
....
....
Integer previousIsolationLevel = DataSourceUtils.prepareConnectionForTransaction(con, definition);
			txObject.setPreviousIsolationLevel(previousIsolationLevel);

			// Switch to manual commit if necessary. This is very expensive in some JDBC drivers,
			// so we don't want to do it unnecessarily (for example if we've explicitly
			// configured the connection pool to set it already).
			
			if (con.getAutoCommit()) {
				
				txObject.setMustRestoreAutoCommit(true);
				
				if (logger.isDebugEnabled()) {
					logger.debug("Switching JDBC Connection [" + con + "] to manual commit");
				}
				con.setAutoCommit(false);
			}
...
...
}

21/01/2009 16:43:01,457 <DEBUG> (org.springframework.transaction.interceptor.NameMatchTransactionAttributeSource)- Adding transactional method [search*] with attribute [PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly]


21/01/2009 17:10:00,864 <DEBUG> (org.springframework.jdbc.datasource.DataSourceTransactionManager)- Creating new transaction with name [com.me.service.logic.ViewService.searchLeave]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly

set transaction read only;
update stu set title = 'oh,god' where id='12345'

ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction

	<aop:config>
		<aop:pointcut id="serviceOperation"
			expression="execution(* com.me.service.logic.*ServiceImpl.*(..))" />
		<aop:advisor pointcut-ref="serviceOperation" advice-ref="txAdvice" />
	</aop:config>

	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="search*" read-only="true" />
		</tx:attributes>
	</tx:advice>

//ViewServiceImpl:
public List searchLeave(Leave leave) {
	
        //update stu set title = 'oh,god' where id='12345'
        int j = viewDAO.updateStu();
		
	return viewDAO.searchLeave(leave);
}

3 楼 workman93 2009-01-22  

geng2483759 写道

@Transactional(readonly="true") 也测试过，也是不行。 并不是只是怀疑spring，我只是想弄清楚其中的缘由，不然怎么能在项目中使用呢。是吧。 我相信大家很多都在项目中配了readonly，可以动手测一下。

我也正在困扰中，我使用SQL 2005貌似也没有起作用。楼主要是有结果的话麻烦告知一下，非常感谢。

if (definition.isReadOnly() && txObject.isNewSession()) {
                                // Just set to NEVER in case of a new Session for this transaction.
                                session.setFlushMode(FlushMode.NEVER);
                        }

if (definition.isReadOnly() && txObject.isNewSession()) {
                                // Just set to NEVER in case of a new Session for this transaction.
                                session.setFlushMode(FlushMode.NEVER);
                        }

public static Integer prepareConnectionForTransaction(Connection con, TransactionDefinition definition)
			throws SQLException {

		Assert.notNull(con, "No Connection specified");

		// Set read-only flag.
		if (definition != null && definition.isReadOnly()) {
			try {
				if (logger.isDebugEnabled()) {
					logger.debug("Setting JDBC Connection [" + con + "] read-only");
				}
				con.setReadOnly(true);
			}
			catch (Throwable ex) {
				// SQLException or UnsupportedOperationException
				// -> ignore, it's just a hint anyway.
				logger.debug("Could not set JDBC Connection read-only", ex);
			}
		}

		。。。。。。。。。。。。。。。。。
	}