How to index data from a database using apache solr with glassfish server on linux?

Question

I want to create a search box in my web application using Apachene Lucene and Apache Solr. I am using a postgres database and should do this using java.

Since I am new to these concepts (solr, lucene), I struggle with this. I already installed and configured apache solr with glassfish.Now, I don’t know how to start from this, should I create a java project in eclipse or do I need to use gur solr admin.

can anyone help me with this?

Thanks in Advance .....

Answer 1

To do a data search, you must first index your data. You can use one of the following methods to index data.

• Using Solr clients such as Solrj
• If you store your data in a relational database, you can use DataImportHandler
• Publish XML or Json Messages. Check the documentation here .

When adding new data, you can index it using Solr clients (Solrj). You can also search your data using Solrj or any other client libraries.

Here you can find other client libraries .

Answer 2

You can start with Solr DIH to index data from postgres to Solr.

For a more detailed understanding, you can refer to: -
how-to-import-data-from-sql-databases-part-1
how-to-import-data-from-sql-databases-part-2
how-to-import-data-from-sql-databases-part-3