geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lin Sun <linsun_...@yahoo.com>
Subject Re: Daytrader Redux
Date Tue, 25 Oct 2005 19:22:10 GMT

FYI... I am not having any problem with this either.

--- Nell Gawor <nell_gawor@hotmail.com> wrote:

> Hi Carla,
> 
> I just took another look at this.  Before trying to register this new 
> user, did you do the following:
> 
> Go to 'Configuration -> (Re)-populate Trade Database' and wait until the 
> quotes and users are created?
> 
> You must do this before doing anything with dayTrader, otherwise there 
> isn't any data for it to work with (including the quotes it is trying to 
> retrieve in this step).  I had forgotten this step with my latest 
> daytrader install but I just repopulated my database and I am not having 
> any problems creating new users.
> 
> Thanks,
> Nell
> 
> Nell Gawor wrote:
> 
> > Hi Carla,
> >
> > It's not working for me either -- I always use the default user so I 
> > have never tried to register a new one. I think this (the exception 
> > you pasted below) is actually the exception you get on subsequent 
> > attempts to create a user you already tried to create -- the root 
> > exception appears to be a duplicate key because you are creating the 
> > same user twice in the database.
> >
> > So the user must get at least partially created. Still, the first 
> > attempt to create the user as well as attempts to log in as that user 
> > all fail with problems (NullPointerException) in the getMarketSummary 
> > method.  I will take a look and see if I can figure out any more.
> >
> > Thanks,
> > Nell
> >
> >>
> >> *"Carla Cremers" <cremers@azulsystems.com>*
> >>
> >> 10/25/2005 01:33 AM
> >> Please respond to
> >> user@geronimo.apache.org
> >>
> >>
> >>     
> >> To
> >>     <user@geronimo.apache.org>
> >> cc
> >>     
> >> Subject
> >>     Daytrader Redux
> >>
> >>
> >>
> >>     
> >>
> >>
> >>
> >>
> >>
> >> Many thanks to Nell Gawor !  After figuring out how to build svn. I 
> >> was able to download top of tree Geronimo and able to build and load 
> >> my database and deploy DayTrader and get to the web pages.   I 
> >> created a user John Doe and got :
> >>  
> >> Once again, any clues appreciated :
> >>  
> >> *Processing request:*/daytrader/app *
> >> StatusCode:* 500 *
> >> Message:*TradeServletAction.doRegister(...) exception user =jdoe *
> >> Exception:*java.rmi.RemoteException: Unable to commit container 
> >> transaction; nested exception is: javax.transaction.SystemException: 
> >> Unable to commit container transaction
> >> java.rmi.RemoteException: Unable to commit container transaction; 
> >> nested exception is: javax.transaction.SystemException: Unable to 
> >> commit container transaction at 
> >> org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.java:138)

> >> at 
> >> org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$3240b09e.register() 
> >> at 
> >> org.apache.geronimo.samples.daytrader.TradeAction.register(TradeAction.java:472)

> >> at 
> >>
>
org.apache.geronimo.samples.daytrader.web.TradeServletAction.doRegister(TradeServletAction.java:622)
> 
> >> at 
> >>
>
org.apache.geronimo.samples.daytrader.web.TradeAppServlet.performTask(TradeAppServlet.java:145)
> 
> >> at 
> >>
>
org.apache.geronimo.samples.daytrader.web.TradeAppServlet.doGet(TradeAppServlet.java:82)
> 
> >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at 
> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at 
> >> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427) 
> >> at 
> >> org.apache.geronimo.jetty.JettyServletHolder.handle(JettyServletHolder.java:99)

> >> at 
> >>
>
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
> 
> >> at 
> >>
>
org.apache.geronimo.samples.daytrader.web.OrdersAlertFilter.doFilter(OrdersAlertFilter.java:92)
> 
> >> at 
> >>
>
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
> 
> >> at 
> >> org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171) 
> >> at 
> >>
>
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
> 
> >> at 
> >>
>
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
> 
> >> at 
> >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) 
> >> at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) at 
> >>
> org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:635)

> >> at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) at 
> >> org.mortbay.http.HttpServer.service(HttpServer.java:954) at 
> >> org.mortbay.http.HttpConnection.service(HttpConnection.java:816) at 
> >> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) 
> >> at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) at 
> >> org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) 
> >> at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at 
> >> org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) 
> >> Caused by: javax.transaction.SystemException: Unable to commit 
> >> container transaction at 
> >>
>
org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:327)
> 
> >> at 
> >>
>
org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
> 
> >> at 
> >>
>
org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
> 
> >> at 
> >> org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.java:152)

> >> at 
> >>
>
org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:80)
> 
> >> at 
> >> org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor.java:82)

> >> at 
> >> org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238) 
> >> at 
> >> org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.java:129)

> >> ... 26 more Caused by: org.tranql.ql.QueryException: Error executing 
> >> statement: INSERT INTO AccountProfileEJB (address, password, userID, 
> >> email, creditCard, fullName) VALUES (?, ?, ?, ?, ?, ?) at 
> >> org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:69) 
> >> at 
> >> org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:62) 
> >> at 
> >> org.tranql.cache.SimpleFlushStrategy.flush(SimpleFlushStrategy.java:49) 
> >> at 
> >> org.tranql.cache.cache.InTxCacheTracker.flush(InTxCacheTracker.java:41) 
> >> at org.tranql.cache.InTxCache.flush(InTxCache.java:86) at 
> >>
>
org.apache.geronimo.transaction.context.AbstractTransactionContext.flushState(AbstractTransactionContext.java:115)
> 
> >> at 
> >>
>
org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:175)
> 
> >> ... 32 more Caused by: SQL Exception: The statement was aborted 
> >> because it would have caused a duplicate key value in a unique or 
> >> primary key constraint or unique index identified by 
> >> 'PK_ACCOUNTPROFILE2' defined on 'ACCOUNTPROFILEEJB'. at 
> >> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown 
> >> Source) at 
> >> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown

> >> Source) at 
> >> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
> >> Source) at 
> >> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown 
> >> Source) at 
> >> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown 
> >> Source) at 
> >> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown 
> >> Source) at 
> >> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown 
> >> Source) at 
> >> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown 
> >> Source) at 
> >> org.apache.derby.iapi.jdbc.BrokeredPreparedStatement.executeUpdate(Unknown 
> >> Source) at 
> >>
>
org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
> 
> 
=== message truncated ===



		
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

Mime
View raw message