1 Reply Latest reply on Jun 14, 2004 3:50 AM by Holger Baxmann

    Getting shared memory error "java.lang.Exception: java.sql.S

    Nischal Sharma Newbie

      hi

      friends

      I am facing one problem while using the jboss-3.2.3 with oracle 9i as RDBMS.
      here in my application i am using ejb which mainly contain cmp and session bean

      when i starts my application on jboss and after browsing few pages
      i get this error message:

      ERROR message is given below
      -----------------------------------

      java.lang.Exception: java.sql.SQLException: ORA-04031: unable to allocate 1292 bytes of shared memory
      ("large pool","unknown object","session heap","koh-kghu session heap") :
      Get Access Level from Database error!


      oracle-ds.xml file
      -----------------------
      <?xml version="1.0" encoding="UTF-8"?>

      <!-- ===================================================================== -->
      <!-- -->
      <!-- JBoss Server Configuration -->
      <!-- -->
      <!-- ===================================================================== -->


      <local-tx-datasource>
      <jndi-name>ESPDS</jndi-name>
      <!-- <connection-url>jdbc:oracle:thin:@xxx.xxx.x.x:1521:Testhna</connection-url> -->
      <connection-url>jdbc:oracle:thin:@xxx.xxx.xx.xx:1521:esp</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>esp</user-name>
      <!-- xxxxx -->
      xxxxxx
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>30</max-pool-size>
      <blocking-timeout-millis>10000</blocking-timeout-millis>
      <idle-timeout-minutes>1</idle-timeout-minutes>
      </local-tx-datasource>
      <local-tx-datasource>
      <jndi-name>PSESPDS</jndi-name>
      <!-- <connection-url>jdbc:oracle:thin:@xxx.xxx.x.x:1521:Test</connection-url> -->
      <connection-url>jdbc:oracle:thin:@xxx.xxx.x.x:1521:esp</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>ps_esp</user-name>
      <!-- xxxxxx -->
      xxxxx
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>30</max-pool-size>
      <blocking-timeout-millis>10000</blocking-timeout-millis>
      <idle-timeout-minutes>1</idle-timeout-minutes>
      </local-tx-datasource>





      i will be grateful if anyone knows how to prevent this kind
      of error

      with regards
      nischal