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 35200] New: - Tomcat connection pooling fault with MySql derived tables
Date Fri, 03 Jun 2005 09:17:41 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=35200>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=35200

           Summary: Tomcat connection pooling fault with MySql derived
                    tables
           Product: Tomcat 5
           Version: 5.5.7
          Platform: Other
        OS/Version: Windows 2000
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: Unknown
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: jcoleman@sopragroup.com


When using Tomcats connection pooling a query using derived tables seems to 
loop infinately with a jumble of the first records of result set. When same 
query run stand-alone using JDBC, works fine.

eg:

SELECT a.col1, b.col2
       FROM table1 a, (SELECT col1 FROM table2) b
       WHERE a.col1=b.col1;


servlet.xml

    <Resource
      name="jdbc/local"
      type="javax.sql.DataSource"
      password="password"
      driverClassName="org.gjt.mm.mysql.Driver"
      maxIdle="10"
      maxWait="15000"
      validationQuery="select count(*) from usermaster"
      username="username"
      url="jdbc:mysql://localhost:3306/dbname?autoReconnect=true"
      maxActive="100"/>

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

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


Mime
View raw message