Do I need to put mysql driver in the common/lib/ directory in linux? Currently this tomcat server (in linux) has the following jar flies in the common/lib/ folder:
linux:~/tomcat/apache-tomcat-5.5.26/common/lib # ls . commons-el.jar jasper-compiler.jar jsp-api.jar naming-factory.jar servlet-api.jar .. jasper-compiler-jdt.jar jasper-runtime.jar naming-factory-dbcp.jar naming-resources.jar If I need to have that, where can I download it? Thanks > ----- Original Message ----- > From: sam wun > Sent: 28/08/08 04:44 pm > To: Tomcat Users List > Subject: Re: Re: Can't execute servlet project > > 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: 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] > > >