Hi Team, We have a oracle Ds file which stops working time to time. T

Hi Team,

We have a oracle Ds file which stops working time to time. The error which user see on the screen is Details”. [Unable to connect to database: javax.resource.ResourceException: IJ000453: Unable to get managed connection for jdbc/ABC].
After we redeploy the DS file datasource starts working as expected but this is not a permanent soulution for us. I have checked the maximum pool size is already set to 250. Kinldy suggest

Thanks,
...

OriginalPostID-116728

OriginalPostID-116728

  Discussion posts and replies are publicly visible

Parents
  • Hi Ed,
    We implemented the change and addes the above suggested tag in ds file changing the Word DUAL with one of the table name. But after few hours we faced the same issue and the we redeployed the ds.
    Can you please help to trouble shoot taking into consideraion the other possiblity you mentioned that some plugin not working poperly or not closing all the connection properly..Please suggest the next steps towards the solution.

    Thanks,
    Rahul
Reply
  • Hi Ed,
    We implemented the change and addes the above suggested tag in ds file changing the Word DUAL with one of the table name. But after few hours we faced the same issue and the we redeployed the ds.
    Can you please help to trouble shoot taking into consideraion the other possiblity you mentioned that some plugin not working poperly or not closing all the connection properly..Please suggest the next steps towards the solution.

    Thanks,
    Rahul
Children
No Data