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: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to