Hmm. I bet your location query is all wrong.
Take this:
query="select themeid from location_themes where locationid='${location.ID}'"
I'm pretty sure that locationid is not a string (since it's extracted as an int
below), which means your SQL query will be trying to match an int against a
string.
Take the single quotes out, thus:
query="select themeid from location_themes where locationid=${location.ID}"
...and it should work.
Either way, you should test it in SQL Server Management Studio.
-----Original Message-----
From: PeterKerk [mailto:vettepa...@hotmail.com]
Sent: Tuesday, August 03, 2010 12:16 PM
To: solr-user@lucene.apache.org
Subject: RE: Indexing data on MSSQL failed: Caused by:
org.apache.solr.common.SolrException: Error loading class 'com.micros
oft.sqlserver.jdbc.SQLServerDriver'
I had a look at this URL:
http://localhost:8983/solr/db/admin/dataimport.jsp?handler=/dataimport
There I see the data-config.xml on the left side and the full data import
result on the right.
The response is:
<response>
−
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">234</int>
</lst>
−
<lst name="initArgs">
−
<lst name="defaults">
<str name="config">wedding-data-config.xml</str>
</lst>
</lst>
<str name="command">full-import</str>
<str name="mode">debug</str>
−
<arr name="documents">
−
<lst>
−
<arr name="id">
<int>1</int>
</arr>
−
<arr name="title">
<str>Gemeentehuis Nijmegen</str>
</arr>
</lst>
−
<lst>
−
<arr name="id">
<int>2</int>
</arr>
−
<arr name="title">
<str>Gemeentehuis Utrecht</str>
</arr>
</lst>
−
<lst>
−
<arr name="id">
<int>3</int>
</arr>
−
<arr name="title">
<str>Beachclub Vroeger</str>
</arr>
</lst>
</arr>
<lst name="verbose-output"/>
<str name="status">idle</str>
<str name="importResponse">Configuration Re-loaded sucessfully</str> − <lst
name="statusMessages"> <str name="Total Requests made to DataSource">7</str>
<str name="Total Rows Fetched">3</str> <str name="Total Documents
Skipped">0</str> <str name="Full Dump Started">2010-08-03 18:13:15</str> − <str
name=""> Indexing completed. Added/Updated: 3 documents. Deleted 0 documents.
</str>
<str name="Total Documents Processed">3</str> <str name="Time taken
">0:0:0.219</str> </lst> − <str name="WARNING"> This response format is
experimental. It is likely to change in the future.
</str>
</response>
So there again, I dont see the themes or features back.
Anything I can check here for you?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Indexing-data-on-MSSQL-failed-Caused-by-org-apache-solr-common-SolrException-Error-loading-class-com-tp1015137p1019666.html
Sent from the Solr - User mailing list archive at Nabble.com.
