ofbiz 9.04 Installation on AIX 6.1 and postgres 9.0

[khindri]

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

[Jacques Le Roux]

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" <[hidden email]>

> 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.

[khindri]

hi Jacques
  Thanx for the quick answer. Just another query

   Does ofbiz support AIX 6.1 platform as the same code works on Linux.

Regards,
Vipin