Return-Path: 
 <tomcat-user-return-125188-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 42675 invoked from network); 19 Apr 2005 17:57:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Apr 2005 17:57:54 -0000
Received: (qmail 98970 invoked by uid 500); 19 Apr 2005 17:57:24 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 98954 invoked by uid 500); 19 Apr 2005 17:57:24 -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 98892 invoked by uid 99); 19 Apr 2005 17:57:22 -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 10:57:21 -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 12:57:03
 -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 12:57:02 -0500
X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0
content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: RE: Problems with DataSourceRealm Tomcat 5.5
Date: Tue, 19 Apr 2005 12:57:02 -0500
Message-ID: <58219B9E373C964681A59C6DD048722E01A1E7FE@etrmb1.jdnet.deere.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Problems with DataSourceRealm Tomcat 5.5
Thread-Index: AcVFAGBaI6LR1rdHSLyvLpddI0/iPgAAHYkwAAC4s7AAAUsEUA==
From: "Kanda Upendra" <UKanda@agris.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
X-OriginalArrivalTime: 19 Apr 2005 17:57:02.0760 (UTC)
 FILETIME=[30EA2280:01C54509]
X-WSS-ID: 6E7B99E40VG2811457-02-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 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