Hi Alan,
Can you access your DB from Cayenne Modeler? For instance you can go
to "Tools -> Reengineer Database Schema" and see if that works. Use
the same URL and userid/password you are using to connect from the
application tutorial.
Also - can you find the full stack trace in the tomcat logs? The one
you posted does not show the real cause of the error.
Andrus
On Apr 3, 2006, at 10:58 PM, Alan Baltazar wrote:
hello,
I'm running the 'cayenne-1.1.4\src\tutorials\cayenne-web-app'
sample. everything works
well until I run the 'add artist,painting,gallery' pages. the
problem is this, when I
enter to save new data (for an insert), i get this exception:
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: [v.1.1.4 January 5 2006] Commit
Exception
org.apache.struts.action.RequestProcessor.processException
(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process
(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:
1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
org.objectstyle.cayenne.CayenneRuntimeException: [v.1.1.4 January 5
2006] Commit
Exception
org.objectstyle.cayenne.access.DataContext.commitChanges
(DataContext.java:1275)
org.objectstyle.cayenne.access.DataContext.commitChanges
(DataContext.java:1236)
action.SaveGalleryAction.execute(SaveGalleryAction.java:34)
org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process
(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:
1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the
Apache Tomcat/5.0.28
logs.
----------------------------------------------------------------------
----------
Apache Tomcat/5.0.28
ps: i can entered all complete rights for the user in mysql and was
able to physically
insert directly to the mysql database. i'm only having problems
inserting from thia app.
thanks,
alan
