Jim,
I understand most part of it now. the only thing that i dont
understand is how will the connection pooling be handled. I am using
tomcat 5. will the following code(from the link that u sent me) serve
the purpose?
<data-sources>
<!-- configuration for commons BasicDataSource -->
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property
property="driverClassName"
value="org.postgresql.Driver" />
<set-property
property="url"
value="jdbc:postgresql://localhost/mydatabase" />
<set-property
property="username"
value="me" />
.
.
.
......
regards
saurabh
On Mon, 2004-08-16 at 16:45, Jim Barrows wrote:
> > -----Original Message-----
> > From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 16, 2004 2:42 PM
> > To: Struts Users Mailing List
> > Subject: RE: connection pooling
> >
> >
> > Jim,
> > I am sorry but I am confused now. Just correct me if I am
> > wrong........ I want to call my DAO from my Action class. So
> > the snippet
> > that you sent me would go in my DAO class in the function
> > getConnection() (or something like that).
>
> Yes, that is correct. I acutally implment that in my DaoFactory class, and put the
> resultant connection from the data source in the DaoFactory class. That allows me
> to easily de-couple the dao class for testing.
>
> > And if what I said is correct then does it mean that I
> > dont need to
> > have a connection pool class and my webserver would handle everything
> > for me.
>
> Depends on the web server... websphere has it's own, tomcat allows you to have
> several choices, and I have no idea what BEA does.
>
>
> >
> > regards
> > saurabh
> >
> > On Mon, 2004-08-16 at 16:29, Jim Barrows wrote:
> > > > -----Original Message-----
> > > > From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> > > > Sent: Monday, August 16, 2004 2:24 PM
> > > > To: Struts Users Mailing List
> > > > Subject: Re: connection pooling
> > > >
> > > >
> > > > David,
> > > > But i want to make a business layer and call the DAO
> > from there. I
> > > > think that the links that you have sent me couple
> > > > presentation layer and
> > > > database tightly. I know i can use EJB for presentation layer
> > > > but I dont
> > > > want that as it would be overkill for the small project I am
> > > > working on.
> > > > I want to have a connection pool class initialized at the time the
> > > > server starts and then all my DAO should get the
> > connection from that
> > > > pool. Is it possible?
> > > > I am a beginner in this field and I might not understand it
> > > > completely. please correct me if i am wrong.
> > >
> > > Ah, okay.. I also posted a link to the struts way to do the
> > JNDI data source stuff.... in that case.. you follow your web
> > app servers guide on how to setup a data source, then you
> > follow the destructions for a normal jndi data source. Something like:
> > >
> > > /**
> > > *
> > > */
> > > public static DataSource getDataSource() throws
> > NamingException {
> > > if (ds == null) {
> > > Context ctx = (Context) new InitialContext();
> > > ds =
> > > (DataSource) ctx.lookup(
> > > "jdbc/yourDataSource);
> > > }
> > > return ds;
> > > }
> > >
> > > > regards
> > > > saurabh
> > > >
> > > >
> > > >
> > ---------------------------------------------------------------------
> > > > 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]
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
