commit error with cayenne 1.1.4 ,tomcat 5 and mysql 5

From: Alan Baltazar (acatalan..ahoo.com)
Date: Mon Apr 03 2006 - 14:58:59 EDT

  • Next message: Craig Turner: "Seeking to automate generation the cayenne schema"

    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

    __________________________________________________
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com



    This archive was generated by hypermail 2.0.0 : Mon Apr 03 2006 - 14:59:30 EDT