Project

General

Profile

« Previous | Next » 

Revision 9a1e9d18

Added by Andreas Kohlbecker almost 9 years ago

trying to avoid excessive connection testing and to quickly reduce the number of connections in the pools

View differences:

src/main/resources/c3p0.properties
10 10 
#			number of seconds
11 11 
# c3p0.idleConnectionTestPeriod = 60
12 12 

  		




  13
  
  
    
c3p0.testConnectionOnCheckout = true


  		




  
  13
  
    
# For some applications, high performance is more important than the risk of an 


  		




  
  14
  
    
# occasional database exception. In its default configuration, c3p0 does no 


  		




  
  15
  
    
# Connection testing at all. Setting a fairly long idleConnectionTestPeriod, and 


  		




  
  16
  
    
#  not testing on checkout and check-in at all is an excellent, high-performance 


  		




  
  17
  
    
# approach. 


  		




  
  18
  
    
#


  		




  
  19
  
    

  		




  
  20
  
    
c3p0.idleConnectionTestPeriod = 120


  		




  
  21
  
    
c3p0.testConnectionOnCheckout = false


  		




  
  22
  
    
c3p0.testConnectionOnCheckin = true


  		




  
  23
  
    
c3p0.maxConnectionAge = 600


  		




  
  24
  
    
c3p0.maxIdleTime = 300


  		




  
  25
  
    
c3p0.maxIdleTimeExcessConnections = 200


  		




  
  26
  
    
c3p0.minPoolSize = 2


  		




  14
  27
  
    

  		




  15
  28
  
    
## automatichoweverTestTable: 


  		




  16
  29
  
    
#			If provided, c3p0 will create an


  		












Also available in:  Unified diff