I am trying Open Catalog for the first time, but have run into a snap when attempting to add an article.
Here are my steps:
1. Download, unzipped, and started jboss-3.0.0.zip
Result: normal startup
2. Copied opencatalog.ear to <JBOSS>/server/default/deploy
Result: normal deploy, creates tables
3. Opened browser to http://127.0.0.1:8080/opencatalog
Result: got login screen
4. Added a user and logged in
Results: user add and login successful
5. Went to add catalog screen and Added Catalog
Result: catalog add successful
6. Went to add article screen, selected the just added catalog, filled in description, pressed Add Article button.
Result:
An application error has occured.
No exception was provided.
The Hypersonic db created file, default.script, contains:
INSERT INTO CATALOGEJB VALUES(1,NULL)
DELETE FROM UNIQUEIDEJB WHERE UNIQUEID=1 AND ARTICLEID=2 AND ATTRIBUTEID=3 AND CATALOGID=1 AND CLASSIFICATIONID=4 AND CATEGORYID=5 AND USERID=7
INSERT INTO UNIQUEIDEJB VALUES(1,2,3,2,4,5,7)
DELETE FROM CATALOGEJB WHERE ID=1 AND DESCRIPTION=NULL
INSERT INTO CATALOGEJB VALUES(1,'Catalog 1')
.
.
.
DELETE FROM UNIQUEIDEJB WHERE UNIQUEID=1 AND ARTICLEID=2 AND ATTRIBUTEID=3 AND CATALOGID=2 AND CLASSIFICATIONID=4 AND CATEGORYID=5 AND USERID=7
INSERT INTO UNIQUEIDEJB VALUES(1,3,3,2,4,5,7)
INSERT INTO ARTICLEEJB VALUES(2,NULL)
/*C0*/DELETE FROM ARTICLEEJB WHERE ID=2 AND DESCRIPTION=NULL
DELETE FROM UNIQUEIDEJB WHERE UNIQUEID=1 AND ARTICLEID=3 AND ATTRIBUTEID=3 AND CATALOGID=2 AND CLASSIFICATIONID=4 AND CATEGORYID=5 AND USERID=7
INSERT INTO UNIQUEIDEJB VALUES(1,2,3,2,4,5,7)
/*C2*/ROLLBACK
SET AUTOCOMMIT TRUE
Where do I look find out why the value of description is not getting properly set?
In between the stack trace messages on the jboss console are these:
09:57:43,019 INFO [STDOUT] [org.opencatalog.ejb.session.managearticle.ManageArticleBean] RemoteException : null
Embedded Exception
$Proxy70; nested exception is:
javax.ejb.EJBException: null
Embedded Exception
$Proxy70
09:57:43,029 INFO [STDOUT] [org.opencatalog.presentation.article.AddArticleServlet] Exception while processing the request : null
Embedded Exception
$Proxy70; nested exception is:
javax.ejb.EJBException: null
Embedded Exception
$Proxy70
09:57:44,331 INFO [Jetty] JSP: init
09:57:44,391 WARN [Jetty] WARNING: Servlet Exception for /opencatalog/AddArticleServlet?catalogId=1&description=article+description
java.lang.IllegalStateException: committed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You're probably one of the first non-opencatalog developer to try out our software!
I'm happy to see you deployed the .ear with no problem. At least we've got that working properly :-)
Concerning your issue, well, it doesn't work because we haven't coded it yet...
We spent a lot of time designing the EJBs and the presentation layer (with Struts), and now this part should not be a big burden. So I hope we'll have it coded quickly.
Oh, if you really want it we can do with more hands :-))
Julien.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I am trying Open Catalog for the first time, but have run into a snap when attempting to add an article.
Here are my steps:
1. Download, unzipped, and started jboss-3.0.0.zip
Result: normal startup
2. Copied opencatalog.ear to <JBOSS>/server/default/deploy
Result: normal deploy, creates tables
3. Opened browser to http://127.0.0.1:8080/opencatalog
Result: got login screen
4. Added a user and logged in
Results: user add and login successful
5. Went to add catalog screen and Added Catalog
Result: catalog add successful
6. Went to add article screen, selected the just added catalog, filled in description, pressed Add Article button.
Result:
An application error has occured.
No exception was provided.
The Hypersonic db created file, default.script, contains:
INSERT INTO CATALOGEJB VALUES(1,NULL)
DELETE FROM UNIQUEIDEJB WHERE UNIQUEID=1 AND ARTICLEID=2 AND ATTRIBUTEID=3 AND CATALOGID=1 AND CLASSIFICATIONID=4 AND CATEGORYID=5 AND USERID=7
INSERT INTO UNIQUEIDEJB VALUES(1,2,3,2,4,5,7)
DELETE FROM CATALOGEJB WHERE ID=1 AND DESCRIPTION=NULL
INSERT INTO CATALOGEJB VALUES(1,'Catalog 1')
.
.
.
DELETE FROM UNIQUEIDEJB WHERE UNIQUEID=1 AND ARTICLEID=2 AND ATTRIBUTEID=3 AND CATALOGID=2 AND CLASSIFICATIONID=4 AND CATEGORYID=5 AND USERID=7
INSERT INTO UNIQUEIDEJB VALUES(1,3,3,2,4,5,7)
INSERT INTO ARTICLEEJB VALUES(2,NULL)
/*C0*/DELETE FROM ARTICLEEJB WHERE ID=2 AND DESCRIPTION=NULL
DELETE FROM UNIQUEIDEJB WHERE UNIQUEID=1 AND ARTICLEID=3 AND ATTRIBUTEID=3 AND CATALOGID=2 AND CLASSIFICATIONID=4 AND CATEGORYID=5 AND USERID=7
INSERT INTO UNIQUEIDEJB VALUES(1,2,3,2,4,5,7)
/*C2*/ROLLBACK
SET AUTOCOMMIT TRUE
Where do I look find out why the value of description is not getting properly set?
In between the stack trace messages on the jboss console are these:
09:57:43,019 INFO [STDOUT] [org.opencatalog.ejb.session.managearticle.ManageArticleBean] RemoteException : null
Embedded Exception
$Proxy70; nested exception is:
javax.ejb.EJBException: null
Embedded Exception
$Proxy70
09:57:43,029 INFO [STDOUT] [org.opencatalog.presentation.article.AddArticleServlet] Exception while processing the request : null
Embedded Exception
$Proxy70; nested exception is:
javax.ejb.EJBException: null
Embedded Exception
$Proxy70
09:57:44,331 INFO [Jetty] JSP: init
09:57:44,391 WARN [Jetty] WARNING: Servlet Exception for /opencatalog/AddArticleServlet?catalogId=1&description=article+description
java.lang.IllegalStateException: committed
Hi Dennis,
You're probably one of the first non-opencatalog developer to try out our software!
I'm happy to see you deployed the .ear with no problem. At least we've got that working properly :-)
Concerning your issue, well, it doesn't work because we haven't coded it yet...
We spent a lot of time designing the EJBs and the presentation layer (with Struts), and now this part should not be a big burden. So I hope we'll have it coded quickly.
Oh, if you really want it we can do with more hands :-))
Julien.