local database for application on N95 mobile

[burinutit]

Hi all,

I'm developing an application on the Nokia N95. I need to store some data locally and later to update them.
I tried to use Record Store but it not so suitable for a relational database.
I would like to find some database management system for the mobile, just as simple as Microsoft Access or MySQL for Windows.
While searching on the internet, I found Symbian SQL, but this one seems not to be used for Java application. The other solutions that I found such as Sybase's SQL anywhere, Microsoft SQL Server Compact... are only supporting Windows Mobile.

Could someone please tell me which DBMS I could use? I don't have much experience with mobile application development.
Thank you very much in advance.

Best regards,
burin

[petrib]

You can do file access via JSR-75 (FileConnection API). I don't know if there are any good JME (J2ME) database implementations (over JSR-75) that you could use.

You could also use a native (Symbian) database through a C++ server (your Java app would use local TCP/IP sockets to talk to the C++ server that accesses the datbase).

[burinutit]

Hi Petrib,

Thank you for your advice. The 2nd solution sounds good. Do you have any helpful acticle for it?

Best regards,
burin

[burinutit]

Hi Petrib and everybody,

Do you have any example of a C++ server for Symbian database? I'm not so experienced with C++ and I'm null at what you call "native Symbian database".
Could you help me please?
Thank you.

Best regards,
burin

[raj_J2ME]

Hi Petrib and everybody,

Do you have any example of a C++ server for Symbian database? I'm not so experienced with C++ and I'm null at what you call "native Symbian database".

Well I would suggest you that discuss the same thing in the symbain forums and there are the chances to get the quick solution.

[burinutit]

Hi all,

I found OpenBaseMovil, pretty cool!

Best regards,
burin

[raj_J2ME]

Hi all,

I found OpenBaseMovil, pretty cool!

Best regards,
burin

Could you please compare the both and share the same here that what are the points that you found more better than any other like the RMS and other.

[ektasrv]

Here are some other good options out which the bold are the once I used and found good.

1) Apache Derby
http://db.apache.org/derby/

2) Java DB
http://developers.sun.com/javadb/

3)Floggy
http://floggy.sourceforge.net/

4)mcobject - Perst Lite Embedded Micro-Database for J2ME
http://www.mcobject.com/j2me_database/

5)J2ME Device DB
http://j2me-device-db.sourceforge.net/pmwiki/index.php

6)Mimer Database
http://developer.mimer.com/downloads/index.htm

7)Mobile Query Manager
http://www.midpjdbc.de/test.html
http://www.midpjdbc.de/javadoc/index.html

8)J2MEMicroDB
http://morfeo.upc.es/crom/mod/wiki/v...IB&gid=0&uid=0

9)mDrawer
http://sourceforge.net/projects/mdrawer/

10)RMS DB Class
http://sourceforge.net/projects/rms-db-class/

11)Micro DB
http://sourceforge.net/projects/microdb/

thanks,
Ekta