Groups > BEA > BEA AquaLogic > DS sends updates to DB only in commit (can't find modified data in same




DS sends updates to DB only in commit (can't find modified
data in same

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
about | contact