We're updating the issue view to help you get more done. 

potential leak connection on standard window

Description

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

Environment

None

Status

Assignee

Carlos Ruiz

Reporter

Hiep Lq

Labels

Tested By

None

Priority

Major