0042163: Grid timeout returns unclear message in the backoffice

Description

The grid timeout returns unclear message to the user:

org.hibernate.exception.GenericJDBCException: could not extract ResultSet

Steps To Reproduce

Define low value to db.queryTimeout.grid in Openbravo.properties.

Open a window in the backend and filter the window to provoke a timeout.

The grid shows the unclear message.

Proposed Solution

Handle the hibernate exception to show better message to the user.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0042153

closed

alostale

Grid timeout returns unclear message in the backoffice

Notes
(0115400) hgbot (developer) 2019-11-05 09:16	Repository: erp/backports/3.0PR19Q2.4 Changeset: d65560d0a983a400bb7235263d74ca7acdfc8e76 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Oct 31 09:05:28 2019 +0100 URL: http://code.openbravo.com/erp/backports/3.0PR19Q2.4/rev/d65560d0a983a400bb7235263d74ca7acdfc8e76 [^] fixed bug 42163: grid timeout returns unclear message When a query timeout occurs fetching grid data, the message displayed in UI is not user friendly. This is caused by different exception thrown after Hibernate upgrade. --- M modules/org.openbravo.service.json/src/org/openbravo/service/json/JsonUtils.java ---

(0115410) AugustoMauch (manager) 2019-11-05 11:00	Code reviewed and verified

Issue History
Date Modified	Username	Field	Change
2019-10-31 09:11	alostale	Type	defect => backport
2019-10-31 09:11	alostale	Target Version	=> 3.0PR19Q2.4
2019-11-05 09:16	hgbot	Checkin
2019-11-05 09:16	hgbot	Note Added: 0115400
2019-11-05 09:16	hgbot	Status	scheduled => resolved
2019-11-05 09:16	hgbot	Resolution	open => fixed
2019-11-05 09:16	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/backports/3.0PR19Q2.4/rev/d65560d0a983a400bb7235263d74ca7acdfc8e76 [^]
2019-11-05 11:00	AugustoMauch	Note Added: 0115410
2019-11-05 11:00	AugustoMauch	Status	resolved => closed