=?iso-8859-1?B?Y2FutHQgQ29uZmlndXJhdGUgRGF0YWJhc2UgQ29ubmVjdGlvbiBQb29s?= =?iso-8859-1?B?IChEQkNQKSB3aXRoIFRvbWNhdCA1LjAuMjg=?=

[Sevillano sevi llano]

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]