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

gauravp over 10 years ago

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,
...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

If the database becomes unavailable for a certain period of time and your appian-ds.xml is not configured to automatically reconnect then you have to restart the application server /redeploy. You can add the following to make sure the app server will try to reconnect (replace the word DUAL with the name of any table in that DB)

<validation>
<check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
</validation>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

If the database becomes unavailable for a certain period of time and your appian-ds.xml is not configured to automatically reconnect then you have to restart the application server /redeploy. You can add the following to make sure the app server will try to reconnect (replace the word DUAL with the name of any table in that DB)

<validation>
<check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
</validation>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data