Search Issue - Using Oracle9i and websphere

[Migrated From Jforum.net]

Hi Rafael,

I am using oracle 9i as the database and websphere 6 as app server. I am facing an issue with SEARCH functionality. When i edit an existing post,the search with new text does not work. I found Indexing is not getting performed after editing an existing post as JFORUM_SEARCH_WORDS is not getting updated. I am getting the following warning:

WARN [MessageIndexerTask] - Error while indexing a post: com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.

I commented some code in index-method and it seems to be working fine

public void index(Post post)
	{
//		if (SystemGlobals.getBoolValue(ConfigKeys.BACKGROUND_TASKS)) {
//			try {
//				QueuedExecutor.getInstance().execute(new MessageIndexerTask(post));
//			}
//			catch (Exception e) {
//				logger.error("Error while running the search task", e);
//			}
//		}
//		else {
			try {
				SearchIndexerDAO indexer = DataAccessDriver.getInstance().newSearchIndexerDAO();
				indexer.setConnection(JForumExecutionContext.getConnection());
				indexer.insertSearchWords(post);
			}
			catch (Exception e) {
				throw new SearchException("Error while indexing a message", e);
			}
//		}
	}

but then I found all the words in edited post are getting into JFORUM_SEARCH_WORDS. I know there is a problem with closed connection(cudn't figure out where), but just want to know if the above commented code would create any problems..please let me know

thank you
[originally posted on jforum.net by rags]

[Migrated From Jforum.net]

The check for background taks exists to make posting faster. When you don't use background tasks, the user have to wait for the message indexation end first, so it can read the new message.

It is only a performance issue.. should not affect the functionalities of your forum at all.

Rafael
[originally posted on jforum.net by Rafael Steil]