HI Thanks a lot. I am sending the server.xml and web.xml files below.
Server.xml
<?xml version="1.0" encoding="utf-8" ?>
- <Server>
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
/>
<Listener
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />
- <GlobalNamingResources>
<Environment description="" name="maxExcemptions" override="false"
type="java.lang.Integer" value="10" />
<Environment name="simpleValue" type="java.lang.Integer" value="30" />
<Resource auth="Container" description="User database that can be updated
and saved" name="UserDatabase" type="org.apache.catalina.UserDatabase" />
<Resource description="" name="EIRPDB1"
type="org.apache.catalina.UserDatabase" />
<Resource name="jdbc/db2" type="javax.sql.DataSource" />
- <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>
- <ResourceParams name="EIRPDB1">
- <parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
- <parameter>
<name>pathname</name>
<value>D:\DB2\NODE0000\</value>
</parameter>
</ResourceParams>
- <ResourceParams name="jdbc/db2">
- <parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
- <parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
- <parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
- <parameter>
<name>password</name>
<value>db2admin</value>
</parameter>
- <parameter>
<name>url</name>
<value>jdbc:db2:EIRPDB1</value>
</parameter>
- <parameter>
<name>driverClassName</name>
<value>COM.ibm.db2.jdbc.app.DB2Driver</value>
</parameter>
- <parameter>
<name>maxIdle</name>
<value>2</value>
</parameter>
- <parameter>
<name>username</name>
<value>db2admin</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
- <Service name="Catalina">
<Connector acceptCount="100" connectionTimeout="20000"
disableUploadTimeout="true" port="8080" redirectPort="8443"
maxSpareThreads="75" maxThreads="150" minSpareThreads="25" />
<Connector port="8009" protocol="AJP/1.3"
protocolHandlerClassName="org.apache.jk.server.JkCoyoteHandler"
redirectPort="8443" />
- <Engine defaultHost="localhost" name="Catalina">
- <Host appBase="webapps" name="localhost">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_log." suffix=".txt" timestamp="true" />
</Host>
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="catalina_log." suffix=".txt" timestamp="true" />
<Realm className="org.apache.catalina.realm.UserDatabaseRealm" />
</Engine>
</Service>
</Server>
web.xml:
<?xml version="1.0" encoding="ISO-8859-1" ?>
+ <!--
Copyright 2004 The Apache Software Foundation
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
- <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>
- <!--
JSPC servlet mappings start -->
- <servlet>
<servlet-name>org.apache.jsp.index_jsp</servlet-name>
<servlet-class>org.apache.jsp.index_jsp</servlet-class>
</servlet>
- <servlet-mapping>
<servlet-name>org.apache.jsp.index_jsp</servlet-name>
<url-pattern>/index.jsp</url-pattern>
</servlet-mapping>
- <!--
JSPC servlet mappings end -->
- <resource-ref>
<description>DB2 Datasource example</description>
<res-ref-name>jdbc/db2</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
- <resource-env-ref>
<description>Object factory for MyBean instances.</description>
<resource-env-ref-name>bean/MyBeanFactory</resource-env-ref-name>
<resource-env-ref-type>com.iipl.eirp.dbconnection.test</resource-env-ref-typ
e>
</resource-env-ref>
</web-app>
You have take so much of trouble to help. Thanks a lot once again.
Regards
Bhaskar
----- Original Message -----
From: "Pradeep Chauhan" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Friday, August 06, 2004 3:58 PM
Subject: RE: [SPAM_EMAIL] - Database connection - Found word(s) list error
in the Text body.
> Ok then do one thing post your web.xml and server.xml
>
>
> -----Original Message-----
> From: Bhaskar Jyoti Phukan [mailto:[EMAIL PROTECTED]
> Sent: 06.08.2004 15:13
> To: Tomcat Users List
> Subject: [SPAM_EMAIL] - Database connection - Found word(s) list error in
> the Text body.
>
>
> Hi!
>
> Thanks a lot for the reply. We have tried all this and also followed the
> tomcat doc but still not able to connect the application to the db2
> database.
>
> Regards
>
> Bhaskar
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
