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
> 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.
Locked
Oct 18, 2011; 6:16am
