How to Connect Online hosted my sql database using java coding?

Question

Possible Duplicate:
How to connect Java to Mysql?

I have a website and its my MySQL database in blue-host.I also have in-house warehouse software in Java. I want to connect from my in house desktop software with on-line hosted my MySQL server. Can any one tell me how to connect?

score 2 · Answer 1 · answered Dec 22 '11 at 12:06

2

You probably can't: Most providers don't allow external access to their databases.

Ask your provider; they will also be able to provide you with all necessary data if it's possible after all.

answered Dec 22 '11 at 12:06

Pekka

431,103
135
960
1,075

IF they grant access then how I will connect in Java? – Saddam Hussain Attari Dec 22 '11 at 12:10
@saddam just like you connect to any other mySQL database, I suppose? I don't know, I don't do Java. – Pekka Dec 22 '11 at 12:11

score 0 · Answer 2 · answered Dec 22 '11 at 12:30

After you have got the connection parameters from your provider (if they do that at all),you can look at the MySQL documentation itself, how to connect to the database:

JDBC Connector main: http://dev.mysql.com/doc/refman/5.6/en/connector-j.html
Connection examples: http://dev.mysql.com/doc/refman/5.6/en/connector-j-examples.html

How to Connect Online hosted my sql database using java coding?

2 Answers2