Improve company productivity with a Business Account.Sign Up

x
?
Solved

SOLR Index

Posted on 2015-01-16
5
Medium Priority
?
268 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 62

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 62

Expert Comment

by:gheist
ID: 40562102
0
 
LVL 54

Accepted Solution

by:
Vitor Montalvão earned 2000 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 62

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

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
This video teaches viewers about errors in exception handling.
Viewers will learn how the fundamental information of how to create a table.

606 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