ok, its working now, for some reason the script below wasnt being accepted by Mysql,
so i just left it out..
I just used the oracle insert statements now ITS WORKING!!!
-----Original Message-----
From: Butt, Dudley
Sent: Thursday, October 16, 2003 9:02 PM
To: 'Struts Users Mailing List'
Subject: RE: jpetstore example from ibatis uses struts
I get this error
Can't create table '.\jpetstore\#sql-5ec_3a.frm' (errno: 150)
when trying to run the mysql script
ALTER TABLE item ADD FOREIGN KEY (supplierid)
REFERENCES supplier(suppid)
ON DELETE RESTRICT
ON UPDATE RESTRICT;
-----Original Message-----
From: Butt, Dudley
Sent: Thursday, October 16, 2003 8:42 PM
To: 'Struts Users Mailing List'
Subject: RE: jpetstore example from ibatis uses struts
I did notice i got an error on trying to run one of the mysql scripts...maybe my
database is screwy..I am using mysql Ver 8.40 Distrib 4.0.12, for
Win95/Win98 on i32
-----Original Message-----
From: James Mitchell [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 7:41 PM
To: 'Struts Users Mailing List'
Subject: RE: jpetstore example from ibatis uses struts
What container/version are you using?
--
James Mitchell
Software Engineer / Struts Evangelist
http://www.struts-atlanta.org
678.910.8017
AIM:jmitchtx
> -----Original Message-----
> From: Butt, Dudley [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 16, 2003 1:29 PM
> To: '[EMAIL PROTECTED]'
> Subject: jpetstore example from ibatis uses struts
>
>
> Hi all,
>
> Anyone managed to successfully get the JPetstore app working?
> I managed to build ok, but I'm getting the following error
> when trying to do anything on
> the index page
>
> type Exception report
> message Internal Server Error
> description The server encountered an internal error
> (Internal Server Error) that prevented it from fulfilling
> this request.
> exception
> javax.servlet.ServletException: Cannot find bean category in
> scope null
> at
> org.apache.jasper.runtime.PageContextImpl.handlePageException(
> PageContextImpl.java:471)
> at
> org.apache.jsp.Category$jsp._jspService(Category$jsp.java:934)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.service
> (JspServlet.java:201)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> .java:381)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(Applicat
> ionDispatcher.java:683)
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(Appli
> cationDispatcher.java:431)
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(Applica
> tionDispatcher.java:355)
> at
> org.apache.struts.action.ActionServlet.processActionForward(Ac
> tionServlet.java:1759)
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.j
> ava:1596)
> 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.ApplicationFilterChain.internalDoFilt
> er(ApplicationFilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> cationFilterChain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.java:243)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.java:190)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:566)
> at
> org.apache.catalina.valves.CertificatesValve.invoke(Certificat
> esValve.java:246)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContex
> t.java:2347)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:180)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:566)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> spatcherValve.java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:564)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:564)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv
> e.java:468)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java:174)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpP
> rocessor.java:1027)
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProce
> ssor.java:1125)
> at java.lang.Thread.run(Thread.java:536)
> root cause
> javax.servlet.jsp.JspException: Cannot find bean category in
> scope null
> at
> org.apache.struts.util.RequestUtils.lookup(RequestUtils.java:493)
> at
> org.apache.struts.taglib.bean.WriteTag.doStartTag(WriteTag.java:179)
> at
> org.apache.jsp.Category$jsp._jspService(Category$jsp.java:703)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.service
> (JspServlet.java:201)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet
> .java:381)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(Applicat
> ionDispatcher.java:683)
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(Appli
> cationDispatcher.java:431)
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(Applica
> tionDispatcher.java:355)
> at
> org.apache.struts.action.ActionServlet.processActionForward(Ac
> tionServlet.java:1759)
> at
> org.apache.struts.action.ActionServlet.process(ActionServlet.j
> ava:1596)
> 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.ApplicationFilterChain.internalDoFilt
> er(ApplicationFilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli
> cationFilterChain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardW
> rapperValve.java:243)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardC
> ontextValve.java:190)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:566)
> at
> org.apache.catalina.valves.CertificatesValve.invoke(Certificat
> esValve.java:246)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContex
> t.java:2347)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHost
> Valve.java:180)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:566)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDi
> spatcherValve.java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:564)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport
> Valve.java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:564)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValv
> e.java:468)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
> gineValve.java:174)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardP
> ipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipel
> ine.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpP
> rocessor.java:1027)
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProce
> ssor.java:1125)
> at java.lang.Thread.run(Thread.java:536)
>
>
>
> NOTICE:
>
> This message contains privileged and confidential information
> intended
> only for the person or entity to which it is addressed.
> Any review, retransmission, dissemination, copy or other use of, or
> taking of any action in reliance upon this information by persons or
> entities other than the intended recipient, is prohibited.
>
> If you received this message in error, please notify the sender
> immediately by e-mail, facsimile or telephone and thereafter
> delete the
> material from any computer.
>
> The New Africa Capital Group, its subsidiaries or associates do not
> accept liability for any personal views expressed in this message.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
NOTICE:
This message contains privileged and confidential information intended
only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or
taking of any action in reliance upon this information by persons or
entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not
accept liability for any personal views expressed in this message.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
NOTICE:
This message contains privileged and confidential information intended
only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or
taking of any action in reliance upon this information by persons or
entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not
accept liability for any personal views expressed in this message.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
NOTICE:
This message contains privileged and confidential information intended
only for the person or entity to which it is addressed.
Any review, retransmission, dissemination, copy or other use of, or
taking of any action in reliance upon this information by persons or
entities other than the intended recipient, is prohibited.
If you received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
material from any computer.
The New Africa Capital Group, its subsidiaries or associates do not
accept liability for any personal views expressed in this message.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
