Hii, I new to SOLR world... i am using solr multicore config in my webapp.... i am able to configure solr properly... but problem is when i am building using full data-import... if my databse table has few number of rows say 10 to 25 the index is created properly... and search query returns proper result.... but when i create index table for large table...index is not propery created.. and it does not return any result for search ... what's the problem... can any body help me out .....
my data-config file looks like this.. <dataSource type="JdbcDataSource" name="ds-1" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/retaildb?characterEncoding=UTF-8" user="kickuser" password="kickapps" /> <document name="countries"> <entity dataSource="ds-1" name="zonesToCountry" pk="countryId" query="select * from countries limit 10" deltaQuery="select * from countries limit 10" docRoot="true"> <field column="countries_id" name="id" /> <field column="countries_name" name="countries_name" /> <field column="countries_iso_code_2" name="countries_iso_code_2" /> <field column="countries_iso_code_3" name="countries_iso_code_3" /> <entity dataSource="ds-1" name="zones" pk="zone_id" query="select * from zones z where z.zone_country_id='${zonesToCountry.countries_id}'"> <field column="zone_code" name="zone_code" /> <field column="zone_name" name="zone_name" /> </entity> </entity> </document> -- Thanks and Regards Rahul G.Brid