Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 45595 invoked from network); 13 Dec 2003 08:34:24 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 13 Dec 2003 08:34:24 -0000 Received: (qmail 24433 invoked by uid 500); 13 Dec 2003 08:33:58 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 24422 invoked by uid 500); 13 Dec 2003 08:33:57 -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 24402 invoked from network); 13 Dec 2003 08:33:57 -0000 Received: from unknown (HELO elrond.tucana.at) (213.229.1.27) by daedalus.apache.org with SMTP; 13 Dec 2003 08:33:57 -0000 Received: from localhost (localhost [127.0.0.1]) by elrond.tucana.at (Postfix) with ESMTP id A9469178A74 for ; Sat, 13 Dec 2003 09:32:28 +0100 (CET) Received: from elrond.tucana.at ([127.0.0.1]) by localhost (elrond [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23094-05 for ; Sat, 13 Dec 2003 09:32:00 +0100 (CET) Received: from marmot.at (unknown [213.143.116.192]) by elrond.tucana.at (Postfix) with ESMTP id E84FA17886D for ; Sat, 13 Dec 2003 09:31:59 +0100 (CET) Message-ID: <3FDAD126.9090800@marmot.at> Date: Sat, 13 Dec 2003 09:43:18 +0100 From: Martin Poeschl User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20030925 X-Accept-Language: en-us, en, de-de MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: which DatasourceFactory? References: <200312130916.23382.zamek@vili.pmmf.hu> In-Reply-To: <200312130916.23382.zamek@vili.pmmf.hu> X-Enigmail-Version: 0.76.7.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at tucana.at 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 The TorqueDataSourceFactory is deprecated as it has some known bugs (it has been removed from cvs HEAD) SharedPoolDataSourceFactory works great for me ... make sure commons-dbcp-1.1.jar and commons-pool-1.1.jar are in your classpath!! martin Zamek wrote: >Hi All, > >I have a Turbine portal on a Linux Debian and Postgresql 7.3. and sun's jvm >1.4. >Which Datasourceactory is the best for me? > >The current setting is: > >torque.database.default=portal >torque.database.portal.adapter=postgresql >torque.dsfactory.portal.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory >torque.dsfactory.portal.pool.defaultMaxConnections=10 >torque.dsfactory.portal.pool.defaultMaxExpiryTime=3600 >torque.dsfactory.portal.pool.connectionWaitTimeout=10 >torque.dsfactory.portal.connection.driver = org.postgresql.Driver >torque.dsfactory.portal.connection.url = jdbc:postgresql:portal?charSet=LATIN2 >torque.dsfactory.portal.connection.user = ... >torque.dsfactory.portal.connection.password = ... > >This isn't ok, because it works well and I've get an error after a few time: >Error >org.apache.torque.TorqueException: Backend start-up failed: FATAL: Sorry, too >many clients already Backend start-up failed: FATAL: Sorry, too many clients >already at >org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:306) >at org.postgresql.Driver.connect(Driver.java:122) at >java.sql.DriverManager.getConnection(DriverManager.java:512) at >java.sql.DriverManager.getConnection(DriverManager.java:171) at >org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:179) > >Restart Turbine is not good, because I use cocoon too on this server, and >after a restart all of cached cocoon data are missing. >Max connection of Postgresql is 64. > > >I tried SharedPoolDataSourceFactory with these settings: >torque.database.default=portal > >torque.database.portal.adapter=postgresql >torque.dsfactory.portal.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory >torque.dsfactory.portal.pool.defaultMaxActive=30 >torque.dsfactory.portal.pool.testOnBorrow=true >torque.dsfactory.portal.pool.validationQuery=SELECT 1 >torque.dsfactory.portal.connection.driver = org.postgresql.Driver >torque.dsfactory.portal.connection.url = jdbc:postgresql:portal?charSet=LATIN2 >torque.dsfactory.portal.connection.user = ... >torque.dsfactory.portal.connection.password = ... > >and I've get an error: > >java.lang.NullPointerException > at org.apache.turbine.Turbine.doGet(Turbine.java:876) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at >org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:450) > at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java:180) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) > at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) > at filters.EncodingFilter.doFilter(EncodingFilter.java:60) > at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) > at >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) > at >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at >org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) > at >org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) > at >org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) > at >org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) > at >org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347) > > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org