Hi,
Our application has an requirement of handling failover/overload in backend access components. (Any suggestions other than mentioned below to handle runtime FAILURE/SUSPEND/OVERLOAD OF DATASOURCE is appreciated)
since i am a newbie in
JDBC and datasource i need some clarifications on jdbc datasource.
i have a datasource DS1
associated with connectionpool CP1 , max connection capacity - 50
if i create new datasource DS2 n associate with CP1.
In runtime how many connections can be provided to our application , 100 or still 50 ?
How deeply connection objects are associated with the Datasource ?
If the above question holds good and DS1 datasource fails in runtime , do i need to transfer all the active jdbc connections to DS2, in order to perform a safe switch ?
thanks and regards
raghavendra