but...
where do I add the Context exactly?
this is my server.xml, If I add context, tomcat doesn�t start
thanks
<Server port="8005" shutdown="SHUTDOWN">
<GlobalNamingResources>
<!-- Used by Manager webapp -->
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved">
</Resource>
<ResourceParams name="UserDatabase">
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
</GlobalNamingResources><Service name="Catalina"> <Connector port="8080" />
<!-- This is here for compatibility only, not required --> <Connector port="8009" protocol="AJP/1.3" />
<Engine name="Catalina" defaultHost="localhost">
<Logger className="org.apache.catalina.logger.FileLogger" /> <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase" />
<Host name="localhost" appBase="webapps"/>
</Engine>
</Service>
</Server>From: "Parsons Technical Services" <[EMAIL PROTECTED]>
Reply-To: "Tomcat Users List" <[email protected]>
To: "Tomcat Users List" <[email protected]>
Subject: Re: can�t Configurate Database Connection Pool (DBCP) with Tomcat 5.0.28
Date: Fri, 15 Apr 2005 07:56:36 -0400
Do you have your resource link in the context element? And if you don't have a context for the app you need to create one.
Doug
----- Original Message ----- From: "Sevillano sevi llano" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, April 15, 2005 5:34 AM
Subject: can�t Configurate Database Connection Pool (DBCP) with Tomcat 5.0.28
Hi, I�m a newbie trying to configurate DBCP with Tomcat 5.0.28
I�m following this documentation: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
"...Add this in between the </Context> tag of the examples context and the </Host> tag closing the localhost definition..."
but there is no </Context> in my server.xml
also I�ver read tons of forums about this question, and I�ve tested a lot of different configuration.
this is the error I�ve got (the usual I think):
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
any help please? I�ve been the whole week trying to fix it
thanks
these are my files:
SERVER.XML
<Server port="8005" shutdown="SHUTDOWN">
<GlobalNamingResources> <!-- Used by Manager webapp --> <Resource name="UserDatabase" auth="Container" type="org.apache.catalina.UserDatabase" description="User database that can be updated and saved"> </Resource> <ResourceParams name="UserDatabase"> <parameter> <name>factory</name> <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value> </parameter> <parameter> <name>pathname</name> <value>conf/tomcat-users.xml</value> </parameter> </ResourceParams>
<Resource name="jdbc/myoracle" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/myoracle">
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter> <parameter><name>username</name><value>***</value></parameter> <parameter><name>password</name><value>***</value></parameter>
<parameter><name>driverClassName</name><value>oracle.jdbc.driver.OracleDriver</value></parameter>
<parameter><name>url</name><value>jdbc:oracle:thin:@****:1521:bddesa</value></parameter>
<parameter><name>removeAbandoned</name><value>false</value></parameter>
<parameter><name>removeAbandonedTimeout</name><value>300</value></parameter> <parameter><name>logAbandoned</name><value>true</value></parameter> <parameter><name>maxActive</name><value>10</value></parameter> </ResourceParams>
</GlobalNamingResources>
<Service name="Catalina"> <Connector port="8080" />
<!-- This is here for compatibility only, not required --> <Connector port="8009" protocol="AJP/1.3" />
<Engine name="Catalina" defaultHost="localhost"> <Logger className="org.apache.catalina.logger.FileLogger" />
<Realm className="org.apache.catalina.realm.UserDatabaseRealm" resourceName="UserDatabase" />
<Host name="localhost" appBase="webapps" /> </Engine> </Service> </Server>
WEB.XML
<?xml version="1.0" encoding="ISO-8859-1"?>
<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">
<display-name>Welcome to Tomcat</display-name> <description> Welcome to Tomcat </description>
<resource-ref> <res-ref-name>jdbc/myoracle</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
</web-app>
TEST.JSP
... Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:/comp/env"); DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle"); conn = ds.getConnection(); ...
_________________________________________________________________
Descarga gratis la Barra de Herramientas de MSN http://www.msn.es/usuario/busqueda/barra?XAPID=2031&DI=1055&SU=http%3A//www.hotmail.com&HL=LINKTAG1OPENINGTEXT_MSNBH
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Descubre la descarga digital con MSN Music. M�s de medio mill�n de canciones. http://music.msn.es/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
