Geek Answers Handbook

Solr DataImportHandler registers in SQL but never retrieves data

Hi, I copied the Solr configuration from the working Windows server to a new one and could not start the import.

They both use win server 2008 and SQL 2008R2. This is the data import configuration:

<dataConfig>  
  <dataSource type="JdbcDataSource"  name="ds1"
        driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"  
        url="jdbc:sqlserver://localhost;databaseName=DB"   
        user="Solr"  
        password="pwd"/>  
  <document name="datas">  
    <entity name="data" dataSource="ds1" pk="key"
    query="EXEC SOLR_COMPANY_SEARCH_DATA"
    deltaImportQuery="SELECT * FROM Company_Search_Data WHERE [key]='${dataimporter.delta.key}'"
    deltaQuery="SELECT [key] FROM Company_Search_Data WHERE modify_dt > '${dataimporter.last_index_time}'">  
          <field column="WorkDesc_Comments" name="WorkDesc_Comments_Split" />
          <field column="WorkDesc_Comments" name="WorkDesc_Comments_Edge" />
    </entity>  
  </document>  
</dataConfig>

I can use MS SQL Profiler to view the Solr user log successfully, but then nothing. It doesn't seem to even try to execute the stored procedure. Any ideas why this will work on one server and not on another?

FTR is the only thing in the tomcat directory log:

org.apache.solr.handler.dataimport.JdbcDataSource$1 call
INFO: Creating a connection for entity data with URL: jdbc:sqlserver://localhost;databaseName=CATLive

UPDATE: Me Yavar Husain Solr Mailing MS JDBC - , , , , Java, DIH MS JDBC.

2: Java 1.6.0_29, ! http://blogs.msdn.com/b/jdbcteam/archive/2011/11/07/supported-java-versions-november-2011.aspx

+5
5

, JDBC , , jTDS Open Source JDBC driver. , :

<dataConfig>
  <dataSource type="JdbcDataSource" 
              driver="net.sourceforge.jtds.jdbc.Driver"
              url="jdbc:jtds:sqlserver://localhost;databaseName=DBName" 
              user="Solr" 
              password="password" name="ds1"/>
  <document>
    <entity dataSource="ds1" name="sometext" 
            query="SELECT * FROM mytable">
    </entity>
  </document>
</dataConfig>

HTH - - , , MS...

+2

,

URL = "JDBC: MySQL:///_"

dbname → \SQL2008

0

, Solr , . , , Solr . , , .

?

0

java- . , Java runtime JDBC Microsoft SQL Server, Solr.

, 3 . , . Solr 3.4.0 SQL Server JDBC 3.0. JRE 1.6.0_20, , 1.6.0_20 ( RPM, yum CentOS).

java , .

,

:
http://pkgs.org/centos-5-rhel-5/centos-rhel-x86_64/java-1.6.0-openjdk-1.6.0.0-1.22.1.9.8.el5_6.x86_64.rpm.html

non-working:
http://pkgs.org/centos-5-rhel-5/centos-rhel-updates-x86_64/java-1.6.0-openjdk-src-1.6.0.0-1.23.1.9.10.el5_7.x86_64. rpm.html

0
source

More articles:


All Articles