aspose file tools*
The moose likes JDBC and the fly likes using database at remote location Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "using database at remote location" Watch "using database at remote location" New topic
Author

using database at remote location

him jain
Ranch Hand

Joined: Feb 05, 2010
Posts: 56
I want to store the data in database, but db is on different computer.
So, is it possible to save data in that db from my computer?


--Himanshu Jain
http://jainhim.blogspot.com/
Ravishanker kumar
Ranch Hand

Joined: Jul 20, 2006
Posts: 53
yes its possible. Provide machine name and database name for other machine.
For example if you are using mysql database, jdbc connection url is :jdbc:mysql://[Machine Name]/[Database Name]

Hope this will help you.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41529
    
  53
Yes, JDBC is in most cases used to access DBs that are *not* on the local machine, but somewhere on a server. As long as that server is reachable via TCP/IP (meaning, there's no firewall in between that blocks the DB port) it should work fine.


Ping & DNS - my free Android networking tools app
him jain
Ranch Hand

Joined: Feb 05, 2010
Posts: 56
thanks for help..
 
 
subject: using database at remote location