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