Return-Path: 
 <tomcat-user-return-109397-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 9337 invoked from network); 6 Sep 2004 12:26:59 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 6 Sep 2004 12:26:59 -0000
Received: (qmail 42718 invoked by uid 500); 6 Sep 2004 12:26:19 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 42675 invoked by uid 500); 6 Sep 2004 12:26:19 -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 42654 invoked by uid 99); 6 Sep 2004 12:26:19 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of pengtuck@gmail.com designates
 64.233.170.200 as permitted sender)
Received: from [64.233.170.200] (HELO mproxy.gmail.com) (64.233.170.200)
  by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 06 Sep 2004 05:26:18 -0700
Received: by mproxy.gmail.com with SMTP id 75so267949rnk
        for <tomcat-user@jakarta.apache.org>;
 Mon, 06 Sep 2004 05:26:16 -0700 (PDT)
Received: by 10.38.125.73 with SMTP id x73mr1403106rnc;
        Mon, 06 Sep 2004 05:26:16 -0700 (PDT)
Received: by 10.38.207.24 with HTTP; Mon, 6 Sep 2004 05:26:16 -0700 (PDT)
Message-ID: <2fae47480409060526306e4375@mail.gmail.com>
Date: Mon, 6 Sep 2004 20:26:16 +0800
From: Peng Tuck Kwok <pengtuck@gmail.com>
Reply-To: Peng Tuck Kwok <pengtuck@gmail.com>
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
Subject: Re: Using JDBC Data source from a business class
In-Reply-To: <019201c49401$ad1020d0$7d00a8c0@juxtapose>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <08c101c49400$6be16160$d200000a@msoyer>
	 <019201c49401$ad1020d0$7d00a8c0@juxtapose>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Adding to this, you could also supply a context.xml seperately  with
the war file when you deploy the app, this is optional.


On Mon, 6 Sep 2004 06:07:18 -0500, Keith Bottner <kbottner@comcast.net> wrote:
> The context.xml file is under your WebRoot/META-INF directory. When you
> application is deployed it gets copied to the conf/Catalina/[host name]/
> directory then renamed to be the same as your web application. (Which BTW,
> if it is NOT being copied could also be part of the problem). 5.0.27 has a
> problem on Windows doing the copy so you have to do it manually, I believe
> it has been fixed in 5.0.28.
> 
> Keith
> 
> 
> 
> -----Original Message-----
> From: muhammed soyer [mailto:muhammed@ges.net.tr]
> Sent: Monday, September 06, 2004 5:58 AM
> To: Tomcat Users List
> Subject: Re: Using JDBC Data source from a business class
> 
> Hello
> 
>     Where is this context.xml file .should I create a file in web-inf
> directory named context.xml . I put a ResourceLink line in my webapp.xml
> files which is at "jakarta-tomcat-5.0.28/conf/Catalina/localhost"
> 
> -ms
> ----- Original Message -----
> From: "Keith Bottner" <kbottner@comcast.net>
> To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
> Sent: Monday, September 06, 2004 1:48 PM
> Subject: RE: Using JDBC Data source from a business class
> 
> I believe you also need an entry in your web.xml file that looks something
> like this (obviously changed for your DB settings).
> 
> <resource-ref>
> <description>postgreSQL Datasource</description>
> <res-ref-name>jdbc/postgres</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
> 
> You also need the ResourceLink entry in your context.xml
> 
> <ResourceLink name="jdbc/database" global="jdbc/postgres"
> type="javax.sql.DataSource" />
> 
> I use JNDI to retrieve the DB connection with
> 
> private static final String JNDI_CONTEXT = "java:comp/env"; private static
> final String DATASOURCE_DB_NAME = "jdbc/database";
> 
> try
> {
> Context initCtx = new InitialContext();
> Context envCtx = (Context)
> initCtx.lookup(JNDI_CONTEXT);
> datasource = (DataSource)
> envCtx.lookup(DATASOURCE_DB_NAME);
> }
> catch ( NamingException e )
> {
> if ( log.isEnabledFor(Level.ERROR) ) log.error(sm.getString("DAO.creation"),
> e); }
> 
> Hope that helps.
> 
> Keith
> -----Original Message-----
> From: muhammed soyer [mailto:muhammed@ges.net.tr]
> Sent: Monday, September 06, 2004 5:06 AM
> To: Peng Tuck Kwok; Tomcat Users List
> Subject: Re: Using JDBC Data source from a business class
> 
> For my web applications(servlets) I add the following lines  in the
> webapp.xml .For my classes what should I do ..These classes is not directly
> called from the browser .My JSP files use them ..
> 
> <ResourceLink name="jdbc/gp" type="javax.sql.DataSource" global="jdbc/gp"/>
> <Resource type="javax.sql.DataSource" description="Oracle Datasource
> example" auth="Container" name="jdbc/gp"/>
> 
> -ms
> ----- Original Message -----
> From: "Peng Tuck Kwok" <pengtuck@gmail.com>
> To: "muhammed soyer" <muhammed@ges.net.tr>
> Sent: Monday, September 06, 2004 12:11 PM
> Subject: Re: Using JDBC Data source from a business class
> 
> You should be able to access the datasource from your classes.  You said
> earlier you had problems doing so, could you describe the problems ?
> 
> On Mon, 6 Sep 2004 11:31:04 +0300, muhammed soyer <muhammed@ges.net.tr>
> wrote:
> > Yes they are in my web-inf/classes directory .I use them to do my db
> > jobs ..from jsp pages .. these classes access db .so I want to make
> > them use Tomcats conneciton pooling machanism . I can do this from
> > servlets ..
> >
> > -ms
> >
> > ----- Original Message -----
> > From: "Peng Tuck Kwok" <pengtuck@gmail.com>
> > To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> > Sent: Monday, September 06, 2004 10:44 AM
> > Subject: Re: Using JDBC Data source from a business class
> >
> > On Mon, 6 Sep 2004 09:12:51 +0300, muhammed soyer
> > <muhammed@ges.net.tr>
> > wrote:
> >
> > > My servlets are using the ds without a problem ..But I have some
> > > classes
> > which are >POJO classes to make my job easier whie accessing the DB
> ..these
> > classes couldnt use > my JDBC definition ..As I guess its from context
> > problems ..But I couldnt solve the >problem
> >
> > What's the exact problem? You don't exactly say where your POJO
> > classes are, so I assume they are in your webapp right, then it should
> > be ok.
> >
> > >
> > > What should I do to use tomcat's ds from a POJO class ?
> > >
> > > thnx
> > >
> > > -ms
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> > << Bu mail GESNET sunucusu tarafindan virus kontrolunden
> > gecirilmistir.>>
> >
> >
> 
> << Bu mail GESNET sunucusu tarafindan virus kontrolunden gecirilmistir.>>
> 
> ---------------------------------------------------------------------
> 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
> 
> << Bu mail GESNET sunucusu tarafindan virus kontrolunden gecirilmistir.>>
> 
> ---------------------------------------------------------------------
> 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