I need to create a RELATIONAL database in J2ME but I was told there is no SQL in J2ME and that I should use XML to store data. Is this the best way? I need to store the data in the device, so it doesn't connect to any server or anything like that.
Does anybody know how to do this?
example: RecordStore.openRecordStore("Database Name",true);
then you can add new records on the records store.
for more info see : http://www.enoughsoftware.com/javadoc/j2me/index.html
All the best
3 cheers JavaRanch
It can be embedded and supports CDC profile.
EmbeddedSimpleDataSource is Derby's DataSource implementation for J2ME/CDC/Foundation. It is also supports J2SE platforms. Supports the same properties as EmbeddedDataSource, see that class for details.
EmbeddedSimpleDataSource automatically supports the correct JDBC specification version for the Java Virtual Machine's environment.
* JDBC Optional Package for CDC/Foundation Profile(JSR-169) - J2ME - CDC/Foundation
Quoted from this page
Also, i found out about JDBM which stores java objects and have the atomic transaction feature. I read others say about hsqldb that works great (although i ended up with failures when trying hsqldb with IBM J9)
Anyway, please share other solutions which works for you :-)