Accessing Sqlite Database file for i-Jetty Web App

64 views
Skip to first unread message

Kamal Mohemed

unread,
Apr 1, 2016, 8:52:31 AM4/1/16
to SQLDroid
Hi,

I used SqlDriod jar library for my servlet application to be deploy using I-Jetty Android Web server, awesome working fine, but i am not able to see any sqlite database created on my emulator memory and not able to do any database transaction? Help required for this.

Thanks
Kamal. m

Kristian Lein-Mathisen

unread,
Apr 4, 2016, 3:21:59 AM4/4/16
to <sqldroid@googlegroups.com>

Hi Kamal,

SQLDroid simply lets you use the standrad JDBC interfaces, and doesn't really touch where your database files go. If you are using an Sqlite backend, you'll need to track down where that backend is putting its file. The filename should be part of you JDBC config string. You could also try an absolute pathname there (eg. "jdbc:sqlite:/cache/test.sqlite3"). For relative filenames on Android, I'd try and look under `/data/data/<your-package-name>`

Best of luck!
K.

--
You received this message because you are subscribed to the Google Groups "SQLDroid" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqldroid+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Kamal Mohemed

unread,
Apr 4, 2016, 7:10:25 AM4/4/16
to SQLDroid
Hi,

I used to create or connect the sqlite database from a .dex file which is stored in external sd card and that .dex file  deployed using I-Jetty Mobile Webserver application which can be accessible by servlet request and response concept. For Example i  accessing those servlet program from browser. 
Now in that servlet application i have given the external path of where the database to create, but unfortunately i am not able to create the database in the sdcard location where the .dex file installed.

I think this question can be understand better if you are using I-jetty Mobile Webserver.

------------------------------------------------------------------------------------------------------------------------------------

Kristian Lein-Mathisen

unread,
Apr 7, 2016, 6:59:47 AM4/7/16
to <sqldroid@googlegroups.com>

Hi Kamal,

I think you're right, this seems more like a file-permissions problems of I-jetty Mobile Webserver than SQLDroid. I hope you can work things out.

K.
Reply all
Reply to author
Forward
0 new messages