tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From EmCpam <emmanuel.lallem...@laposte.net>
Subject Tomcat 6 / Mysql with connection Pool Error isValid Method
Date Thu, 25 Nov 2010 15:50:42 GMT

Hello, 

I've a problem when i use the  isValid method of Connection class with a
connection pool.
The java exception is:

javax.servlet.ServletException:
com.sun.jersey.api.container.ContainerException:
java.lang.AbstractMethodError:
org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.isValid(I)Z

com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:346)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.cnamts.securite.filtres.FiltreSecurite.doFilter(FiltreSecurite.java:133)
	org.cnamts.securite.filtres.FiltreCommun.doFilter(FiltreCommun.java:128)
        ....

I'm using tomcat 6.0.29 with java jdk 1.6 and netbeans 6.9. My jdbc
connector jar is mysql-connector-java-5.1.13-bin.jar, placed in tomcat lib
path.

The declaration of my ressource in web.xml is:
<resource-ref>
            <description>DB Connection</description>
            <res-ref-name>jdbc/connData</res-ref-name>
            <res-type>javax.sql.DataSource</res-type>
            <res-auth>Container</res-auth>
    </resource-ref>
in my context.xml file:
<Context path="/QualifluxWeb" antiJARLocking="true">
    <Resource name="jdbc/connData" auth="Container" 
type="javax.sql.DataSource"
               maxActive="10" maxIdle="3" maxWait="10000"
               username="root" password=""
driverClassName="com.mysql.jdbc.Driver"
               url="jdbc:mysql://localhost:3306/test"
               validationQuery="select 1" />
</Context>

Others methods for retrieve or update data works well. I've only a problem
with isValid.
What is wrong, or is there any other solution for checking my connection ?

Thanks a lot for your help.

Emmanuel
-- 
View this message in context: http://old.nabble.com/Tomcat-6---Mysql-with-connection-Pool--Error-isValid-Method-tp30306398p30306398.html
Sent from the Tomcat - Dev mailing list archive at Nabble.com.


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


Mime
View raw message