ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mailtorakeshp <mailtorake...@gmail.com>
Subject Re: Ibatis+Spring related: Update over a dblink doesn't update the table
Date Thu, 28 Aug 2008 18:44:45 GMT

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.


Mime
View raw message