File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java Micro Edition and the fly likes Connecting to Database Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Mobile » Java Micro Edition
Bookmark "Connecting to Database Server" Watch "Connecting to Database Server" New topic

Connecting to Database Server

Jeffry Kristianto Yanuar
Ranch Hand

Joined: Oct 01, 2007
Posts: 759
Dear friends, I have a little problem about MIDP application.

How can I connect my MIDP application to the database server for doing CRUD (Create, Read, Update, Delete) ? Until now, I don't know what database server that will be used but I assume it will be MySQL. Are there any API for doing that ? Thanks for your help.

Jeffry Kristianto Yanuar (Java Instructor)
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 17417

JDBC isn't part of J2ME. So there's no universal way. Even if there was, 2-tier applications are a menace, as SQL Slammer demonstrated. You can't even do JDBC in 2-tier mode from unsigned Java applets, because it's such a security issue.

You might want to investigate setting up some sort of web service. Although it's not as convenient as the brute-force approach, it's more secure - besides insulating your backend database server direct outside attacks, you can use encrypted channels (https).

An IDE is no substitute for an Intelligent Developer.
Jeffry Kristianto Yanuar
Ranch Hand

Joined: Oct 01, 2007
Posts: 759
Can you provide the reference where can I use web-service for doing that ? Can I use servlet to connect to the database and using HTTP connection from my MIDP application to connect the servlet ?

Jeffry Kristianto Yanuar (Java Instructor)
I agree. Here's the link:
subject: Connecting to Database Server
jQuery in Action, 3rd edition