Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org Received: (qmail 6888 invoked from network); 16 Sep 2004 19:11:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 16 Sep 2004 19:11:34 -0000 Received: (qmail 19492 invoked by uid 500); 16 Sep 2004 19:10:40 -0000 Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 19469 invoked by uid 500); 16 Sep 2004 19:10:39 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 19451 invoked by uid 99); 16 Sep 2004 19:10:38 -0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=DNS_FROM_RFC_ABUSE,FROM_ENDS_IN_NUMS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [144.160.20.36] (HELO sbcsmtp6.sbc.com) (144.160.20.36) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 16 Sep 2004 12:10:35 -0700 Received: from sbc.com (localhost [127.0.0.1]) by sbcsmtp6.sbc.com (8.12.10/8.12.10) with ESMTP id i8GJAW1L005342 for ; Thu, 16 Sep 2004 15:10:33 -0400 (EDT) Received: from MISOUT7MSGHUB02.ITServices.sbc.com (misout7msghub02.itservices.sbc.com [144.155.106.22]) by sbcsmtp6.sbc.com (8.12.10/8.12.10) with ESMTP id i8GJARv0005304 for ; Thu, 16 Sep 2004 15:10:27 -0400 (EDT) Received: from misout7msgusr06.ITServices.sbc.com ([144.155.106.20]) by MISOUT7MSGHUB02.ITServices.sbc.com with Microsoft SMTPSVC(5.0.2195.5329); Thu, 16 Sep 2004 15:10:27 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: RE: Server.xml configuration problem Date: Thu, 16 Sep 2004 15:10:26 -0400 Message-ID: <530439A50955B840BA743D6692B0DBD10220B7F7@misout7msgusr06.itservices.sbc.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Server.xml configuration problem Thread-Index: AcScHdSk6cUIeUmcQHaygXxFv7oGiAAAtnpQ From: "LINGALA, AMARESHWAR G \(SBCSI\)" To: "Tomcat Users List" X-OriginalArrivalTime: 16 Sep 2004 19:10:27.0516 (UTC) FILETIME=[D38A4FC0:01C49C20] X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N It is working now, All I have to do is put the resource params inside of the Thanks for all your help !!! =20 -----Original Message----- From: Jukka Uusisalo [mailto:jukka.uusisalo@dnainternet.net]=20 Sent: Thursday, September 16, 2004 1:50 PM To: Tomcat Users List Subject: Re: Server.xml configuration problem Hi, Your datasource jdbc/myOracle must be inside some Context element or DefaultContext element like factoryn org.apache.commons.dbcp.BasicDataSourceFactory Default context element is inside Host element. And also there have be reference in your application web.xml like Datasource for my app jdbc/myDataSource javax.sql.DataSource container - Jukka - ----- Original Message -----=20 From: "LINGALA, AMARESHWAR G (SBCSI)" To: "Tomcat Users List" Sent: Thursday, September 16, 2004 9:21 PM Subject: RE: Server.xml configuration problem Can you please be more specific, I tried to follow up the documents but am unable to fix the bug. Can you please send me the example of the change? I would be very much thankful to you. I am assuming that type=3D"javax.sql.DataSource"/> > > Should make the tomcat recognise the database. Thanks Amar -----Original Message----- From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com] Sent: Thursday, September 16, 2004 1:12 PM To: Tomcat Users List Subject: RE: Server.xml configuration problem Hi, You need to add an explicit Context element for your webapp, and inside it a ResourceLink element to make the GlobalNamingResources DataSource visible to your webapp. Check the configuration reference document for GlobalNamingResourcs and ResourceLink for details. Yoav Shapira Millennium Research Informatics >-----Original Message----- >From: LINGALA, AMARESHWAR G (SBCSI) [mailto:al3495@sbc.com] >Sent: Thursday, September 16, 2004 2:04 PM >To: Tomcat Users List >Subject: Server.xml configuration problem > > > Hi, > I am trying to set-up Connection pooling for my web application, I >have made the following modifications to my server.xml file. > > > > > > > > > > > > className=3D"org.apache.catalina.mbeans.ServerLifecycleListener" > debug=3D"0"/> > className=3D"org.apache.catalina.mbeans.GlobalResourcesLifecycleListener= " > debug=3D"0"/> > > > > > > value=3D"30"/> > > > type=3D"org.apache.catalina.UserDatabase" > description=3D"User database that can be updated and saved"> > > > > factory > >org.apache.catalina.users.MemoryUserDatabaseFactory > > > pathname > conf/tomcat-users.xml > > > > Modified by Amar Lingala on 09/15/04 <--> > type=3D"javax.sql.DataSource"/> > > > > factory > >org.apache.commons.dbcp.BasicDataSourceFactory > > > driverClassName > oracle.jdbc.driver.OracleDriver > > > url > > > >jdbc:oracle:thin:@chd4.sbc.com:1521:ostl411 > > > username > scott > > > password > tiger > > > maxActive > 20 > > > maxIdle > 10 > > > maxWait > -1 > > > End of Modification <--> > > > > > > > > > > > > maxThreads=3D"150" minSpareThreads=3D"25" >maxSpareThreads=3D"75" > enableLookups=3D"false" redirectPort=3D"8443" >acceptCount=3D"100" > debug=3D"0" connectionTimeout=3D"20000" > disableUploadTimeout=3D"true" /> > > > > > > > > > enableLookups=3D"false" redirectPort=3D"8443" = debug=3D"0" > protocol=3D"AJP/1.3" /> > > > > > > > > > > > > > > > > > prefix=3D"catalina_log." suffix=3D".txt" > timestamp=3D"true"/> > > > > > debug=3D"0" resourceName=3D"UserDatabase"/> > > > > > > > > > > > > > > unpackWARs=3D"true" autoDeploy=3D"true" > xmlValidation=3D"false" xmlNamespaceAware=3D"false"> > > > > > > > > > > > > > > > > directory=3D"logs" prefix=3D"localhost_log." suffix=3D".txt" > timestamp=3D"true"/> > > > > > > > > > > But whenever I try to access the database I get the following error. > > > org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver >of class '' for connect URL 'null' > at >org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSourc e >.java:780) > at >org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.j a >va:540) > at >com.sbc.ssbilling.database.DBConnectionImpl.makeDBConnection(DBConnecti o >nImpl.java:63) > at >com.sbc.ssbilling.calculation.action.CalculationsReportAction.execute(C a >lculationsReportAction.java:49) > at >org.apache.struts.action.RequestProcessor.processActionPerform(RequestP r >ocessor.java:484) > at >org.apache.struts.action.RequestProcessor.process(RequestProcessor.java : >274) > at >org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) > at >org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic a >tionFilterChain.java:237) > at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil t >erChain.java:157) > at >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal v >e.java:214) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:104) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 5 >20) > at >org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCo n >textValve.java:198) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal v >e.java:152) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:104) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 5 >20) > at >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav a >:137) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:104) > at >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav a >:117) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:102) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 5 >20) > at >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve . >java:109) > at >org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveC o >ntext.java:104) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 5 >20) > at >org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) > at >org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) > at >org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:7 9 >9) > at >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process C >onnection(Http11Protocol.java:705) > at >org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:5 7 >7) > at >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo l >.java:683) > at java.lang.Thread.run(Thread.java:534) >Caused by: java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getDriver(DriverManager.java:243) > at >org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSourc e >.java:773) > ... 33 more > > >Any help would be greatly appreciated. > > >Thanks > Amar > >--------------------------------------------------------------------- >To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org >For additional commands, e-mail: tomcat-user-help@jakarta.apache.org This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org