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