[SM-1816] AuditMBean getExchangeByRante() method returns java.sql.SQLException: Invalid cursor state - no current row when no exchange present yet

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.3
• Component/s: servicemix-audit

Environment

Linux Debian 5.0
JVM Sun 1.5.0_14
ServiceMix 3.3

• Assignee: Unassigned
• Reporter: Jean-Baptiste Onofré
• Created: 26/Feb/09 14:59
• Updated: 26/Mar/13 13:36
• Resolved: 26/Mar/13 13:36

Description

Using JMX client, I start the JdbcAuditor service.

When I call the getExchangeByRange() method on the AuditorMBean, if no exchange are stored in the audit derby database, I get :

java.sql.SQLException: Invalid cursor state - no current row.

The AuditorMBean should be able to return an empty list.

The current workaround is to call getExchangeCount() to check if some exchange are stored and after call getExchangeByRange().