You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by mailtorakeshp <ma...@gmail.com> on 2008/08/28 19:36:06 UTC
Ibatis+Spring related: Update over a dblink doesn't update the
table
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-tp19205467p19205467.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
RE: Ibatis+Spring related: Update over a dblink doesn't update the
table
Posted by mailtorakeshp <ma...@gmail.com>.
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:mailtorakeshp@gmail.com]
> 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.
RE: Ibatis+Spring related: Update over a dblink doesn't update the
table
Posted by Poitras Christian <Ch...@ircm.qc.ca>.
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:mailtorakeshp@gmail.com]
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.
Re: Ibatis+Spring related: Update over a dblink doesn't update the
table
Posted by mailtorakeshp <ma...@gmail.com>.
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.