java - SQLException w/ Tomcat 7.0 JDBC connection pool and MySql -
i'm trying use new tomcat 7.0 jdbc connection pool , mysql. says here can drop latest tomcat-jdbc.jar tomcat/lib directory in tomcat 6.0 environment, , that's i've done. i'm using spring initialize , instantiate datasource per examples around web: <bean id="mydatasource" class="org.apache.tomcat.jdbc.pool.datasource" destroy-method="close" p:driverclassname="${driver_class}" p:url="${url}" p:username="${username?root}" p:password="${password}" p:initialsize="10" p:initsql="select dts dt_tm_ts read ur" p:minidle="10" p:maxidle="100" p:maxactive="100" p:maxwait="6000" p:jmxenabled="true" p:jdbcinterceptors="org.apache.tomcat.jdbc.pool.interceptor.connectionstate;org.apache.tomcat.jdbc.pool.interceptor.statementfinalizer" p:removeabandoned="true" p:removeabandonedtimeout="60" p:logabandoned=...