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

Tuesday, 15 July 2014

    [
https://issues.jboss.org/browse/ARQ-1444?page=com.atlassian.jira.plugin.s...
] 

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)

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009