Devart Forums

fbkevy

Hi,
This post might be the wrong area to post this.

I would like to be able to record db interactions to a file and later playback these interactions to test if the content of the data is the same. For example before an DB upgrade /change. I could run all the apps, record what was sent and received. Do the DB change and then playback what was sent and compare what was received against what was recorded before the upgrade. This allow me to test the DB and mock out the clients. The clients would have to be run manually which is time consuming also they have other interactions with other system.

Similarly, I would like to be able to mock out the DB to regression test my software applications. If I could record interaction and later rerun this fooling the applications into thinking the DB was real and receiving the exact same data time after time.

I use Oracle and DevArt.

I'm sure others would have done this before however after googling I didn't find anything. I might just not have the correct search term.

I noticed that he dbMonitor tool record a lot of the interaction therefore this should be possible and this is very close to what I would need.

Thanks,
Kevin

fbkevy

Could my problem be license related? Is 0x80004005 common?
http://www.devart.com/forums/viewtopic. ... 0653#80653

fbkevy

It could also be possible the the server side data is changing.

It is also possible that multiple clients are accessing the DB at the exact same time.

fbkevy

This error happens about 1 in 50 DB connection attempts. For some reason. Anyone got any ideas? Is this a problem on the client side or the server side?

Thanks in advance!

Devart.Data.Oracle.dll version: 6.0.86.0
Windows 2008 (64bit), .Net4, c#
Oracle client lib version: 11.2 (32 bit)
Oracle version: 11.2
Client software is 32 bit.

Error:

Code: Select all

18 Apr 2012 07:35:54,787 [16] ERROR xxx.yyy [(null)] - Error when executing ODP query
Devart.Data.Oracle.OracleException (0x80004005): ORA-08103: object no longer exists
   at Devart.Data.Oracle.a0.b(Int32 A_0)
   at Devart.Data.Oracle.a2.c(Int32 A_0)
   at Devart.Data.Oracle.OracleDataReader.Read()
   at xxx.yyy.OranetQueryDatabase[T](IDictionary`2 filterDictionary, IDictionary`2 minValuesDictionary, IDictionary`2 maxValuesDictionary, Int64 maxRows, Int64 pageNo, DbTransaction dbTransaction)

Devart Forums

Search found 4 matches

Record and playback DB interactions

Occasional error: ORA-08103