[CONNECTORS-1281] Bug for crawling documents from Microsoft SQL database

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: ManifoldCF 2.2, ManifoldCF 2.3
• Fix Version/s: ManifoldCF 2.4
• Component/s: JDBC connector
• Assignee: Karl Wright
• Reporter: Olivier Tavard
• Created: 24/Feb/16 18:26
• Updated: 24/Feb/16 22:39
• Resolved: 24/Feb/16 18:56

Description

Hi,

I have some issue to crawl documents from a Microsoft SQL database.
The jtds-1.2.4.jar is well present in my MCF installation (MCF built from sources and jtds.jar added in lib-proprietary from the ant script)
After crawling about 200 documents the job does not do anything and the following error is present for each document crawled :

FATAL 2016-02-24 18:27:47,078 (Startup thread) - Error tossed: null
java.lang.AbstractMethodError
        at net.sourceforge.jtds.jdbc.ConnectionJDBC2.isValid(ConnectionJDBC2.java:2589)
        at org.apache.manifoldcf.core.jdbcpool.ConnectionPool.getConnection(ConnectionPool.java:92)
        at org.apache.manifoldcf.jdbc.JDBCConnectionFactory.getConnection(JDBCConnectionFactory.java:132)
        at org.apache.manifoldcf.jdbc.JDBCConnection$PreparedStatementQueryThread.run(JDBCConnection.java:1389)

It seems that there is an issue with the validation of the connection between MCF and JTDS : http://stackoverflow.com/questions/26404283/java-hibernate-with-sql-server-2012-not-working
What is the best way to fix it ? Do we need to implement our own isValid() method and do a simple select into it ?

By the way, we do not have this issue with MCF 2.0.1.

Thanks