0 Replies Latest reply on Jun 29, 2010 10:58 PM by NIranjan Nanda

    JBoss Managed connection pool issue

    NIranjan Nanda Apprentice

      Hi 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