load on startup causing problems

[sylvia greene]

I have the following Servlet

 package com;
 
import java.sql.*;
import java.util.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
public class HelloWorldServlet extends HttpServlet
{
    Connection dbConnection;
 
public void init() {
 
    System.out.println(getServletName()+"   :   Initializing...") ;
ServletConfig config = getServletConfig() ;
String driverClassName = config.getInitParameter("driverclassname");
        String dburl = config.getInitParameter("dburl") ;
String username = config.getInitParameter("username") ;
String password = config.getInitParameter("password") ;
 
        try  {
      Class.forName(driverClassName) ;
          dbConnection = DriverManager.getConnection(dburl,username,password) ;
          }
        catch (SQLException s)  {
        System.out.println("SQLException") ;
        }
        catch (ClassNotFoundException c)  {
        System.out.println("ClassNotFoundExceptionException") ;
        }
System.out.println("initilized") ;
}
   public void doGet(HttpServletRequest request, HttpServletResponse response){ 
        

        try  {
    PrintWriter pw = response.getWriter(); 
Statement stmt = dbConnection.createStatement() ;
ResultSet rs = stmt.executeQuery("Select user_name from user_details") ;
     while(rs.next()) {
         pw.println(rs.getString(1)) ;
     }
}
        catch (SQLException sql)  {
             System.out.println("SQLException second") ;
        }           
        catch (IOException sql)  {
           System.out.println("IOException second") ;
        }           
 
   }
 
 
   public void destroy() {
     try {
     dbConnection.close() ;
     }
     catch (Exception e){
 e.printStackTrace() ;
     }
   }
 
}
 

and the following web.xml file

<?xml version="1.0" encoding="ISO-8859-1"?>
 
<!DOCTYPE web-app
   PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
   "http://java.sun.com/dtd/web-app_2_3.dtd">
 
<web-app>
   <servlet>
      <servlet-name>HelloWorldServlet</servlet-name>
      <servlet-class>com.HelloWorldServlet</servlet-class>
      <init-param>
     <param-name>driverclassname</param-name>
         <param-value>oracle.jdbc.driver.OracleDriver</param-value>
      </init-param>
  <init-param>
     <param-name>dburl</param-name>
         <param-value>jdbc  :-o	  racle:thin:@127.0.0.1:1521  :-o	  rcl</param-value>
      </init-param>
  <init-param>
     <param-name>username</param-name>
         <param-value>accounts</param-value>
      </init-param>
  <init-param>
     <param-name>password</param-name>
         <param-value>accounts</param-value>
      </init-param>
 
   </servlet>
 
   <servlet-mapping>
      <servlet-name>HelloWorldServlet</servlet-name>
  <url-pattern>/HelloWorldServlet</url-pattern>
   </servlet-mapping>
</web-app>
  

It works fine
But as soon as I add the load on startup element in web.xml its causing problems

 
    .....
   <servlet-name>HelloWorldServlet</servlet-name>
      <servlet-class>com.HelloWorldServlet</servlet-class>
     [B] <load-on-startup>1</load-on-startup>[/B]
  <init-param>
     .....
 

I get the following error when i restart the tomcat server.



Jul 15, 2004 6:18:54 PM org.apache.commons.digester.Digester error
SEVERE: Parse Error at line 29 column 14: The content of element type "servlet"
must match "(icon?,servlet-name,display-name?,description?,(servlet-class|jsp-fi
le),init-param*,load-on-startup?,run-as?,security-role-ref*)".
org.xml.sax.SAXParseException: The content of element type "servlet" must match
"(icon?,servlet-name,display-name?,description?,(servlet-class|jsp-file),init-pa
ram*,load-on-startup?,run-as?,security-role-ref*)".
at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Un
known Source)
at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown S
ource)
at org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(
Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent
Dispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un
known Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1548)
at org.apache.catalina.startup.ContextConfig.applicationConfig(ContextCo
nfig.java:282)
at org.apache.catalina.startup.ContextConfig.start(ContextConfig.java:63
9)
at org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfi
g.java:243)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:166)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3
582)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:821)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:80
7)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)

at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDep
loyer.java:307)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:788)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:559)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:401
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:718)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:358)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:166)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1196)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:754)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1188)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:363
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
97)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:219
0)
at org.apache.catalina.startup.Catalina.start(Catalina.java:512)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:400)
at org.apache.catalina.startup.Catalina.process(Catalina.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)


Please tell me what's the reason for this and how can i correct it.
[ July 15, 2004: Message edited by: sylvia greene ]

[Bear Bibeault]

The message is telling you quite clearly that the load-on-startup element must follow the init-parameter elements.

[sylvia greene]

Thanks a lot