ODBC in Docker Container

[Matthias Caesar]

Copying from GitHub:

Provide one or more Orbeon Forms Docker images · Issue #3321 · orbeon/orbeon-forms (github.com)

"Hi @avernet I downloaded the driver files from mySQL.com too and placed them in the ./lib folder but this did not have the desired effect. What information would you need from me to help. I would want to try to setup Orbeon in a local docker to test and evaluate. Thanks a mil!"

Would be great if you could help us with our evaluation.

Thanks a mil!

Matthias

[Alessandro Vernet]

Hi Matthias,

I feel like I'm missing some information. How are you creating the Docker image? Is MySQL running in a separate container, or the same container? Have you done the required setup at the Orbeon, Tomcat, and MySQL level for that database (more on this on the page linked below)?

https://doc.orbeon.com/form-runner/persistence/relational-db

-Alex

[Alessandro Vernet]

Hi Matthias,

Did you get a chance to make some progress on that setup with Docker and MySQL? If so, did things work out for you, or did you hit any other issue along the way?

-Alex

[Matthias Caesar]

This is my config:

I can create a form but not save it. The database connection is wrong.

This is the error message:

BTW, already when I create a new form, I get this message:

Any idea what I am doing wrong?

Thank you so much for your help!

Matthias

[Matthias Caesar]

I am using  Dyomedea/orbeon-docker: Docker images for Orbeon Forms - orbeon-docker - Gitea: Git with a cup of tea.

The instance starts just fine using this docker config. I can create a form and all. Only when I want to Save or Publish, the ODBC connection is needed to store the form in the database. That is where it stops working.

So any information, any hint regarding how the ODBC connect might be setup in docker is highly appreciated.

Thank you so much, Alessandro!

Matthias

Alessandro Vernet schrieb am Mittwoch, 23. Februar 2022 um 02:57:24 UTC+1:

[Matthias Caesar]

Seems to be this error, related to ODBC, no?

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1364)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1185)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:483)

Alessandro Vernet schrieb am Mittwoch, 23. Februar 2022 um 02:57:24 UTC+1:

[Matthias Caesar]

I am trying to make  Dyomedea/orbeon-docker: Docker images for Orbeon Forms - orbeon-docker - Gitea: Git with a cup of tea work.

The issue is still that I have no idea how to configure a working instance of the ODBC Connector using docker.
The Oberon instance I created with this docker container works. It starts, all fine. Onle no database connection can be established.
Any hints how ODBC can be put to work in this scenario are very welcome. 

Thank you so much, Alessandro!

Alessandro Vernet schrieb am Mittwoch, 23. Februar 2022 um 02:57:24 UTC+1:

[Alessandro Vernet]

Hi Matthias,

I don't have any experience with those Docker images. You mention ODBC, but I think you're referring to JDBC, or more generally the connection between Tomcat / Orbeon Forms and MySQL, correct?

In your message from March 4, you quoted the error "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver". This seems to indicate that the MySQL JDBC driver is missing on the Tomcat / Orbeon Forms side. Have you copied the driver to `mysql/tomcat/lib/`, as mentioned on the page linked below?

https://gitea.dyomedea.com/Dyomedea/orbeon-docker

-Alex

[Matthias Caesar]

Yes, I think.
Isn't that what I did in the config I shared? Sorry if this is a very basic question.
See image above:

[Alessandro Vernet]

Hi Matthias,

Ah, yes, that seems correct. And you're saying that with this you're getting the error "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" in the log?

-Alex