• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using database at remote location

 
him jain
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Ravishanker kumar
Ranch Hand
Posts: 53
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
him jain
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks for help..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic