Sunday 27 August 2017

java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z

Error -

java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z

at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:924)
at org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:282)
at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:359)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2316)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2299)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2043)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543)

Solution - 

For tomcat - in context.xml update resource tag value -> validationQuery="select 1"

<Resource ...............  validationQuery="select 1" />


Link -> https://stackoverflow.com/questions/41231750/abstractmethoderror-with-jtds-jdbc-driver-on-tomcat-8