UDR module

[Wan-Derer]

Hi! I'm trying to use Tescontainers with firebirdsql/firebird:5.0.2 container. My scenario is:

• start container;
• copy my Master DB into it as /var/lib/firebird/data/test.fdb;
• copy data.sql file with some INSERT commands;
• execute command "isql -i data.sql, test.fdb" to populate the DB.

I receive the error:
Statement failed, SQLSTATE = HY000
UDR module not loaded
-/opt/firebird/plugins/udr/libbvUDRCore.so: cannot open shared object file: No such file or directory
After line 0 in file /var/lib/firebird/data/data.sql

How can I fix the error?

[mrotteveel]

Have you installed the UDR library (libbvUDRCore.so) into the container?

As an aside, this doesn't seem to be a firebird-testcontainers-java issue (a library for using the Firebird Docker image for unit tests in Java), but an issue with using the Firebird Docker image, as none of your steps seem to involve Java.

[Wan-Derer]

Sorry if my question is offtop. But how can I get this library? Or where can I ask my question?

[mrotteveel]

That is not a standard UDR library (i.e. it is not part of Firebird itself), so you need to ask whoever developed/created this database.

[mrotteveel]

The error itself happens because the database contains a stored procedure, stored function, or trigger that is implemented as a UDR (User-Defined Routine), and something in your SQL code is causing it to be used (e.g. by using a function, or a trigger firing on insert, etc.). To be able to use it, the UDR library must be available to the server (i.e. installed in the /opt/firebird/plugins/udr/ directory, or with a custom UdfAccess setting in the firebird.conf, another location).

[mrotteveel]

In short, for your immediate problem, you need to contact the developers or vendor of the database.

For general Firebird help, you can use https://groups.google.com/g/firebird-support