I'm trying to connect oracle db from AEM end using "JDBC Datasources for the Datasource Pool Service" .
I'm having successful connection for some time after that I'm getting error like ::"SQLException : No more data to read from socket"
to resolve that I'm providing select 1 from dual in OSGI console for validation query but still I'm getting same error to resolve this every time It requires to refresh the bundle.
I'm suing Database: Oracle (ver. Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning.
Any help to resolve this that would be really appreciated.
This issue even we have faced many a times and still facing.
this will start to work when you go and save the datasource. but this is not the solution.
also the link you suggested, has many parameters to set like as below. Need to know how do we setup the additional properties in datasource creation