Troubleshooting

I have entered a word and dbsight showed be additional keywords....which was cool.

But I can't get it to work anymore....when/how are those "related" keywords generated ?

I have added a second subquery, now I can not index anymore...the message is:

RROR 2008-07-06 17:41:48,112- Error During Main Query:java.sql.SQLException: The statement (1) has no open cursor.:The statement (1) has no open cursor.
ERROR 2008-07-06 17:41:48,114- Detailed Error
java.sql.SQLException: The statement (1) has no open cursor.
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2901)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:773)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1304)
at com.mysql.jdbc.MysqlIO.fetchRowsViaCursor(MysqlIO.java:933)

I get this null pointer exception:

:35,344- 385057 documents to index
INFO 2008-07-05 12:51:35,344- closing result set ...
INFO 2008-07-05 12:51:35,348- closing jdbc connection ...
INFO 2008-07-05 12:51:35,349- Scheduled Period to index:[2007/11/01 15:28:01 GMT ~ 2008/04/18 20:39:15 GMT]
FATAL 2008-07-05 12:51:35,352- PANIC! Task net.javacoding.xsearch.core.A.oOOO.OoOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO@4548e798 threw an excpetion!

Hi,

A co-worker and I where looking for a dbsight option to add a minimum-relevance to a dbsight query or index.

I am not sure if Lucene supports it, but it might be something dbsight could support as a filter on a Lucene result set.

Kind regards

-r-

Hi,

Having multiple databases with a common structure, I would like to offer visitors a single search. The id's would be prefixed by the source database id, and have their own site ids as a separate keyword field. The articles source sites would be represented by a little icon in the output template.

I figured I'd need to define an index main query and subquery for each database, but was wondering where to configure them to use the same index, and not run in each other, and prevent too many locking problems.

Kind regards

-r-

When i am selecting rest template then in search it is showing only one column related to the query (title column and document column) ...if i need to show all columns related to that query then what i need to do ?..

In sortable table template it is showing all the columns related to query ,,,,

but why not in rest ?

Hi,

I just want to know how to set which information to display related to the searched id when a query is done on the index .

Hi,

I am trying to embedd DBsight in my site..what i am doing is i am calling the url from my java class then trying to retieve data from the output url will display..

import java.awt.Component;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.* ;
import java.net.URLConnection;
import java.util.Hashtable;

public class URL {

public static void main(String args[])
{
URLConnection conn = null;
java.net.URL url= null;

try {
url=new java.net.URL("http://localhost:8080/dbsight/search.do?indexName=myindex&templateName=MyTemplate&q=23");

Hey,

when i am trying to run the java example for REST provided with DBsight i am getting this error

Starting Application...
queryURL=http://localhost:8080/dbsight/search.do?indexName=myIndex&templateName=MyTemplate&q=23
Experienced IOException
java.io.FileNotFoundException: http://localhost:8080/dbsight/search.do?indexName=myIndex&templateName=MyTemplate&q=23

I'm using version 1.5.2 beta and I was able to delete current index successfully but when I try to "Recreate whole index" it doesn't work...no index is created. In the rolling.log i get this:
INFO 08-04-06 17:23:08,509| buiding index for template_test |DBIndexer:
INFO 08-04-06 17:23:08,509| Period Table: |super:
INFO 08-04-06 17:23:08,509| TaskScheduler provider class is 'class net.javacoding.xsearch.core.A.B.B' |O0OO:o00000
INFO 08-04-06 17:23:08,540| DBCP using driver: net.sourceforge.jtds.jdbc.Driver at URL: jdbc:jtds:sqlserver://proddbvs01:1433/databasename;instance=CSV;domain=domain |O0OO:super
INFO 08-04-06 17:23:09,212| DBCP prepared statement pooling enabled |O0OO:super
INFO 08-04-06 17:23:09,446| IndexWriter Pool: 3 index writer under directory: C:\Program Files\DBSight\webapps\dbsight\WEB-INF\data\indexes\template_test |C:o00000
INFO 08-04-06 17:23:09,446| Loading Analyzer:net.javacoding.xsearch.indexer.analyzer.NumberLowerCaseAnalyzer |D:
INFO 08-04-06 17:23:09,477| Starting 7 fetcher workers... |super:
INFO 08-04-06 17:23:09,477| Starting 3 writer workers... |super:
INFO 08-04-06 17:23:09,493| Previous Fecther jobs : 0 |DBIndexer:start
INFO 08-04-06 17:23:09,493| Dir size:0 Bytes |DirectorySizeChecker:isOverLimit
INFO 08-04-06 17:23:09,493| Getting the connection... |J:o00000
INFO 08-04-06 17:23:09,634| Connected. |J:o00000
INFO 08-04-06 17:23:09,634| Preparing the statement... |J:o00000
INFO 08-04-06 17:23:09,649| exec spDBSightSearch2 |J:o00000
INFO 08-04-06 17:23:09,649| Set Fetch Size to 1000 |J:o00000
INFO 08-04-06 17:23:09,649| executing the statement... |J:o00000
INFO 08-04-06 17:23:26,494| Dir size:0 Bytes |DirectorySizeChecker:isOverLimit
INFO 08-04-06 17:23:43,494| Dir size:0 Bytes |DirectorySizeChecker:isOverLimit
INFO 08-04-06 17:24:00,495| Dir size:0 Bytes |DirectorySizeChecker:isOverLimit
INFO 08-04-06 17:24:17,496| Dir size:0 Bytes |DirectorySizeChecker:isOverLimit
INFO 08-04-06 17:24:34,496| Dir size:0 Bytes |DirectorySizeChecker:isOverLimit
INFO 08-04-06 17:24:51,497| Dir size:0 Bytes |DirectorySizeChecker:isOverLimit
INFO 08-04-06 17:25:08,498| Dir size:0 Bytes |DirectorySizeChecker:isOverLimit
WARN 08-04-06 17:25:11,279| Running flag file not found. Process terminating... |super:OO0000
WARN 08-04-06 17:25:11,279| stopping indexing for template_test |SchedulerTool:stop
WARN 08-04-06 17:25:11,279| stopping indexing for template_test |SchedulerTool:stop
INFO 08-04-06 17:25:11,279| Period Table: |super:ÔO0000
INFO 08-04-06 17:25:11,279| Releasing connection pool... |super:ÔO0000
INFO 08-04-06 17:25:11,279| Released connection pool. |super:ÔO0000
INFO 08-04-06 17:25:11,279| Stopping fetchers... |super:ÔO0000
INFO 08-04-06 17:26:33,767| 0 documents to index |J:o00000