>
> >
> > With this and updated versions of the petstore patches I am able to run
> > the petstore app against a cloudscape db.
> >
>
> I'm trying to figure out who reported being able to run the Pet Store.
> Scott? The > quoting brackets are confusing.
>
I have the petstore nearly running.
> 1) What was the nature of the patches?
>
> Deploy-er? or deploy-ment?
Merging the jboss src patches with the latest code and changes to jboss.jcml
for changes to DataSourceClass impl. For example, here is the InventoryDB
setup:
<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="URL">jdbc:cloudscape:rmi:CloudscapeDB;create=true</attribute>
<attribute name="JDBCUser">estoreuser</attribute>
<attribute name="Password">estore</attribute>
<attribute name="Properties"></attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="MaxSize">1</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">true</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
>
> 2) Is the Inventory Bean finding inventory correctly?
>
> If not, products will show up as "Back Ordered" on the screen that
> offers to add the product to the cart.
>
> I suspect there may be a problem with the way the Inventory Datasource
> is configured.
I think so as I can view the stocks of fish, etc.
What I cannot do is login. The security credentials are being passed correctly now
but when the AccountDAO object tries to get the account info for the j2ee userid
it is getting an error indicating the table does not even exist. Right now I'm
suspicious
of the minerva layer since it changed recently, but I need to debug it some more.
jboss server.log with the petstore compiled with debugging on:
...
[TheShoppingClientController] ModelUpdateManager: getUpdateModels
[TheShoppingClientController] ModelUpdateManager: LoginEvent
[TheShoppingClientController] ModelUpdateManager: LoginEvent over
[TheAccount] queryString is: SELECT userid FROM account WHERE userid = 'j2ee'
[TheCustomer] TRANSACTION ROLLBACK EXCEPTION:null; nested exception is:
javax.ejb.EJBException
[TheCustomer] javax.ejb.FinderException: SQLException while checking for an existing
user - id -> j2ee :
[TheCustomer] java.sql.SQLException: Table not found: ACCOUNT in statement [SELECT
userid FROM account WHERE userid = 'j2ee']
[TheCustomer] at
com.sun.j2ee.blueprints.customer.account.ejb.AccountEJB.ejbFindByPrimaryKey(AccountEJB.java:107)
[TheCustomer] at java.lang.reflect.Method.invoke(Native Method)
[TheCustomer] at
org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:458)
[TheCustomer] at
org.jboss.ejb.plugins.BMPPersistenceManager.findEntity(BMPPersistenceManager.java:211)
[TheCustomer] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:419)
[TheCustomer] at java.lang.reflect.Method.invoke(Native Method)
[TheCustomer] at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:639)
[TheCustomer] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:160)
[TheCustomer] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:87)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[TheCustomer] at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:119)
[TheCustomer] at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[TheCustomer] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
[TheCustomer] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:424)
[TheCustomer] at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:198)
[TheCustomer] at $Proxy16.findByPrimaryKey(Unknown Source)
[TheCustomer] at
com.sun.j2ee.blueprints.customer.customer.ejb.CustomerEJB.getAccountDetails(CustomerEJB.java:84)
[TheCustomer] at java.lang.reflect.Method.invoke(Native Method)
[TheCustomer] at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
[TheCustomer] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[TheCustomer] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:137)
[TheCustomer] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[TheCustomer] at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
[TheCustomer] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:464)
[TheCustomer] at
org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:152)
[TheCustomer] at $Proxy9.getAccountDetails(Unknown Source)
[TheCustomer] at
com.sun.j2ee.blueprints.petstore.control.ejb.ShoppingClientControllerEJB.getCustomer(ShoppingClientControllerEJB.java:51)
[TheCustomer] at java.lang.reflect.Method.invoke(Native Method)
[TheCustomer] at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:570)
[TheCustomer] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:137)
[TheCustomer] at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:206)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
[TheCustomer] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[TheCustomer] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[TheCustomer] at
org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSessionContainer.java:326)
[TheCustomer] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:384)
[TheCustomer] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:455)
[TheCustomer] at
org.jboss.ejb.plugins.jrmp.interfaces.StatefulSessionProxy.invoke(StatefulSessionProxy.java:150)
[TheCustomer] at $Proxy14.getCustomer(Unknown Source)
[TheCustomer] at
com.sun.j2ee.blueprints.petstore.control.web.ShoppingClientControllerWebImpl.getCustomerEJB(ShoppingClientControllerWebImpl.java:75)
[TheCustomer] at
com.sun.j2ee.blueprints.petstore.control.web.ModelManager.getCustomerEJB(ModelManager.java:154)
[TheCustomer] at
com.sun.j2ee.blueprints.petstore.control.web.AccountWebImpl.performUpdate(AccountWebImpl.java:41)
[TheCustomer] at
com.sun.j2ee.blueprints.petstore.control.web.ModelUpdateNotifier.notifyListeners(ModelUpdateNotifier.java:37)
[TheCustomer] at
com.sun.j2ee.blueprints.petstore.control.web.RequestProcessor.checkForWebServerLogin(RequestProcessor.java:143)
[TheCustomer] at
com.sun.j2ee.blueprints.petstore.control.web.RequestProcessor.processRequest(RequestProcessor.java:99)
[TheCustomer] at
com.sun.j2ee.blueprints.petstore.control.web.MainServlet.doGet(MainServlet.java:61)
[TheCustomer] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
[TheCustomer] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[TheCustomer] at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[TheCustomer] at org.apache.tomcat.core.Handler.service(Handler.java:286)
[TheCustomer] at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[TheCustomer] at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
[TheCustomer] at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[TheCustomer] at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
[TheCustomer] at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[TheCustomer] at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[TheCustomer] at java.lang.Thread.run(Thread.java:484)
