Jar file contains MySQL

[jpaulm]

The jar file contains MySQL because of ReadJDBC and WriteJDBC - we need to find a way to defer this, probably using ClassLoader

[jpaulm]

Looking at the jar file for javafbp, I see about 11 Mb of MySQL and ProtoBuf, combined - JavaFBP itself is about 0.5 Mb. Needless to say, I'd like to carve off the MySQL, etc., stuff.

I think there are a couple of ways, just blue-skying for now:

• carve through the component method in the network definitions. However, this would mean intercepting every API call, and adding a level of indirection...

• (better) separate mysql jar file from FBP-related logic and use Java reflection in MySQL-related components

• (just added) imbed ReadJDBC and WriteJDBC in dynamic subnets (SubNet will need some tweaks)

Will keep you posted... input would be appreciated, of course!

[jpaulm]

I now have a working version of ReadJDBC which uses reflection and names the MySQL jar file (in user\.m2\repository) - partial:

    File f = new File("C:\\Users\\" + userName + "\\.m2\\repository\\mysql\\mysql-connector-java\\8.0.21\\mysql-connector-java-8.0.21.jar");		
URL[] urls = {f.toURI().toURL()};
URLClassLoader ucl = new URLClassLoader(urls);
Class<?> conn_cls = ucl.loadClass("java.sql.Connection"); 
     ....    

The problems are: a) version number is hard-wired, and b) it is Eclipse-dependent (the MySQL jar file may be in different places

Ideally, I'd like to get it from Maven, but I'm not sure how to download the file, and then do a new File() on it!

Don't know how many people are watching this... but help would be appreciated!