tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 44904] New: Provide warning message when DataSource' s maxActive="0"
Date Tue, 29 Apr 2008 19:01:26 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=44904

           Summary: Provide warning message when DataSource's maxActive="0"
           Product: Tomcat 5
           Version: 5.5.26
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: Unknown
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: belingueres@yahoo.com.ar


Hi,

While I was trying to set up a Tomcat 5.5.26, using an old configuration from a
Tomcat 5.5.9, I did copy & paste of a datasource with the following form:

    <Resource
      name="jdbc/MySQLDS"
      type="javax.sql.DataSource"
      password="password"
      driverClassName="com.mysql.jdbc.Driver"
      maxIdle="8"
      maxWait="5000"
      validationQuery=""
      username="username"
     
url="jdbc:mysql://localhost:3306/mydatabase?zeroDateTimeBehavior=convertToNull"
      maxActive="0" />

This works under 5.5.9, but it doesn't work on 5.5.26. Both databases are the
same (MySQL 5.0.x) and equal JDBC driver (MySQL 5.0.3)

Changing the maxActive attribute to some positive or negative value it will
start working.

The maxActive="0" will refuse to get a connection from the database and will
throw an exception because of the exhausted timeout period. 

This is clear to me now after being researching the issue, but it would be nice
to add at least a WARNING in a log file when detected that maxActive="0".

(Don't know if this enhacement belongs to Tomcat or DBCP, though.)

Regards,
Gabriel


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org


Mime
View raw message