[RAVE-502] Unable to load an initial_data.sql file in Oracle

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.8-INCUBATING
• Fix Version/s: 0.9-INCUBATING
• Assignee: Tony Carlucci
• Reporter: Tony Carlucci
• Created: 02/Mar/12 21:05
• Updated: 16/Apr/12 18:59
• Resolved: 02/Mar/12 21:14

Description

When loading an initial_data.sql file in Oracle the o.a.r.jdbc.util.DataSourcePopulator fails with an "Invalid operation for forward only resultset : first". This is because the Statement is producing a non-scrollable ResultSet.

Fix: Create the Statement with a ResultSet.TYPE_SCROLL_INSENSITIVE flag.