Occured error when install "WEB-API"

11112 · December 19, 2018, 3:58am

Hi I’m a biginer in atlaas user.
So I want to install all of System.

But I was just doing install “webapi” continueously occur error.

when I type
“mvn clean package -s WebAPIConfig/settings.xml -P webapi-oracle”
this comman Line. and it work.

put error message like this.

“”
[ERROR] Failed to execute goal on project WebAPI: Could not resolve dependencies for project org.ohdsi:WebAPI:war:1.0.0-SNAPSHOT: Failure to find ojdbc:ojdbc:jar:14 in http://repo.maven.apache.org/maven2/ was cached in the local repository, resolution will not be reattempted until the update interval of central has elapsed or updates are forced -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
“”

please give me a solution.

Chris_Knoll · December 19, 2018, 9:37am

Try to replace your pom.xml with the latest pom.xml from master:

github.com

OHDSI/WebAPI/blob/master/pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <groupId>org.ohdsi</groupId>
  <artifactId>WebAPI</artifactId>
  <packaging>war</packaging>
  <version>2.9.0-SNAPSHOT</version>
  <name>WebAPI</name>
  <properties>
    <build.number>${BUILD_NUMBER}</build.number>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <!-- Spring Boot manages spring.version as well -->
    <spring.boot.version>1.5.22.RELEASE</spring.boot.version>
    <flyway.version>4.2.0</flyway.version>
    <waffle.version>2.2.1</waffle.version>
    <jna.version>5.5.0</jna.version>
    <hibernate.version>5.4.2.Final</hibernate.version>
    <postgresql.version>42.2.18</postgresql.version>

This file has been truncated. show original

This version of the file contains a new reference to an oracle driver, the change can be seen here:

11112 · January 4, 2019, 8:15am

Thanks for your favor.

Thanks to your advice. I can pass that.
But I face to the other error in tomcat.

It show that in ‘FLYWAY’ can’t migration.

As it possible how can I resolve that.

(P.S)
I installed oracle 11g in my local pc.

Chris_Knoll · January 4, 2019, 4:26pm

On oracle, when a migration fails, the database maybe left in an inconsistent state because DDL statements (such as alter/create tables) are not transactional. Therefore, the easiest way to resolve the error is to go to a backup of your database, and deploy again.

If you have the choice, I would host the WebAPI database on postgresql. It handles migrations in a transnational way, and it’s easier to restart a failed migration.