Uploaded image for project: 'ManifoldCF'
  1. ManifoldCF
  2. CONNECTORS-1281

Bug for crawling documents from Microsoft SQL database

    Details

    • 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
    • Labels:
      None

      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

        Attachments

          Activity

            People

            • Assignee:
              kwright@metacarta.com Karl Wright
              Reporter:
              olivierfl Olivier Tavard
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: