Return-Path: 
 <tomcat-user-return-125197-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 7900 invoked from network); 19 Apr 2005 20:51:48 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Apr 2005 20:51:48 -0000
Received: (qmail 32233 invoked by uid 500); 19 Apr 2005 20:51:05 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 32198 invoked by uid 500); 19 Apr 2005 20:51:04 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 32050 invoked by uid 99); 19 Apr 2005 20:51:03 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=FORGED_RCVD_HELO
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from ftrdmzsmtp2.jdstg.com (HELO ftrdmzsmtp2.JDGlobalAg.net)
 (207.3.86.77)
  by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 19 Apr 2005 13:51:00 -0700
Received: from 204.54.89.36 by ftrdmzsmtp2.JDGlobalAg.net with ESMTP (
 Tumbleweed MMS SMTP Relay (MMS v5.6.0)); Tue, 19 Apr 2005 15:50:48
 -0500
X-Server-Uuid: 23E1BC42-1962-4FBA-B3DA-824F1DC78D9D
Received: from etrmb1.jdnet.deere.com ([204.54.89.29]) by
 etrbridge1.jdnet.deere.com with Microsoft SMTPSVC(5.0.2195.6747); Tue,
 19 Apr 2005 15:50:47 -0500
X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0
content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: RE: [SPAM2] - RE: Problems with DataSourceRealm Tomcat 5.5 -
 Found word(s) list error in the Text body
Date: Tue, 19 Apr 2005 15:50:47 -0500
Message-ID: <58219B9E373C964681A59C6DD048722E01A1E8B0@etrmb1.jdnet.deere.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [SPAM2] - RE: Problems with DataSourceRealm Tomcat 5.5 -
 Found word(s) list error in the Text body
Thread-Index: AcVFAGBaI6LR1rdHSLyvLpddI0/iPgAAHYkwAAC4s7AAAUsEUAAE0s+QAAFHueA=
From: "Kanda Upendra" <UKanda@agris.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
X-OriginalArrivalTime: 19 Apr 2005 20:50:47.0747 (UTC)
 FILETIME=[76B0E930:01C54521]
X-WSS-ID: 6E7BB0A20VG2822484-01-01
Content-Type: text/plain;
 charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N


Hi

 Thanks for the suggestion. It works now. As Hassan had suggested, the =
resource params are listed as XML attributes in for Tomcat 5.5.=20

Thanks again,

-----Original Message-----
From: Lorenzo Jim=E9nez [mailto:ljimenez@nacion.co.cr]=20
Sent: Tuesday, April 19, 2005 4:17 PM
To: Tomcat Users List
Subject: RE: [SPAM2] - RE: Problems with DataSourceRealm Tomcat 5.5 - =
Found word(s) list error in the Text body
Importance: High

This is my context.xml

<?xml version=3D"1.0" encoding=3D"UTF-8"?>
<Context docBase=3D"C:\Apps\NB41\Registro" path=3D"/registry">
  <Logger className=3D"org.apache.catalina.logger.FileLogger" =
prefix=3D"registry." suffix=3D".log" timestamp=3D"true"/>
 =20
  <Resource name=3D"jdbc/egistry" scope=3D"Shareable" =
type=3D"javax.sql.DataSource"/>
  <ResourceParams name=3D"jdbc/registry">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <!-- DBCP database connection settings -->
    <parameter>
      <name>url</name>
      <value>jdbc:sybase:Tds:172.16.19.11:5000/WEB</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>com.sybase.jdbc2.jdbc.SybDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>WEB123</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>456PASSW</value>
    </parameter>
    <!-- DBCP connection pooling options -->
    <parameter>
      <name>initialSize</name>
      <value>1</value>
    </parameter>
    <parameter>
      <name>minIdle</name>
      <value>1</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>2</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>2</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>30000</value>
    </parameter>
  </ResourceParams>
 =20
    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <WatchedResource>META-INF/context.xml</WatchedResource>

</Context>

-----Original Message-----
From: Kanda Upendra [mailto:UKanda@agris.com]=20
Sent: Martes, 19 de Abril de 2005 11:57 a.m.
To: Tomcat Users List
Subject: [SPAM2] - RE: Problems with DataSourceRealm Tomcat 5.5 - Found =
word(s) list error in the Text body


Hi,

  Thanks for the quick response. I have the <resource-ref> defined in my =
web.xml and it still doesn't work.

Throws me the same error.

"Name jdbc not bound in this context"

Thanks

Upendra


-----Original Message-----
From: Lorenzo Jim=E9nez [mailto:ljimenez@nacion.co.cr]=20
Sent: Tuesday, April 19, 2005 1:20 PM
To: Tomcat Users List
Subject: RE: Problems with DataSourceRealm Tomcat 5.5
Importance: High

On the web.xml you have also to write down after ther welcome files:

<resource-ref>
	<res-ref-name>jdbc/myDB</res-ref-name>
	<res-type>javax.sql.DataSource</res-type>
	<res-auth>Container</res-auth>

	<-- optional.if you like -->
	<res-sharing-scope>Shareable</res-sharing-scope> =20
</resource-ref>

Lorenzo

-----Original Message-----
From: Kanda Upendra [mailto:UKanda@agris.com]=20
Sent: Martes, 19 de Abril de 2005 11:06 a.m.
To: Tomcat Users List
Subject: Problems with DataSourceRealm Tomcat 5.5


Hi,

  I am using Tomcat 5.5 and having problems with the DataSourceRealm
finding the data source in the JNDI.=20

Here is the configuration of my context.xml,

<Realm className=3D"org.apache.catalina.realm.DataSourceRealm" =
debug=3D"99"
             dataSourceName=3D"jdbc/myDB"
           userTable=3D"users" userNameCol=3D"login" =
userCredCol=3D"password"
           userRoleTable=3D"user_roles" roleNameCol=3D"role_name" />


<Resource name=3D"jdbc/myDB" 	auth=3D"Container"
type=3D"javax.sql.DataSource"
      maxActive=3D"10" maxIdle=3D"5" maxWait=3D"100"  username=3D"myDB"
password=3D"myDB" driverClassName=3D"com.mysql.jdbc.Driver"
	url=3D"jdbc:mysql://localhost/myDB?autoReconnect=3Dtrue"/>



I get this error "Name jdbc not bound in this context". I tried moving
the Resource configuration under <GlobalNamingResources> in server.xml,
but I get the same error. JDBCRealm works, but I want it use a
connection pool and hence I am trying to change it to a DataSourceRealm.

Also, interestingly, when I try to access the data source from a jsp in
my webapplication it works. The problem seems to be with the
DataSourceRealm looking up for the resource using JNDI.

Any help will be appreciated.

Thanks,

Upendra





---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


-------------------------------------------------------------

Si usted no es el destinatario indicado en este mensaje o responsable =
como persona=20
de la entrega del mensaje, no debe copiar o reenviar este mensaje, por =
favor notifique=20
al correo infosegura@nacion.com. Para m=E1s referencia sobre t=E9rminos =
importantes=20
relacionados a este correo visite =
http://www.nacion.com/disclaimer/index_es2.htm

If you are not the addressee indicated in this message (or responsible =
for delivery of the=20
message to such person), you may not copy or send this message to =
anyone, please notify
to infosegura@nacion.com. Click here for important additional terms =
relating to this e-mail.=20
<http://www.nacion.com/disclaimer/index_en2.htm>

-------------------------------------------------------------



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org





---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org





---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org