I downloaded a web app created by Chuck Cavaness from http://jakarta.apache.org/struts/resources/projects.html and failed to run it? I am running struts 1.1b2 and tomcat4.1.12, jdk1.3.1.
The exception I got is [org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: SQLException during the ex ecution of materializeObject: Table not found: S0002 Table not found: OJB_HL_SEQ in statement [SELECT MAX_KEY,TABLENAME,GRAB_SIZE,FIELDNAME FROM OJB_HL_SEQ WHER E (OJB_HL_SEQ.TABLENAME = 'OJB_DLIST' ) AND (OJB_HL_SEQ.FIELDNAME = 'id' )] Table not found: S0002 Table not found: OJB_HL_SEQ in statement [SELECT MAX_KEY, TABLENAME,GRAB_SIZE,FIELDNAME FROM OJB_HL_SEQ WHERE (OJB_HL_SEQ.TABLENAME = 'OJB _DLIST' ) AND (OJB_HL_SEQ.FIELDNAME = 'id' )] java.sql.SQLException: Table not found: S0002 Table not found: OJB_HL_SEQ in sta tement [SELECT MAX_KEY,TABLENAME,GRAB_SIZE,FIELDNAME FROM OJB_HL_SEQ WHERE (OJB_ HL_SEQ.TABLENAME = 'OJB_DLIST' ) AND (OJB_HL_SEQ.FIELDNAME = 'id' )] at org.hsqldb.Trace.getError(Trace.java:226) at org.hsqldb.jdbcResultSet.<init>(jdbcResultSet.java:6595) at org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:2951) at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:2540) at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1804) at org.hsqldb.jdbcStatement.executeQuery(jdbcStatement.java:199) at org.hsqldb.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.j ava:391) at org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknow n Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Unkn own Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdent ity(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByExamp le(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery (Unknown Source) at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUni queId(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getUniqueId(Unkn own Source) at org.apache.ojb.odmg.collections.DListImpl.generateNewId(Unknown Sourc e) at org.apache.ojb.odmg.collections.DListImpl.<init>(Unknown Source) at java.lang.Class.newInstance0(Native Method) at java.lang.Class.newInstance(Class.java:232) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedCatalogs( Beer4AllOBJService.java:32) at com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.jav a:18) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:446) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:266) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:129 2) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp atcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD ispatcher.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis patcher.java:356) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.jav a:427) at org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:17 7) at org.apache.jsp.index_jsp._jspx_meth_logic_forward_0(index_jsp.java:78 ) at org.apache.jsp.index_jsp._jspService(index_jsp.java:54) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper .java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2 89) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22 3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ssConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:533) at java.lang.Thread.run(Thread.java:479) [org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: SQLException during the ex ecution of the query: Table not found: S0002 Table not found: CATALOG in stateme nt [SELECT A0.ID,A0.NAME FROM Catalog A0] Table not found: S0002 Table not found: CATALOG in statement [SELECT A0.ID,A0.NA ME FROM Catalog A0] java.sql.SQLException: Table not found: S0002 Table not found: CATALOG in statem ent [SELECT A0.ID,A0.NAME FROM Catalog A0] at org.hsqldb.Trace.getError(Trace.java:226) at org.hsqldb.jdbcResultSet.<init>(jdbcResultSet.java:6595) at org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:2951) at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:2540) at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1804) at org.hsqldb.jdbcStatement.executeQuery(jdbcStatement.java:199) at org.hsqldb.jdbcPreparedStatement.executeQuery(jdbcPreparedStatement.j ava:391) at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown Sou rce) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQ uery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedCatalogs( Beer4AllOBJService.java:32) at com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.jav a:18) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:446) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:266) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:129 2) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp atcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD ispatcher.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis patcher.java:356) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.jav a:427) at org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:17 7) at org.apache.jsp.index_jsp._jspx_meth_logic_forward_0(index_jsp.java:78 ) at org.apache.jsp.index_jsp._jspService(index_jsp.java:54) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper .java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2 89) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22 3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ssConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:533) at java.lang.Thread.run(Thread.java:479) [ODMG] ERROR: null org.apache.ojb.broker.PersistenceBrokerSQLException at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(Unknown Sou rce) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQ uery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQ uery(Unknown Source) at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedCatalogs( Beer4AllOBJService.java:32) at com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.jav a:18) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:446) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:266) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:129 2) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp atcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD ispatcher.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis patcher.java:356) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.jav a:427) at org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:17 7) at org.apache.jsp.index_jsp._jspx_meth_logic_forward_0(index_jsp.java:78 ) at org.apache.jsp.index_jsp._jspService(index_jsp.java:54) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper .java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2 89) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22 3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ssConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:533) at java.lang.Thread.run(Thread.java:479) org.odmg.QueryException at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedCatalogs( Beer4AllOBJService.java:32) at com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.jav a:18) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:446) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:266) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:129 2) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp atcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD ispatcher.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis patcher.java:356) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.jav a:427) at org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:17 7) at org.apache.jsp.index_jsp._jspx_meth_logic_forward_0(index_jsp.java:78 ) at org.apache.jsp.index_jsp._jspService(index_jsp.java:54) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper .java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2 89) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22 3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ssConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:533) at java.lang.Thread.run(Thread.java:479) [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(Bee r4AllOBJService.java:52) at com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.jav a:19) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:446) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:266) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:129 2) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp atcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD ispatcher.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis patcher.java:356) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.jav a:427) at org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:17 7) at org.apache.jsp.index_jsp._jspx_meth_logic_forward_0(index_jsp.java:78 ) at org.apache.jsp.index_jsp._jspService(index_jsp.java:54) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper .java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2 89) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22 3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ssConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:533) at java.lang.Thread.run(Thread.java:479) org.odmg.QueryException at org.apache.ojb.odmg.oql.OQLQueryImpl.execute(Unknown Source) at com.cavaness.beer4all.service.Beer4AllOBJService.getFeaturedItems(Bee r4AllOBJService.java:52) at com.cavaness.beer4all.catalog.WelcomeAction.execute(WelcomeAction.jav a:19) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:446) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:266) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:129 2) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp atcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD ispatcher.java:432) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis patcher.java:356) at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.jav a:427) at org.apache.struts.taglib.logic.ForwardTag.doEndTag(ForwardTag.java:17 7) at org.apache.jsp.index_jsp._jspx_meth_logic_forward_0(index_jsp.java:78 ) at org.apache.jsp.index_jsp._jspService(index_jsp.java:54) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper .java:204) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2 89) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatche rValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContex t.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav a:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:22 3) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ssConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java :508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP ool.java:533) at java.lang.Thread.run(Thread.java:479) I have modified the repository.xml dbalias to c:/test/beer4all, where beer4all.data, beer4all.script, and beer4all.properties are stored under c:\test. Please help! Thanks! CT __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>