Java Exception java.lang.AbstractMethodError

Question

How can I solve this exception:

Exception in thread "main" java.lang.AbstractMethodError: com.mysql.jdbc.Connection.isValid(I)Z
    at org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914)
...

I read that this error is something about libraries/ jdk but I can't find a good way to solve it. I need some help from you. Thank you!

You're using an incorrect JDBC driver version. Try upgrading to the latest jar — Reimeus
– Reimeus, Commented Mar 1, 2015 at 20:52

Brett Okken · Accepted Answer · 2015-03-01 20:53:46Z

3

This means that your mysql jdbc driver does not implement the jdbc methods added in jre 6, such as isValid.

answered Mar 1, 2015 at 20:53

Brett Okken

6,3261 gold badge21 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mhvelplund · Accepted Answer · 2017-06-05 13:40:27Z

2

If you provide a validation query, you can avoid upgrading your driver.

answered Jun 5, 2017 at 13:40

mhvelplund

2,3803 gold badges24 silver badges44 bronze badges

Comments

Homayoun · Accepted Answer · 2016-06-12 23:58:11Z

0

I upgraded the JDBC driver jar file to mysql-connector-java-6.0.2 and resolved this prolem.

answered Jun 12, 2016 at 23:58

Homayoun

215 bronze badges

Comments

Pixelstix · Accepted Answer · 2023-11-10 22:34:57Z

0

Combining multiple answers and expanding on the information so all the information is in one place ...

As @BrettOkken mentions, JDK 1.6 added the isValid method on Connection, so your best bet is to find a newer version of the driver.

To expand on the answer from @mhvelplund ...

You can avoid upgrading your JDBC driver if you convince Tomcat's dbcp2 to not call the isValid method. You can do this by specifying validationQuery (and maybe validationQueryTimeout and maxConnLifetimeMillis as well) in your Resource definition in your context.xml file (which gets put into Tomcat's /conf/Catalina/localhost/{myappname}.xml).

<Resource name="jdbc/ajx"
    auth="Container" type="javax.sql.DataSource"
    maxTotal="25" maxIdle="30" maxWaitMillis="10000"
    maxConnLifetimeMillis="300000"
    validationQuery="SELECT CURRENT_TIME()"
    validationQueryTimeout="1"
    driverClassName="{...}"
    url="jdbc:{...}"/>

edited Nov 10, 2023 at 22:34

answered Nov 10, 2023 at 21:08

Pixelstix

8107 silver badges23 bronze badges

2 Comments

user85421 Over a year ago

after 8 years, for sure a newer version of the driver is the better solution

Pixelstix Over a year ago

True. However, sometimes you come across an old code base that has not been touched in years and you have to resurrect it, and can't update all of the dependencies at once. e.g. I arrived here due to having to talk to an old version of a database, and the newer JDBC drivers recommend not talking to the old version of the database.

Collectives™ on Stack Overflow

Java Exception java.lang.AbstractMethodError

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related