topic Activiti on a tomcat docker container doesn't work with oracle database ?!? in Alfresco Forum

Activiti on a tomcat docker container doesn't work with oracle database ?!?

delimaniac — Fri, 26 May 2017 14:25:02 GMT

Hello there,I am gonna use activiti for a java spring project, so i started to study activiti. 1. Scenario : I used tomcat 8 and activiti 5.22.0 and oracle 11g R2 on my localhost machine. I created a schema, user activiti password activiti. I put ojdbc6.jar into WEB-INF/classes/lib. I chan

Re: Activiti on a tomcat docker container doesn't work with oracle database ?!?

afaust — Fri, 26 May 2017 15:43:16 GMT

Ehm - are you sure your JDBC URL is correct? I would not use "localhost" in that case unless the Oracle database is running in the same container.

Re: Activiti on a tomcat docker container doesn't work with oracle database ?!?

Anonymous — Sat, 27 May 2017 07:46:11 GMT

The stack trace indicates the following cause.

Caused by: java.net.ConnectException: Connection refused (Connection refused)

Can your docker container access Oracle database(Host machine localhost:1521)?

Re: Activiti on a tomcat docker container doesn't work with oracle database ?!?

delimaniac — Sat, 27 May 2017 13:19:16 GMT

I guess my JDBC URL is correct. In my 1. scenario, i used same db.properties file and same application-custom-context.xml and it worked. I mean activiti-explorer worked with same oracle database (same jdbc url) on my local machine. By local machine, i mean my own computer and oracle db was installed on a container. It wouldn't work with the same logic you pointed i guess. Im a newbie, I'm open to suggestions don't get me wrong, i just try to understand.

Re: Activiti on a tomcat docker container doesn't work with oracle database ?!?

delimaniac — Sat, 27 May 2017 13:20:16 GMT

How should i test it ?

Re: Activiti on a tomcat docker container doesn't work with oracle database ?!?

afaust — Sun, 28 May 2017 13:22:41 GMT

The JDBC URL is fine if Activiti is running directly on the host and only Oracle DB was installed in a container. But if Activiti is installed in its own container you cannot use localhost as that would refer to only that container. In that case you should either use the name/address of the container for the Oracle DB, or the docker host that forwards ports to the Oracle DB container.

Re: Activiti on a tomcat docker container doesn't work with oracle database ?!?

delimaniac — Sun, 28 May 2017 18:19:14 GMT

Thank you for the explanation. I will give it a try.

Edit :
I got same errors. I couldnt two containers connected to each other i guess. Can you help me more ? Any advice ?

This is my new docker-compose file :

version: '2.1'
services:
  actexplorer:
    build: .
    ports:
      - '8080:8080'
    depends_on:
      - oracle
    links:
      - oracle
  oracle:
      image: my oracle image(i cant give full image name sorry, its private)
      ports:
        - "1521:1521"
        - "8081:8080"
      environment:
        USERS: ACTIVITI
        PASSWORDS: ACTIVITI
      tty: true

Edit 2 : Ok. This is my second attempt without docker compose :
1 - docker network create --driver bridge isolated_network
2 - I typed docker run -it --net=isolated_network --name oracle -e USERS=ACTIVITI -e PASSWORDS=ACTIVITI -p 1521:1521 -p 8081:8080 myoracleimage
3 - oracle ran perfectly.
4- I typed docker run -it --net=isolated_network --name activiti -p 8080:8080 activiti_actexplorer
5 - It worked as before. Tomcat works but activiti does not work.
6 - In activiti container bash, i typed 'ping oracle' and it got response. Like this :
PING oracle (172.18.0.2): 56 data bytes
64 bytes from 172.18.0.2: icmp_seq=0 ttl=64 time=0.104 ms
64 bytes from 172.18.0.2: icmp_seq=1 ttl=64 time=0.098 ms
64 bytes from 172.18.0.2: icmp_seq=2 ttl=64 time=0.065 ms
64 bytes from 172.18.0.2: icmp_seq=3 ttl=64 time=0.063 ms

However, i got the same errors while step 4 was processing.

In addition, I changed my db.properties like this :

db=oracle
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@oracle:1521:XE
jdbc.username=ACTIVITI
jdbc.password=ACTIVITI

What did i do wrong ? Activiti explorer still does not work on tomcat

Edit 3: Okay. I forgot to edit jdbc url in activiti-custom-context.xml It works now. However, it works with docker run commands, i need same networking in docker-compose file ? Do you have any advice ?

Edit 4: I managed to get activity-explorer work with docker-compose file. Here is my docker-compose solution :

version: '2.1'
services:
  actexplorer:
    build: .
    ports:
      - '8080:8080'
    depends_on:
      oracle:
        condition: service_healthy
  oracle:
    image: my oracle image
    ports:
      - "1521:1521"
      - "8081:8080"
    environment:
      USERS: ACTIVITI
      PASSWORDS: ACTIVITI
    healthcheck:
      test: "exit 0"
    tty: true

Hope this helps everyone.