sql server indexing using dih problem

2009-08-31 Thread rameshgalla 

Hi,

I am trying to index sql server table using dih.

my data-config.xml file configuration:

 
 
 
 







 
 
 


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

 
- 
- 
  0 
  29672 
  
- 
- 
  db-data-config.xml 
  
  
  full-import 
  debug 
   
- 
- 
- 
  select
CustomerID,Title,Forename,Surname,Address_1,Address_2,Town,Postcode from
customers 
  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.(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.(JdbcDataSource.java:173)
... 32 more 
  0:0:29.641 
  
  
  
  idle 
  Configuration Re-loaded sucessfully 
- 
  0:0:29.641 
  1 
  0 
  0 
  0 
  2009-08-31 15:21:22 
  
  This response format is experimental. It is likely to
change in the future. 
  


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.

schedule indexing with DataImportHandler

2008-09-15 Thread rameshgalla 

hi,

Is it possible to schedule indexing with solr DataImportHandler?

eg: I want to do delta import automatically everyday at 12AM like that.

or 

Is it possible to initiate delta import automatically whenever there is a
modification in
database?
-- 
View this message in context: 
http://www.nabble.com/schedule-indexing-with-DataImportHandler-tp19488273p19488273.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Question about solr spellcheck

2008-10-12 Thread rameshgalla 

Hi,

I don't know there is better solution for this one. But I resolved this
problem in my application like this.
After getting the spell suggestion I have performed the search operation
without displaying the results.
If the numdocs is greater than or equal to one only I have displayed the
spellcheck result. Otherwise don't display the spell check value.
-- 
View this message in context: 
http://www.nabble.com/Question-about-solr-spellcheck-tp19943116p19949041.html
Sent from the Solr - User mailing list archive at Nabble.com.

solr internationalization support

2008-11-24 Thread rameshgalla 

hi,

1)Which languages solr supports out-of-the box other than english?

2)What are the analyzers(stemmer,synonym,tokenizer etc) it provides for each
language?

3)Shall we create our own analyzers for any languages?(If possible explain
how?)

thanx in advance
-- 
View this message in context: 
http://www.nabble.com/solr-internationalization-support-tp20661848p20661848.html
Sent from the Solr - User mailing list archive at Nabble.com.