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.
