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" <[EMAIL PROTECTED]>*
10/25/2005 01:33 AM
Please respond to
[email protected]
To
<[email protected]>
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
