I can't rememeber which questions were asked on this thread but being rather taken with my own approach, let me reiterate.
There are maybe three questions you could ask that include the word database:
1) How do I access a remote DB?
2) How do I create a local DB?
3) How do I manipulate DB search results or temporary data ( what associative containers exist)?
AFAIK, there is no uniformly supported JSR for J2ME that implements JDBC but you can go to sun and search the JSR's for
DB and look at JDBC4.0 spec for ideas. You are always free to create your own webpages and open your own http connections
and send an SQL query to your webpage and get back a result set in the format of your choice ( xml text or binary).
JDBC is not magic, anything off of the phone will involve sockets which, within business related limits imposed by RIMM or
carrier, let you do anything you want.
For local DB, sure, if you had jdbc you would not care about which DB is where, but in this environment it can be a big
issue. AFAIK, on BB your option is essentially persistent store with your own container classes. If you can find my
posts, I offer one solution that also addresses question 3 above.
If you write your own associative containers and group them together ( conceptually no different than a bunch of tables from
a DB) and use persistent store, the temporary or permanent nature is transparent to your code and it still acts like a DB.
I wrote my classes with my own interface ( even getting rid of various overloaded function names with quirky ones so
I could search more easily for the references ) but any set of containers for target and index data with add delete find and
reorg functions will work. So far, I've found a basic threaded tree ( B-tree with simultaneous linked list structure )
works well ( you could even argue about need for the linked list as traversing a tree is not that difficult for sequential
access but I'm still playing with this for use in more complicated index structures. ).
