Re: SQLCE 3.0 losing data after transaction

Tech-Archive recommends: Speed Up your PC by fixing your registry

Pablo,

Do you have a *small* code sample that illustrates this issue including code to create the database?

How much memory is available on the device you're using? Are you using DataSet or something less memory hungry like SqlCeResultSet?

Thanks,

--

Ginny Caughey
Device Application Development MVP



"Pablo Barros" <Pablo Barros@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5D679B61-5EC3-4881-A279-4EBF594F7E5F@xxxxxxxxxxxxxxxx
Hi, I have the same problem, after some rows are inserted in various tables
and we read the data, the data inserted (not all some rows) dissapeared. Do
you find a resolution for the problem?
Thks

"ErusGladius" wrote:

Hi,
We are having difficulties on our mobile application. We were using CE
2.0 and it was working perfect. Now that we upgraded to 3.0 , problems
occur every day. We are using Singleton Connection and transaction.

We are having difficulty on memory usage, after some work and
inserting many rows to the database we get a "not enough memory"
exception. And we can not go anywhere after that. Closing the
connection and opening again does not work.Only solution is to close
the application.

Our 2nd problem is , sometime we lose data. After some rows are
inserted and we succesfully read the data , there is a chance to lose
the data thats being inserted. We lose not all the rows but some rows.
And it occurs like there is a huge transaction and its roll backed.
But there is no such transaction. We commit our transaction after each
succesful insert.

Any help will be appreciated

.

Relevant Pages

  • Re: Looking for super fast CSV parser
    ... My findings show that DISQLite3 can insert the 20 ... It uses the latest DISQLite3 Pro as database engine. ... GB memory, 5200 rpm hard drive, WinXP SP2. ... a new transaction started every TRANSACTION_DELTA inserts. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: SQLCE 3.0 losing data after transaction
    ... I think that not resolve the problem, because between the transaction commit ... You can also control the flush scheduling time using Connection String ... only SqlCeResultSet to get data from the database. ... inserting many rows to the database we get a "not enough memory" ...
    (microsoft.public.sqlserver.ce)
  • Re: Recordset.AddNew and the recordset objects data retaining
    ... The statement you make about the individual updates not hitting the database ... to do with the updates being in a transaction but rather on whether you specify ... spill over and the memory starts paging out to disk that concerns me). ...
    (microsoft.public.data.ado)
  • Re: Interconnection Delay
    ... Are these JDBC connections? ... But I observed delays also for a single database ... A reason/excuse could be the particular transaction ... memory model that JET used. ...
    (comp.lang.java.databases)
  • Re: Transforming ascii file (pseduo database) into proper database
    ... The ascii files are just a series of lines, ... do not match up with those in the database in which i need to insert ... so pulling everything into memory and matching up the relations before ... inserting the data into the database is impossible. ...
    (comp.lang.python)