[smilebb]

Hi all,

I am very new to blackberry application development.
I wanted to connect database to my blackberry simulator.

I am able to retrieve values from a database which is located on a sdcard, but now I want to retrieve the data from MySql datadase server.

Can u guys plz help me in this...plz give some code details....

It's urgent..!!!

[neha.chaudhary]

hi!
for making connection with database present on remote server u have have to write servlet at server side,which will be responsible for storing data on db.

[smilebb]

Hi neha,

thnx for ur suggestion.
but I am using Blackberry JDE 5.0 in which database API is provided.
and till now what i've been doing is that my database was created on sdcard and code to access it is:

String dbLocation = "file:///SDCard/BlackBerry";
URI myURI = URI.create( dbLocation + "/databasename.db");
d = DatabaseFactory.open(myURI);
Statement stSelect = d.createStatement("SELECT Col1 FROM table1");
stSelect.prepare();
Cursor cursor = stSelect.getCursor();
while(cursor.next())
{
//do sumthing
}

I simply retieve the data from the table in the database and display it on the screen by clicking the application icon in the downloads tab on bb simulator 9550.

Now what i want is that instead of using the database on the sdcard I want to retrieve data from a remote server which is either on my machine or any other machine.

can u plz help in this and provide some code for the same.

Thx in advance!

[Dougsg38p]

There is no Blackberry API for connecting to a remote database.

As stated in the previous post, you'll need some type of server-side code to accept an HTTP GET or POST. Your server-side code will make the database query and return the data, probably in an XML or JSON document.

[smilebb]

thanks, now I have created a servlet to insert data into MySQL database.

but how can I retrieve the data from database and display that data on the blackberry screen.

Thanks in advance!

[neha.chaudhary]

Hi!

do u know how to access database using servlet???? if yes thn,
use HttpConnection to communicate servlet with your device.