How to handle a big database in j2me

Question

I want to made one application that use a database of 400Mb in sqlite3. I looking for sqlite support in j2me but nothing there is a implementation of sqlite sqljet plataform independent but use the java.io.File that not exist in j2me. I think that RMS can't handle this capacity.

The db is big but is only one table.

I looking for other format to convert the sqlite db.Database is readonly and can be a resource.

Any ideas?

@funkybro Is a telephonic directories in my country the phones don't have access to internet i have to do locally. The app with 400mg Db for android is done and easy to do but for j2me I don't find a option yet even one that not use database at all — Rolando Corratge Nieves, Aug 20 '12 at 14:50
How will you deploy the midlet without Internet access? Alternative idea, split the files into smaller chunks, and bake an index in to the app. Then load the relevant file from file system. — funkybro, Aug 20 '12 at 19:10

score 3 · Accepted Answer · edited May 23 '17 at 12:12

3

You can see list of Database in J2ME in this thread at JavaRanch forum. Or you can use Perst Lite(a Java ME embedded database).

I found above links in these questions:
J2ME With Sqlite
Is there any option for local database like Sqlite for j2me - CLDC devices?

edited May 23 '17 at 12:12

Community

1
1

answered Aug 18 '12 at 21:01

hasanghaforian

13,858
11
76
167

score 1 · Answer 2 · edited Dec 27 '12 at 10:38

I found this answer : List of Database in J2ME:

Apache Derby - an open source relational database / about 2 megabytes
Java DB - Sun's supported distribution of Apache Derby database / footprint of 2.5 MB
Floggy - free object persistence framework for J2ME/MIDP applications / 11k API
J2MEMicroDB - free object persistence framework for J2ME
mDrawer - J2ME generic database program with DES encryption
RMS DB Class - J2ME class to provide easy access to the RMS-Database system of mobile phones
Micro DB - implementation of relation database in J2ME plataform

For small amount of data you also may use kXML + miniXPath

How to handle a big database in j2me

2 Answers2