Thanks Doug,Harry and rest of my friends, After going thru the links ,I was able to make it work.Before I end this thread I just want to clarify some doubts.I am querying a database ,but I have some delay getting back the results.Now I want to check if the query is causing the delay or am I going wrong with allocating connections.So,I want to log all my program steps in a log file,can u just tell me what code I have to add and where?? Would this code help me?? <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/>
Looking for these answers and thanks for your generous help. cheers. On Thu, 20 Jan 2005 Parsons Technical Services wrote : >People who have to figure out how to use other peoples work either have messy >hair or are bald. > >There are three main pages for reference: >http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations > >http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-resources-howto.html > >http://jakarta.apache.org/tomcat/tomcat-5.0-doc/config/globalresources.html > >Now the basics. There are four pieces to the puzzle. > >I am going for a Global Setup. > >First is the server.xml Resource and ResourceParams elements. It appears that >you have these. Connects to the database and create a pool of connections. > >Second is the web.xml entry for the resource-ref. > >Third is the Resource link placed in the apps context. > >Fourth is the calling of the resource from code. > >When you say "use to BasicDataSource to see thw no. of active connections " is >this you application or something built into Tomcat? > >Doug > >----- Original Message ----- From: "micky none" <[EMAIL PROTECTED]> >To: "Tomcat Users List" <tomcat-user@jakarta.apache.org> >Sent: Wednesday, January 19, 2005 4:54 PM >Subject: Re: Re: ConnectionPooling > > >Tried that too my friend,isn't there any sure shot answer for this one..im >like half mad after this...as of now..... > > >On Thu, 20 Jan 2005 Harry Mantheakis wrote : >>This may not help, but try swapping the order of the <ResourceParams> and >><Resource> elements in your 'server.xml' file. >> >>Also, you seem to be declaring the <DefaultContext> element three times (!) >>which seems wrong. >> >>HTH >> >>Harry Mantheakis >> >> >> > Hi Friends, >> > This is my first message on this list.I want to use the dbcp connection >> > pooling.I set up the server.xml according to an example,but when i > >> > trying to >> > use to BasicDataSource to see thw no. of active connections it's > throwing >> > errors.I tried searching a lot but to no use.If I go into the > >> > administrator >> > tool,it shows nothing there?I am using tomcat5.0..please tell me ..where > >> > i am >> > going wrong and if there is any other way to see the number of active >> > connections. >> > >> > >> > Here's my server.xml,please tell me if there's anything wrong with it: >> > >> > <Logger className="org.apache.catalina.logger.FileLogger" > >> > directory="logs" >> > prefix="localhost_log." suffix=".txt" timestamp="true" /> >> > <DefaultContext reloadable="true" /> >> > <DefaultContext path="/database" docBase="database" debug="0" >> > reloadable="true" /> >> > - <DefaultContext> >> > - <ResourceParams name="jdbc/conversion"> >> > - <parameter> >> > <name>username</name> >> > <value>xxxx</value> >> > </parameter> >> > - <parameter> >> > <name>password</name> >> > <value>xxxx</value> >> > </parameter> >> > - <parameter> >> > <name>driverClassName</name> >> > <value>com.ibm.db2.jcc.DB2Driver</value> >> > </parameter> >> > - <parameter> >> > <name>url</name> >> > <value>jdbc:db2j:netxxxx</value> >> > </parameter> >> > - <parameter> >> > <name>removeAbandoned</name> >> > <value>true</value> >> > </parameter> >> > - <parameter> >> > <name>removeAbandonedTimeout</name> >> > <value>0</value> >> > </parameter> >> > - <parameter> >> > <name>logAbandoned</name> >> > <value>true</value> >> > </parameter> >> > - <parameter> >> > <name>maxActive</name> >> > <value>1</value> >> > </parameter> >> > - <parameter> >> > <name>factory</name> >> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> >> > </parameter> >> > </ResourceParams> >> > <Resource name="jdbc/conversion" auth="Container" > >> > type="javax.sql.DataSource" >> > /> >> > </DefaultContext> >> > <Loader className="org.apache.catalina.loader.WebappLoader" >> > loaderClass="org.apache.catalina.loader.WebappClassLoader" > >> > checkInterval="3" >> > /> >> > </Host> >> > >> > please,please,please help me...its very urgent. >> >> >>--------------------------------------------------------------------- >>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] >