Quick morning answer: I don't you if it will help you but you can increase from 250... Mmn... seems it's not your problem but rather
you Postgres config...
Jacques
From: "khindri" <[email protected]>
Experts,
I try to install the ofbiz 9.04 release on AIX 6.1 and postegres 9.0
It seems that their is connection pooling error as the postgres is
configured to handle 750 concurrent connection whereas the maximum i am
specifying in the datasource is 250.
The following error which i got.
org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:276)
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:95)
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
org.postgresql.Driver.makeConnection(Driver.java:386)
org.postgresql.Driver.connect(Driver.java:260)
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
org.apache.commons.dbcp.managed.LocalXAConnectionFactory.createConnection(LocalXAConnectionFactory.java:62)
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:117)
org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55)
org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77)
org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53)
org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128)
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85)
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95)
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73)
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:259)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:365)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:336)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1270)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1250)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Thread.java:736)
Its the default setup on AIX only thing is i have changed entityengine.xml
to use localpostnew datasource and changed the jdbc connection url and
related parameters.
Also changed the algorithm SunX509 to IbmX509 .
Regards,
Vipin
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/ofbiz-9-04-Installation-on-AIX-6-1-and-postgres-9-0-tp3914330p3914330.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
