JBoss Managed connection pool issue
nnanda Jun 29, 2010 10:58 PMHi All,
I am using JBoss 5.1 application server in my project and configured JDBC connection pool for Oracle DB. The connection pool configuration is shown below.
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>MyDS</jndi-name> <use-java-context>false</use-java-context> <connection-url>url</connection-url> <user-name>userId</user-name> <password>password</password> <min-pool-size>5</min-pool-size> <max-pool-size>10</max-pool-size> <idle-timeout-minutes>0</idle-timeout-minutes> </local-tx-datasource> </datasources>
In our production environment, we have been noticing intermittently following exception traces and once it appears no DB operation goes through and we have to restart the JBoss server.
Caused by: java.sql.SQLException: ORA-20002: OTHER Exception in p_update_user SQL Error : ORA-20002: OTHER Exception in p_update_user SQL Error : ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at "USER.PKG_UPDATE_USER", line 502 ORA-06512: at line 1 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3422) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:299) at org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:980) at org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:1) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:928) ... 50 more
Is it because of some configuration issue? This happens in every 6-7 days.
Please help us in identifying the issue.
Thanks,
Niranjan