Submitted by garyp on Mon, 2009-03-02 05:51.Troubleshooting

I'm seeing the following error in log after re-indexing

ERROR 2009-03-02 13:00:32,362- When reIndexing:java.lang.NoClassDefFoundError: com/google/common/collect/Multimap
ERROR 2009-03-02 13:00:32,363- ------
java.lang.NoClassDefFoundError: com/google/common/collect/Multimap
at net.javacoding.xsearch.ReIndexing.reIndexing(DBSight:110)
at net.javacoding.xsearch.ReIndexing.start(DBSight:54)
at net.javacoding.xsearch.IndexManager.start(DBSight:219)
at net.javacoding.xsearch.IndexManager.main(DBSight:96)

I'm using dbsight2, sun-java6-jre/jdk, tomcat5 packages from Debian.

Can you advise ??

Triggering a complete re-index

Submitted by dmoreitz on Mon, 2009-02-09 20:32.Troubleshooting

Hi there,

Is there any way I can trigger a complete re-index programmatically from another application?

I.e. is there a URL I can load?

The reason for the request is that we have a system where sometimes massive database updates occur via our custom written application. As soon as the data updates are completed we want the search indexes in DBSight to be automatically updated, rather than log in and manually update 8+ indexes.

Thanks in advance...

Dom :-)

How to write data source password in config files

Submitted by masm on Mon, 2009-02-09 09:39.Troubleshooting

Hi all,
I am writing the config files to feed dbsight using some scripts and meta data we have gathered. Every thing is going fine except for the database password. How should I encode the password in order to allow dbsight to understand it?

Licensing on temporary IP address

Submitted by JockMullin on Wed, 2009-02-04 11:32.Troubleshooting

We are ready to license DBSight, but notice the license is by IP address. Right now it is running on our testbed server, but will be moving to a production server once we are past the development/testing stage. The IP address will then change.
1. Can we migrate the license to a new IP address later or should we wait until moving before licensing?
2. We are using 1.6 now, but want to upgrade to 2.0 after putting the 1.6 version into production on the new server. Then we would upgrade the 1.6 on testbed to 2.0 to make sure everything works OK and then would upgrade the production server. Does this sound like a good plan and would it involve any additional licensing costs?
If you want to see how we are doing, check out the search on

Single vs Plural

Submitted by JockMullin on Wed, 2009-02-04 09:02.Troubleshooting

I am currently evaluating dbSight and have it working very well; quite impressed with the product. Still running version 1.6 but will upgrade soon.

However having a problem in that singlular and plural forms are not considered equivalent. For example, if I search for pan I get x results, but if I search for pans I get far fewer results.

Is there an easy way to make the singular and plural forms equivalent, or do I have to add them all to synonyms.txt (a major undertaking).

Many thanks,

Indexing takes long

Submitted by Peter_H on Sun, 2009-02-01 06:48.Troubleshooting

I've installed the most recent version of DBSight to index a forum which contains over 50.000.000 posts in 1.200.000 topics. The posts are all put together, so only the topics containing all the text from the posts have to be indexed.
The DB itself is about 9 gigabytes.
When I start the indexing it goes very fast, when the index starts to grow > 1 gigabyte indexing becomes slower and slower. I've indexed 380816 topics after almost 20 hours, and in my opinion this is a bit slow.
The config I use:
Processors 1
Model AMD Athlon(tm) XP 2200+
CPU Speed 1.8 GHz
Cache Size 256 KB
System Bogomips 3602.37
Memory 1.98 GB

luceneQuery and addSort via api

Submitted by bschlaac on Fri, 2009-01-30 08:57.Troubleshooting

Hi there,
i have a problem with the addSort function when I build a searchQuery with sorting and a luceneQuery component.
This is my code:

SearchQuery q = new SearchQuery( searchQuery).setDebug(true).highlight("CADDRESS_NAME1").setHighlightTag("", "").setFacetCountLimit(20).setLength(600).addSort("COURSESUPPLIER_ID", false);
if ( luceneSearchQuery != null && luceneSearchQuery.length() > 0 ) {

In this case DBSight ignores the luceneQuery.
If I remove the addSort the luceneQuery is used.
And another problem ... when I add the addSort, I think it has no affect to the result.
The sort order is the same like the result without sort.

JEE DataSource

Submitted by jkoek on Mon, 2009-01-26 03:22.Troubleshooting


I hope that I'm in the right area.

Is it possible to use a jee datasource in stead of the jdbc driver which is now used.

I'm using JBoss and want to seperate the database from the search engine.



Multisearch and setting highlighting

Submitted by jkoek on Mon, 2009-01-19 06:00.Troubleshooting

I'm using the url and I want to use the highlighting feature that is also available when using the
I'm using the macro
which is available through com.
However the multisearch object there isn't a summerizer and setting it on searchResult objects results in a core dump;
Expected hash. searchResult evaluated instead to freemarker.template.SimpleScalar on line 177, column 7 in page/lib/common.ftl.
The problematic instruction:
==> if searchResult.summarizer?has_content [on line 177, column 2 in page/lib/common.ftl]
in user-directive com.useHighlightTag [on line 20, column 9 in templates/multiSearch/main.ftl]
in user-directive layout [on line 14, column 1 in templates/multiSearch/main.ftl]

Fixed: Lucene query through the API not working

Submitted by masm on Tue, 2009-01-13 10:47.Troubleshooting

I am trying to use lucene query syntax using the search API but to no avail. Using the setLuceneQuery(myLuceneQuery) method does not seem to be working. Any insight will be appreciated.

XML feed