while investigate IDEMPIERE-3883, i see code at GridTable.openResultSet line 3593
when SQLException happen for m_rs = m_pstmt.executeQuery();
don't see anywhere close m_pstmt, m_rs so can potential leak connection
i try my assumption by below change:
after m_rs = m_pstmt.executeQuery(); add throw new SQLException("test");
now each time i refresh on standard window, one connection will leak on "idle transaction" state
can confirm it by pgadmin
attach patch from