WebPI Flyway migration error on Oracle database

Anaxymenes · June 5, 2018, 1:29pm

Hello all.
I have a little problem with connecting WebAPI to oracle database. After deploy WebAPI.war on tomcat server, I’ve got a error " Schema “” contains a failed migration to version 1.0.6.0.1 ! ". I also noticed that the oracle migration files contain commands from postgresql. I am asking for help and thank you in advance

Chris_Knoll · June 6, 2018, 12:34am

Here’s the file in question:

github.com

OHDSI/WebAPI/blob/master/src/main/resources/db/migration/oracle/V1.0.6.0.1__schema-add-analysis_execution_password.sql

ALTER TABLE ${ohdsiSchema}.cca_execution ADD CONSTRAINT PK_cca_execution PRIMARY KEY (cca_execution_id);

CREATE TABLE ${ohdsiSchema}.cca_execution_ext (
  cca_execution_id INTEGER NOT NULL,
  update_password  VARCHAR2(255)
);

CREATE TABLE ${ohdsiSchema}.input_files
(
  id               NUMBER(19),
  cca_execution_id NUMBER(19)                 NOT NULL,
  file_contents    BLOB,
  file_name        VARCHAR2(255) NOT NULL,
  CONSTRAINT input_files_pkey PRIMARY KEY (id)
);

ALTER TABLE ${ohdsiSchema}.input_files
  ADD CONSTRAINT fk_sof_cca_execution FOREIGN KEY (cca_execution_id)
  REFERENCES ${ohdsiSchema}.cca_execution (cca_execution_id)
  ON DELETE CASCADE;

This file has been truncated. show original

Can you open up a webAPI issue in github on this? Also if you have the oracle expertise to correct the script, that would be very helpful.

-Chris

richawilliams · July 20, 2018, 6:52am

Hai,
As i am new to this one. As per my Knowledge i am sharing my idea with you. The problem with connecting WebAPI to Oracle Database is authenticate a Tomcat7 webapp (Server 1) using KeyCloak 4.0.0 (deployed on Server 2). But, each time I try to develop a WAR on Tomcat (Server 1).

Thanks,
Riya

Chris_Knoll · July 20, 2018, 7:34pm

I’m sorry, I’m not familiar with authentication to Oracle using KeyCloak. However, WebAPI is just a java application, so if you have an example of how that works using a simple Java example, we could work on a new enhancement that supports that mechanism for connection.