lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rameshgalla <ramesh.ga...@cognizant.com>
Subject sql server indexing using dih problem
Date Mon, 31 Aug 2009 09:55:10 GMT

Hi,

I am trying to index sql server table using dih.

my data-config.xml file configuration:

<dataConfig> 
<dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
type="JdbcDataSource"
url="jdbc:sqlserver://10.232.6.38:1433;databaseName=Rames" user="sa"
password="password-1" /> 
<document name="customers"> 
<entity name="customers" query="select
CustomerID,Title,Forename,Surname,Address_1,Address_2,Town,Postcode from
customers"> 
<field column="CustomerID" name="CustomerID"/>
<field column="Title" name="Title"/>
<field column="Forename" name="Forename"/>
<field column="Surname" name="Surname"/>
<field column="Address_1" name="Address_1"/>
<field column="Address_2" name="Address_2"/>
<field column="Town" name="Town"/>
<field column="Postcode" name="Postcode"/> 
</entity> 
</document> 
</dataConfig>

When i have tried to debug i got the following error:

<?xml version="1.0" encoding="UTF-8" ?> 
- <response>
- <lst name="responseHeader">
  <int name="status">0</int> 
  <int name="QTime">29672</int> 
  </lst>
- <lst name="initArgs">
- <lst name="defaults">
  <str name="config">db-data-config.xml</str> 
  </lst>
  </lst>
  <str name="command">full-import</str> 
  <str name="mode">debug</str> 
  <null name="documents" /> 
- <lst name="verbose-output">
- <lst name="entity:customers">
- <lst name="document#1">
  <str name="query">select
CustomerID,Title,Forename,Surname,Address_1,Address_2,Town,Postcode from
customers</str> 
  <str
name="EXCEPTION">org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query: select
CustomerID,Title,Forename,Surname,Address_1,Address_2,Town,Postcode from
customers Processing Document # 1 at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:186)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:143)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:43)
at
org.apache.solr.handler.dataimport.DebugLogger$2.getData(DebugLogger.java:183)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:74)
at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:285)
at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:178)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:136)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:334)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:386)
at
org.apache.solr.handler.dataimport.DataImportHandler.handleRequestBody(DataImportHandler.java:190)
at
org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:131)
at org.apache.solr.core.SolrCore.execute(SolrCore.java:1204) at
org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:303)
at
org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:232)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1089)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:365)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:285) at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502) at
org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:821)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:513) at
org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:208) at
org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:378) at
org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:226)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP
connection to the host 10.232.6.38, port 1433 has failed. Error: "Connection
refused: connect. Verify the connection properties, check that an instance
of SQL Server is running on the host and accepting TCP/IP connections at the
port, and that no firewall is blocking TCP connections to the port.". at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1049)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
at
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:133)
at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:119)
at
org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:298)
at
org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:43)
at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:173)
... 32 more</str> 
  <str name="time-taken">0:0:29.641</str> 
  </lst>
  </lst>
  </lst>
  <str name="status">idle</str> 
  <str name="importResponse">Configuration Re-loaded sucessfully</str> 
- <lst name="statusMessages">
  <str name="Time Elapsed">0:0:29.641</str> 
  <str name="Total Requests made to DataSource">1</str> 
  <str name="Total Rows Fetched">0</str> 
  <str name="Total Documents Processed">0</str> 
  <str name="Total Documents Skipped">0</str> 
  <str name="Full Dump Started">2009-08-31 15:21:22</str> 
  </lst>
  <str name="WARNING">This response format is experimental. It is likely to
change in the future.</str> 
  </response>


Please let me know what might be the reason?
-- 
View this message in context: http://www.nabble.com/sql-server-indexing-using-dih-problem-tp25220884p25220884.html
Sent from the Solr - User mailing list archive at Nabble.com.


Mime
View raw message