users@glassfish.java.net

RE: Glassfish Oracle Mystery

From: Kenneth Clark <kenneth.clark_at_skyetech.co.za>
Date: Wed, 31 Oct 2007 10:19:54 +0200

I will book some time on the server and get that stuff to you ASAP

________________
Thanks and regards

Kenneth Clark
Solutions Engineer


Tel: 27 11 679 3075
Mobile: 27 (0) 84 583 1348
Email: kenneth.clark_at_skyetech.co.za
Website: http://www.skyetech.co.za


-----Original Message-----
From: Sanjeeb.Sahoo_at_Sun.COM [mailto:Sanjeeb.Sahoo_at_Sun.COM] On Behalf Of Sahoo
Sent: 31 October 2007 10:16
To: users_at_glassfish.dev.java.net
Subject: Re: Glassfish Oracle Mystery

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

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.15.14/1100 - Release Date: 2007/10/30 18:26
 

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.15.14/1100 - Release Date: 2007/10/30 18:26