• Post Reply Bookmark Topic Watch Topic
  • New Topic

how to accessing remote multiple databases

 
magesh varatharaj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Need to access remote clients(client1, client2,client3) databases, Each client have different type of database are mysql,oracle,sql server.
Each client does not allow to access directly to the database by Connection url with login and password.
how it can be done
 
William Brogden
Author and all-around good cowpoke
Rancher
Posts: 13078
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sounds like you will have to have a separate application/process running on each "client" system with the correct security and drivers to handle queries to that database.

Why are you calling them "clients" if they are acting like servers?

What is the application that has to talk to all these databases? Where does it live?

Bill
 
magesh varatharaj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Client refers to the database which we want retrieve (with security) and we want to connect using java technology .the application will be online. Our website should remote access ours clients database and make analysis of the same and revert back the results
 
William Brogden
Author and all-around good cowpoke
Rancher
Posts: 13078
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Therefore - like I said - you will have to have a application running on each "client" system, customized for the particular database. You should now be considering exactly what kind of application this will be. There are many possibilities - direct sockets, HTTP server, eMail, Java Message Service, JavaSpaces/Jini.

There really is no magic way to get around this - think of the security problem it would cause if there was!

If I was the administrator of one of these databases you want remote access to, I would insist on SERIOUS security precautions, beyond simple password, etc.
 
magesh varatharaj
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply. given that the adminstrator of the database gives us access unconditionaly what would be the procedure for editing and retriveing the data.


ps: we are using java technology with SOAP and XML and HTTP service
 
William Brogden
Author and all-around good cowpoke
Rancher
Posts: 13078
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Talking to databases and interpreting the reply is the realm of JDBC - Java DataBase Connectivity. The ranch has a forum devoted to this topic.

SOAP clients and servers are discussed in the Web Services forum. Be sure to mention the SOAP toolkit you are using when posting there.

Bill
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!