You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by th...@kbc.be on 2005/02/23 17:03:41 UTC

ODMG error beer4all example from Chuck Cavaness


Hello,

I am trying to get the beer4all sample application running, which I
downloaded from SourceForge.
To ojb I am a newbie, so don't shoot me for asking silly questions.

System is : Tomcat 5.0.28, jk2, apache 2.0.48, mysql 4.1.4-gamma-nt,
eclipse 3.0.1, mysql connector 3.1.1-alpha, ojb-0.9.4 (came with example
download)

I have modified the repository.xml file (which is in the classpath) to use
the installed MySql server, user/password were modified, access is OK.
I created a database ojb and loaded the sql.sql file which came with the
example zipfile.

I verified that all tables were created and are filled : everything is in
place within Mysql.

When I run the application, I have found three places (for now) where
DB-access is used (signin authenticate method, getFeaturedCatalogs,
getFeaturedItems).
Where struts seems to work OK (welcome page is displayed, links are
active), DB access keeps going wrong.

The errors are always similar to those from getFeaturedCatalogs :


INFO 23:02:2005-16:03:31 org.apache.struts.action.RequestProcessor -
Processing a 'GET' for path '/main'
[ODMG] ERROR: null
org.apache.ojb.broker.TransactionInProgressException
      at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.beginTransaction(Unknown

 Source)
      at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source)
      at
com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedCatalogs(Beer4AllOBJService.java:31)

      at
com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.java:18)
      at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)

      at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)

      at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
      at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

      at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)

      at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)

      at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)

      at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)

      at
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670)

      at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637)
      at
org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:177)
      at org.apache.jsp.index_jsp.
_jspx_meth_logic_forward_0(index_jsp.java:88)
      at org.apache.jsp.index_jsp._jspService(index_jsp.java:61)
      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

      at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
      at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
      at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)

      at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

      at java.lang.Thread.run(Thread.java:536)
org.odmg.QueryException
      at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source)
      at
com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedCatalogs(Beer4AllOBJService.java:31)

      at
com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.java:18)
      at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)

      at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)

      at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
      at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

      at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)

      at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)

      at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)

      at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)

      at
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670)

      at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637)
      at
org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:177)
      at org.apache.jsp.index_jsp.
_jspx_meth_logic_forward_0(index_jsp.java:88)
      at org.apache.jsp.index_jsp._jspService(index_jsp.java:61)
      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

      at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
      at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
      at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)

      at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

      at java.lang.Thread.run(Thread.java:536)
[ODMG] ERROR: null
org.apache.ojb.broker.TransactionInProgressException
      at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.beginTransaction(Unknown

 Source)
      at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source)
      at
com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedItems(Beer4AllOBJService.java:51)

      at
com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.java:19)
      at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)

      at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)

      at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
      at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

      at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)

      at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)

      at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)

      at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)

      at
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670)

      at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637)
      at
org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:177)
      at org.apache.jsp.index_jsp.
_jspx_meth_logic_forward_0(index_jsp.java:88)
      at org.apache.jsp.index_jsp._jspService(index_jsp.java:61)
      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

      at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
      at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
      at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)

      at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

      at java.lang.Thread.run(Thread.java:536)
org.odmg.QueryException
      at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source)
      at
com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedItems(Beer4AllOBJService.java:51)

      at
com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.java:19)
      at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)

      at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)

      at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
      at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

      at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)

      at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)

      at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)

      at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)

      at
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:670)

      at
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:637)
      at
org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:177)
      at org.apache.jsp.index_jsp.
_jspx_meth_logic_forward_0(index_jsp.java:88)
      at org.apache.jsp.index_jsp._jspService(index_jsp.java:61)
      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

      at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

      at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

      at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
      at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
      at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
      at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
      at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
      at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)

      at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

      at java.lang.Thread.run(Thread.java:536)

Every idea over what could be wrong would be welcome !

Also something I don't get :

In the DB, the User table has 4 fields:  ID, Firstname, Lastname, username,
there is no password field
In the authenticate() method a query is being made with the password field
in the where clause.
How can this be ? Where is the password info stored ?

Thanx for any reply,

Thierry Van Acker.

PS : The link to this document : The famous Beer4All Struts/OJB tutorial by
Chuck Cavaness  seems not to be working...




________________________________________________
DISCLAIMER

This e-mail and any attached files are confidential and may be legally privileged. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify KBC immediately and then delete this e-mail.
KBC does not accept liability for the correct and complete transmission of the information, nor for any delay or interruption of the transmission, nor for damages arising from the use of or reliance on the information.
All e-mail messages addressed to, received or sent by KBC or KBC employees are deemed to be professional in nature. Accordingly, the sender or recipient of these messages agrees that they may be read by other KBC employees than the official recipient or sender in order to ensure the continuity of work-related activities and allow supervision thereof.


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org