> (PS. is there a way where I can test the current connectionstring?) There are many jdbc-explorer apps around that take a jdbc url. You should be able to test your jdbc url and driver with one of those.
On Mon, Aug 2, 2010 at 2:33 PM, PeterKerk <vettepa...@hotmail.com> wrote: > > 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. > -- Lance Norskog goks...@gmail.com
