Dear Baskar, It seems that you are trying to jump into the middle, and have a complete understanding of everything before trying things. This makes things difficult both for yourself, and for people trying to help you. Solr can be a little complex for beginners, so it is best to approach things a step at a time.
I would suggest: * Learn how to index from a single database table into Solr. The Wiki links that I referred you to should help. It might be easiest to get started with the DataImportHandler using the configuration in example/example-DIH/solr/db/ in the Solr source code. * Familiarise yourself with how queries work in Solr, in particular how to use the default search field, and specific fields. * Set up SolrJ to index the same table as with DIH * Move on to multiple, possibly related tables only once you understand the above. Regards, Gora