Re: Solr SQL Express Integrated Security - Unable to execute query

[Shawn Heisey]

On 1/23/2013 2:32 PM, O. Olson wrote:
Hi,
        I am using the /example-DIH in the Solr 4.0 download. The example worked
out of the box using the HSQLDB. I then attempted to modify the files to
connect to a SQL Express instance running on my local machine. A
http://localhost:8983/solr/db/dataimport?command=full-import results in

org.apache.solr.common.SolrException log
SEVERE: Full Import failed:java.lang.RuntimeException:
java.lang.RuntimeException:
org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to
execute query: SELECT [ProdID],[Descr] FROM [Amazon].[dbo].[Table_Temp]
Processing Document # 1
        at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:273) …

There will be a lot more detail to this error.  This detail may have a 
clue about what happened.  Can you include the entire stacktrace?

Thanks,
Shawn