[arquillian-issues] [JBoss JIRA] (ARQ-1444) Oracle does not support query delimiter inside statements

[Michel Graciano (JIRA)]

    [ https://issues.jboss.org/browse/ARQ-1444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12985217#comment-12985217 ] 

Michel Graciano commented on ARQ-1444:
--------------------------------------

I will update the Reference Guide later today, but I need to get all the possible values so I will need some time to dig the source code.
Maybe you have some 'cache' for your arquillian file, or some tests run with different version of this file? I think here is not the place for this discussion, maybe you can add more details in the forum reference https://community.jboss.org/message/807298#807298.

Regards

> Oracle does not support query delimiter inside statements
> ---------------------------------------------------------
>
>                 Key: ARQ-1444
>                 URL: https://issues.jboss.org/browse/ARQ-1444
>             Project: Arquillian
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: Extension - Persistence
>    Affects Versions: persistence_1.0.0.Alpha6
>         Environment: Oracle Database.
>            Reporter: Michel Graciano
>            Assignee: Bartosz Majsak
>             Fix For: persistence_1.0.0.Alpha7
>
>
> When we try to use @ApplyScriptBefore and the script file has more than one statement, we use ; as delimiter. The problem is that the delimiter is not removed from the statement before run it, so Oracle database return the following exception:
> Caused by: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)