Hi Michael, Thanks, I now use that. But the same error.
(PS. is there a way where I can test the current connectionstring?) Therefore I have attached 1 image with 2 screenshots of my situation. http://lucene.472066.n3.nabble.com/file/n1017327/Untitled.png Untitled.png Here's my current data-config: <dataConfig> <dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost\SQLEXPRESS\Databases\wedding:1433" user="sa" password="123456" /> <document name="weddinglocations"> <entity name="location" dataSource="ds1" query="select * from locations"> <field column="ID" name="id" /> <field column="TITLE" name="title" /> <field column="CITY" name="city" /> <entity name="location_feature" query="select FEATUREID from location_features where locationid='${location.ID}'"> <entity name="feature" query="select title from features where id = '${location_feature.FEATUREID}'"> <field name="features" column="title" /> </entity> </entity> <entity name="location_theme" query="select CATEGORYID from location_themes where locationid='${location.ID}'"> <entity name="theme" query="select title from features where id = '${location_theme.FEATUREID}'"> <field name="cat" column="title" /> </entity> </entity> </entity> </document> </dataConfig> And here's the current output in cygwin: INFO: Creating a connection for entity location with URL: jdbc:sqlserver://local host\SQLEXPRESS\Databases\wedding:1433 Aug 2, 2010 11:29:25 PM org.apache.solr.handler.dataimport.DocBuilder buildDocum ent SEVERE: Exception while processing: location document : SolrInputDocument[{}] org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select * from locations Processing Document # 1 at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAnd Throw(DataImportHandlerException.java:72) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< init>(JdbcDataSource.java:253) at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSou rce.java:210) at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSou rce.java:39) at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEn tityProcessor.java:58) at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEnti tyProcessor.java:71) at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(Ent ityProcessorWrapper.java:237) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde r.java:357) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.j ava:242) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java :180) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImpo rter.java:331) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.j ava:389) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.ja va:370) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for use r 'sa'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246 ) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerC onnection.java:2529) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConne ction.java:1905) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServer Connection.java:41) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecu te(SQLServerConnection.java:1893) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLSer verConnection.java:1045) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConne ction.java:817) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerCon nection.java:700) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver. java:842) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSour ce.java:162) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSour ce.java:128) at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcD ataSource.java:363) at org.apache.solr.handler.dataimport.JdbcDataSource.access$300(JdbcData Source.java:39) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< init>(JdbcDataSource.java:240) ... 11 more Aug 2, 2010 11:29:25 PM org.apache.solr.handler.dataimport.DataImporter doFullIm port SEVERE: Full Import failed org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query: select * from locations Processing Document # 1 at org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAnd Throw(DataImportHandlerException.java:72) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< init>(JdbcDataSource.java:253) at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSou rce.java:210) at org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSou rce.java:39) at org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEn tityProcessor.java:58) at org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEnti tyProcessor.java:71) at org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(Ent ityProcessorWrapper.java:237) at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilde r.java:357) at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.j ava:242) at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java :180) at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImpo rter.java:331) at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.j ava:389) at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.ja va:370) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for use r 'sa'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246 ) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerC onnection.java:2529) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConne ction.java:1905) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServer Connection.java:41) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecu te(SQLServerConnection.java:1893) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1400) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLSer verConnection.java:1045) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConne ction.java:817) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerCon nection.java:700) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver. java:842) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSour ce.java:162) at org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSour ce.java:128) at org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcD ataSource.java:363) at org.apache.solr.handler.dataimport.JdbcDataSource.access$300(JdbcData Source.java:39) at org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.< init>(JdbcDataSource.java:240) ... 11 more Aug 2, 2010 11:29:25 PM org.apache.solr.update.DirectUpdateHandler2 rollback INFO: start rollback Aug 2, 2010 11:29:25 PM org.apache.solr.update.DirectUpdateHandler2 rollback INFO: end_rollback -- 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-tp1015137p1017327.html Sent from the Solr - User mailing list archive at Nabble.com.
