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 9 years ago

It seems it could be a bug with that plug-in. Let's do this:

1. Update these settings to these values

min-pool-size : 5
max-pool-size: 400

2. Add the following tag below </timeout>

<statement>
<track-statements>true</track-statements>
</statement>

3. Restart JBoss and wait for the issue to re-occur

4. Stop JBoss and remove the tag added on step #2 (i.e. <track-statements>)

5. Start JBoss and attach the server log
6. Paste the <validation> section of your data source that is experiencing the behavior
7. Check what version of com.appiancorp.forms.ajax_*.jar you have under <APPIAN_HOME>\\_admin\\plugins
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 9 years ago

It seems it could be a bug with that plug-in. Let's do this:

1. Update these settings to these values

min-pool-size : 5
max-pool-size: 400

2. Add the following tag below </timeout>

<statement>
<track-statements>true</track-statements>
</statement>

3. Restart JBoss and wait for the issue to re-occur

4. Stop JBoss and remove the tag added on step #2 (i.e. <track-statements>)

5. Start JBoss and attach the server log
6. Paste the <validation> section of your data source that is experiencing the behavior
7. Check what version of com.appiancorp.forms.ajax_*.jar you have under <APPIAN_HOME>\\_admin\\plugins
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data