sam wun wrote: > HI there, > > According to the tomcat online document, do I have to modify the > context.xml file? > > $CATALINA_HOME/conf/context.xml
Not that one, that one affects *all* deployed contexts. Add a context.xml file to your webapp, in the META-INF folder. DBTest/index.jsp DBTest/META-INF/context.xml DBTest/WEB-INF/web.xml p > 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: users@tomcat.apache.org >>>> 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: users@tomcat.apache.org >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
