[
https://issues.apache.org/jira/browse/RAVE-502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13222417#comment-13222417
]
Anthony Carlucci commented on RAVE-502:
---------------------------------------
Unfortunately no...once I fixed this issue I'm running into a problem with the
SqlFileParser class that tries to filter out invalid statements and isn't
taking into account certain Oracle keywords like DECLARE, BEGIN, etc. Also, to
define a variable in Oracle the syntax looks like:
myVar NUMBER(10);
so there is no SQL keyword in front, and thus the SqlFileParser will never
execute these lines. I decided to run our Oracle initial_data.sql files
manually, as you had written up in the documentation, instead. Given that our
reference implementation is running on H2 I didn't want to start changing the
SqlFileParser / DataSourcePopulator classes. Do we (the community) think we
need to support other databases besides H2 using the DataSourcePopulator
feature?
> 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
