Arbitrary JDBC connect string / jar file support

[tom-dyar]

I would like to be able to connect to more databases, such as snowflake, but ARX GUI (and the library?) only supports certain databases.

It would be great to be able to specify an arbitrary JDBC connection string, and be able to point ARX to a jar file that supports that connection string.

[prasser]

Thanks for your interest in ARX! This limitation does not exist in the ARX library, it only affects the GUI. It would be relatively easy to implement a method for dynamically loading the JDBC driver through the GUI. I won't have the time to do this, however, in the foreseeable future. Maybe you could try to enhance ARX in this regard?

[tom-dyar]

Thanks, Dr. Prasser,

So I guess this would entail:

• adding a new drop-down option
• Implement a dialog to configure for JDBC, that would include:
• select .jar file, and then code would enumerate the driver classes in the jar
• select driver class

Then this information needs to be used to instantiate the data source object, perhaps after a "classforname" call?

I also don't have time to implement this right now, but it is good to scope out the work in case someone else would like this feature.

[prasser]

Thomas, thanks for your effort! The outline of the changes sounds reasonable. Maybe this gets picked up by someone willing and able to contribute.