Kenneth Clark wrote:
> BUT
> When I open the SQL Editor and do a "SELECT * FROM PRODUCT where ID = 3D88A6C1-FF98-3EA8-1460-88350A38A414" the row return is:
> Code = A21
> Description = B31
> ID = 3D88A6C1-FF98-3EA8-1460-88350A38A414
>
> ---------------------------------------
>
Although you have mentioned that "listAll" method returns only one
instance, to avoid any surprises, can you please do a "SELECT * FROM
PRODUCT" and see if a new row was inserted by mistake?
> Sahoo I am in the process of getting that log file to you, I am not the only one that works on this server so it is mangled. Could you tell me what you are looking for specifically?
>
It is extremely important that we have control over the environment and
we look at all the log messages. This is what I want you to do:
1. You be the only user of the system during this exercise.
2. Go to admin console, and set the log level to FINE for both jta
logger as well as persistence logger.
3. Clear the log file.
4. Restart the server.
5. Run "SELECT * FROM PRODUCT" query ad capture the results in a file
(say) orig.txt.
6. Call the persistEntity() web service method.
7. Run "SELECT * FROM PRODUCT" query ad capture the results in a file
(say) new1.txt.
8. Call the mergeEntity() web service method.
9. Run "SELECT * FROM PRODUCT" query ad capture the results in a file
(say) new2.txt.
10. Send server.log, orig.txt, new[12].txt. If the database has too many
rows, then you can send diff between the txt files. Please also send the
data sent to persistEntity() & mergeEntity().
All these should not take more than 5-10 minutes, so you are really not
blocking the whole system for long.
Thanks,
Sahoo