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

[Josef Schauer (JIRA)]

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

Josef Schauer commented on ARQ-1444:
------------------------------------

We try the same for db2 and get an error, too. 
It's the same reason like the error in oracle.

Caused by: org.jboss.arquillian.test.spi.ArquillianProxyException: com.ibm.db2.jcc.am.SqlSyntaxErrorException : DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;DELETE FROM ADDRESS;END-OF-STATEMENT, DRIVER=3.65.77 [Proxied because : Original exception not deserilizable, ClassNotFoundException]




                
> 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
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira