How to Create one DB connection per executor and close it after the job is done?

[kant kodali]

Hi All,

I understand creating a connection forEachPartition but I am wondering can
I create one DB connection per executor and close it after the job is done?
any sample code would help. you can imagine I am running a simple batch
processing application.

Thanks!