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.