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.