[arquillian-issues] [JBoss JIRA] (ARQ-1444) Oracle does not support query delimiter inside statements
[
https://issues.jboss.org/browse/ARQ-1444?page=com.atlassian.jira.plugin.s...
]
Rafael Pestano commented on ARQ-1444:
-------------------------------------
Hi guys,
sorry for bothering you, <extension qualifier="persistence-script">
<property name="sqlDialect">oracle</property>
</extension>
really solves the issue with the delimite.
The clue here is to use TestExecutionPhase.AFTER to see the real error cause after solving
the delimiter problem i was receiving a constaint exception and the error was hidden in
BEFORE phase.
thanks
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)