You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@rave.apache.org by "Anthony Carlucci (Created) (JIRA)" <ji...@apache.org> on 2012/03/02 22:05:57 UTC
[jira] [Created] (RAVE-502) Unable to load an initial_data.sql file
in Oracle
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
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
[jira] [Commented] (RAVE-502) Unable to load an initial_data.sql
file in Oracle
Posted by "marijan milicevic (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/RAVE-502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13222419#comment-13222419 ]
marijan milicevic commented on RAVE-502:
----------------------------------------
please also see discussion (Matt's reply) @:
https://issues.apache.org/jira/browse/RAVE-392
> 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
[jira] [Commented] (RAVE-502) Unable to load an initial_data.sql
file in Oracle
Posted by "Jasha Joachimsthal (Commented) (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Commented] (RAVE-502) Unable to load an initial_data.sql
file in Oracle
Posted by "Anthony Carlucci (Commented) (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Resolved] (RAVE-502) Unable to load an initial_data.sql
file in Oracle
Posted by "Anthony Carlucci (Resolved) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/RAVE-502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anthony Carlucci resolved RAVE-502.
-----------------------------------
Resolution: Fixed
Fix Version/s: 0.9-INCUBATING
> 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