Suppose I will put following code in my struts-config.xml instead of
tomcat's server.xml will it work as per the expectation for abandoned
connection.
<set-property property="maxCount" value="1500"/>
<set-property property="minCount" value="1500"/>
<set-property property="username" value="jpatel" />
<set-property property="password" value="jpatel" />
<set-property property="removeAbandoned" value="true"/>
<set-property property="removeAbandonedTimeout" value="300"/>
<set-property property="logAbandoned" value="true"/>
-Jignesh
On Mon, 2004-08-16 at 18:20, Jim Barrows wrote:
> > -----Original Message-----
> > From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> > 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:[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]
> >
> >
>
> ---------------------------------------------------------------------
> 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]
