List of Database in J2ME

[Kamal Trivedi]

Hi Friends,
I was finding a complete local database which is compatible with all CLDC & MIDP versions & consisting of Relational Database & also supports SQL query.But i didn't found all in one feature.I have selected J2MEMicroDB as per my requirement.
Below is list of all J2ME CLDC/MIDP Database.

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) Openbasemovil
http://www.openbasemovil.org/

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

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

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

9)J2MEMicroDB
http://morfeo.upc.es/crom/mod/wiki/view.php?id=16&page=Qu%E8+%E9s+J2MELSDATALIB&gid=0&uid=0

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

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

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

Let me know which you have selected & discuss it's features,is you have used.

[Bruce Howard]

I have been developing mobile applications since 2000 and have had many issues with few good database options. Both Apache Derby and and Java DB are reasonably good db’s, but are better on CDC or desktop devices and slow on CLDC. They are both bigger than 3 MB with no data in them and many of their SQL statements are not standard SQL statements and there is no built-in JDBC.

Mimer Database only provides a JDBC connection to a server, except for Symbian. This is also true of a couple others.

J2MEMicroDB, Perst Lite and several others are object databases and some of them are over 30 MB.

There are others on your list that started a sourceforge project, but never actually produced a product.

Pointbase is not on your list. It was a reasonable solution for this, but IBM bought the parent company and shelved the product. We licensed Pointbase, but IBM stopped the licensing after they purchased the company. However, even Pointbase was not well tested and produced errors on various SQL statements that their documentation indicated were supported.

Our experience has not been that positive for any of these solutions on the CLDC platform, although some have worked okay for the CDC platform. For CLDC there is a new solution being develop by our company, simply to deal with the frustration of the current opyions. The db we are producing will meet all of the needs you have described and much, much more taking only about 100K of space, supporting all CLDC 1.0, CLDC 1.1 and CDC environments, supporting embedded JDBC driver, encryption, uencoding and a large portion of the SQL 92 standards. Thus, developers will have a truly light db for mobile phones that can process 10,000 joined records in 3 seconds with most transactions being less than 1/2 second. More importantly, this db has been tested with over 2,000 test points to ensure a quality product. If anyone is interested in the db, which will be released in February 2009, let me know: [e-mail].

[Marcos Maia]

Thanks for taking your time to build this list. It was very helpful for me!

[Bruce Howard]

We have had a lot of questions about the Zoduna Datastore, so I am providing an update on the information. We do not have the website up, but the database is available and is being used by 30 companies at this time.

Here are some basic facts regarding the DB:

Support for both Java J2ME / MIDP CLDC and CDC devices

Database use: business applications, consumer applications, digital media management, games, etc. Is also being tested in military, aircraft, and automotive embedded application applications. We are also using the database for the development of consumer applications

It is not free, but it is about 1/4 the cost of other commercial databases and is very inexpensive (can't build, maintain and support for free): Price is $15 on CLDC devices and $25 on CDC devices with volume discounts taking the price to as little as $.10 in very large quantities

Size: 100K and small enough to run on nearly all phones, including the cheap, inexpensive phones (less than 1/3 the size of any other options and less than 1/20 to 1/200th the size of most free options)

Because of the size of the database, it is the only database that will run on more than 1/2 of the devices in the world

Performance: About 5X to 20X faster than any other options available (A query for 200 records can be less than 1/10th of a second or under 1 second depending on the type of query and indexing. We have joined over 10,000 records in 3 seconds on a mobile phone with average capabilities)

Platform Support (over 3 billion devices): Fully tested on Windows mobile, Windows Blackberry, Symbian, Android, Brew, MobiLinux, LiMo and many other forms of Linux with more than 4,000 function points per platform

JVM Support: Built-in JVMS for Blackberry, Symbian, and Android as well as Aplix (JBlend), Esmertec (Jbed), Mysaifu JVM (free), KAFFE (Free), NSIcomp (CreMe), IBM J9

Characteristics (Many of the functions can be removed upon request to shrink the DB size and further improve performance):

Storage mode, Memory mode, Combination of storage and memory mode

Built-in JDBC (In the very near future, we will also have an ODBC driver)

Database Encryption: great for financial transactions and digital media (music, video, etc.)

UTF-8 Unicode Support: with language, specific sort templates (starting with English, Spanish, French, German, Italian, Chinese and Arabic)

Views with limited update and delete capabilities

Triggers

Referential integrity

ACID Support (Autocommit, Commit, Rollback)

Data Types: Data Types: INTEGER, STRING, TEXT,CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, DATE, TIME, TIMESTAMP, DECIMAL, BYTE, SHORT, BLOB, CLOB, NCLOB, BOOLEAN, FLOAT, DOUBLE, SMALLINT, INT

Select Statements: Support WHERE, and all Aggregate Functions, all Predicate Functions, etc.

Joins Functions: Inner Joins (Equi-join / Natural join, Cross join), Outer Joins (Left outer join, Right outer join, Full outer join), Self Join, Sub-Queries, Nested Queries, Union

Predicate Functions: Comparison (">","<", "=", etc.), LIKE, AND, OR NOT, BETWEEN, LIMIT

Aggregate Functions: DISTINCT, COUNT, GROUP BY, HAVING, IN, EXISTS, SUM, TOTAL, MAX, MIN, AVG

String Functions: UPPER, LOWER, LENGTH, LTRIM, RTRIM, ISNULL, REPLACE, SOUNDEX, SUBSTRING, TRIM

Arithmetic Functions: ABS, COALESCE, CEIL, FLOOR, EXP, POW, LN, ROUND, ROOT

Date Functions: ADDMONTHS, ADDDAYS, CURRENTDATE, CURRENTTS, DIFFDATE, DATEFORMAT, TODATE, TOTIME, TOTIMESTAMP

Cursor Functions: Scrollable and Updatable

We released the CLDC 1.0 version in February and are in the final testing of CLDC 1.1 with enhanced functionality across all of the platforms noted above. The product also runs in the desktop environment. We are currently working on database design tools / integration with popular tools as well as a mobile to server synchronization tool to improve the overall programming and deployment capabilities of the database.

That should give you a good view of the database. If you know someone who would like an evaluation copy, provide the following information to [e-mail] and we will send you a copy:

Company Name

Company Address

Company Phone Number

Company Website

Contact Person

Contact Person Email

Contact Person Phone

The types of mobile devices you want to use the database on (i.e. CLDC 1.0, CLDC 1.1, Blackberry, Symbian, Android, Brew, MobiLinux, Limo, CDC, etc.)

Java J2ME MIDP CLDC Embedded SQL Persistence Database JDBC

[Marcos Maia]

Hi,

Just found this suite of tools, never used thought.


http://www.j2mepolish.org


[]s