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