BTW, where should I place the web.xml file in the tomcat server?

The web (root) execution path of my tomcat server is:

/tomcat/apache-tomcat-5.5.26/webapps/DBTest



Thanks

Sam

> ----- Original Message -----
> From: sam wun
> Sent: 28/08/08 02:45 am
> To: Tomcat Users List, Tomcat Users List
> Subject: Re: Re: Can't execute servlet project
> 
> HI there,
> 
> 
> 
> I managed to fix the jdk version error, now it comes with a different 
> error.
> 
> The url I am trying to put on the firefox browser is 
> 
> http://10.1.9.1:8080/DBTest/CreateCustomerServlet
> 
> 
> 
> 
> 
> The error is:
> 
> TTP Status 500 - 
> 
> type Exception report
> 
> message 
> 
> description The server encountered an internal error () that prevented it 
> from fulfilling this request.
> 
> exception javax.servlet.ServletException: Cannot create JDBC driver of 
> class '' for connect URL 'null'
>       servlet.CreateCustomerServlet.doGet(CreateCustomerServlet.java:38)
>       javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>       javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> 
> root cause org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create 
> JDBC driver of class '' for connect URL 'null'
> 
> 
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150)
> 
> 
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
>       command.CommandExecutor.getConnection(CommandExecutor.java:54)
>       command.CommandExecutor.executeDatabaseCommand(CommandExecutor.java:38)
>       servlet.CreateCustomerServlet.doGet(CreateCustomerServlet.java:33)
>       javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>       javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> 
> root cause java.sql.SQLException: No suitable driver
>       java.sql.DriverManager.getDriver(Unknown Source)
> 
> 
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143)
> 
> 
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
>       command.CommandExecutor.getConnection(CommandExecutor.java:54)
>       command.CommandExecutor.executeDatabaseCommand(CommandExecutor.java:38)
>       servlet.CreateCustomerServlet.doGet(CreateCustomerServlet.java:33)
>       javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
>       javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> 
> note The full stack trace of the root cause is available in the Apache 
> Tomcat/5.5.26 logs.
> > ----- Original Message -----
> > From: David Smith
> > Sent: 28/08/08 12:44 am
> > To: Tomcat Users List
> > Subject: Re: Can't execute servlet project
> > 
> > Looks normal .. you won't get a file named CreateCustomerServlet under 
> > DbTest.  You should get a class named CreateCustomerServlet.class in 
> > WEB-INF/classes/servlet.  That class will be called when your webapp 
> > receive's a request for 
> > http://localhost:8080/DbTest/CreateCustomerServlet (assuming tomcat was 
> > installed with listening on port 8080 and it's installed on your local 
> > workstation).  That's what the <servlet-mapping> ... </servlet-mapping> 
> > part of web.xml is all about -- mapping URLs to servlets.
> > 
> > 
> > --David
> > 
> > sam wun wrote:
> > > I got a similar web.xml, but the is different. 
> > >
> > > Here is the entire content of my web.xml.
> > >
> > >
> > >
> > > <?xml version="1.0" encoding="UTF-8"?>
> > > <web-app id="WebApp_ID" version="2.4" 
> > > xmlns="http://java.sun.com/xml/ns/j2ee"; 
> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; 
> > > xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
> > > http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd";>
> > >     <display-name>
> > >     DBTest</display-name>
> > >     <servlet>
> > >         <description>
> > >         Servlet to create customers</description>
> > >         <display-name>
> > >         CreateCustomerServlet</display-name>
> > >         <servlet-name>CreateCustomerServlet</servlet-name>
> > >         <servlet-class>
> > >         servlet.CreateCustomerServlet</servlet-class>
> > >     </servlet>
> > >     <servlet-mapping>
> > >         <servlet-name>CreateCustomerServlet</servlet-name>
> > >         <url-pattern>/CreateCustomerServlet</url-pattern>
> > >     </servlet-mapping>
> > >     <welcome-file-list>
> > >         <welcome-file>index.html</welcome-file>
> > >         <welcome-file>index.htm</welcome-file>
> > >         <welcome-file>index.jsp</welcome-file>
> > >         <welcome-file>default.html</welcome-file>
> > >         <welcome-file>default.htm</welcome-file>
> > >         <welcome-file>default.jsp</welcome-file>
> > >     </welcome-file-list>
> > >     <resource-ref>
> > >         <description>DB Connection</description>
> > >           <res-ref-name>jdbc/TestDB</res-ref-name>
> > >          <res-type>javax.sql.DataSource</res-type>
> > >          <res-auth>Container</res-auth>
> > >     </resource-ref>
> > > </web-app>
> > >
> > >
> > >
> > > However, I don't see "CreateCustomerServlet" copied into my DBTest 
> > folder 
> > > in the linux(tomcat) server.
> > >
> > > Here is the project directory listing of my tomcat server (in linux):
> > >
> > > linux:~/tomcat/apache-tomcat-5.5.26/webapps/DBTest # ls
> > > .  ..  META-INF  WEB-INF  customers.jsp
> > >
> > >
> > >
> > > Thanks
> > >
> > > Sam
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >   
> > >> ----- Original Message -----
> > >> From: David Smith
> > >> Sent: 27/08/08 11:29 pm
> > >> To: Tomcat Users List
> > >> Subject: Re: Can't execute servlet project
> > >>
> > >> But if you followed the tutorial, there should be a servlet mapping 
> in 
> > >> your web.xml looking like what I copied and pasted from the article 
> > >> below:
> > >>
> > >> <servlet>
> > >>     <description>Create Customers Servlet</description>
> > >>     <display-name>ListCustomers</display-name>
> > >>     <servlet-name>ListCustomers</servlet-name>
> > >>     <servlet-class>servlet.ListCustomersServlet</servlet-class>
> > >> </servlet>
> > >> <servlet-mapping>
> > >>     <servlet-name>ListCustomers</servlet-name>
> > >>     <url-pattern>/ListCustomers</url-pat-tern>
> > >> </servlet-mapping>
> > >>
> > >> This defines a servlet in the <servlet> element and then defines the 
> > >> URLs this servlet should service in the <servlet-mapping> element.  
> In 
> > >> this case there doesn't need to be a physical file named 
> ListCustomers 
> > >> in the top level of the DbTest webapp.
> > >>
> > >> Your tutorial was very much geared to showing you how Eclipse works, 
> > >> more or less assuming you had some familiarity with servlet and/or 
> > java 
> > >> programming.  I would recommend finding some tutorial material that 
> > >> focuses on servlet/jsp programming, ignoring IDEs like Eclipse.
> > >>
> > >> --David
> > >>
> > >> sam wun wrote:
> > >>     
> > >>> HI there,
> > >>>
> > >>>
> > >>>
> > >>> It sounds logical, but there is no LIstCustomers in the DBTest 
> > folder.
> > >>>
> > >>>
> > >>>
> > >>> Thanks
> > >>>
> > >>> Sam
> > >>>
> > >>>
> > >>>
> > >>>   
> > >>>       
> > >>>> ----- Original Message -----
> > >>>> From: David Smith
> > >>>> Sent: 27/08/08 09:59 pm
> > >>>> To: Tomcat Users List
> > >>>> Subject: Re: Can't execute servlet project
> > >>>>
> > >>>> I see .... the jsp is a view and as such wasn't designed to be run 
> > on 
> > >>>> it's own.  Try http://localhost/DBTest/ListCustomers in your 
> > browser.  
> > >>>> That should hit the servlet which in turn should generate the 
> > required 
> > >>>> bean and forward the user to your jsp.
> > >>>>
> > >>>> --David
> > >>>>
> > >>>>
> > >>>> sam wun wrote:
> > >>>>     
> > >>>>         
> > >>>>> Hi, thanks for trying to help.
> > >>>>>
> > >>>>> I dont' have a clue on this *bean*.
> > >>>>>
> > >>>>> The entire tutorial doesn't mention about how to setup a bean...
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>> The tutorial I;ve followed is shown as below:
> > >>>>>
> > >>>>> http://java.sys-con.com/node/152270
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>> Thanks
> > >>>>>
> > >>>>> Sam
> > >>>>>
> > >>>>>
> > >>>>>
> > >>>>>   
> > >>>>>           
> > 
> > 
> > ---------------------------------------------------------------------
> > To start a new topic, e-mail: users@tomcat.apache.org
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > 
> 

Reply via email to