manifoldcf-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karl Wright (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CONNECTORS-1281) Bug for crawling documents from Microsoft SQL database
Date Wed, 24 Feb 2016 18:50:18 GMT

    [ https://issues.apache.org/jira/browse/CONNECTORS-1281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15163504#comment-15163504
] 

Karl Wright commented on CONNECTORS-1281:
-----------------------------------------

Hi [~olivierfl],

Thanks for reporting this problem.
The call to isValid() was added in r1695839 to help detect stale connections.  Unfortunately,
some JDBC drivers did not implement this method but instead throw exceptions of some kind.
 We can work around the problem by simply catching the exception and treating it as if the
answer to the isValid() question is unknown.

I'll attach a patch shortly.


> Bug for crawling documents from Microsoft SQL database 
> -------------------------------------------------------
>
>                 Key: CONNECTORS-1281
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-1281
>             Project: ManifoldCF
>          Issue Type: Bug
>          Components: JDBC connector
>    Affects Versions: ManifoldCF 2.2, ManifoldCF 2.3
>            Reporter: Olivier Tavard
>            Assignee: Karl Wright
>             Fix For: ManifoldCF 2.4
>
>
> 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 :
> {code:xml}
> 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)
> {code}
> 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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message