Just checking - Did you verify the data was being extracted with the DIH UI?
http://localhost:8983/solr/admin/dataimport.jsp -----Original Message----- From: PeterKerk [mailto:vettepa...@hotmail.com] Sent: Tuesday, August 03, 2010 11:28 AM 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' Ok, that works... But it only confirms that the extra data to be indexed I have defined in my data-config does not seem to be indexed. What can I do to debug this? Because nothing special is logged in my cygwin window! I have even simplified the data-config further to this: <dataConfig> <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost:1433;databaseName=wedding" user="sa" password="123456" /> <document name="weddinglocations"> <entity name="location" query="select * from locations"> <field column="ID" name="id" /> <field column="TITLE" name="title" /> <field column="CITY" name="city" /> <entity name="location_theme" query="select themeid from location_themes where locationid='${location.ID}'"> <entity name="theme" query="select title from themes where id = '${location_theme.themeid}'"> <field name="cat" column="title" /> </entity> </entity> </entity> </document> </dataConfig> I have attached a screenshot of my datamodel for this part. http://lucene.472066.n3.nabble.com/file/n1019514/DBmodel.png DBmodel.png More help is greatly appreciated! :) -- 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-tp1015137p1019514.html Sent from the Solr - User mailing list archive at Nabble.com.
