Re: [xwiki-users] DBCPConnectionProvider - Could not create a DBCP pool

2012-04-27 Thread jerem 
Do you get this exception everytime or did it happen once ?
What I can say is that with MySql my pool size is set to default (2) and I
never had any problem of this kind ...

--
View this message in context: 
http://xwiki.475771.n2.nabble.com/DBCPConnectionProvider-Could-not-create-a-DBCP-pool-tp7504835p7505261.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] DBCPConnectionProvider - Could not create a DBCP pool

2012-04-27 Thread Geo Du 
Thanks for your response, After It happened, then it happened everytime, I
have to restart the postgres database server, then the exception has not
happened so far. I also increased the pool_size to 20 and the cache_size to
5.

Any more clues about why?

Thanks again

Dave

On Fri, Apr 27, 2012 at 3:53 AM, jerem jeremie.bousq...@gmail.com wrote:

 Do you get this exception everytime or did it happen once ?
 What I can say is that with MySql my pool size is set to default (2) and I
 never had any problem of this kind ...

 --
 View this message in context:
 http://xwiki.475771.n2.nabble.com/DBCPConnectionProvider-Could-not-create-a-DBCP-pool-tp7504835p7505261.html
 Sent from the XWiki- Users mailing list archive at Nabble.com.
 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] DBCPConnectionProvider - Could not create a DBCP pool

2012-04-26 Thread Geo Du 
Hi, all,

After I used xwiki for a while with POSTGRES database, I got Exception:
Could not create a DBCP pool. There is an error in the hibernate
configuration file, please review it

since it said   Cannot create PoolableConnectionFactory (FATAL: sorry, too
many clients already), I checked the hibernate.cfg.xml file, I can see the
connection.pool_size property is configured with value 2 by default, I have
some doubts about this value, only 2 connections in the pool? that is not
enough at all, any good reason why the default value is 2? so what is  the
recommended value?

Thanks
Dave


property
name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property
property name=connection.pool_size2/property
property name=statement_cache.size2/property



ERROR com.xpn.xwiki.store.DBCPConnectionProvider - Could not create a DBCP
pool. There is an error in the hibernate configuration file, please review
it.
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (FATAL: sorry, too many clients already)
at
org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
~[commons-dbcp-1.3.jar:1.3]
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
~[commons-dbcp-1.3.jar:1.3]
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
~[commons-dbcp-1.3.jar:1.3]
at
com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:196)
~[xwiki-platform-legacy-oldcore-3.5.jar:na]
at
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:143)
[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
at
org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:84)
[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
at
org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:459)
[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:90)
[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
at
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
[hibernate-core-3.6.9.Final.jar:3.6.9.Final]
at
nextek.geo.fileupload.MediaViewServlet.doGet(MediaViewServlet.java:57)
[geoservice-3.3.jar:na]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
[servlet-api.jar:na]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
[servlet-api.jar:na]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
[catalina.jar:7.0.26]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[catalina.jar:7.0.26]
at
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
[xwiki-platform-webdav-server-3.5.jar:na]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[catalina.jar:7.0.26]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[catalina.jar:7.0.26]
at
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217)
[xwiki-platform-container-servlet-3.5.jar:na]
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users