struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jim Barrows" <jbarr...@sssc.com>
Subject RE: connection pooling
Date Mon, 16 Aug 2004 22:20:47 GMT


> -----Original Message-----
> From: Saurabh Bhatla [mailto:saurabh@resolution.com]
> Sent: Monday, August 16, 2004 3:16 PM
> To: Struts Users Mailing List
> Subject: RE: connection pooling
> 
> 
> 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" />

http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations
The short version is that it is handled automagically for you.  No need to borrow or return
the connection etc.


> .
> .
> .
> ......
> 
> regards
> saurabh
> 
> 
> 
> On Mon, 2004-08-16 at 16:45, Jim Barrows wrote:
> > > -----Original Message-----
> > > From: Saurabh Bhatla [mailto:saurabh@resolution.com]
> > > 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:saurabh@resolution.com]
> > > > > 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: user-unsubscribe@struts.apache.org
> > > > > For additional commands, e-mail: user-help@struts.apache.org
> > > > > 
> > > > > 
> > > > 
> > > > 
> > > 
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > > > For additional commands, e-mail: user-help@struts.apache.org
> > > > 
> > > > 
> > > 
> > > 
> > > 
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > > For additional commands, e-mail: user-help@struts.apache.org
> > > 
> > > 
> > 
> > 
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > For additional commands, e-mail: user-help@struts.apache.org
> > 
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
> 
> 

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


Mime
View raw message