You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by pp...@apache.org on 2021/11/11 16:28:12 UTC
[camel-quarkus] branch main updated: Sql tests with external oracle
database fail #3256
This is an automated email from the ASF dual-hosted git repository.
ppalaga pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/camel-quarkus.git
The following commit(s) were added to refs/heads/main by this push:
new ff97e82 Sql tests with external oracle database fail #3256
ff97e82 is described below
commit ff97e825984022a10b5c97db69d11c3846f81610
Author: JiriOndrusek <on...@gmail.com>
AuthorDate: Fri Nov 5 13:15:48 2021 +0100
Sql tests with external oracle database fail #3256
---
.../java/org/apache/camel/quarkus/component/sql/it/SqlResource.java | 1 +
integration-tests/sql/src/main/resources/sql/oracle/initDb.sql | 6 ++++++
2 files changed, 7 insertions(+)
diff --git a/integration-tests/sql/src/main/java/org/apache/camel/quarkus/component/sql/it/SqlResource.java b/integration-tests/sql/src/main/java/org/apache/camel/quarkus/component/sql/it/SqlResource.java
index 702b5ba..464ac63 100644
--- a/integration-tests/sql/src/main/java/org/apache/camel/quarkus/component/sql/it/SqlResource.java
+++ b/integration-tests/sql/src/main/java/org/apache/camel/quarkus/component/sql/it/SqlResource.java
@@ -166,6 +166,7 @@ public class SqlResource {
switch (dbKind) {
case "db2":
case "mssql":
+ case "oracle":
case "mariadb":
case "mysql":
List<LinkedCaseInsensitiveMap> addNumsResults = producerTemplate.requestBody(
diff --git a/integration-tests/sql/src/main/resources/sql/oracle/initDb.sql b/integration-tests/sql/src/main/resources/sql/oracle/initDb.sql
index 234247d..5884e1a 100644
--- a/integration-tests/sql/src/main/resources/sql/oracle/initDb.sql
+++ b/integration-tests/sql/src/main/resources/sql/oracle/initDb.sql
@@ -35,3 +35,9 @@ DROP TABLE aggregation
CREATE TABLE aggregation (id VARCHAR2(255) NOT NULL, exchange BLOB NOT NULL, version INT, PRIMARY KEY (id))
DROP TABLE aggregation_completed CASCADE CONSTRAINTS
CREATE TABLE aggregation_completed (id VARCHAR2(255) NOT NULL, exchange BLOB NOT NULL, version INT, PRIMARY KEY (id))
+
+-- stored procedure
+DROP TABLE ADD_NUMS_RESULTS
+CREATE TABLE ADD_NUMS_RESULTS(id NUMBER GENERATED BY DEFAULT AS IDENTITY, value NUMBER NOT NULL, PRIMARY KEY(id))
+DROP PROCEDURE ADD_NUMS
+CREATE PROCEDURE ADD_NUMS (a IN NUMBER, b IN NUMBER) IS BEGIN insert into ADD_NUMS_RESULTS (id, value) VALUES (1, a + b); END;