Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connecting to Remote Database

 
Bindu Roshan
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to JDBC
 
Wayne L Johnson
Ranch Hand
Posts: 399
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you very much Wayne.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic