Hi Naveen, I'm using Spring to control the transaction on my (sql server) db I added to my spring.xml;
Declaration (and jars); <beans xmlns="http://www.springframework.org/schema/beans"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:aop="http://www.springframework.org/schema/aop"; xmlns:tx="http://www.springframework.org/schema/tx"; xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd";> Transaction manager configuration; <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean> <aop:config> <aop:advisor pointcut="execution(* esos.server.DAO.*DAOImpl.*(..))" advice-ref="txAdvice"/> </aop:config> <tx:advice id="txAdvice"> <tx:attributes> <tx:method name="update*" timeout="600"/> <tx:method name="exec*" timeout="1800"/> <tx:method name="*" propagation="NEVER" timeout="60"/> </tx:attributes> </tx:advice> This will put all methods in the classes in esos.server.DAO.DAOImpl into transaction. The method names starting with update or exec will be encapsulated and all the other methods will not be placed in a transaction. The method names starting with exec have been given 30 minutes time to complete (batch process stored procedures) I don't know the list of required JARs from the top of my head, but you will be able to find that on the spring help files. Kind Regards Meindert -----Original Message----- From: naveendutt [mailto:naveendutt.v...@gmail.com] Sent: 01 December 2009 11:56 AM To: user-java@ibatis.apache.org Subject: Transactionality using ibatis Hi All, I am using weblogic portal and for database insertion and all, ibatis. i am facing issues in how to make transactions using ibatis if i need to insert data on more than one tables [transaction include failure scenarios as well]. Could you please let me know how can I do that? is that possible by just adding some annotation over my method in my DAO class file? i Suppose i need to make some changes in application context xml also, what will be they, if i m correct? else please let me know how can i accomplish that???? naveen -- View this message in context: http://old.nabble.com/Transactionality-using-ibatis-tp26588112p26588112.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.88/2537 - Release Date: 11/30/09 23:05:00 --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
