Database support for devices with cldc midp configuration

[sheryl merchel]

Hi,

I want to build a j2me application which would need database support for storing different tables with large amount of records. This application should be able to
work in ordinary java enabled mobiles.
Currently I have a java appliaction that runs in Windows Mobile using IBM weme j9 and hsqldb (as the database support) . Now I want to create the same application
in j2me that can run in any java enabled mobile, with the aim of cost reduction in mind.
I m new to j2me. Those who have been using large database applications in j2me ,would you please suggest any open source database support for j2me (or any open source frameworks with built in databse suppory)that can help me achieve this.

---
Thanks

[Ulf Dittmer]

Anything "large" might be a problem, considering that the "L" in CLDC stands for "limited". Although some JME devices (e.g. BlackBerry which runs the CDC) are capable smartphones, that's not true in general. Many CLDC devices are on the lower end of the spectrum - think Symbian phones. Furthermore, JDBC is not available on CLDC, so you'd have to use a non-standard DB API.

Does the data have to reside on the device, or would a solution where the device accesses a remote DB server be feasible?

[sheryl merchel]

The data needs to be frequently retrieved.So I think we need to store them in device.

[Darryl Burke]

This old thread may be useful.

[sheryl merchel]

thanks for the link...
Can I be able to get some sample or some link which would tell me how to integrate the open source DB with the j2me midlet and help me do a simple
form with some values to be saved to the database and later retrieving those values for display.
That is, I want to check the feasibilty first.
Any samples you have about using any of the listed Db with j2me ,would help me get an insight to how to start it from scratch.
----
Thanks again