Here is the mysql-connector jar file I got in the common/lib directory:
linux:~/tomcat/apache-tomcat-5.5.26/common/lib # ls mysql*
mysql-connector-java-5.1.3-rc-bin.jar
Is thsi the correct mysql jar file?
Thanks
Sam
> ----- Original Message -----
> From: David Smith
> Sent: 03/09/08 01:49 am
> To: Tomcat Users List
> Subject: Re: Can't execute servlet project
>
> DataSource invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException:
> Cannot create JDBC driver of class '' for connect URL 'null'"
>
> This error typically indicates the JNDI db pool hasn't been setup
> correctly. Some config option isn't setup. What's in this webapp's
> context xml file? Also what's in it's WEB-INF/web.xml? Lastly, you
> should have your database driver jar file in tomcat's common/lib (for
> tomcat v 5.5) or /lib (tomcat v 6).
>
> You can also take a look at tomcat's JDBC Datasource howto's on the
> tomcat website for your version of tomcat which offer a lot of help.
>
> --David
>
> sam wun wrote:
> > Thanks David,
> >
> >
> >
> > After copied the jstl and standard dot jar files into the directory:
> >
> > linux:~/tomcat/apache-tomcat-5.5.26/webapps/DBTest/WEB-INF/lib # ls
> > . .. jstl.jar mysql-connector-java-5.1.3-rc-bin.jar standard.jar
> >
> >
> >
> > I got the following different errors:
> >
> > (In line 4, what is jdbc/TestDB? I have database called javatest, and
> table
> > testdata. Should I rename it to jdbc/javatest?
> >
> >
> >
> >
> >
> > HTTP Status 500 -
> >
> > type Exception report
> >
> > message
> >
> > description The server encountered an internal error () that prevented
> it
> > from fulfilling this request.
> >
> > exception org.apache.jasper.JasperException: Exception in JSP:
> > /testdb.jsp:4
> >
> > 1: <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
> > 2: <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
> > 3:
> > 4: <sql:query var="rs" dataSource="jdbc/TestDB">
> > 5: select id, foo, bar from testdata
> > 6: </sql:query>
> > 7:
> >
> >
> > Stacktrace:
> >
> >
> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
> >
> >
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
> >
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> >
> > root cause javax.servlet.ServletException: Unable to get connection,
> > DataSource invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException:
> Cannot
> > create JDBC driver of class '' for connect URL 'null'"
> >
> >
> org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
> >
> >
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
> > org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:82)
> > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> >
> >
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
> >
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> >
> > root cause javax.servlet.jsp.JspException: Unable to get connection,
> > DataSource invalid: "org.apache.tomcat.dbcp.dbcp.SQLNestedException:
> Cannot
> > create JDBC driver of class '' for connect URL 'null'"
> >
> >
> org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
> >
> >
> org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
> >
> >
> org.apache.jsp.testdb_jsp._jspx_meth_sql_005fquery_005f0(testdb_jsp.java:101)
> > org.apache.jsp.testdb_jsp._jspService(testdb_jsp.java:58)
> > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> >
> >
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
> >
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
> > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
>
> > javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> >
> >
> >
> >
> >
> >
> >> ----- Original Message -----
> >> From: David Smith
> >> Sent: 03/09/08 01:23 am
> >> To: Tomcat Users List
> >> Subject: Re: Can't execute servlet project
> >>
> >> Download the binary zip file and expand it. Within it is a lib
> >> directory with just standard.jar and jstl.jar.
> >>
> >> --David
> >>
> >> sam wun wrote:
> >>
> >>> I just went to the website , very confused.
> >>>
> >>> The taglib file is not a jar file. they are binary or source file.
> >>>
> >>> And I couldn't find standard.jar file either.
> >>>
> >>>
> >>>
> >>> Thanks
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>> ----- Original Message -----
> >>>> From: David Smith
> >>>> Sent: 02/09/08 11:44 pm
> >>>> To: Tomcat Users List
> >>>> Subject: Re: Can't execute servlet project
> >>>>
> >>>> Hmmm... good question. I moved over to Maven and don't manually
> >>>> download these any more. This looks like it should do the trick:
> >>>>
> >>>> Try
> >>>>
> >>>>
> >>
> http://jakarta.apache.org/site/downloads/downloads_taglibs-standard.cgi
> >>
> >>>> --David
> >>>>
> >>>> sam wun wrote:
> >>>>
> >>>>
> >>>>> Hi David,
> >>>>>
> >>>>>
> >>>>>
> >>>>> No, I don't have this 2 jar files in the common/lib/ directory.
> >>>>>
> >>>>> where can I download it from?
> >>>>>
> >>>>>
> >>>>>
> >>>>> Thanks
> >>>>>
> >>>>> Sam
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>> ----- Original Message -----
> >>>>>> From: David Smith
> >>>>>> Sent: 02/09/08 10:39 pm
> >>>>>> To: Tomcat Users List
> >>>>>> Subject: Re: Can't execute servlet project
> >>>>>>
> >>>>>> Do you have jstl.jar and standard.jar in your WEB-INF/lib
> directory?
> >>>>>>
> >>>>>> --David
> >>>>>>
> >>>>>> sam wun wrote:
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>> Hi,
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> I have added testdb.jsp in the following path in Suse linux
(the
> >>>>>>>
> >>>>>>>
> >>>> tomcat
> >>>>
> >>>>
> >>>>>>> server):
> >>>>>>>
> >>>>>>> /tomcat/apache-tomcat-5.5.26/webapps/DBTest/
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> The content of the testdb.jsp code is:
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"
%>
> >>>>>>> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"
%>
> >>>>>>>
> >>>>>>> <sql:query var="rs" dataSource="jdbc/TestDB">
> >>>>>>> select FIRST_NAME from DBTest.Customer
> >>>>>>> </sql:query>
> >>>>>>>
> >>>>>>> <html>
> >>>>>>> <head>
> >>>>>>> <title>DB Test</title>
> >>>>>>> </head>
> >>>>>>> <body>
> >>>>>>>
> >>>>>>> <h2>Results</h2>
> >>>>>>>
> >>>>>>> <c:forEach var="row" items="${rs.rows}">
> >>>>>>> Foo ${row.foo}<br/>
> >>>>>>> Bar ${row.bar}<br/>
> >>>>>>> </c:forEach>
> >>>>>>>
> >>>>>>> </body>
> >>>>>>> </html>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> when I execute url 10.1.9.1:8080/testdb.jsp in firefox web
> browser,
> >>>>>>>
> >>>>>>>
> >>>> it
> >>>>
> >>>>
> >>>>>>> shown the following error:
> >>>>>>>
> >>>>>>> HTTP Status 500 -
> >>>>>>>
> >>>>>>> type Exception report
> >>>>>>>
> >>>>>>> message
> >>>>>>>
> >>>>>>> description The server encountered an internal error ()
that
> >>>>>>>
> >>>>>>>
> >>>> prevented
> >>>>
> >>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>> it
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>> from fulfilling this request.
> >>>>>>>
> >>>>>>> exception org.apache.jasper.JasperException: The absolute
uri:
> >>>>>>> http://java.sun.com/jsp/jstl/sql cannot be resolved in either
> >>>>>>>
> >> web.xml
> >>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>> or
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>> the jar files deployed with this application
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:51)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:409)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:116)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.compiler.TagLibraryInfoImpl.generateTLDLocation(TagLibraryInfoImpl.java:317)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.compiler.TagLibraryInfoImpl.<init>(TagLibraryInfoImpl.java:148)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.compiler.Parser.parseTaglibDirective(Parser.java:424)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> org.apache.jasper.compiler.Parser.parseDirective(Parser.java:493)
> >>>>>>>
> org.apache.jasper.compiler.Parser.parseElements(Parser.java:1557)
> >>>>>>> org.apache.jasper.compiler.Parser.parse(Parser.java:127)
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.compiler.ParserController.doParse(ParserController.java:212)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.compiler.ParserController.parse(ParserController.java:101)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >> org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:156)
> >>
> >>>>>>> org.apache.jasper.compiler.Compiler.compile(Compiler.java:296)
> >>>>>>> org.apache.jasper.compiler.Compiler.compile(Compiler.java:277)
> >>>>>>> org.apache.jasper.compiler.Compiler.compile(Compiler.java:265)
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
> >>
> >>>>
> >>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
> >>>>>>>
> >>>>>>> Here is the web.xml file I got:
> >>>>>>>
> >>>>>>> (in the path
> /tomcat/apache-tomcat-5.5.26/webapps/DBTest/WEB-INF/)
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> <?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>
> >>>>>>> Create customer servlet</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>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>> Thanks
> >>>>>>>
> >>>>>>> Sam
> >>>>>>>
> >>>>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>> ----- Original Message -----
> >>>>>>>> From: Martin Gainty
> >>>>>>>> Sent: 28/08/08 10:07 pm
> >>>>>>>> To: sw2018@gmx.com
> >>>>>>>> Subject: RE: Can't execute servlet project
> >>>>>>>>
> >>>>>>>> david's advice is correct..
> >>>>>>>>
> >>>>>>>> configure ./META-INF/ApplicationContext.xml
> >>>>>>>> <Context path="/DBTest" docBase="DBTest"
> >>>>>>>> debug="5" reloadable="true" crossContext="true">
> >>>>>>>>
> >>>>>>>> <!-- maxActive: Maximum number of dB connections
in pool.
> Make
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> sure
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> you
> >>>>>>>> configure your mysqld max_connections large
enough to
> >>>>>>>>
> >>>>>>>>
> >>>> handle
> >>>>
> >>>>
> >>>>>>>> all of your db connections. Set to 0 for no
limit.
> >>>>>>>> -->
> >>>>>>>>
> >>>>>>>> <!-- maxIdle: Maximum number of idle dB connections
to
> retain
> >>>>>>>>
> >> in
> >>
> >>>>>>>> pool.
> >>>>>>>> Set to -1 for no limit. See also the DBCP
> documentation
> >>>>>>>>
> >> on
> >>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> this
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> and the minEvictableIdleTimeMillis configuration
> >>>>>>>>
> >> parameter.
> >>
> >>>>>>>> -->
> >>>>>>>>
> >>>>>>>> <!-- maxWait: Maximum time to wait for a dB connection
to
> >>>>>>>>
> >> become
> >>
> >>>>>>>> available
> >>>>>>>> in ms, in this example 10 seconds. An Exception
is
> thrown
> >>>>>>>>
> >>>>>>>>
> >>>> if
> >>>>
> >>>>
> >>>>>>>> this timeout is exceeded. Set to -1 to wait
> >>>>>>>>
> >> indefinitely.
> >>
> >>>>>>>> -->
> >>>>>>>>
> >>>>>>>> <!-- username and password: MySQL dB username
and password
> for
> >>>>>>>>
> >>>>>>>>
> >>>> dB
> >>>>
> >>>>
> >>>>>>>> connections -->
> >>>>>>>>
> >>>>>>>> <!-- driverClassName: Class name for the old
mm.mysql JDBC
> >>>>>>>>
> >>>>>>>>
> >>>> driver
> >>>>
> >>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> is
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> org.gjt.mm.mysql.Driver - we recommend using
> Connector/J
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> though.
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> Class name for the official MySQL Connector/J
driver is
> >>>>>>>> com.mysql.jdbc.Driver.
> >>>>>>>> -->
> >>>>>>>>
> >>>>>>>> <!-- url: The JDBC connection url for connecting
to your
> MySQL
> >>>>>>>>
> >>>>>>>>
> >>>> dB.
> >>>>
> >>>>
> >>>>>>>> The autoReconnect=true argument to the url
makes sure
> >>>>>>>>
> >> that
> >>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> the
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> mm.mysql JDBC Driver will automatically reconnect
if
> >>>>>>>>
> >> mysqld
> >>
> >>>>>>>> closed the
> >>>>>>>> connection. mysqld by default closes idle
connections
> >>>>>>>>
> >>>>>>>>
> >>>> after
> >>>>
> >>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> 8
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> hours.
> >>>>>>>> -->
> >>>>>>>>
> >>>>>>>> <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"/>
> >>>>>>>>
> >>>>>>>> </Context>
> >>>>>>>> //sub in the username and password for the DB
> >>>>>>>> also in /WEB-INF/web.xml you would need this entry
> >>>>>>>> <web-app 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"
> >>>>>>>> version="2.4">
> >>>>>>>> <description>MySQL Test App</description>
> >>>>>>>> <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>
> >>>>>>>> then put in this test code changing :
> >>>>>>>> DBNAME to the name of your Database
> >>>>>>>> TABLE to the name of the table in DBNAME you want to
query
> >>>>>>>> COLUMN for the specific attribute to query
> >>>>>>>> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql"
prefix="sql"
> %>
> >>>>>>>> <%@ taglib uri="http://java.sun.com/jsp/jstl/core"
prefix="c" %>
> >>>>>>>>
> >>>>>>>> <sql:query var="rs" dataSource="jdbc/TestDB">
> >>>>>>>> select COLUMN from DBNAME.TABLE
> >>>>>>>> </sql:query>
> >>>>>>>>
> >>>>>>>> <html>
> >>>>>>>> <head>
> >>>>>>>> <title>DB Test</title>
> >>>>>>>> </head>
> >>>>>>>> <body>
> >>>>>>>>
> >>>>>>>> <h2>Results</h2>
> >>>>>>>>
> >>>>>>>> <c:forEach var="row" items="${rs.rows}">
> >>>>>>>> Foo ${row.foo}<br/>
> >>>>>>>> Bar ${row.bar}<br/>
> >>>>>>>> </c:forEach>
> >>>>>>>>
> >>>>>>>> </body>
> >>>>>>>> </html>
> >>>>>>>>
> >>>>>>>> if you need UNICODE support or Character Large Object
(strings >
> >>>>>>>>
> >> 64k
> >>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> in
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> length) download JDBC 4 driver
> >>>>>>>> http://dev.mysql.com/downloads/connector/j/5.1.html
> >>>>>>>>
> >>>>>>>> personally I am using the 'older' version of MYSQL so
I use the
> >>>>>>>>
> >> 3.1
> >>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> jar
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> which you can acquire here
> >>>>>>>> http://dev.mysql.com/downloads/connector/j
> >>>>>>>>
> >>>>>>>> location of driver classes:
> >>>>>>>>
> >>>>>>>> is located in $TOMCAT_HOME/common/lib
> >>>>>>>> personally I dont like putting anything in common since
it will
> >>>>>>>>
> >>>>>>>>
> >>>> affect
> >>>>
> >>>>
> >>>>>>>> all webapps but i usually
> >>>>>>>> place in /WEB-INF/lib
> >>>>>>>>
> >>>>>>>> and please follow david's advice and read the tutorial
> >>>>>>>>
> >>>>>>>> Martin
> >>>>>>>> ______________________________________________
> >>>>>>>> Disclaimer and confidentiality note
> >>>>>>>> Everything in this e-mail and any attachments relates
to the
> >>>>>>>>
> >>>>>>>>
> >>>> official
> >>>>
> >>>>
> >>>>>>>> business of Sender. This transmission is of a confidential
> nature
> >>>>>>>>
> >>>>>>>>
> >>>> and
> >>>>
> >>>>
> >>>>>>>> Sender does not endorse distribution to any party other
than
> >>>>>>>>
> >>>>>>>>
> >>>> intended
> >>>>
> >>>>
> >>>>>>>> recipient. Sender does not necessarily endorse content
contained
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>> within
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>> this transmission.
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>> Date: Thu, 28 Aug 2008 11:02:52 +0200
> >>>>>>>>> From: sw2018@gmx.com
> >>>>>>>>> Subject: Re: Re: Can't execute servlet project
> >>>>>>>>> To: users@tomcat.apache.org; users@tomcat.apache.org
> >>>>>>>>>
> >>>>>>>>> Hi,
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> I couldn't find an installation document about installing
the
> >>>>>>>>>
> >>>>>>>>>
> >>>> driver.
> >>>>
> >>>>
> >>>>>>>>> I;ve downloaded the driver:
> >>>>>>>>>
> >>>>>>>>> linux:~/tomcat/apache-tomcat-5.5.26/common/lib #
ls
> >>>>>>>>> mysql-connector-java-5.1.3-rc-bin.jar
> >>>>>>>>> mysql-connector-java-5.1.3-rc-bin.jar
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> Do you know how to configure tomcat to make use
of it?
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> Thanks
> >>>>>>>>>
> >>>>>>>>> Sam
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
|