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:[EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: "muhammed soyer" <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> 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
> <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
> << Bu mail GESNET sunucusu tarafindan virus kontrolunden
> gecirilmistir.>>
>
>
<< Bu mail GESNET sunucusu tarafindan virus kontrolunden gecirilmistir.>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
