[Proxool-developer] Proxool:How to connect SQL Server2005 Mirror Database?

[维波 张 <zwb...@ho...>]

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