wood burning stoves*
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: 41101
    
  45
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..
 
Consider Paul's rocket mass heater.
 
subject: using database at remote location
 
Similar Threads
Showing Table On Startup
What kind of file does MySQL create?
MS Access database
Cannot find file / dbpath not correct
Online interview questions & answers for Core JAVA