Hello Community

We received the below issues  when we try to configure when
apache-ofbiz-18.12.14 with PostgreSQL db 13  ,but when we try with
 apache-ofbiz-18.12.10  with the same PostgreSQL db 13  configuration ,it's
working property.




new connection from the pool). Rolling back transaction.
org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a
connection with the database. (Unable to acquire a new connection from the
pool)
        at
org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:351)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1314)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:437)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:116)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:134)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:99)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:69)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:218)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
~[ofbiz.jar:?]
        at org.apache.ofbiz.base.start.Start.main(Start.java:85)
~[ofbiz.jar:?]
Caused by: java.sql.SQLException: Unable to acquire a new connection from
the pool
        at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
~[ofbiz.jar:?]
        ... 19 more
Caused by: java.util.NoSuchElementException: Unable to activate object
        at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474)
~[commons-pool2-2.6.0.jar:2.6.0]
        at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
~[commons-pool2-2.6.0.jar:2.6.0]
        at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
~[ofbiz.jar:?]
        ... 19 more
Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
        at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775)
~[postgresql-9.1-901.jdbc4.jar:?]
        at
org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465)
~[commons-pool2-2.6.0.jar:2.6.0]
        at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
~[commons-pool2-2.6.0.jar:2.6.0]
        at
org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
~[commons-dbcp2-2.5.0.jar:2.5.0]
        at
org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
~[ofbiz.jar:?]
        at
org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
~[ofbiz.jar:?]
        ... 19 more

Reply via email to