tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Smith <d...@cornell.edu>
Subject Re: Can't execute servlet project
Date Tue, 02 Sep 2008 17:06:45 GMT
>
> 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?
>   
Yes ... looks good.  Just be sure this is the only place you have a 
mysql JDBC driver installed.  There should not be one in 
webapps/DBTest/WEB-INF/lib if it exists here.

> This is the only context.xml file I got in the tomcat (5.5.26) directory:
>
> /tomcat/apache-tomcat-5.5.26/conf/context.xml: ...
That is the universal one.  The context xml file should be either in 
your webapp's META-INF folder named context.xml or in tomcat's 
conf/Catalina/localhost named DBTest.xml.  It only contains a <Context 
... > xml element and it's contents.  Something like:

<Context >
   <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"  
validationQuery="select 1" />
</Context>

Obviously replace the username, password, and URL with what's 
appropriate to your database environment.

You can read more on this at 
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html

--David

sam wun wrote:
> 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)
>>>
>>>
>>>
>>>
>>>
>>>   
>>>       


---------------------------------------------------------------------
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


Mime
View raw message