Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 46404 invoked from network); 5 Mar 2004 14:09:45 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 5 Mar 2004 14:09:45 -0000 Received: (qmail 48555 invoked by uid 500); 5 Mar 2004 14:09:38 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 48540 invoked by uid 500); 5 Mar 2004 14:09:38 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 48526 invoked from network); 5 Mar 2004 14:09:38 -0000 Received: from unknown (HELO mailgw1a.lmco.com) (192.31.106.7) by daedalus.apache.org with SMTP; 5 Mar 2004 14:09:38 -0000 Received: from emss07g01.ems.lmco.com (relay5.ems.lmco.com [166.29.2.16]) by mailgw1a.lmco.com (8.12.10/8.12.10) with ESMTP id i25E9b8S026015 for ; Fri, 5 Mar 2004 07:09:38 -0700 (MST) Received: from CONVERSION-DAEMON.lmco.com by lmco.com (PMDF V6.1-1X6 #30875) id <0HU300H01WO0J8@lmco.com> for torque-user@db.apache.org; Fri, 05 Mar 2004 07:09:36 -0700 (MST) Received: from EMSS06M01.us.lmco.com ([134.5.45.74]) by lmco.com (PMDF V6.1-1X6 #30875) with ESMTP id <0HU300IURWNZ5D@lmco.com> for torque-user@db.apache.org; Fri, 05 Mar 2004 07:09:36 -0700 (MST) Received: by emss06m01.ems.lmco.com with Internet Mail Service (5.5.2653.19) id ; Fri, 05 Mar 2004 09:09:35 -0500 Content-return: allowed Date: Fri, 05 Mar 2004 09:02:20 -0500 From: "Tebano, Vincent A" Subject: RE: DB Issues To: "'Apache Torque Users List'" Message-id: <51AC628CDA12C948805A20D724E621720171D6@emss06m03.us.lmco.com> MIME-version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 8BIT X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I tried your (modifying it for mine) and this is the error I get when after startup: org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException at org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfil e(JetspeedProfilerService.java:544) at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet speedProfilerService.java:292) at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet speedProfilerService.java:570) at org.apache.jetspeed.services.Profiler.getProfile(Profiler.java:125) at org.apache.jetspeed.modules.actions.JetspeedAccessController.doPerform(Jetsp eedAccessController.java:112) at org.apache.turbine.modules.Action.perform(Action.java:87) at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122) at org.apache.turbine.Turbine.doGet(Turbine.java:529) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher. java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatch er.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher .java:356) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:430) at org.apache.jsp.index_jsp._jspService(index_jsp.java:42) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 ) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:666) at java.lang.Thread.run(Thread.java:479) Vincent A. Tebano (Vinnie) Software Engineer Lockheed Martin Aircraft & Logistics Centers 244 Terminal Road Greenville, SC 29605 864-299-7267 -----Original Message----- From: Gerhard Otte [mailto:Gerhard.Otte@emediapark.de] Sent: Friday, March 05, 2004 8:44 AM To: Apache Torque Users List Subject: AW: DB Issues Ok, here is my working sqlserver 2000 setup, contents of Torque.properties: torque.applicationRoot = . torque.defaults.pool.logInterval = 0 torque.defaults.pool.connectionWaitTimeout = 10 torque.defaults.pool.defaultMaxConnections = 80 torque.defaults.pool.maxExpiryTime = 3600 torque.defaults.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.defaults.connection.url = jdbc:microsoft:sqlserver://ep01.local:1433;DatabaseName=LVS;SelectMethod =cursor torque.defaults.connection.user = ... torque.defaults.connection.password = ... torque.database.default=LVS torque.database.LVS.adapter=mssql torque.dsfactory.LVS.factory=org.apache.torque.dsfactory.SharedPoolDataS ourceFactory torque.dsfactory.LVS.pool.defaultMaxActive=10 torque.dsfactory.LVS.pool.testOnBorrow=true torque.dsfactory.LVS.pool.validationQuery=SELECT 1 HTH Gerhard Otte __ mailto:G.Otte@emediapark.de emediapark GmbH http://www.emediapark.de Tel:+49 (0)941 630804-2 Fax:-9 Hemauerstr.14,93047 Regensburg,Germany -----Urspr�ngliche Nachricht----- Von: Tebano, Vincent A [mailto:vincent.a.tebano@lmco.com] Gesendet: Freitag, 5. M�rz 2004 14:33 An: 'Apache Torque Users List' Betreff: RE: DB Issues Nope, Tried that and it didn't work Vincent A. Tebano (Vinnie) Software Engineer Lockheed Martin Aircraft & Logistics Centers 244 Terminal Road Greenville, SC 29605 864-299-7267 -----Original Message----- From: Gerhard Otte [mailto:Gerhard.Otte@emediapark.de] Sent: Friday, March 05, 2004 8:25 AM To: Apache Torque Users List Subject: AW: DB Issues may be you should try microsoft instead of Microsoft in the connection url Gerhard Otte __ mailto:G.Otte@emediapark.de emediapark GmbH http://www.emediapark.de Tel:+49 (0)941 630804-2 Fax:-9 Hemauerstr.14,93047 Regensburg,Germany -----Urspr�ngliche Nachricht----- Von: Tebano, Vincent A [mailto:vincent.a.tebano@lmco.com] Gesendet: Freitag, 5. M�rz 2004 14:01 An: torque-user@db.apache.org Betreff: DB Issues I can't seem to get the system to connect to my Microsoft SQL 2000 DB. Are these statements needs in Torque.Properties when I am setting up my own DB. torque.database.default=default torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataS ourc eFactory torque.dsfactory.default.pool.defaultMaxConnections=10 torque.dsfactory.default.pool.maxExpiryTime=3600 torque.dsfactory.default.pool.connectionWaitTimeout=10 torque.database.logInterval=0 torque.idbroker.cleverquantity=true Here is what I have set in the Torque.Properties file. I have omitted my ip, user and password for obvious reasons. torque.dsfactory.default.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.dsfactory.default.connection.url = jdbc:Microsoft:sqlserver::1433 torque.dsfactory.default.connection.user = torque.dsfactory.default.connection.password = I am getting this error when I startup the application. org.apache.jetspeed.om.profile.ProfileException: java.lang.NullPointerException I have also had the error that states that the system could not connect to the DB. Any Ideas what I am doing wrong? Vincent A. Tebano (Vinnie) Software Engineer Lockheed Martin Aircraft & Logistics Centers 244 Terminal Road Greenville, SC 29605 864-299-7267 --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org