[
https://issues.apache.org/jira/browse/RAVE-502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13222254#comment-13222254
]
Jasha Joachimsthal commented on RAVE-502:
-----------------------------------------
Are the SQL statements in initial_data.sql now compatible with Oracle? In
http://incubator.apache.org/rave/documentation/configure-database.html we have
a minimal set of queries necessary to run the portal with a completely
different SQL syntax.
> Unable to load an initial_data.sql file in Oracle
> -------------------------------------------------
>
> Key: RAVE-502
> URL: https://issues.apache.org/jira/browse/RAVE-502
> Project: Rave
> Issue Type: Bug
> Affects Versions: 0.8-INCUBATING
> Reporter: Anthony Carlucci
> Assignee: Anthony Carlucci
> Priority: Minor
> Fix For: 0.9-INCUBATING
>
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
