I am using appfuse 1.9x and webwork as the web framework Regarding my problem, I'm using the same object (User) from the example on appfuse. I cant update the information of the User object on the database on my application and throws some errors. Heres some part of those errors in tomcat after trigerring the save button to update the user profile on database. [Thinkscan] DEBUG [http-8080-Processor24] UserDaoHibernate.saveUser(49) | user's id: 2 [Thinkscan] WARN [http-8080-Processor24] JDBCExceptionReporter.logExceptions(71) | SQL Error: 1062, SQLState: 23000 [Thinkscan] ERROR [http-8080-Processor24] JDBCExceptionReporter.logExceptions(72) | Duplicate entry 'admin' for key 2 [Thinkscan] WARN [http-8080-Processor24] UserAction.save(154) | User 'admin' already exists! [Thinkscan] WARN [http-8080-Processor24] DefaultActionInvocation.executeResult(313) | No result defined for action com.voxsant.thinkscan.webapp.action.UserAction and result input

I tried to test it for each tier and heres what ive got
*   * Dao test**
[Thinkscan] INFO [main] UserDaoTest.loadContextLocations(136) | Loading context for: classpath*:/**/dao/applicationContext-*.xml,classpath*:META-INF/applicationContext-*.xml [Thinkscan] INFO [main] UserDaoTest.startNewTransaction(309) | Began transaction (1): transaction manager [EMAIL PROTECTED]; default rollback = true [Thinkscan] WARN [main] UserDaoHibernate.getUser(30) | uh oh, user '1000' not found... [Thinkscan] INFO [main] UserDaoTest.endTransaction(275) | Rolled back transaction after test execution [Thinkscan] INFO [main] UserDaoTest.startNewTransaction(309) | Began transaction (1): transaction manager [EMAIL PROTECTED]; default rollback = true [Thinkscan] INFO [main] UserDaoTest.endTransaction(275) | Rolled back transaction after test execution [Thinkscan] INFO [main] UserDaoTest.startNewTransaction(309) | Began transaction (1): transaction manager [EMAIL PROTECTED]; default rollback = true
  [Thinkscan] DEBUG [main] UserDaoHibernate.saveUser(49) | user's id: 1
[Thinkscan] INFO [main] UserDaoTest.endTransaction(275) | Rolled back transaction after test execution
  [Thinkscan] DEBUG [main] UserDaoHibernate.saveUser(49) | user's id: null
[Thinkscan] WARN [main] JDBCExceptionReporter.logExceptions(71) | SQL Error: 1062, SQLState: 23000 [Thinkscan] ERROR [main] JDBCExceptionReporter.logExceptions(72) | Duplicate entry 'user' for key 2 [Thinkscan] DEBUG [main] UserDaoTest.testUpdateUser(60) | expected exception: could not insert: [com.voxsant..voxsant.thinkscan.model.User]; nested exception is org.hibernate.exception.ContraintViolationException: could not insert: [com.voxsant.thinkscan.model.User]

  **Action test* -- *UserExistsException was thrown
error on saving user /*** I printed it to console to test if an error occurred
    WARN [main] UserAction.save(154) | User 'user' already exists!
     Saving user
      DEBUG [main] UserDaoHibernate.saveUser(49) | user's id: 1
DEBUG [main] UserSecurityAdvice.afterReturning(118) | Removing 'user' from userCache added user
      DEBUG [main] UserManagerImpl.removeUser(67) | removing user: 2

*  *Service test**
       [copy] Copying 2 files to C:\thinkscan\build\test\service\classes
  Testsuite: com.voxsant.thinkscan.service.UserManagerTest
[Thinkscan] DEBUG [main] UserManagerImpl.removeUser(67) | removing user: 5 [Thinkscan] DEBUG [main] UserManagerTest.testUserExistsException(124) | expected exception: User 'admin' already exists!
  Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.969 sec
   ------------- Standard Output ---------------
[Thinkscan] DEBUG [main] UserManagerImpl.removeUser(67) | removing user: 5 [Thinkscan] DEBUG [main] UserManagerTest.testUserExistsException(124) | expected exception: User 'admin' already exists! * *It seems that my problems are more likely in saving(Dao) but I already compared my java classes to the original java files from the appfuse and they look the same. I still dont know the problem :D. I could add new records to user's table but i cant update it after inserting a record on my application
  Please suggest some solutions. Thanks! :D


Michael Horwitz wrote:
Which version of AppFuse and which web frontend are you using? Some more details on the exact nature of the problem would also be useful: when you say can't update, do you mean the data does not appear in the database or is an exception raised? Have you got unit tests for each tier and are they passing? Mike.

On 7/12/07, *Mel Pison* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

    Hi All,

    Good Day everyone!

    I'm new here and I'm just starting in j2ee. I'm currently creating
    the
    same application from the tutorials(Person and User objects). I
    followed
    the steps from the tutorial and I already have a User object and I
    want
    to manipulate this object but I'm still encountering some problems. I
    just copied all the needed files for the User object from the myapp
sample and I made some modifications on jsp files for viewing the user
    information. I could add a new record of user to my application but I
cant update the user information including the new roles for a user. I
    already compared all my java files for users to the tutorials java
    files
    and it seems that there are no errors on that. I cant use the update
    functionality.

    Please suggest some solutions. Thanks! :D

    Regards,
    Mel Pison


    ---------------------------------------------------------------------
    To unsubscribe, e-mail: [EMAIL PROTECTED]
    <mailto:[EMAIL PROTECTED]>
    For additional commands, e-mail: [EMAIL PROTECTED]
    <mailto:[EMAIL PROTECTED]>



Reply via email to