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)
--
Thx,
Zoltan Zidarics programmer
PTE University Pecs, Hungary
icq: 43288694
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
