Index generation using SOLR 4.2 configurations

[aniljayanti <an...@yahoo.co.in>]

Hi,

Presently i am generating employee details index using solr 3.3 &
apache-tomcat-7.0.19 setup. Now i want to try this with solr 4.2 new
version. created new setup for this.

d:\apache-tomcat-7.0.19\solr_4_2\collection1\

in this below directories are there.

1) bin
2) conf >>
   solrconfig.xml,schema.xml,data-config.xml,scripts.conf & zoo.cfg files
are there.
3) lib  >>
    hsqldb-1.8.0.10.jar ,
solr-4.2.0.war,solr-dataimporthandler-4.2.0.jar,solr-dataimporthandler-extras-4.2.0.jar
files are there.

in data-config.xml below tags are there.

<dataConfig>
    <dataSource driver="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb://127.0.0.1;databaseName=EMP" user="sa" password="pass"/>
    <document  name="EMPLOYEE">
       <entity name="COMMON" query="select type,title,name,empid from
employee" >  
       <field column="type" name="type"/>  
       <field column="title" name="title"/>  
       <field column="name" name="name"/>  
       <field column="empid" name="empid"/>  
      </entity> 
    </document>
</dataConfig>

when im using dataimport command
http://localhost:8080/solr_4_2/dataimport?command=full-import getting index
failed. below are the errors.

SEVERE: Exception while processing: EMPLOYEE document :
SolrInputDocument[]:org.apache.solr.handler.dataimport.DataImportHandlerException:
Unable to execute query: select type,title,name,empid from employee
Processing Document # 1
	at
org.apache.solr.handler.dataimport.DataImportHandlerException.wrapAndThrow(DataImportHandlerException.java:71)
	at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:253)
	at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:210)
	at
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:38)
	at
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
	at
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
	at
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
	at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:465)
	at
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:404)
	at
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:319)
	at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:227)
	at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:422)
	at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:487)
	at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:468)
Caused by: java.sql.SQLException: *File input/output error
//127.0.0.1.properties java.io.FileNotFoundException:
\\127.0.0.1.properties.new* (The filename, directory name, or volume label
syntax is incorrect)
	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
	at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
	at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
	at org.hsqldb.jdbcDriver.connect(Unknown Source)
	at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:161)
	at
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:127)
	at
org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:366)
	at
org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:38)
	at
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:240)
	... 12 more

Please help me in this... Thanks in Advance.

AnilJayanti




--
View this message in context: http://lucene.472066.n3.nabble.com/Index-generation-using-SOLR-4-2-configurations-tp4049618.html
Sent from the Solr - User mailing list archive at Nabble.com.