lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From PeterKerk <vettepa...@hotmail.com>
Subject Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'
Date Mon, 02 Aug 2010 21:33:57 GMT

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.

Mime
View raw message