How to indexing data which is updating or adding into tables through java programming

Submitted by RamanjuluKalupuri on Wed, 2009-05-06 07:24.Troubleshooting

I am able to indexing table data from DBSight UI.
But whenever I added or updated data into tables I have to index it manually from DBSight UI to get into search results.

How can I index immdiatly the data which is midified or added into tables with out using DBSight UI.

Please let me know if there is any API to indexing.
Thanks in advance for the replies.


If I trigger the same URLs which they have provided for Incremental Indexing or Full Indexing from Browser It is asking some JavaScript Popup confirmations and Authentication to indexing.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Submitted by will on Wed, 2009-05-06 18:56.

Need to use the scheduler.

You can also use Java API to submit content, and it'll be searchable right away in memory index. DBSight will still use SQL to do the real indexing.

Submitted by RamanjuluKalupuri on Thu, 2009-06-11 09:31.

Hi Will ,

Thanks for the Information provided to Buffer Indexing.....

I am trying to send content to DBSight immediatly after saving into Database to make it searchable immediatly.

I am using the following code to send Http post Request

String link = "http://localhost:8080/dbsight/ Song to Indexing&WRITER=Composer&PUBLISHER=Publisher&CATALOG_ID=2&COUNTRY_ID=1";
try {
// Create a URL for the desired page
URL url = new URL(link);
// Read all the text returned by the server
BufferedReader in = new BufferedReader(new InputStreamReader(url.openStream()));
String str;
while ((str = in.readLine()) != null) {
} catch (MalformedURLException e) {
} catch (IOException e) {

It is throwing following error

Security Error during submit. Please check allowed IP address list includes

And I am trying to add this IP in advanced settings of my index
It is not saving while giving the IP and it is showing message me like

Your License Level does not allow [setting allowed IP addresses].

Please Help me on this how to allow Particular IP Address
(If i issue the same URL After login It is working fine and saving data in Buffer Indexing and I am able to search new content)

Submitted by will on Thu, 2009-06-11 13:25.

It's due to the fact that the free license doesn't include this feature.

Submitted by RamanjuluKalupuri on Thu, 2009-05-07 01:27.

Thanks for the info will,

If we want to use schedulers , we need to take paid version fo DBSight,we are using free version. But schedulers we can give once or twice in a day. My requiremet is whenever i added data into tables I should able to search.

I will try the second option through Java API.