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

[Rafael Pestano (JIRA)]

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

Rafael Pestano commented on ARQ-1444:
-------------------------------------

Hi guys,

is this issue really resolved?

im trying to clean a oracle db using @CleanupUsingScript or @ApplyScriptAfter/Before and still having ORA-00911: invalid character in Alpha.

My scripts are simple DELETE from TABLE;


my arquillian.xml is as follows:

<extension qualifier="persistence-dbunit">
		<property name="schema">TR_DETRAN_RED_AD</property>
       <!-- <property name="datatypeFactory">org.dbunit.ext.oracle.Oracle10DataTypeFactory</property>-->
 	  <property name="filterTables">true</property>
 		<!--<property name="filterForeignKeysEnabled">false</property>-->
 		<!--<property name="customTableFilter">org.jboss.arquillian.persistence.dbunit.filter.OracleDatabaseSequenceFilterProvider</property>-->
	</extension>

    <extension qualifier="persistence">
        <property name="defaultDataSource">java:jboss/datasources/RedTesteDS</property>
        <!--<property name="defaultDataSeedStrategy">CLEAN_INSERT</property> -->
<!--         <property name="defaultCleanupPhase">NONE</property> -->
        <property name="dumpData">false</property>
    </extension>

    <!-- <extension qualifier="persistence-script">
        <property name="sqlStatementDelimiter">;</property>
    </extension>  -->


thanks in advance.


> 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)