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"
> <[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">
> >>
>
=== 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]
