Replacing .db from internet gives error

kaputo · Apr 29, 2012

Hi, I have the below code to replace an sqlite database file from internet. The code seems to run OK, but after I have replaced the .db, when I run a query against the database I receive an error that the database disk image is malformed. All help appreciated, thanks

Sub JobDone (Job As String)

Dim In As InputStream, Out As OutputStream

If HttpUtils.IsSuccess(dlfilename) Then

In = HttpUtils.GetInputStream(dlfilename)
Out = File.OpenOutput(dir, "update.db", False)
Out.Flush
File.copy2(HttpUtils.GetInputStream(dlfilename),File.OpenOutput(dir, "update.db", False) )
Out.Close
SQL1.Close
File.copy(dir,"fiestas.db",dir,"old.db")
File.copy(dir,"update.db",dir,"fiestas.db")

SQL1.Initialize(dir, "fiestas.db", False)

ToastMessageShow("¡Ya los datos estan actualizados!", False)
'Button_InstallUpdate.Enabled = False

Else
'Button_InstallUpdate.Enabled = False
ToastMessageShow("No se puede conectar con el Servidor: ¡Compruebe tu conexion de Internet!",True)

End If
HttpUtils.Complete = False

End Sub

DouglasNYoung · Apr 29, 2012

kaputo,
Looks to me like there is a sequence error in your program flow - Try it like this:-

B4X:

Sub JobDone (Job As String)
Dim In As InputStream, Out As OutputStream

If HttpUtils.IsSuccess(dlfilename) Then
  In = HttpUtils.GetInputStream(dlfilename)
  Out = File.OpenOutput(dir, "update.db", False)
  File.copy2(In,Out)
  Out.Flush
  Out.Close
  SQL1.Close
  File.copy(dir,"fiestas.db",dir,"old.db")
  File.copy(dir,"update.db",dir,"fiestas.db")

  SQL1.Initialize(dir, "fiestas.db", False)

  ToastMessageShow("¡Ya los datos estan actualizados!", False)
  'Button_InstallUpdate.Enabled = False

Else
'Button_InstallUpdate.Enabled = False
  ToastMessageShow("No se puede conectar con el Servidor: ¡Compruebe tu conexion de Internet!",True)
  End If
  HttpUtils.Complete = False
End Sub

cheers,
Douglas

kaputo · Apr 29, 2012

Great! Now working, thanks a lot

kaputo · May 4, 2012

kaputo said:
Great! Now working, thanks a lot

Hi, although error in title now fixed, I also get (but only sometimes!) another error - java.io.FileNotFoundException: /update.db (Permission Denied). I have checked Manifest and have the following line:
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>
I am copying update.db to sd card, so any ideas why I might receive a permissions error (although as mentioned not every time the code is run) - thanks

Erel · May 4, 2012

The sd card might not be writable. You can check it with File.ExternalWritable.
When the device is mounted to the desktop (in storage mode), it makes the storage card read-only.

kaputo · May 4, 2012

Erel said:
The sd card might not be writable. You can check it with File.ExternalWritable.
When the device is mounted to the desktop (in storage mode), it makes the storage card read-only.

Hi, I use dbutils.CopyDBFromAssets to specify directory to write to, and in debug I see that that the sd card is writeable. Also the device is not mounted in storage mode. The problem does not occur all the time, only some of the time, but I can't see any pattern as to when it fails

Erel · May 6, 2012

Copy the database to the external storage. When you get this error, copy the database from the external storage to the computer and check the file. See if it is a valid database.

luke2012 · Mar 6, 2013

kaputo said:
Hi, I have the below code to replace an sqlite database file from internet. The code seems to run OK, but after I have replaced the .db, when I run a query against the database I receive an error that the database disk image is malformed. All help appreciated, thanks

Sub JobDone (Job As String)

Dim In As InputStream, Out As OutputStream

If HttpUtils.IsSuccess(dlfilename) Then

In = HttpUtils.GetInputStream(dlfilename)
Out = File.OpenOutput(dir, "update.db", False)
Out.Flush
File.copy2(HttpUtils.GetInputStream(dlfilename),File.OpenOutput(dir, "update.db", False) )
Out.Close
SQL1.Close
File.copy(dir,"fiestas.db",dir,"old.db")
File.copy(dir,"update.db",dir,"fiestas.db")

SQL1.Initialize(dir, "fiestas.db", False)

ToastMessageShow("¡Ya los datos estan actualizados!", False)
'Button_InstallUpdate.Enabled = False

Else
'Button_InstallUpdate.Enabled = False
ToastMessageShow("No se puede conectar con el Servidor: ¡Compruebe tu conexion de Internet!",True)
End If
HttpUtils.Complete = False
End Sub

I have a similar message when I try to use the mailparser library to download and replace the .db file that is using my app.

N.B. Before doing this I close the db using SQL.Close method.
Could be related to the db cache (Memory table?)

Erel · Mar 6, 2013

Check the size of the new database. Is it exactly the same as the file you sent?

luke2012 · Mar 7, 2013

The size (kb) is the same of the sent file.
The problem occurs sometimes but I probably understood the problem.

In my case the download attachment procedure HandlePart was interrupted.
I have to check when the download procedure end in order to known when the file il well formed on the filesystem.

luke2012 · Mar 7, 2013

luke2012 said:
The size (kb) is the same of the sent file.
The problem occurs sometimes but I probably understood the problem.

In my case the download attachment procedure HandlePart was interrupted.
I have to check when the download procedure end in order to known when the file il well formed on the filesystem.

I have only a question about this.
There is a way to read only the mail that are present in the mail client cache ?

The ParseMail library process all the mail that found in the server's mailbox while in my client I have only one mail (all the other mails has been deleted).

Erel · Mar 7, 2013

SMTP returns the mails that the server sends. You use DownloadTop to download the headers only and then decide which mails to download.

luke2012 · Mar 11, 2013

Erel said:
Check the size of the new database. Is it exactly the same as the file you sent?

The size of the db downloaded is smaller than the original one.
The original is about 539 mb and the downloaded db is about 940 kb.

I'm using SMTP to send the mail and create attachment.

Erel · Mar 11, 2013

Are you sure that the size is 539mb??? Are you sending it from one device to another?

luke2012 · Mar 11, 2013

Sorry Iim wrong. The original il 539 kb.

Yes I sending it from a device to another device.
I'll give you further details when I can access to my B4A IDE.

luke2012 · Mar 13, 2013

I think I solved the issue.
Thanks anyway for your support!

Replacing .db from internet gives error

kaputo

Member

DouglasNYoung

Active Member

kaputo

Member

kaputo

Member

Erel

B4X founder

kaputo

Member

Erel

B4X founder

luke2012

Well-Known Member

Erel

B4X founder

luke2012

Well-Known Member

luke2012

Well-Known Member

Erel

B4X founder

luke2012

Well-Known Member

Erel

B4X founder

luke2012

Well-Known Member

luke2012

Well-Known Member

Similar Threads

Replacing .db from internet gives error

Member

Active Member

Member

Member

B4X founder

Member

B4X founder

Well-Known Member

B4X founder

Well-Known Member

Well-Known Member

B4X founder

Well-Known Member

B4X founder

Well-Known Member

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency