问Spring/Hibernate @Transactional方法防止更新SQL

EN

@Configuration
@EnableTransactionManagement
@PropertySource(
        {
            "classpath:jdbc.properties",
            "classpath:hibernate.properties"
        })
@ComponentScan(value = "com.savant.test.spring.donorservice.core.dao")
public class ApplicationContext {


    @Bean(destroyMethod = "close")
    @Autowired
    public DataSource dataSource() {

        // Hikari is a connection pool manager.
        HikariDataSource dataSource = new HikariDataSource();
        dataSource.setUsername(env.getProperty("jdbc.username"));
        dataSource.setPassword(env.getProperty("jdbc.password"));
        dataSource.setJdbcUrl(env.getProperty("jdbc.url"));
        dataSource.setDriverClassName(env.getProperty("jdbc.driverClassName"));
        dataSource.setIsolateInternalQueries(true);
        System.out.println(dataSource);

        dataSource.setConnectionTestQuery("SELECT count(*) from system.onerow");
        dataSource.setMaximumPoolSize(3);
        dataSource.setAutoCommit(false);

        return dataSource;
    }


    @Bean
    @Autowired
    public LocalSessionFactoryBean sessionFactory(DataSource datasouce) {
        LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
        sessionFactory.setDataSource(datasouce);
        sessionFactory.setPackagesToScan(package_to_scan);
        sessionFactory.setHibernateProperties(hibernateProperties());
        return sessionFactory;
    }


    private Properties hibernateProperties() {
        Properties hibernateProperties = new Properties();
        hibernateProperties.put(hibernate_dialect, env.getProperty(hibernate_dialect));
        hibernateProperties.put(hibernate_current_session_context_class, env.getProperty(hibernate_current_session_context_class));
        hibernateProperties.put(hibernate_connection_autocommit, env.getProperty(hibernate_connection_autocommit));
        hibernateProperties.put(hibernate_format_sql, env.getProperty(hibernate_format_sql));
        hibernateProperties.put(hibernate_hbm2ddl_auto, env.getProperty(hibernate_hbm2ddl_auto));
        hibernateProperties.put(hibernate_show_sql, env.getProperty(hibernate_show_sql));
//        hibernateProperties.put(hibernate_connection_provider_class, env.getProperty(hibernate_connection_provider_class));
        return hibernateProperties;

    }


    @Bean
    @Autowired
    public HibernateTransactionManager transactionManager(SessionFactory sessionFactory) {
        HibernateTransactionManager txManager = new HibernateTransactionManager(sessionFactory);
        return txManager;
    }

    @Test
    @Transactional
    public void c_testUpdateAddress1() {
        System.out.println("findById");
        String id = donorId;
        Donor donor = donorDao.findById(id);

        donor.setAbogrp(" O");

        for (DonorAddress da : donor.getDonorAddressCollection()) {
            da.setAddr1("Updated line");
            System.out.println(da.getDonorAddressPK().getAddrtype() + " " + da.getAddr1());
        }

        System.out.println("Update");

        Donor savedDonor = donorDao.save(donor);

    }