L
Lars80
Gast
Hallo Ihr,
ich suche gerade den Einstig in EJB, XDoclet & Co und nachdem ich nun einen ganzen Tag verbraten habe, die xpetstore sample Applicaton
http://xpetstore.sourceforge.net/index.html
zum Laufen zu kriegen, wollte ich mal fragen, ob das jemand schonmal hingekriegt hat. Es ist zum verrücktwerden, ich habe alles genau nach Anleitung mehrmals gemacht.
1) JBoss Setup
http://xpetstore.sourceforge.net/setup_jboss-3.0.x.html
2) Run the Application
http://xpetstore.sourceforge.net/run.html
wobei sich die Tasks build.sh und build.sh deploy fehlerfrei ausführen lassen
build.sh test und build.sh db brechen mit folgendem fehler ab:
init:
[echo] Database=hsqldb
data:
[sql] Executing file: /home/eclipse/JBoss/jboss-3.2.7/server/xpetstore/xpetstore-ejb/sql/data.sql
[sql] Failed to execute: DELETE FROM T_COUNTER
BUILD FAILED
/home/eclipse/JBoss/jboss-3.2.7/server/xpetstore/xpetstore-ejb/build-database.xml:40: java.sql.SQLException: Table not found: T_COUNTER in statement [DELETE FROM T_COUNTER]
HSQL DB läuft und ist konfiguriert.
Immerhin lässt sich die Startseite
http://localhost:8080/xpetstore-ejb
anzeigen, wenn ich hier allerdings was anklicke
kommt folgendes:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Could not dereference object
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:507)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:448)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
xpetstore.web.filter.SignOnFilter.doFilter(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(Unknown Source)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
javax.naming.NamingException: Could not dereference object [Root exception is javax.naming.NameNotFoundException: PetstoreLocal not bound]
org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1047)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:681)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:697)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:568)
javax.naming.InitialContext.lookup(InitialContext.java:347)
xpetstore.services.petstore.util.PetstoreUtil.getLocalHome(Unknown Source)
xpetstore.web.struts.action.BaseAction.getPetstore(Unknown Source)
xpetstore.web.struts.action.category.CategoryAction.doExecute(Unknown Source)
xpetstore.web.struts.action.BaseAction.execute(Unknown Source)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
xpetstore.web.filter.SignOnFilter.doFilter(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(Unknown Source)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
javax.naming.NameNotFoundException: PetstoreLocal not bound
org.jnp.server.NamingServer.getBinding(NamingServer.java:490)
org.jnp.server.NamingServer.getBinding(NamingServer.java:498)
org.jnp.server.NamingServer.getObject(NamingServer.java:504)
org.jnp.server.NamingServer.lookup(NamingServer.java:277)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:606)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:568)
javax.naming.InitialContext.lookup(InitialContext.java:347)
org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1041)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:681)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:697)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:568)
javax.naming.InitialContext.lookup(InitialContext.java:347)
xpetstore.services.petstore.util.PetstoreUtil.getLocalHome(Unknown Source)
xpetstore.web.struts.action.BaseAction.getPetstore(Unknown Source)
xpetstore.web.struts.action.category.CategoryAction.doExecute(Unknown Source)
xpetstore.web.struts.action.BaseAction.execute(Unknown Source)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
xpetstore.web.filter.SignOnFilter.doFilter(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(Unknown Source)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
Apache Tomcat/5.0.30
Die entsprechende sql Datei sieht so aus, ich frage mich wo hier die Tabellen defniert werden, in dem ganzen Projekt habe ich keine Tabellendefinitionen gefunden ?:
Hat schonmal jemand diese Applikation zum Laufen gebracht?
Vielen Dank im voraus!
ich suche gerade den Einstig in EJB, XDoclet & Co und nachdem ich nun einen ganzen Tag verbraten habe, die xpetstore sample Applicaton
http://xpetstore.sourceforge.net/index.html
zum Laufen zu kriegen, wollte ich mal fragen, ob das jemand schonmal hingekriegt hat. Es ist zum verrücktwerden, ich habe alles genau nach Anleitung mehrmals gemacht.
1) JBoss Setup
http://xpetstore.sourceforge.net/setup_jboss-3.0.x.html
2) Run the Application
http://xpetstore.sourceforge.net/run.html
wobei sich die Tasks build.sh und build.sh deploy fehlerfrei ausführen lassen
build.sh test und build.sh db brechen mit folgendem fehler ab:
init:
[echo] Database=hsqldb
data:
[sql] Executing file: /home/eclipse/JBoss/jboss-3.2.7/server/xpetstore/xpetstore-ejb/sql/data.sql
[sql] Failed to execute: DELETE FROM T_COUNTER
BUILD FAILED
/home/eclipse/JBoss/jboss-3.2.7/server/xpetstore/xpetstore-ejb/build-database.xml:40: java.sql.SQLException: Table not found: T_COUNTER in statement [DELETE FROM T_COUNTER]
HSQL DB läuft und ist konfiguriert.
Immerhin lässt sich die Startseite
http://localhost:8080/xpetstore-ejb
anzeigen, wenn ich hier allerdings was anklicke
kommt folgendes:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Could not dereference object
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:507)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:448)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
xpetstore.web.filter.SignOnFilter.doFilter(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(Unknown Source)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
javax.naming.NamingException: Could not dereference object [Root exception is javax.naming.NameNotFoundException: PetstoreLocal not bound]
org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1047)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:681)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:697)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:568)
javax.naming.InitialContext.lookup(InitialContext.java:347)
xpetstore.services.petstore.util.PetstoreUtil.getLocalHome(Unknown Source)
xpetstore.web.struts.action.BaseAction.getPetstore(Unknown Source)
xpetstore.web.struts.action.category.CategoryAction.doExecute(Unknown Source)
xpetstore.web.struts.action.BaseAction.execute(Unknown Source)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
xpetstore.web.filter.SignOnFilter.doFilter(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(Unknown Source)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
root cause
javax.naming.NameNotFoundException: PetstoreLocal not bound
org.jnp.server.NamingServer.getBinding(NamingServer.java:490)
org.jnp.server.NamingServer.getBinding(NamingServer.java:498)
org.jnp.server.NamingServer.getObject(NamingServer.java:504)
org.jnp.server.NamingServer.lookup(NamingServer.java:277)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:606)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:568)
javax.naming.InitialContext.lookup(InitialContext.java:347)
org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1041)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:681)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:697)
org.jnp.interfaces.NamingContext.lookup(NamingContext.java:568)
javax.naming.InitialContext.lookup(InitialContext.java:347)
xpetstore.services.petstore.util.PetstoreUtil.getLocalHome(Unknown Source)
xpetstore.web.struts.action.BaseAction.getPetstore(Unknown Source)
xpetstore.web.struts.action.category.CategoryAction.doExecute(Unknown Source)
xpetstore.web.struts.action.BaseAction.execute(Unknown Source)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:492)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
xpetstore.web.filter.SignOnFilter.doFilter(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(Unknown Source)
com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(Unknown Source)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
Apache Tomcat/5.0.30
Die entsprechende sql Datei sieht so aus, ich frage mich wo hier die Tabellen defniert werden, in dem ganzen Projekt habe ich keine Tabellendefinitionen gefunden ?:
Code:
-- Cleanup
DELETE FROM T_COUNTER;
DELETE FROM T_ORDER_ITEM;
DELETE FROM T_ORDER;
DELETE FROM T_CUSTOMER;
DELETE FROM T_ITEM;
DELETE FROM T_PRODUCT;
DELETE FROM T_CATEGORY;
DELETE FROM T_ACCOUNT;
-- Load
INSERT INTO T_ACCOUNT VALUES ( 'user1', 'password1' );
....
INSERT INTO T_CUSTOMER VALUES ( 'user1', 'firstname1', 'lastname1', 'herve@localdomain', '111-1111', 'en', 'street1.1', 'street1.2', 'city1', 'ST1', 'A1B-1C1', 'US', '111-111-111', 'Visa', '01-11', 'user1' );
INSERT INTO T_CUSTOMER VALUES ( 'user2', 'firstname2', 'lastname2', 'daniele@localdomain', '222-2222', 'en', 'street2.1', 'street2.2', 'city1', 'ST2', 'A2B-2C2', 'US', '222-222-222', 'Visa', '02-22', 'user2' );
INSERT INTO T_CATEGORY VALUES ('FISH', 'Fish', 'description of FISH' );
...
INSERT INTO T_PRODUCT VALUES ('FI-SW-01', 'Angelfish', 'Saltwater fish from Australia', 'FISH');
...
INSERT INTO T_ITEM VALUES ('EST-1', 'Large', '16.50', '10.00', 'fish1.jpg', 'FI-SW-01');
...
INSERT INTO T_COUNTER VALUES('Customer', 1000);
Hat schonmal jemand diese Applikation zum Laufen gebracht?
Vielen Dank im voraus!