Board index » delphi » Potential Problem in dbExpress Informix driver?

2006-01-18 04:36:15 AM
delphi174
Hi,
I am maintaining an application written in Delphi, using dbExpress to
connect to Informix Engine (9.x). We are using Borland's dbExpress
driver for Informix, dbexpinf.dll Version 7.0.2.113.
I am wondering whether there is a known issue in the Borland dbExpress
driver for Informix, where intermittently, it appears as if
ApplyUpdates is successfull (even get a valid read back), but it never
actually hit the database?
Because we have seen that most of the time it works fine, but
intermittently we noticed that whole bunch of records (in multiple
tables) that we know already written to database are missing. There is
no trace at all that those records ever written to database. We
conclude this based on the fact that we do a read / query after a
successful call to ApplyUpdates and we get the value we just written.
We also put trigger on the database that log whenever the tables gets
inserted/updated (with timestamp), and we don't see any records got
inserted or updated during a time frame where we have hard-copy proof
that we have succesfully called ApplyUpdate and get a value we just
written to database back.
We are really scratching our head in this one :-)
Thank you,
David Hadiprijanto
 

Hoi David
You need to repost your question on the Borland news server to make
everybody see it and possibly answer your question.
Take a look here:
<tinyurl.com/8m5nw>
which links to
<delphi.wikicities.com/wiki/Delphi_Newsgroups>
 

Hi,
I am maintaining an application written in Delphi, using dbExpress to
connect to Informix Engine (9.x). We are using Borland's dbExpress
driver for Informix, dbexpinf.dll Version 7.0.2.113.
I am wondering whether there is a known issue in the Borland dbExpress
driver for Informix, where intermittently, it appears as if
ApplyUpdates is successfull (even get a valid read back), but it never
actually hit the database?
Because we have seen that most of the time it works fine, but
intermittently we noticed that whole bunch of records (in multiple
tables) that we know already written to database are missing. There is
no trace at all that those records ever written to database. We
conclude this based on the fact that we do a read / query after a
successful call to ApplyUpdates and we get the value we just written.
We also put trigger on the database that log whenever the tables gets
inserted/updated (with timestamp), and we don't see any records got
inserted or updated during a time frame where we have hard-copy proof
that we have succesfully called ApplyUpdate and get a value we just
written to database back.
We are really scratching our head in this one :-)
Thank you,
David Hadiprijanto