Accessing the DAO layer without http requests

[Migrated From Jforum.net]

I have written scriplet to get the recent topics in JForum to show on the index page. I added the method getForumForApps(t.getForumId()) and I was successful in getting the recent topics, however there are some problems with the database connection. the index page works only after accessing some link of JForum, also after some time the database connection is lost I suppose. What will be the correct way to do what I am trying.

<!-- TOPICS LISTING -->

		
		ArrayList forums = new ArrayList();
		List topics = null;
		
		try{
		topics = TopicRepository.getRecentTopics();
		for (Iterator iter = topics.iterator(); iter.hasNext(); ) {
			Topic t = (Topic)iter.next();
			Forum f = ForumRepository.getForumForApps(t.getForumId());
			forums.add(f);

		}
		} catch (RuntimeException re){
			re.printStackTrace();
		}
		Topic topic = null; 
		Forum forum = null;
		String imgPath = basePath + "templates/default";
		String url = null;
		for(int i = 0; i < 10; i++){
				topic = (Topic)topics.get(i);
				forum = (Forum)forums.get(i);
				out.println("<tr>");
				
				//url = JForumContext.encodeURL("/forums/show/"+forum.getId());
				
				out.println("	<td class=\"row2\" valign=\"middle\" align=\"center\"><a class=\"postdetails\" href=\""+basePath+"forums/show/"+forum.getId()+".page\">"+forum.getName()+"</a></td>");
				
				out.println("	<td class=\"row1\" valign=\"middle\" align=\"center\" width=\"20\">##</td>");
				
				out.println("	<td class=\"row1\" width=\"70%\">");
				out.println("		<span class=\"topictitle\">");
				out.println("		<a href=\"posts/list/"+topic.getId()+".page\">");
				if(topic.getTitle().length() == 0){
					out.println("No Subject");
				} else {
					out.println(topic.getTitle());
				}
				out.println("		</span>");

				
				out.println("	</td>");

				out.println("	<td class=\"row2\" valign=\"middle\" align=\"center\"><span class=\"postdetails\">"+topic.getTotalReplies()+"</span></td>");
				
				out.println("	<td class=\"row3\" valign=\"middle\" align=\"center\">");
				out.println("		<span class=\"name\"><a href=\""+basePath+"user/profile/"+topic.getPostedBy().getId()+".page\">"+topic.getPostedBy().getUsername()+"</a></span>");
				out.println("	</td>");

				out.println("	<td class=\"row2\" valign=\"middle\" align=\"center\"><span class=\"postdetails\">"+topic.getTotalViews()+"</span></td>");
				
				out.println("	<td class=\"row3right\" valign=\"middle\" nowrap=\"nowrap\" align=\"center\">");
				//out.println("		<#if (topic.lastPostTime?length > 0)>");
				out.println("			<span class=\"postdetails\">"+topic.getLastPostTime()+"<br />");
				out.println("			<a >"+topic.getLastPostBy().getUsername()+"</a>");

				/*out.println("			<#assign startPage = \"\"/>");
				out.println("			<#if (topic.totalReplies + 1 > postsPerPage?number)>");
				out.println("				<#assign startPage = ((topic.totalReplies / postsPerPage?number)?int * postsPerPage?number) +\"/\"/>");
				out.println("			</#if>");
				  
				out.println("			<a ><img  border=\"0\"  Reply\" /></a></span>");
				out.println("		</#if>	");	*/
				out.println("	</td>"); 
				out.println("</tr>	");	
			}


				
          <!-- END OF TOPICS LISTING -->

[originally posted on jforum.net by judekm]

[Migrated From Jforum.net]

First, I'm assuming that this code is running in the same web app as jForum and not a different one..

If so, the problem with the initial call to a Jforum page may be because the CacheEngine and database engine are initialized in the JForum Servlet init method. This servlet processes all *.page requests.

If I remember correctly, the J2EE Specs are kind of vague on when application engines are required to call the init method. There is a load-on-startup web.xml parameter but this may not be honored or the container may be letting requests come through before everything is initialized. Or worse, not calling the init method until the first call to the jForum servlet is made.

The DB problem (and maybe the init problem) may be due to the fact that the JForum servlet service method does a check to see if the DB is initialized and re-initializes it if it isn't. I'm not sure, but I guess that code is being called every time to fix similar problems.
[originally posted on jforum.net by monroe]

[Migrated From Jforum.net]

Thank You for the response.
If so how can I initialize the cache engine and database engine from the scriplet.
[originally posted on jforum.net by judekm]