Why am I not able to establish a JDBC connection with the "database" function when compiled using MATLAB Compiler R2021b onwards?

I am trying to connect to a JDBC-based database. I am compiling my code using MATLAB Compiler R2023a and trying to run the compiled code. However, I encounter the following error:

Unable to connect to database or to the URL in the tnsNames file

The issue occurs when the app is compiled using MATLAB Compiler R2021b onwards. The error is thrown when trying to run the compiled app, but there is no error thrown while compiling the app. The app works as expected when run as a script in MATLAB but does not work when run after compiling it.

How can I compile my application using newer versions of MATLAB Compiler and successfully establish a JDBC connection from my deployed application?

Answer 1

[MathWorks Support Team]

Prior to MATLAB Compiler R2021b, the contents of MATLAB's preference folder were captured in the standalone application. This became untenable and unnecessarily increased the size of the standalone application with a lot of files that weren't required for its execution. Hence, it was removed from the future releases of MATLAB Compiler. One such file was the “javalibrarypath.txt” file. However, in some cases, it is necessary to include the path to the JDBC driver in a “javalibrarypath.txt” file for the standalone application.

While compiling, you can force its inclusion by adding the “-a” option to your “mcc” command and adding the path to the “javalibrarypath.txt” file. Please refer to the following link for more information:

https://www.mathworks.com/help/compiler/mcc.html#mw_7edfbe05-4c1e-41bf-bb6f-bb7b35ad49a0

For example:

mcc -a C:\Users\<user>\AppData\Roaming\MathWorks\MATLAB\<matlab_version>\javalibrarypath.txt