Re: commit error with cayenne 1.1.4 ,tomcat 5 and mysql 5

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Apr 04 2006 - 07:03:17 EDT

  • Next message: Cyp her: "test"

    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

    This archive was generated by hypermail 2.0.0 : Tue Apr 04 2006 - 07:03:52 EDT