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.
