aspose file tools*
The moose likes JDBC and the fly likes What should be the connection URL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "What should be the connection URL" Watch "What should be the connection URL" New topic
Author

What should be the connection URL

Mahesh Lohi
Ranch Hand

Joined: Jun 22, 2009
Posts: 151
Hi all,

I use two systems. I have placed the DB in one of the system(server) and would like to insert and select data from the second system.

my connection is String url=("jdbc:mysql://localhost:3306/warehouse?"+"user=root&password=123456");

Now what should I change my url string to, so that I can access the warehouse database via the client system

Thank you in advance
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42930
    
  68
You'd replace "localhost" by the name (or IP address) of the DB server, "3306" by the port number on which the server is listening, "warehouse" by the name of the DB schema you want to access, "root" by the username, and "123456" by the user's password.
Mahesh Lohi
Ranch Hand

Joined: Jun 22, 2009
Posts: 151
Thank you for the quick response.. is DB schema different from my db name

Thank you in advance
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42930
    
  68
No, that's the same.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: What should be the connection URL