Mantis - Resin
Viewing Issue Advanced Details
4231 minor always 09-28-10 14:54 01-13-11 13:25
alex  
ferg  
normal  
closed 4.0.7  
fixed  
none    
none 4.0.15  
0004231: database pool can not recover
database: MS SQL 2000
driver: jtds1.2.2

database pool does not recover after database restart
--------------------------------------------

        <ping>true</ping>
              <ping-interval>10s</ping-interval>
              <ping-table>csd.pvltp_rcpt_acct</ping-table>

--------------------------------------------

see attached log file for the complete context.
see support thread: [1012535] 4.0.7 Pool issues

 resin.log [^] (118,170 bytes) 09-29-10 09:04

Notes
(0004769)
alex   
09-29-10 10:31   
<database>
          <jndi-name>jdbc/ITASDEV</jndi-name>
          <driver type="net.sourceforge.jtds.jdbc.Driver">
             <url>jdbc:jtds:sqlserver://128.231.74.198:1433/itasprod</url> [^]
               <user>......</user>
               <password>......</password>

           </driver>
               <prepared-statement-cache-size>25</prepared-statement-cache-size>
               <max-connections>350</max-connections>
               <max-idle-time>30s</max-idle-time>
               <max-active-time>1h</max-active-time>
               <max-pool-time>2h</max-pool-time>
               <ping>true</ping>
               <ping-interval>10s</ping-interval>
               <ping-table>csd.pvltp_rcpt_acct</ping-table>
               <connection-wait-time>5m</connection-wait-time>
               <max-overflow-connections>100</max-overflow-connections>
         </database>
(0004926)
ferg   
01-13-11 13:25   
env/118a