Hi I have managed to get Petstore 1.1.2 setup and working with Oracle 8.1.7 database. I can select records and add them to my shopping cart. But I I get an error when trying to save the orders ie when I press the last proceed button. I dot experiece these problems when working with Cloudscape and Hypersonic. I used j2ee 1.2.1 and jdk 1.3.1 on Windows NT/2000. I configured jboss.jcml according to the maillist and documentation suggestions. See below. Any help is appreciated. Error Message: Server Error null; nested exception is: javax.ejb.EJBException Oops! Your request cannot be completed. The server got the following error. com.sun.j2ee.blueprints.petstore.control.exceptions.GeneralFailureException: null; nested exception is: javax.ejb.EJBException at com.sun.j2ee.blueprints.petstore.control.web.ShoppingClientControllerWebImpl.handleEvent(ShoppingClientControllerWebImpl.java:142) at com.sun.j2ee.blueprints.petstore.control.web.RequestProcessor.processRequest(RequestProcessor.java:84) at com.sun.j2ee.blueprints.petstore.control.web.MainServlet.doProcess(MainServlet.java:111) at com.sun.j2ee.blueprints.petstore.control.web.MainServlet.doGet(MainServlet.java:91) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Thread.java:484) Please notify the administrator. Thank you. Listing: jboss.jcml <?xml version="1.0" encoding="UTF-8"?> <!-- This is where you can add and configure your MBeans ATTENTION: The order of the listing here is the same order as the MBeans are loaded. Therefore if a MBean depends on another MBean to be loaded and started it has to be listed after all the MBeans it depends on. --> <server> <!-- Classloading --> <mbean code="org.jboss.web.WebService" name="DefaultDomain:service=Webserver"> <attribute name="Port">8083</attribute> </mbean> <!-- JNDI --> <mbean code="org.jboss.naming.NamingService" name="DefaultDomain:service=Naming"> <attribute name="Port">1099</attribute> </mbean> <mbean code="org.jboss.naming.JNDIView" name="DefaultDomain:service=JNDIView" /> <!-- Transactions --> <mbean code="org.jboss.tm.TransactionManagerService" name="DefaultDomain:service=TransactionManager"> <attribute name="TransactionTimeout">300</attribute> </mbean> <!-- Security --> <!-- Uncomment to enable the sample SRPVerifierStore service <mbean code="org.jboss.security.srp.SRPVerifierStoreService" name="Security:name=SRPVerifierStoreService"> <attribute name="JndiName">SRPDefaultVerifierSource</attribute> <attribute name="StoreFile">SRPVerifierStore.ser</attribute> </mbean> --> <!-- Uncomment to enable the SRP login service <mbean code="org.jboss.security.srp.SRPService" name="service:name=SRPService"> <attribute name="JndiName">SRPServerInterface</attribute> <attribute name="VerifierSourceJndiName">SRPDefaultVerifierSource</attribute> <attribute name="AuthenticationCacheJndiName">SRPAuthenticationCache</attribute> <attribute name="ServerPort">10099</attribute> </mbean> --> <!-- JAAS security manager and realm mapping --> <mbean code="org.jboss.security.plugins.JaasSecurityManagerService" name="Security:name=JaasSecurityManager"> <attribute name="SecurityManagerClassName">org.jboss.security.plugins.JaasSecurityManager</attribute> </mbean> <!-- Uncomment to enable the XML implementation of the JAAS policy <mbean code="org.jboss.security.plugins.SecurityPolicyService" name="Security:name=SecurityPolicyService"> <attribute name="JndiName">DefaultSecurityPolicy</attribute> <attribute name="PolicyFile">sample_policy.xml</attribute> </mbean> --> <!-- JDBC --> <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider"> <attribute name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,oracle.jdbc.OracleDriver</attribute> </mbean> <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=MyOracleDS"> <attribute name="PoolName">MyOracleDS</attribute> <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute> <attribute name="Properties"></attribute> <attribute name="URL">jdbc:oracle:thin:@n2f1:1521:gis8i</attribute> <attribute name="xURL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute> <attribute name="GCMinIdleTime">1200000</attribute> <attribute name="JDBCUser">unicity</attribute> <attribute name="xJDBCUser">sa</attribute> <attribute name="MaxSize">10</attribute> <attribute name="xPassword" /> <attribute name="Password">unicity</attribute> <attribute name="GCEnabled">false</attribute> <attribute name="InvalidateOnError">false</attribute> <attribute name="TimestampUsed">false</attribute> <attribute name="Blocking">false</attribute> <attribute name="GCInterval">120000</attribute> <attribute name="IdleTimeout">1800000</attribute> <attribute name="IdleTimeoutEnabled">false</attribute> <attribute name="LoggingEnabled">true</attribute> <attribute name="MaxIdleTimeoutPercent">1.0</attribute> <attribute name="MinSize">0</attribute> </mbean> <mbean code="org.jboss.jdbc.HypersonicDatabase" name="DefaultDomain:service=Hypersonic"> <attribute name="Port">1476</attribute> <attribute name="Silent">false</attribute> <attribute name="Database">default</attribute> <attribute name="Trace">true</attribute> </mbean> <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=InstantDB"> <attribute name="PoolName">InstantDB</attribute> <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute> <attribute name="Properties"></attribute> <attribute name="URL">jdbc:idb:../conf/default/instantdb.properties</attribute> <attribute name="GCMinIdleTime">1200000</attribute> <attribute name="JDBCUser" /> <attribute name="MaxSize">10</attribute> <attribute name="Password" /> <attribute name="GCEnabled">false</attribute> <attribute name="InvalidateOnError">false</attribute> <attribute name="TimestampUsed">false</attribute> <attribute name="Blocking">false</attribute> <attribute name="GCInterval">120000</attribute> <attribute name="IdleTimeout">1800000</attribute> <attribute name="IdleTimeoutEnabled">false</attribute> <attribute name="LoggingEnabled">true</attribute> <attribute name="MaxIdleTimeoutPercent">1.0</attribute> <attribute name="MinSize">0</attribute> </mbean> <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=DefaultDS"> <attribute name="PoolName">DefaultDS</attribute> <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute> <attribute name="Properties"></attribute> <attribute name="URL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute> <attribute name="GCMinIdleTime">1200000</attribute> <attribute name="JDBCUser">sa</attribute> <attribute name="MaxSize">10</attribute> <attribute name="Password" /> <attribute name="GCEnabled">false</attribute> <attribute name="InvalidateOnError">false</attribute> <attribute name="TimestampUsed">false</attribute> <attribute name="Blocking">false</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> </mbean> <!-- Petstore --> <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=EstoreDB"> <attribute name="PoolName">EstoreDB</attribute> <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute> <attribute name="Properties"></attribute> <attribute name="xURL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute> <attribute name="URL">jdbc:oracle:thin:@n11f1:1521:gis8i</attribute> <attribute name="GCMinIdleTime">1200000</attribute> <attribute name="xJDBCUser">sa</attribute> <attribute name="xPassword"></attribute> <attribute name="JDBCUser">unicity</attribute> <attribute name="Password">unicity</attribute> <attribute name="MaxSize">10</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> </mbean> <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=InventoryDB"> <attribute name="PoolName">InventoryDB</attribute> <attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute> <attribute name="Properties"></attribute> <attribute name="xURL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute> <attribute name="URL">jdbc:oracle:thin:@n11f1:1521:gis8i</attribute> <attribute name="GCMinIdleTime">1200000</attribute> <attribute name="xJDBCUser">sa</attribute> <attribute name="xPassword"></attribute> <attribute name="JDBCUser">unicity</attribute> <attribute name="Password">unicity</attribute> <attribute name="MaxSize">10</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> </mbean> <!-- Petstore --> <!-- J2EE deployment --> <mbean code="org.jboss.ejb.ContainerFactory" name=":service=ContainerFactory"> <attribute name="VerifyDeployments">true</attribute> <attribute name="MetricsEnabled">false</attribute> <attribute name="VerifierVerbose">true</attribute> <attribute name="BeanCacheJMSMonitoringEnabled">false</attribute> </mbean> <!-- Uncomment to add embedded tomcat service --> <mbean code="org.jboss.tomcat.EmbeddedTomcatService" name="DefaultDomain:service=EmbeddedTomcat" /> <!-- Uncomment and set file URL to add Jetty service (you can set config more than once) <mbean code="org.jboss.jetty.JettyService" name="DefaultDomain:service=Jetty"> <attribute name="Configuration">file URL to jetty.xml e.g. file:/usr/local/jboss/dist/conf/default/jetty.xml</attribute> </mbean> --> <!-- For Message Driven Beans --> <mbean code="org.jbossmq.server.JBossMQService" name="DefaultDomain:service=JBossMQ" /> <mbean code="org.jboss.jms.jndi.JMSProviderLoader" name=":service=JMSProviderLoader,name=JBossMQProvider"> <attribute name="ProviderName">DefaultJMSProvider</attribute> <attribute name="ProviderAdapterClass">org.jboss.jms.jndi.JBossMQProvider</attribute> </mbean> <mbean code="org.jboss.jms.asf.ServerSessionPoolLoader" name=":service=ServerSessionPoolMBean,name=StdJMSPool"> <attribute name="PoolName">StdJMSPool</attribute> <attribute name="PoolFactoryClass">org.jboss.jms.asf.StdServerSessionPoolFactory</attribute> </mbean> <!-- Make sure you change EmbeddedTomcat to Jetty if you are using Jetty --> <mbean code="org.jboss.deployment.J2eeDeployer" name="J2EE:service=J2eeDeployer"> <attribute name="DeployerName">Default</attribute> <attribute name="JarDeployerName">:service=ContainerFactory</attribute> <attribute name="WarDeployerName">:service=EmbeddedTomcat</attribute> </mbean> <mbean code="org.jboss.ejb.AutoDeployer" name="EJB:service=AutoDeployer"> <attribute name="Deployer">J2EE:service=J2eeDeployer</attribute> <attribute name="URLs">../deploy</attribute> </mbean> <!-- J2EE connector architecture --> <mbean code="org.jboss.resource.RARDeployer" name="JCA:service=RARDeployer"> </mbean> <!-- Minerva no transaction connection manager factory. Use this for resource adapters that don't support transactions. --> <mbean code="org.jboss.resource.ConnectionManagerFactoryLoader" name="JCA:service=ConnectionManagerFactoryLoader,name=MinervaNoTransCMFactory"> <attribute name="FactoryName">MinervaNoTransCMFactory</attribute> <attribute name="FactoryClass">org.opentools.minerva.connector.jboss.MinervaNoTransCMFactory</attribute> <attribute name="Properties"></attribute> </mbean> <!-- Minerva local transaction connection manager factory. Use this for resource adapters that support "local" transactions. --> <mbean code="org.jboss.resource.ConnectionManagerFactoryLoader" name="JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory"> <attribute name="FactoryName">MinervaSharedLocalCMFactory</attribute> <attribute name="FactoryClass">org.opentools.minerva.connector.jboss.MinervaSharedLocalCMFactory</attribute>n <attribute name="Properties"></attribute> </mbean> <!-- Minerva XA transaction connection manager factory Use this for resource adapters that support "xa" transactions. --> <mbean code="org.jboss.resource.ConnectionManagerFactoryLoader" name="JCA:service=ConnectionManagerFactoryLoader,name=MinervaXACMFactory"> <attribute name="FactoryName">MinervaXACMFactory</attribute> <attribute name="FactoryClass">org.opentools.minerva.connector.jboss.MinervaXACMFactory</attribute> <attribute name="Properties"></attribute> </mbean> <!-- Example connection factory for the example "Black Box" resource adapter. This points at the same database as DefaultDS. --> <mbean code="org.jboss.resource.ConnectionFactoryLoader" name="JCA:service=ConnectionFactoryLoader,name=BlackBoxDS"> <attribute name="FactoryName">BlackBoxDS</attribute> <attribute name="RARDeployerName">JCA:service=RARDeployer</attribute> <attribute name="ResourceAdapterName">Black Box LocalTx Adapter</attribute> <attribute name="Properties"> ConnectionURL=jdbc:HypersonicSQL:hsql://localhost:1476 </attribute> <attribute name="ConnectionManagerFactoryName">MinervaSharedLocalCMFactory</attribute> <!-- See the documentation for the specific connection manager implementation you are using for the properties you can set --> <attribute name="ConnectionManagerProperties"> # Pool type - uncomment to force, otherwise it is the default #PoolConfiguration=per-factory # Connection pooling properties - see # org.opentools.minerva.pool.PoolParameters MinSize=0 MaxSize=10 Blocking=true GCEnabled=false IdleTimeoutEnabled=false InvalidateOnError=false TrackLastUsed=false GCIntervalMillis=120000 GCMinIdleMillis=1200000 IdleTimeoutMillis=1800000 MaxIdleTimeoutPercent=1.0 </attribute> <!-- Principal mapping configuration --> <attribute name="PrincipalMappingClass">org.jboss.resource.security.ManyToOnePrincipalMapping</attribute> <attribute name="PrincipalMappingProperties"> userName=sa password= </attribute> </mbean> <!-- This is an example of using a resource adapter that supports XA transactions. The Black Box XA resource adapter requires an XADataSource to be in JNDI somewhere. JBoss doesn't include a database with an XA-compliant JDBC driver, so this will need to be configured to use whatever XADataSource implementation you have. <mbean code="org.jboss.jdbc.RawXADataSourceLoader" name="DefaultDomain:service=RawXADataSourceLoader,name=BlackBoxXADS"> <attribute name="PoolName">BlackBoxXADS</attribute> <attribute name="DataSourceClass">Put your XADataSource implementation class here</attribute> <attribute name="Properties"></attribute> </mbean> <mbean code="org.jboss.resource.ConnectionFactoryLoader" name="JCA:service=ConnectionFactoryLoader,name=XABlackBoxDS"> <attribute name="FactoryName">XABlackBoxDS</attribute> <attribute name="RARDeployerName">JCA:service=RARDeployer</attribute> <attribute name="ResourceAdapterName">Black Box XA Adapter</attribute> <attribute name="Properties"> XADataSourceName=java:/BlackBoxXADS </attribute> <attribute name="ConnectionManagerFactoryName">MinervaXACMFactory</attribute> <attribute name="ConnectionManagerProperties"> # Pool type - uncomment to force, otherwise it is the default #PoolConfiguration=per-factory # Connection pooling properties - see # org.opentools.minerva.pool.PoolParameters MinSize=0 MaxSize=10 Blocking=true GCEnabled=false IdleTimeoutEnabled=false InvalidateOnError=false TrackLastUsed=false GCIntervalMillis=120000 GCMinIdleMillis=1200000 IdleTimeoutMillis=1800000 MaxIdleTimeoutPercent=1.0 </attribute> <attribute name="PrincipalMappingClass">org.jboss.resource.security.ManyToOnePrincipalMapping</attribute> <attribute name="PrincipalMappingProperties"> userName=sa password= </attribute> </mbean> --> <!-- JMX adaptors --> <mbean code="org.jboss.jmx.server.JMXAdaptorService" name="Adaptor:name=RMI" /> <mbean code="org.jboss.jmx.server.RMIConnectorService" name="Connector:name=RMI" /> <mbean code="com.sun.jdmk.comm.HtmlAdaptorServer" name="Adaptor:name=html"> <attribute name="MaxActiveClientCount">10</attribute> <attribute name="Parser" /> <attribute name="Port">8082</attribute> </mbean> <!-- Mail Connection Factory --> <mbean code="org.jboss.mail.MailService" name=":service=Mail"> <attribute name="JNDIName">Mail</attribute> <attribute name="ConfigurationFile">mail.properties</attribute> <attribute name="User">user_id</attribute> <attribute name="Password">password</attribute> </mbean> <!-- Uncomment to enable JMX monitoring of the bean cache <mbean code="org.jboss.monitor.BeanCacheMonitor" name="Monitor:name=BeanCacheMonitor"/> --> <!-- Add your custom MBeans here --> </server> >>> [EMAIL PROTECTED] 05/17/01 05:08PM >>> Hi, first, you neither need the line in jboss.properties, as I guess you are on JBoss 2.2. Then you won't either need the jboss.conf entries, so they must go as well. You should see something like [jdbcDrivers] oracle.jdbc.driver.OracleDriver loaded during startup, or your driver isn't found by JBoss if not drop classes12.zip into lib/ext dir. If this does not start JBoss correctly try using something like a JDBC-Explorer (something nice from Borland) and try whether your URL/user/password work. Report any results... Burkhard ----- Original Message ----- From: "Isidoro Fernandez Diaz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 17, 2001 3:21 PM Subject: [JBoss-user] Oracle Integration again > Hi! > > Those are my JBoss s configuration files: > > The new lines in the files are: > > Jboss.properties : > > > jdbc.drivers=oracle.jdbc.driver.OracleDriver,org.hsql.jdbcDriver,org.enhydra > .instantdb.jdbc.idbDriver > Jboss.conf : > > <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar" > CODEBASE="../lib/ext/"> > <ARG TYPE="java.lang.String" VALUE="OracleDB"> > <ARG TYPE="java.lang.String" > VALUE="org.jboss.minerva.xa.XADataSourceImpl"> > </MLET> > > Jboss.jcml: > > First........................ > > <mbean code="org.jboss.jdbc.JdbcProvider" > name="DefaultDomain:service=JdbcProvider"> > <attribute > name="Drivers">oracle.jdbc.driver.OracleDriver,org.hsql.jdbcDriver,org.enhyd > ra.instantdb.jdbc.idbDriver</attribute> > </mbean> > > and.............. > > > <mbean code="org.jboss.jdbc.XADataSourceLoader" > name="DefaultDomain:service=XADataSource,name=OracleDB"> > <attribute name="PoolName">OracleDB</attribute> > <attribute > name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp > l</attribute> > <attribute name="Properties"></attribute> > <attribute name="URL">jdbc:oracle:thin:@1.0.18.76:1521:SONIX</attribute> > <attribute name="GCMinIdleTime">1200000</attribute> > <attribute name="JDBCUser">provision</attribute> > <attribute name="MaxSize">10</attribute> > <attribute name="Password">provision</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> > </mbean> > > > > the problem is that jboss don't finished and stopped in this line: > > > [OracleDS] XA Connection pool OracleDS bound > tojava:/OracleDS > > and JBoss don't continues, not appears : > > [OracleDS] Started > > > > > Isidoro Fernández Díaz > mailto:[EMAIL PROTECTED] > Software Engineer > TELENIUM, The New Millennium Telecom Company > Agustín de Foxá, 25, plta. 13 > 28036 MADRID > Tel. +34 91 315 85 62 > Fax +34 91 315 63 37 > http://www.telenium.es > > > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user