This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Replication of data in SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Replication of data in SQL Server" Watch "Replication of data in SQL Server" New topic

Replication of data in SQL Server

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
Reqt. is to replicate data in two DB servers(using Publication & Subscription in SQL Server2000) as data is synchronized , initially I fetch data from First DB server, if its down I go for Secong DB server and fetch the data and vice versa as this procedure continues throughout my application and so need to ping everytime I open a connection to DB server and check whether its running.
So, is there any other alternative to test whether connection object is alive to proceed to other server.

SCJP 1.5, SCEA, ICED (287,484,486)
I agree. Here's the link:
subject: Replication of data in SQL Server
Similar Threads
Oracle DB Link to SQL Server 2000
Can we extract the data from resultset after the connection get closed.
Improving performance of a REST Webservice
can the data fetching time be extended?