This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Java Micro Edition and the fly likes List of Database in J2ME Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Mobile » Java Micro Edition
Bookmark "List of Database in J2ME" Watch "List of Database in J2ME" New topic
Author

List of Database in J2ME

Kamal Trivedi
Ranch Hand

Joined: May 22, 2006
Posts: 38
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.


Kamal.B.Trivedi
Bruce Howard
Greenhorn

Joined: Jan 25, 2009
Posts: 2
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: bruce.howard@zoduna.com.

Bruce J Howard
bruce.howard@zoduna.com
815-530-6931
Marcos Maia
Ranch Hand

Joined: Jan 06, 2001
Posts: 977
Thanks for taking your time to build this list. It was very helpful for me!
Bruce Howard
Greenhorn

Joined: Jan 25, 2009
Posts: 2
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 bruce.howard@zoduna.com 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
    Ranch Hand

    Joined: Jan 06, 2001
    Posts: 977
    Hi,

    Just found this suite of tools, never used thought.


    http://www.j2mepolish.org


    []s
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: List of Database in J2ME
     
    Similar Threads
    Embedded database in Java app?
    Using javaDB
    which Database product to select ?
    free database
    Does java world has something like c sqllite