How to use JDBC in native command line app?

[mlbiam]

I'm building a k8s operator that needs to be able to use JDBC from included drivers (MySQL, MariaDB, SQL Server, etc) with arbitrary URLs and credentials. I found https://quarkus.io/guides/datasource, but this won't match my needs. I built a very simple command line POC that connects to a db and runs a query using typical JDBC:

Connection con = DriverManager.getConnection("jdbc:mariadb://192.168.2.139:31435/unison107","unison107","start123");
        
        ResultSet rs = con.createStatement().executeQuery("SELECT * FROM targets");
        System.out.println("pulling data");
        while (rs.next()) {
            System.out.println(rs.getString("name"));
        }
        rs.close();
        System.out.println("done");

when I run ./mvnw quarkus:dev, this works as expected. When I compile to a native executable, I get

2022-01-14 10:24:05,017 ERROR [io.qua.run.Application] (main) Failed to start application (with profile prod): java.sql.SQLException: No suitable driver found for jdbc:mariadb://192.168.2.139:31435/unison107
        at java.sql.DriverManager.getConnection(DriverManager.java:702)
        at java.sql.DriverManager.getConnection(DriverManager.java:228)
        at org.acme.getting.started.GreetingMain.run(GreetingMain.java:21)
        at org.acme.getting.started.GreetingMain_ClientProxy.run(Unknown Source)
        at io.quarkus.runtime.ApplicationLifecycleManager.run(ApplicationLifecycleManager.java:125)
        at io.quarkus.runtime.Quarkus.run(Quarkus.java:67)
        at io.quarkus.runtime.Quarkus.run(Quarkus.java:41)
        at io.quarkus.runner.GeneratedMain.main(Unknown Source)

I know there are constraints on how dynamic native executables can be. is what I'm trying to do possible with native?

Thanks
Marc

[maxandersen]

If You today need dynamic loading you need non-native. No way around it.

If you insist on having one native image being able to support multiple databases you need to build all the drivers into the native image and declare multiple data sources with all the db types listed.

You native image will be big and compile times high and you'll need to rebuild to do updates to the libraries.

So yes it's possible but you'll have to consider if it is worth it for your case.