|
| DS sends updates to DB only in commit (can't find modified data in same |
 |
Fri, 11 Apr 2008 04:23:28 -070 |
Hello experts!
We have a physical data service mapping a simple Oracle database table. When we
update one record in the database (invoking submit on the DS), and use a
function in that same dataservice to get the refreshed record, the updated
column comes with the OLD value. But after the transaction ends (we isolated
this is a simple JWS), the database gets updated.
The most strange fact: we also did a test using another Data Service to do the
update, now mapping a stored procedure to do the updates (without commits in
body). Then the test works fine.
The conclusion I can reach is DSP is holding the instance somewhere after the
submit() and is not sending it to the database connection. I understand that
the commit is not performed, but if I do a query in the same TX, I should see my
changed, shouldn't I?
We use WL 8.1.6 with DSP 2.5.
We´d appreciate very much if yuo guys could help.
Thanks,
|
| Post Reply
|
|
|
|
|
|
|
|
|
|