Daytrader Redux

[Carla Cremers <cr...@azulsystems.com>]

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:13
8) at
org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$3240b09e.register() at
org.apache.geronimo.samples.daytrader.TradeAction.register(TradeAction.java:4
72) at
org.apache.geronimo.samples.daytrader.web.TradeServletAction.doRegister(Trade
ServletAction.java:622) at
org.apache.geronimo.samples.daytrader.web.TradeAppServlet.performTask(TradeAp
pServlet.java:145) at
org.apache.geronimo.samples.daytrader.web.TradeAppServlet.doGet(TradeAppServl
et.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:9
9) at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebAppli
cationHandler.java:830) at
org.apache.geronimo.samples.daytrader.web.OrdersAlertFilter.doFilter(OrdersAl
ertFilter.java:92) at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebAppli
cationHandler.java:821) at
org.mortbay.jetty.servlet.JSR154Filter.doFilter(JSR154Filter.java:171) at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebAppli
cationHandler.java:821) at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandle
r.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.rollbac
kAndThrow(InheritableTransactionContext.java:327) at
org.apache.geronimo.transaction.context.InheritableTransactionContext.complet
e(InheritableTransactionContext.java:199) at
org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(
InheritableTransactionContext.java:146) at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolicy.jav
a:152) at
org.openejb.transaction.TransactionContextInterceptor.invoke(TransactionConte
xtInterceptor.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:12
9) ... 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.complet
e(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(PreparedState
mentHandle.java:103) at
org.tranql.sql.jdbc.JDBCUpdateCommand.execute(JDBCUpdateCommand.java:67) ...
38 more