<bean id="txManagerMssql" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSourceMssql"/>
</bean>
<tx:advice id="txAdviceMssql" transaction-manager="txManagerMssql">
<tx:attributes>
<tx:method name="*" rollback-for="Exception"/>
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="requiredTxMssql"
expression="execution(projectName..service..*Impl.*(..))"/>
<aop:advisor advice-ref="txAdviceMssql"
pointcut-ref="requiredTxMssql" />
</aop:config>
<property name="dataSource" ref="dataSourceMssql"/>
</bean>
<tx:advice id="txAdviceMssql" transaction-manager="txManagerMssql">
<tx:attributes>
<tx:method name="*" rollback-for="Exception"/>
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut id="requiredTxMssql"
expression="execution(projectName..service..*Impl.*(..))"/>
<aop:advisor advice-ref="txAdviceMssql"
pointcut-ref="requiredTxMssql" />
</aop:config>