I hope someone can help me with this problem. I have a webapp that used
an JNDI datasource that runs fine on my local test environment. When I
put it on my server it fails with the following error:
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'"
JDBC drivers for postgreSQL are in <tomcat_home>/common/lib.
I wrote a java app that uses straight JDBC with the same connection URL and
other parameters and it worked just fine.
My local test environment is tomcat 5.5 running through eclipse with the web
tools plugins.
In production I'm using tomcat 5.5 also, exporting my project as a WAR file.
I'm at a loss as to what could be wrong. Can anyone help me?
Dan
Here are my configuration files:
server.xml
--------------------------
<Server port="8005" shutdown="SHUTDOWN">
<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
/>
<Listener
className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>
<!-- Define the Tomcat Stand-Alone Service -->
<Service name="Catalina">
<!-- Define an AJP 1.3 Connector on port 8009 -->
<Connector port="8009"
enableLookups="false" redirectPort="8443" protocol="AJP/1.3" />
<!-- An Engine represents the entry point (within Catalina) that processes
every request. The Engine implementation for Tomcat stand alone
analyzes the HTTP headers included with the request, and passes them
on to the appropriate Host (virtual host). -->
<!-- Define the top level container in our container hierarchy -->
<Engine name="Catalina" defaultHost="localhost">
<!-- Define the default virtual host -->
<Host name="localhost" appBase="webapps"
unpackWARs="true" autoDeploy="true"
xmlValidation="false" xmlNamespaceAware="false">
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="localhost_access_log." suffix=".txt"
pattern="common" resolveHosts="false"/>
</Host>
<Host name="xxxx.xxxxx.com" appBase="/var/www/xxxx"
unpackWARs="false" autoDeploy="true">
<Context path="/" docBase="xxxxWeb.war" debug="0" reloadable="true"/>
<Valve className="org.apache.catalina.valves.AccessLogValve"
directory="logs" prefix="trinket_access_log." suffix=".txt"
pattern="common" resolveHosts="false"/>
</Host>
</Engine>
</Service>
</Server>
META-INF/context.xml
--------------------------------------------
<Context>
<!-- defines the trinket database as a resource -->
<Resource name="jdbc/xxxxDB"
auth="Container"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/database"
username="user"
password="pass"
maxActive = "10"
maxWait = "10000"
removeAbandoned = "true"
removeAbandonedTimeout = "60"
maxIdle = "5"
validationQuery = "select 1"
testWhileIdle = "true"
initialSize = "5"
minIdle = "3"
timeBetweenEvictionRunsMillis = "30000"
numTestsPerEvictionRun = "3"
minEvictableIdleTimeMillis = "24000" />
</Context>
WEB-INF/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>Website</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<!-- defines the datasource for database lookups -->
<resource-ref>
<description>Database Connection</description>
<res-ref-name>jdbc/xxxxDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
index.jsp
---------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql"; prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core"; prefix="c" %>
<%-- here we test to see if an email address has been submitted or not --%>
<c:if test="${param.go == 'go'}">
<sql:query var="emailCheck" dataSource="jdbc/trinketDB">select
address from email_store where address='${param.email}'</sql:query>
${emailCheck.rowCount}
<c:if test="${emailCheck.rowCount < 1}">
<sql:update dataSource="jdbc/trinketDB">insert into email_store
(address) values ('${param.email}')</sql:update>
<c:set var="emailGiven" value="true" scope="session" />
</c:if>
</c:if>
....
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
