Two Laptop Bag
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: 17018

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).

Customer surveys are for companies who didn't pay proper attention to begin with.
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
It's not a secret anymore!