Hi All,
I have some problem again regarding with updating of user object in the
database. I could add new records now, but my problem is like this. When
I try to edit a user information it could update the user in database,
and it will go to the same page where i edited the user information. but
after i press the save button to update the user I get an error message
saying
Object of class [com.voxsant.thinkscan.model.User] with identifier
[3]: optimistic locking failed; nested exception is
org.hibernate.StaleObjectStateException: Row was updated or deleted by
another transaction (or unsaved-value mapping was incorrect):
[com.voxsant.thinkscan.model.User#3]
Michael Horwitz wrote:
The key error here is "Duplicate entry 'admin' for key 2". It looks as
if you are trying to save a user who already exists. Normally this
happens because you do not have a field in your form for the user id
(this should be a hidden field). As a result, when your request goes
back to Hibernate it thinks you are persisting a new user rather than
updating an existing one.
Mike.
On 7/12/07, *Mel Pison* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
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]>
<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]>
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED]>
