Re: Daytrader Redux

[Nell Gawor <ne...@hotmail.com>]

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" <cr...@azulsystems.com>*
>
> 10/25/2005 01:33 AM
> Please respond to
> user@geronimo.apache.org
>
>
> 	
> To
> 	<us...@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) 
> at 
> org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:67) 
> ... 38 more
>  
>