Solved

SOLR Index

Posted on 2015-01-16
5
193 Views
Last Modified: 2015-05-18
I am trying to configure SOLR on my machine for the first time. I am trying to index one of the tables from the sql server and keep on getting the following errors

1/16/2015, 1:29:06 PM
ERROR
DocBuilder
Exception while processing: PolicyIndex document : SolrInputDocument(fields: []):org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select ID,​Name from PolicyIndex Processing Document # 1
1/16/2015, 1:29:06 PM
ERROR
DataImporter
Full Import failed:java.lang.RuntimeException: java.lang.RuntimeException: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select ID,​Name from PolicyIndex Processing Document # 1

Inside the logs I see this error : Caused by: java.lang.NullPointerException

Here is the xml from my data-config file.

<dataConfig>
  <dataSource type="JdbcDataSource"
              driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
              url="jdbc:postgresql:\\servername\dbname;integratedsecurity=true;"

              />
                  
  <document>
    <entity name="PolicyIndex"  
      pk="ID"
      query="select ID,Name from PolicyIndex"
      >
       <field column="ID" name="ID"/>
       <field column="Name" name="Name"/>      
    </entity>
  </document>
</dataConfig>

I think i have the datasource tag wrong.

can someone please help.
0
Comment
Question by:pratikshahse
  • 3
5 Comments
 
LVL 61

Expert Comment

by:gheist
ID: 40556520
Apparently you need to understand jdbc connection strings.
It is absolutely unlikely microsoft jdbc driver understands postgresql connect string.
I suggest you use jTDS right away to avoid confusion and grief.
0
 

Author Comment

by:pratikshahse
ID: 40562091
no luck
0
 
LVL 61

Expert Comment

by:gheist
ID: 40562102
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40562249
Unable to execute query: select ID,​Name from PolicyIndex Processing Document # 1
(...)
url="jdbc:postgresql:\\servername\dbname;integratedsecurity=true;"

You are running with integrated security and you didn't define any database so means that the current user need to have as default database the same database where table PolicyIndex is.
0
 
LVL 61

Expert Comment

by:gheist
ID: 40562481
Lets start with basics.... PostgreSQL driver will not connect to SQL server... If it was sybase there was some hope...
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now