• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

J2ME and Mobile Database

 
Joel Karimpil
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i wanted to know whether there is any free database for mobile devices.

i'm targeting pocketpc,wince and linux based pdas.

also, i need a database which i can access thru a jdbc driver.

so it needs to have a driver coming along with it.

plz hlp. i'm really lost and cannot proceed with my project as i am not able to come to a conclusion.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well for the PocketPC, you can simply use Access, well actually that isn't free.

And I like Pointbase, but that might not be free either.

Well I guess I am of no help here. Sorry

Mark
 
Michael Yuan
author
Ranch Hand
Posts: 1427
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HSQL is an open source pure Java database for J2ME Personal Profile.
 
Joel Karimpil
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you, Mark.

Michael,
i wanted a DB for PocketPC and Linux.
can i use HSQLDB for PocketPC.
i know it works on Linux.
and what abt it's driver?
 
Michael Yuan
author
Ranch Hand
Posts: 1427
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HSQL is a pure Java database -- It runs on any platform that supports the J2ME Personal Profile (as well as J2SE). It does not need a JDBC driver since its native API is already Java.
 
Joel Karimpil
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank You,
Michael.

very pleased with your reply.
actually, i'm wondering whether there is a website offering free chapters from ur book.

also, i have just started reading up on RMS in java.
what is ur opinion on RMS as compared to a conventional DB.
i have read that it offers insert,update and delete.
but i'm not sure abt it's qeurying capabilities.

plz guide.

Thanks.
 
Michael Yuan
author
Ranch Hand
Posts: 1427
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
RMS does not really compare to a conventional DB. Although it provides API to search for records (filter) and order the returned results, one of its key drawbacks is that the records themselves are not typed. They are simply arrays of bytes and you have to do the serialization yourself. So, accordingly, you have to come up with your own filter and order algorithms by providing implementations to related interfaces. That is very different from the structured SQL model.

As of free chapters of my book, you can find some here:

http://www.michaelyuan.com/pages/enterprisej2me/excerpts.php

But unfortunately, the publisher did not make the database chapters available for download ...
 
Joel Karimpil
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot, Sir.

so, do u think HSQLDB would be the correct choice?

also, what abt the jdbc driver?

the site offers ch:4
 
Michael Yuan
author
Ranch Hand
Posts: 1427
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Whether HSQLDB is the right choice depends on what you need to do. For most hobbyist projects, I think you can start from it.

I think I already said this: HSQLDB is pure Java and has a native API in Java. That means it supports JDBC natively -- there is no need for a JDBC "driver" or anything. Read its documentation to find out exactly what classes in JDBC it supports.
 
Joel Karimpil
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi.

is there a database that runs on an MIDP CLDC ?

also, is the kvm shipped with cldc?
 
Michael Yuan
author
Ranch Hand
Posts: 1427
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
PointBase runs on MIDP/CLDC. Yes, KVM is part of CLDC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic