Thanks Christian, I'll take a look at it.

-Rakesh


Poitras Christian wrote:
> 
> Are you using Spring's transaction management?
> Look at Spring declarative transactions if you didn't do so.
> 
> http://static.springframework.org/spring/docs/2.5.x/reference/transaction.html#transaction-declarative
> 
> Christian
> 
> -----Original Message-----
> From: mailtorakeshp [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 28, 2008 2:45 PM
> To: user-java@ibatis.apache.org
> Subject: Re: Ibatis+Spring related: Update over a dblink doesn't update
> the table
> 
> 
> Got it working the following way.
> 
> DaoImpl:
> --------
> getSqlMapClientTemplate().queryForObject("datapull.commit");
> 
> sql:
> ---
> <statement id="commit">commit</statement>
> 
> -Rakesh
> 
> mailtorakeshp wrote:
>>
>> Hi,
>> I am using Ibatis with Spring and updating a table (on the remote DB)
>> over a dblink, but the changes are not being seen when I login to the
>> remote DB. When I update any table in the local DB, I can observe the
>> changes in the database, but not in case of update over a dblink.
>>
>> Looks like, I need to issue an explicit commit statement, if the
>> update is over a dblink; am I correct? If so, please let me know how to
>> do that.
>> Any other solution that can solve my issue, is also very much
>> appreciated.
>>
>> Thanks
>> Rakesh
>>
> 
> --
> View this message in context:
> http://www.nabble.com/Ibatis%2BSpring-related%3A-Update-over-a-dblink-doesn%27t-update-the-table-tp19205467p19206718.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Ibatis%2BSpring-related%3A-Update-over-a-dblink-doesn%27t-update-the-table-tp19205467p19221909.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Reply via email to