Rafizan,
Thanks for your help, please find the conf files below or where appropriate
just pieces of the conf files.
thanks again
Tom
JBOSS.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<jboss>
<enterprise-beans>
<session>
<ejb-name>SequenceSes</ejb-name>
<jndi-name>SequenceSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/SequenceEnt</ejb-ref-name>
<jndi-name>SequenceEnt</jndi-name>
</ejb-ref>
</session>
<entity>
<ejb-name>SequenceEnt</ejb-name>
<jndi-name>SequenceEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/UtilDataSource</res-ref-name>
<resource-name>UtilDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>CustomerEnt</ejb-name>
<jndi-name>CustomerEnt</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/RuleEnt</ejb-ref-name>
<jndi-name>RuleEnt</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/DiscountEnt</ejb-ref-name>
<jndi-name>DiscountEnt</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/CorpDataSource</res-ref-name>
<resource-name>CorpDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>DiscountEnt</ejb-name>
<jndi-name>DiscountEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/CorpDataSource</res-ref-name>
<resource-name>CorpDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>RuleEnt</ejb-name>
<jndi-name>RuleEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/CorpDataSource</res-ref-name>
<resource-name>CorpDataSource</resource-name>
</resource-ref>
</entity>
<session>
<ejb-name>OrderSes</ejb-name>
<jndi-name>OrderSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/OrderEnt</ejb-ref-name>
<jndi-name>OrderEnt</jndi-name>
</ejb-ref>
</session>
<entity>
<ejb-name>OrderLineEnt</ejb-name>
<jndi-name>OrderLineEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/OrdersDataSource</res-ref-name>
<resource-name>OrdersDataSource</resource-name>
</resource-ref>
</entity>
<session>
<ejb-name>CartSes</ejb-name>
<jndi-name>CartSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/OrderSes</ejb-ref-name>
<jndi-name>OrderSes</jndi-name>
</ejb-ref>
</session>
<session>
<ejb-name>OrderCustomerSes</ejb-name>
<jndi-name>OrderCustomerSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/OrderCustomerEnt</ejb-ref-name>
<jndi-name>OrderCustomerEnt</jndi-name>
</ejb-ref>
</session>
<entity>
<ejb-name>OrderCustomerEnt</ejb-name>
<jndi-name>OrderCustomerEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/OrdersDataSource</res-ref-name>
<resource-name>OrdersDataSource</resource-name>
</resource-ref>
<ejb-ref>
<ejb-ref-name>ejb/SequenceSes</ejb-ref-name>
<jndi-name>SequenceSes</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/CustomerEnt</ejb-ref-name>
<jndi-name>CustomerEnt</jndi-name>
</ejb-ref>
</entity>
<entity>
<ejb-name>OrderEnt</ejb-name>
<jndi-name>OrderEnt</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/SequenceSes</ejb-ref-name>
<jndi-name>SequenceSes</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/CustomerEnt</ejb-ref-name>
<jndi-name>CustomerEnt</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/LargeOrderSes</ejb-ref-name>
<jndi-name>LargeOrderSes</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ItemEnt</ejb-ref-name>
<jndi-name>ItemEnt</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ItemEnt</ejb-ref-name>
<jndi-name>ItemEnt</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/OrdersDataSource</res-ref-name>
<resource-name>OrdersDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>ItemEnt</ejb-name>
<jndi-name>ItemEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/OrdersDataSource</res-ref-name>
<resource-name>OrdersDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>AssemblyEnt</ejb-name>
<jndi-name>AssemblyEnt</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/BomEnt</ejb-ref-name>
<jndi-name>BomEnt</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/InventoryEnt</ejb-ref-name>
<jndi-name>InventoryEnt</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/MfgDataSource</res-ref-name>
<resource-name>MfgDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>BomEnt</ejb-name>
<jndi-name>BomEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/MfgDataSource</res-ref-name>
<resource-name>MfgDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>ComponentEnt</ejb-name>
<jndi-name>ComponentEnt</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/InventoryEnt</ejb-ref-name>
<jndi-name>InventoryEnt</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/MfgDataSource</res-ref-name>
<resource-name>MfgDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>InventoryEnt</ejb-name>
<jndi-name>InventoryEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/MfgDataSource</res-ref-name>
<resource-name>MfgDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>LargeOrderEnt</ejb-name>
<jndi-name>LargeOrderEnt</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/SequenceSes</ejb-ref-name>
<jndi-name>SequenceSes</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/MfgDataSource</res-ref-name>
<resource-name>MfgDataSource</resource-name>
</resource-ref>
</entity>
<session>
<ejb-name>LargeOrderSes</ejb-name>
<jndi-name>LargeOrderSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/LargeOrderEnt</ejb-ref-name>
<jndi-name>LargeOrderEnt</jndi-name>
</ejb-ref>
</session>
<entity>
<ejb-name>PartEnt</ejb-name>
<jndi-name>PartEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/MfgDataSource</res-ref-name>
<resource-name>MfgDataSource</resource-name>
</resource-ref>
</entity>
<session>
<ejb-name>ReceiveSes</ejb-name>
<jndi-name>ReceiveSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/ComponentEnt</ejb-ref-name>
<jndi-name>ComponentEnt</jndi-name>
</ejb-ref>
</session>
<entity>
<ejb-name>WorkOrderEnt</ejb-name>
<jndi-name>WorkOrderEnt</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/AssemblyEnt</ejb-ref-name>
<jndi-name>AssemblyEnt</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ComponentEnt</ejb-ref-name>
<jndi-name>ComponentEnt</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SequenceSes</ejb-ref-name>
<jndi-name>SequenceSes</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/MfgDataSource</res-ref-name>
<resource-name>MfgDataSource</resource-name>
</resource-ref>
</entity>
<session>
<ejb-name>WorkOrderSes</ejb-name>
<jndi-name>WorkOrderSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/WorkOrderEnt</ejb-ref-name>
<jndi-name>WorkOrderEnt</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ComponentEnt</ejb-ref-name>
<jndi-name>ComponentEnt</jndi-name>
</ejb-ref>
</session>
<session>
<ejb-name>BuyerSes</ejb-name>
<jndi-name>BuyerSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/SComponent</ejb-ref-name>
<jndi-name>SComponent</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/Supplier</ejb-ref-name>
<jndi-name>Supplier</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/POEnt</ejb-ref-name>
<jndi-name>POEnt</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/SupplierDataSource</res-ref-name>
<resource-name>SupplierDataSource</resource-name>
</resource-ref>
</session>
<entity>
<ejb-name>POEnt</ejb-name>
<jndi-name>POEnt</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/SequenceSes</ejb-ref-name>
<jndi-name>SequenceSes</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/POLineEnt</ejb-ref-name>
<jndi-name>POLineEnt</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/SupplierDataSource</res-ref-name>
<resource-name>SupplierDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>POLineEnt</ejb-name>
<jndi-name>POLineEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/SupplierDataSource</res-ref-name>
<resource-name>SupplierDataSource</resource-name>
</resource-ref>
</entity>
<session>
<ejb-name>ReceiverSes</ejb-name>
<jndi-name>ReceiverSes</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/POEnt</ejb-ref-name>
<jndi-name>POEnt</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/SComponent</ejb-ref-name>
<jndi-name>SComponent</jndi-name>
</ejb-ref>
<ejb-ref>
<ejb-ref-name>ejb/ReceiveSes</ejb-ref-name>
<jndi-name>ReceiveSes</jndi-name>
</ejb-ref>
</session>
<entity>
<ejb-name>SComponentEnt</ejb-name>
<jndi-name>SComponentEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/SupplierDataSource</res-ref-name>
<resource-name>SupplierDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>SupplierCompEnt</ejb-name>
<jndi-name>SupplierCompEnt</jndi-name>
<resource-ref>
<res-ref-name>jdbc/SupplierDataSource</res-ref-name>
<resource-name>SupplierDataSource</resource-name>
</resource-ref>
</entity>
<entity>
<ejb-name>SupplierEnt</ejb-name>
<jndi-name>SupplierEnt</jndi-name>
<ejb-ref>
<ejb-ref-name>ejb/SupplierCompEnt</ejb-ref-name>
<jndi-name>SupplierCompEnt</jndi-name>
</ejb-ref>
<resource-ref>
<res-ref-name>jdbc/SupplierDataSource</res-ref-name>
<resource-name>SupplierDataSource</resource-name>
</resource-ref>
</entity>
</enterprise-beans>
<resource-managers>
<resource-manager>
<res-name>jdbc/OrdersDataSource</res-name>
<res-jndi-name>OrdersDataSource</res-jndi-name>
</resource-manager>
<resource-manager>
<res-name>jdbc/UtilDataSource</res-name>
<res-jndi-name>UtilDataSource</res-jndi-name>
</resource-manager>
<resource-manager>
<res-name>jdbc/MfgDataSource</res-name>
<res-jndi-name>MfgDataSource</res-jndi-name>
</resource-manager>
<resource-manager>
<res-name>jdbc/CorpDataSource</res-name>
<res-jndi-name>CorpDataSource</res-jndi-name>
</resource-manager>
<resource-manager>
<res-name>SupplierDataSource</res-name>
<res-jndi-name>SupplierDataSource</res-jndi-name>
</resource-manager>
</resource-managers>
<container-configuration>
<container-name>Standard BMP EntityBean</container-name>
<call-logging>false</call-logging>
<container-invoker>org.jboss.ejb.plugins.jrmp13.server.JRMPContainerInvoker</container-invoker>
<instance-pool>org.jboss.ejb.plugins.EntityInstancePool</instance-pool>
<instance-cache>org.jboss.ejb.plugins.EntityInstanceCache</instance-cache>
<persistence-manager>org.jboss.ejb.plugins.BMPPersistenceManager</persistence-manager>
<transaction-manager>org.jboss.tm.TxManager</transaction-manager>
<container-invoker-conf>
<RMIObjectPort>4444</RMIObjectPort>
<Optimized>True</Optimized>
</container-invoker-conf>
<container-cache-conf>
<cache-policy>org.jboss.ejb.plugins.LRUEnterpriseContextCachePolicy</cache-policy>
<cache-policy-conf>
<min-capacity>50</min-capacity>
<max-capacity>1000</max-capacity>
<overager-period>300</overager-period>
<max-bean-age>600</max-bean-age>
<resizer-period>400</resizer-period>
<max-cache-miss-period>60</max-cache-miss-period>
<min-cache-miss-period>1</min-cache-miss-period>
<cache-load-factor>0.75</cache-load-factor>
</cache-policy-conf>
</container-cache-conf>
<container-pool-conf>
<MaximumSize>100</MaximumSize>
<MinimumSize>10</MinimumSize>
</container-pool-conf>
<commit-option>A</commit-option>
</container-configuration>
</jboss>
ejb-jar.xml
...
<entity>
<description>Item Entity bean</description>
<display-name>ItemEnt</display-name>
<ejb-name>ItemEnt</ejb-name>
<home>com.sun.ecperf.orders.itement.ejb.ItemEntHome</home>
<remote>com.sun.ecperf.orders.itement.ejb.ItemEnt</remote>
<ejb-class>com.sun.ecperf.orders.itement.ejb.ItemBmpEJB</ejb-class>
<persistence-type>Bean</persistence-type>
<prim-key-class>java.lang.String</prim-key-class>
<reentrant>False</reentrant>
<env-entry>
<description>
The debug level of the bean - higher
value means more information.
</description>
<env-entry-name>debuglevel</env-entry-name>
<env-entry-type>java.lang.Integer</env-entry-type>
<env-entry-value>2</env-entry-value>
</env-entry>
<resource-ref>
<description>Orders DB dataSource</description>
<res-ref-name>jdbc/OrdersDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</entity>
..
jboss.conf
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="OrdersDataSource">
<ARG TYPE="java.lang.String"
VALUE="oracle.jdbc.xa.client.OracleXADataSource"> </MLET>
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="CorpDataSource">
<ARG TYPE="java.lang.String"
VALUE="oracle.jdbc.xa.client.OracleXADataSource"> </MLET>
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="MfgDataSource">
<ARG TYPE="java.lang.String"
VALUE="oracle.jdbc.xa.client.OracleXADataSource"> </MLET>
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="UtilDataSource">
<ARG TYPE="java.lang.String"
VALUE="oracle.jdbc.xa.client.OracleXADataSource"> </MLET>
<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="SupplierDataSource">
<ARG TYPE="java.lang.String"
VALUE="oracle.jdbc.xa.client.OracleXADataSource"> </MLET>
jboss.jcml
<server>
<mbean name="DefaultDomain:service=Logging,type=File">
<attribute name="LogName">server</attribute>
<attribute name="Format">[{2}] {4}</attribute>
</mbean>
<mbean name="DefaultDomain:service=Webserver">
<attribute name="Port">8083</attribute>
</mbean>
<mbean name="DefaultDomain:service=MLet">
<attribute
name="LibraryDirectory">/export/home/td/jboss/jBoss-2.0_FINAL/bin</attribute>
</mbean>
<mbean name="DefaultDomain:service=XADataSource,name=UtilDataSource">
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">ecperf</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">ecperf</attribute>
<attribute
name="URL">jdbc:oracle:thin:@localhost:1521:ecperf2</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="Properties"></attribute>
</mbean>
<mbean name="DefaultDomain:service=XADataSource,name=InstantDB">
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser" />
<attribute name="MaxSize">10</attribute>
<attribute name="Password" />
<attribute
name="URL">jdbc:idb:../conf/default/instantdb.properties</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="Properties"></attribute>
</mbean>
<mbean name="DefaultDomain:service=XADataSource,name=CorpDataSource">
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">ecperf</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">ecperf</attribute>
<attribute
name="URL">jdbc:oracle:thin:@localhost:1521:ecperf2</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="Properties"></attribute>
</mbean>
<mbean name="EJB:service=ContainerFactory">
<attribute name="VerifyDeployments">true</attribute>
<attribute name="MetricsEnabled">false</attribute>
<attribute name="VerifierVerbose">true</attribute>
</mbean>
<mbean name="DefaultDomain:service=XADataSource,name=SupplierDataSource">
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">ecperf</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">ecperf</attribute>
<attribute
name="URL">jdbc:oracle:thin:@localhost:1521:ecperf2</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="Properties"></attribute>
</mbean>
<mbean name="DefaultDomain:service=XADataSource,name=MfgDataSource">
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">ecperf</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">ecperf</attribute>
<attribute
name="URL">jdbc:oracle:thin:@localhost:1521:ecperf2</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="Properties"></attribute>
</mbean>
<mbean name="DefaultDomain:service=Logging,type=Console">
<attribute name="Format">[{2}] {4}</attribute>
</mbean>
<mbean name="DefaultDomain:service=TransactionManager">
<attribute name="TransactionTimeout">300</attribute>
</mbean>
<mbean name="DefaultDomain:service=XADataSource,name=OrdersDataSource">
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">ecperf</attribute>
<attribute name="MaxSize">0</attribute>
<attribute name="Password">ecperf</attribute>
<attribute
name="URL">jdbc:oracle:thin:@localhost:1521:ecperf2</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="Properties"></attribute>
</mbean>
<mbean name="Adaptor:name=html">
<attribute name="MaxActiveClientCount">10</attribute>
<attribute name="Parser" />
<attribute name="Port">8082</attribute>
</mbean>
<mbean name="DefaultDomain:service=Hypersonic">
<attribute name="Port">1476</attribute>
<attribute name="Trace">false</attribute>
<attribute name="Database">default</attribute>
<attribute name="Silent">true</attribute>
</mbean>
<mbean name="DefaultDomain:service=XADataSource,name=DefaultDS">
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password" />
<attribute
name="URL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="Properties"></attribute>
</mbean>
>
> hi
>
> are you calling DefaultDS instead of you oracle pool?
> can you post your conf and the code where you lookup your DS..
>
> .r
>
> On Mon, 12 Feb 2001 [EMAIL PROTECTED] wrote:
>
> > Gidday all,
> >
> > I am currently getting the following error when my BMP code tries to access
> > the Oracle 8.1.7 db (note I am sure that the database and table exist). I
> > have searched the archives and it appears that I may not be acessing my
> > OracleDB pool but rather the hypersonic pool. If this is the case can someone
> > please tell me where to change it as it is not clear to me even though I have
> > virtually copied the Oracle connection pool setup straight from the manual.
> >
> > Thanks in advance
> > Tom
> >
> >
> >
> > [ItemEnt] java.sql.SQLException: Table not found: O_ITEM in statement [SELECT
> > i_id FROM O_item] [ItemEnt] at
> > java.lang.Throwable.fillInStackTrace(Native Method) [ItemEnt] at
> > java.lang.Throwable.<init>(Throwable.java:94) [ItemEnt] at
> > java.lang.Exception.<init>(Exception.java:42) [ItemEnt] at
> > java.sql.SQLException.<init>(SQLException.java:64) [ItemEnt] at
> > org.hsql.Trace.getError(Trace.java:124) [ItemEnt] at
> > org.hsql.Result.<init>(Result.java:70) [ItemEnt] at
> > org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644) [ItemEnt]
> > at org.hsql.jdbcConnection.execute(jdbcConnection.java:540) [ItemEnt] at
> > org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499) [ItemEnt] at
> > org.hsql.jdbcStatement.executeQuery(jdbcStatement.java:37) [ItemEnt] at
> > org.hsql.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.java:99)
> >
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > List Help?: [EMAIL PROTECTED]
> >
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
