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 Learn more!