JDBC Parameters Behavior

Question to clarify the new behavior:

in the past, if you changed the JDBC driver, all JDBC parameters got reset / removed.
Now, you added the setting to default to the latest driver version.

What is the expected behavior once a new driver becomes available?
Will all JDBC Parameters be deleted / kept?

image

or is there any documentation available about the DB nodes that describe the actual behavior?
swapping the driver resulting in the parameters getting cleared seemed always wrong to me / undocumented behavior

Hello @fe145f9fb2a1f6b ,
sorry for the late reply.

If the driver gets automatically updated because you have selected the “Use latest driver version available” option the JDBC parameter stay as they are.

If you manually change the driver the parameter get reset. The reason for this is that some driver updates in the past did come with behavior changes that required us to preset some parameters in order to retain the behavior.

I agree that this decision might not be the best. So we will remove the auto-reset of the JDBC parameters when we migrate the node dialog to the modern UI framework.

Bye
Tobias

2 Likes

sounds reasonable. especially if someone ends up forced to drop to a previous driver from the latest and that finally will not cause the JDBC parameters to be dropped