HI there,
According to the tomcat online document, do I have to modify the
context.xml file?
$CATALINA_HOME/conf/context.xml
with the following new setup: <Resource name="jdbc/TestDB" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="javauser" password="javadude"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/javatest?autoReconnect=true"/>
where username/password is the root/admin user/password of the mysql
database?
thanks
> ----- Original Message -----
> From: David Smith
> Sent: 28/08/08 03:06 am
> To: Tomcat Users List
> Subject: Re: Can't execute servlet project
>
> The datasource for your webapp isn't setup correctly. Take a look at
>
> http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
> for help on how to properly setup a database connection pool. My only
> edit that article I would recommend is don't add ?autoReconnect=true to
> the end of the mysql database url. Instead, add validationQuery="select
> 1" to the <Resource ... /> element in your context.xml file so
> connections are tested and regenerated as needed.
>
> --David
>
> sam wun wrote:
> > 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: [email protected]
> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >> For additional commands, e-mail: [EMAIL PROTECTED]
> >>
> >>
> >
> >
>
>
> --
> David Smith
> Programmer/Analyst
> College of Agriculture and Life Sciences
> Cornell University
> B32 Morrison Hall
> Ithaca, NY 14853
> Phone: (607) 255-4521
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: [email protected]
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
