[elaltaico]

Hello


I want my midlet to connect to a database which is embeed on a web server. I tried to connect it by using netbeans but I could not. I can see there is JDBD:ODBC bridge loaded. I wrote my username password host database at the database section of Netbeans. But it could not connect to database. Do I Need to create a JDBC:ODBC Bridge connection which can connect to database and change url name at my code. Briefly, Could you please tell me how to write my JDBC driver's url at my code and how to establish a connection between my MIDlet and webserver? Thank you in advance..


Here are my database details :

my host : sql104.byetcluster.com
my database: freew_355634_museum
my class name :museums


Best Regards
Altai

[bhanuchandar.k]

Hi elaltaico,
The driver usel will looklike this if you are using the mysql as your data base

URL: jdbc:mysql://sql104.byetcluster.com:3306/freew_355634_museum
jdbc:mysql://host:port/Database name

And also refer this thread to it will help you hoe to connect to the data base using midlet

http://discussion.forum.nokia.com/fo...d.php?t=162255

[elaltaico]

Hello bhanuchandar


I got following error when I try to connect my database with the code that you gave me.. The error is :

Unable to add connection.Cannot establish a connection to

jdbc:mysql://sql104.free.ws:3306/freew_3556534_museum using com.mysql.jdbc.Driver (Communications link failure)

Lat packet sent to the servber was 0ms ago..


I checked everywhere even I checked my password and username if I mistyped them. But for now everything seems fine. I do not know why I come across with this error? Could you please help me to fix this error? Thank you in advance.


Best Regards
Altayli

[bhanuchandar.k]

Hi,
It means you are not able to connect to the host which you have specified or what ever port you are using it migh have blocked
see this link :
http://www.sqlpower.ca/forum/posts/list/1911.page

[elaltaico]

Hello


After searching a lot (also by the helps of the bhanuchandar.k) I found two options to take infos from database. Could you please look at those two possible solutions and tell me which to choose? Thank you in advance.


First Option:


I will embeed database on server and I will preparare a PHP script where I will make the sql operations on PHP Script. Then I will assign the values which I defined at the PHP scrpit to the J2ME values.PHP script will be embeed on database.

Second Option:

I will use sql commands in a different class and take the information from that class to the MIdlet class.

[bhanuchandar.k]

Hi elaltaico,

Most of the people will prefer the first option what you have mentioned.