Hard to figure out what's wrong without more details about your setup, but your Hop Web container probably can't reach your network or doesn't know how to resolve your database's host name. Does it make a difference if you use the database server's IP address instead of the hostname?
Regards, Bart On Mon, Apr 15, 2024 at 5:55 PM <[email protected]> wrote: > Hello Apache Hop User, > > I created my own Apache Hop Web image in order to be able to connect with > an oracle database that is in our network (==outside the container network) > via Apache Hop Web > > > FROM apache/hop-web > > USER root > > COPY --chown=hop:hop ./PlugIns/OracleLib/lib > /usr/local/tomcat/plugins/databases/oracle/lib > COPY --chown=hop:hop ./PlugIns/postgressqlLib/lib > /usr/local/tomcat/plugins/databases/postgressql/lib > > EXPOSE 1521 > > USER hop > > > When I run Apache Hop in the meta setting I can see that the Oracle Jdbc > Driver has been correctly recognized > > But > > When I try to connect with the database I get always this error > ORA-17868: Unknown host specified.: servernameText*replaced*: Name or > service not known > > It looks like Apache Hop web can't see the server. > > I tried to run the container with > --network host > but this was not successful > > > Any idea? (with apache hop Desktop it works without issue) > > Thank you in advance > Michel > >
