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.
