Hi Caroline
it works perfectly now!!
thanks very much for your help
I love you!!
:-)
From: Caroline Jen <[EMAIL PROTECTED]>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
Subject: Re: can´t Configurate Database Connection Pool (DBCP) with Tomcat 5.0.28
Date: Fri, 15 Apr 2005 07:47:11 -0700 (PDT)
Hi Sevillano,
I inserted the configuration after the last <Realm ..../> tag and before the <Host ... >tage (see below) in the $TOMCAT/config/server.xml file. This is my configuration (sorry, I should have shown it in my previous posting). Let us see if it works:
<!-- <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="sun.jdbc.odbc.JdbcOdbcDriver" connectionURL="jdbc:odbc:CATALINA" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name" /> -->
<!-- Define the default virtual host Note: XML Schema validation will not work with Xerces 2.2. -->
<!-- The DefaultContext segment and its elements below are added by Caroline Jen -->
<DefaultContext> <Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/OracleDB"> <parameter> <name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxWait</name> <value>-1</value> </parameter> <parameter> <name>maxActive</name> <value>20</value> </parameter> <parameter> <name>password</name> <value>javadude</value> </parameter> <parameter> <name>url</name>
<value>jdbc:oracle:thin:@bigbird:1522:dcapes</value> </parameter> <parameter> <name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>maxIdle</name> <value>10</value> </parameter> <parameter> <name>username</name> <value>javauser</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>60</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> </ResourceParams> </DefaultContext>
<!-- The DefaultContext segment and its elements above are added by Caroline Jen -->
<Host name="localhost" debug="0" appBase="webapps" unpackWARs="true" autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false">
<!-- The line below is added by Caroline Jen -->
<DefaultContext reloadable="true"/>
<!-- Defines a cluster for this node, By defining this element, means that every manager will be changed. So when running a cluster
-Caroline --- Sevillano sevi llano <[EMAIL PROTECTED]> wrote:
> 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" > <tomcat-user@jakarta.apache.org> > >To: "Tomcat Users List" > <tomcat-user@jakarta.apache.org> > >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: <tomcat-user@jakarta.apache.org> > >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"> > >> > === message truncated ===
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Acepta el reto MSN Premium: Protección para tus hijos en internet. Descárgalo y pruébalo 2 meses gratis. http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
