ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nicholoz Koka Kiknadze <kikna...@gmail.com>
Subject Re: PL/SQL package level variables
Date Fri, 21 Aug 2009 06:43:31 GMT
Honestly, I don't quite understand your config. You have

       <tx:annotation-driven transaction-manager="txManager" />

So I guess you use annotations to mark transactions. In that case you  all
that advice/pointcut stuff seems redundant.

Now as you do not set proxy-target-class=true dont forget that you need to
put Transactional  annotations at the interface level.



On Thu, Aug 20, 2009 at 5:09 PM, CuriousMind <yogeshcjadhav@hotmail.com>wrote:

>
> Here is the code snippet for the transaction management
>
> <bean id="txManager"
> class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
>                <property name="dataSource" ref="dataSource" />
>        </bean>
>        <tx:annotation-driven transaction-manager="txManager" />
>
>        <tx:advice  id="txAdvice" transaction-manager="txManager" >
>                <tx:attributes>
>                        <tx:method name="get*" propagation="SUPPORTS"
> read-only="true"/>
>                        <tx:method name="*" propagation="REQUIRED"
>
> rollback-for="java.sql.SQLException,com.framework.exception.types.BusinessException"/>
>                </tx:attributes>
>        </tx:advice>
>
>        <aop:config>
>            <aop:pointcut id="databaseOperation" expression="execution(*
> com.business.component..*(..))"/>
>            <aop:advisor advice-ref="txAdvice"
> pointcut-ref="databaseOperation"/>
>        </aop:config>
>
> & Here goes the code for ibatis configuration
>
>
> <bean id="sqlMapClient"
> class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
>                <property name="configLocation"
> value="classpath:com/dataservice/ibatis/config/SQLMapConfig.xml"/>
>                <property name="dataSource" ref="dataSource"/>
>                <property name="useTransactionAwareDataSource" value="true"
> />
>                <property name="transactionConfigClass">
>
>
> <value>com.ibatis.sqlmap.engine.transaction.external.ExternalTransactionConfig</value>
>       </property>
>
>                <property name="transactionConfigProperties">
>           <props>
>               <prop key="DefaultAutoCommit">false</prop>
>           </props>
>       </property>
>
>        </bean>
>
>
> Nicholoz Koka Kiknadze wrote:
> >
> > Hm, but I have used package variables at Oracle 9 times (with JDBC
> though,
> > but iBatis just wraps JDBC) and it worked fine.
> >
> > May I ask how do you handle transactions, and may I look at the code
> > snippet
> > calling those procedures?
> >
> > On Tue, Aug 4, 2009 at 9:44 AM, CuriousMind
> > <yogeshcjadhav@hotmail.com>wrote:
> >
> >>
> >> Hi Nichol,
> >>
> >> Thanks for your response. We are already using same transaction while
> >> calling these procedures.
> >> But we are not getting expected results.
> >>
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/PL-SQL-package-level-variables-tp24802267p25061697.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message