Duke快速重复数据删除：java.lang.UnsupportedOperationException：操作尚不支持？ [英] Duke Fast Deduplication: java.lang.UnsupportedOperationException: Operation not yet supported?

问题描述

我正在尝试使用 Duke快速重复数据删除引擎来搜索一些重复的记录在我工作的公司的数据库中。

I'm trying to use the Duke Fast Deduplication Engine to search for some duplicate records in the database at the company where I work.

我从命令行运行它，如下所示：

I run it from the command line like this:

java -cp "C:\utils\duke-0.6\duke-0.6.jar;C:\utils\duke-0.6\lucene-core-3.6.1.jar" no.priv.garshol.duke.Duke --showmatches --verbose .\config.xml

但是我收到一个错误：

Exception in thread "main" java.lang.UnsupportedOperationException: Operation no
t yet supported
        at sun.jdbc.odbc.JdbcOdbcResultSet.isClosed(Unknown Source)
        at no.priv.garshol.duke.datasources.JDBCDataSource$JDBCIterator.close(JD
BCDataSource.java:115)
        at no.priv.garshol.duke.Processor.deduplicate(Processor.java:152)
        at no.priv.garshol.duke.Duke.main_(Duke.java:135)
        at no.priv.garshol.duke.Duke.main(Duke.java:38)

我的配置文件看起来像这个：

My configuration file looks like this:

<duke>
   <schema>
         <threshold>0.82</threshold>
         <maybe-threshold>0.80</maybe-threshold>
         <path>test</path>

         <property type="id">
              <name>ID</name>
         </property>

         <property>
             <name>LNAME</name>
             <comparator>no.priv.garshol.duke.comparators.ExactComparator</comparator>
             <low>0.6</low>
             <high>0.8</high>
         </property>

         <property>
             <name>FNAME</name>
             <comparator>no.priv.garshol.duke.comparators.ExactComparator</comparator>
             <low>0.6</low>
             <high>0.8</high>
         </property>

         <property>
             <name>MNAME</name>
             <comparator>no.priv.garshol.duke.comparators.ExactComparator</comparator>
             <low>0.3</low>
             <high>0.5</high>
         </property>

         <property>
             <name>SSN</name>
             <comparator>no.priv.garshol.duke.comparators.ExactComparator</comparator>
             <low>0.0</low>
             <high>1.0</high>
         </property>

   </schema>
   <jdbc>
          <param name="driver-class" value="sun.jdbc.odbc.JdbcOdbcDriver" />
          <param name="connection-string" value="jdbc:odbc:VT_DeDupe" />
          <param name="user-name" value="aleer" />
          <param name="password" value="**" />
          <param name="query" value="select SocialSecurityNumber, LastName, FirstName, MiddleName, empssn from T_Employees" />

          <column name="SocialSecurityNumber" property="ID" />
          <column name="LastName" property="LNAME" />
          <column name="FirstName" property="FNAME" />
          <column name="MiddleName" property="MNAME" />
          <column name="empssn" property="SSN" />
   </jdbc>
</duke>

它并没有真正告诉我什么是不受支持的......我只是尝试一下，配置还没什么大不了的。

It doesn't really tell me what is unsupported...I'm just trying it out, nothing serious with the configuration yet.

推荐答案

正如mbonaci所说，问题是JDBC驱动程序的isClosed（）方法没有实现。即使实现它也不会简单地写返回已关闭。

As mbonaci says, the problem is that the JDBC driver's isClosed() method is not implemented. This even though implementing it would be no harder than simply writing "return closed".

我现在为此问题添加了一个丑陋的解决方法。请做一个hg pull再试一次。

I added an ugly workaround for this issue now. Please do an "hg pull" and try again.

这篇关于Duke快速重复数据删除：java.lang.UnsupportedOperationException：操作尚不支持？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！