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