connecting to Remote Database

[Bindu Roshan]

Hi,
I want my swing application connect to a remote database(MySQL) and return resultsets.
Now I am getting data directly from remote DB using
remote DbURL =jdbc:mysql://remote IP address:3306/dbname
DriverManager.getConnection(remotedbURL, remoteuserName, remotepassWord);
Is there any problem getting records like this?

What is the best way of doing this?

Is this through RMI?(any reference sites for Tomcat RMI)or any other way?

Thanks in advance.
Bindu

[Gregg Bolinger]

Moving to JDBC

[Wayne L Johnson]

You are doing it correctly: it doesn't matter if the database is local or remote, all you need is the IP address or domain name (and any other optional database parameters).

The java classes (JDBC libraries for the database) are talking either directly to the database, or through some sort of proxy. But it's not using RMI.

[Bindu Roshan]

Thank you very much Wayne.