Android deployment with SQLITE db

[karamell]

Hello all,

I am trying to deploy the example trivial example (HelloWordl) and the SQLITE found on LC website on android emulator.
Thereafter the config I use :
Platform : Linux SMP X64 on elementary OS
LC Community 6.5
Java : Open JDK 7 Runtime
Android SDK : 22.3

Whenever SQLITE is selected in "standalone application setting", the process of testing the app brings up a black screen on the emulated device whatever the version of android is ( 2.2, 2.3, 2.3.3...)
Could someone help with this issue ?
Many thanks.

[vedus]

When i use 2.3 versions the emulator is no working right. (most blank screen's)
I use from version 3 and above in the emulator.
try different version above 3

[karamell]

Thank you for help.
I just tried :
EMulator running : Android 4.4.2 ARM
And Compiled LC example with Standaelone settings "Required Minimum android Version : 3.1"

I still get a blank screen ....

It seems to be really SQLITE embedding within APK generated by LC related...

[vedus]

i am using mac and just i test my app for ios i have make.
i use this settings bellow
i have include the file in the "copy files" .sqlite
i have sign as "sign for development only"
i have check the sqlite checkbox
and minimum android version deploy.2.3.3
and in the emulator
android 4.2.2 api lvl 17
ram 1024
internal storage 200
and is working ok..

[karamell]

I am running linux as development environment.
The file that I use is Sqlite_Example.livecode
I tried both on emulated device (AVD same as yours) and real device (Galaxy Tab 3 GT P5210)... and same config for compiling, I still get the same problem: Black screen.

Maybe a GURU might help ??
Thx

[Simon]

Hi karamell,
You didn't say that you included;

i have include the file in the "copy files" .sqlite

Simon

[karamell]

Sorry... where can I find this file ".sqlite" ?
is it the database itself? (i.e. revdatabase.sqlite ). If yes, then I did it... not working

[Simon]

Hi karamell,
Sorry the sample creates one when you hit "connect to database".
Using the stock (unchanged) Sqlite_Example.livecode it's running fine here for me on mobile.

Simon

[karamell]

Hi,
Somehow, It seems to be Linux related (maybe OpenJava?) as indeed it works under windows 7.

[Klaus]

HI karamell,

can you eventually narrow down the problem?

1. Does the app start at all?
2. When exactly does the screen turn black?
When opening that app?
When trying to connect to the database?
When trying to get/write data from/to database?

Remember that the db file will end in -> specialfolderpath("engine")
when you use the "Copy files" tab in the standalone builder and you do
NOT have WRITE permissions in the ENGINE folder!


Best

Klaus