Java connection to Sql server with jtds error

Question

I use this code to make a connection with Sql server and i get that error when i use Class.forName(driver) it connect correctly but i prefer to use DataSourse.

static final BasicDataSource dataSource = new BasicDataSource();


static {
    dataSource.setDriverClassName("net.sourceforge.jtds.jdbc.Driver");
    dataSource.setUrl("jdbc:jtds:sqlserver://Mypc/Mydb;instance=SQLEXPRESS;");
    dataSource.setUsername("");
    dataSource.setPassword("");


}

public static void main(String[] args){
     try{
dataSource.getConnection();
}
     catch (SQLException ex){
        System.out.println(ex);
    }}


public static Connection getConnection() throws SQLException {
    return dataSource.getConnection();
}

and i get this

 Exception in thread "main" java.lang.AbstractMethodError
at net.sourceforge.jtds.jdbc.JtdsConnection.isValid(JtdsConnection.java:2833)
at org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:918)
at org.apache.commons.dbcp2.PoolableConnection.validate(PoolableConnection.java:283)
at org.apache.commons.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:357)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2307)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)

Try setting a validation query : dataSource.setValidationQuery("SELECT 1") — Arnaud
– Arnaud, Commented Apr 20, 2017 at 9:20
Possible duplicate of AbstractMethodError with jTDS JDBC Driver on Tomcat 8 — Arnaud
– Arnaud, Commented Apr 20, 2017 at 9:21

Youcef LAIDANI · Accepted Answer · 2017-04-20 09:23:06Z

12

You have to add validationQuery="select 1" to your dataSource

dataSource.setValidationQuery("select 1");

edited Apr 20, 2017 at 9:23

Youcef LAIDANI

60.3k21 gold badges111 silver badges178 bronze badges

answered Apr 20, 2017 at 9:19

AMB

1,0351 gold badge14 silver badges27 bronze badges

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

1 Comment

tutiplain Over a year ago

Awesome, it works, but an explanation as to why it's needed would be nice.

Collectives™ on Stack Overflow

Java connection to Sql server with jtds error

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related