[Proxool-developer] Proxool:How to connect SQL Server2005 Mirror Database?
UNMAINTAINED!
Brought to you by:
billhorsman
|
From: 维波 张 <zwb...@ho...> - 2008-11-03 08:54:58
|
HI:
I don’t know to send a message to proxool developer, so I write this letter and want to deliver to them.
Question: My databse is SQL Server 2005 Mirror Databse. Principal database(192.168.0.11), Mirror Databse(192.168.0.12) and Witness Databse(192.168.0.13).
Proxool.xml setup:
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>Proxool</alias>
<driver-url>jdbc:sqlserver://192.168.0.11:1433;DatabaseName=TestMirror;failoverParnter= 192.168.0.12</driver-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<driver-properties>
<property name="user" value="sa"/>
<property name="password" value="zzzz"/>
</driver-properties>
<minimum-connection-count>50</minimum-connection-count>
<maximum-connection-count>3000</maximum-connection-count>
<maximum-active-time>300000</maximum-active-time>
<house-keeping-sleep-time>30000</house-keeping-sleep-time>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
</proxool>
</something-else-entirely>
The web server I used is tomcat 5.5.9. Begin,tomcat setup,this setup is working normally. When I stop the principal databse and the mirror databse is working ,the proxool setup is not working. If I restart tomcat server, the proxool is working normally. I don’t know the reason. Does the proxool not support Sql server 2005 mirror?
Please tell me the solutions.
Best regards.
George
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE |