I am so so so so sorry for wasting everyone's time. I feel like such a moron.
Okay problem resolution: The GUID is 36 in length, the field is 38 is length. The padded whitespace was causing the issue as it was not being passed back as part of the ID. Hence the reason it was not finding the ID.
I dropped the length of the field to 36 and it works now. Again I am so sorry to all the people that participated, that is such a stupid mistake. Thanks to Sahoo for making me generate output from the DB to file. Without that I would never have seen the error.
One point though, this does work in Postgresql. Maybe Postgresql pads the input value.
Thanks again, you guys rule! I hope you all have a fantastic day.
________________
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: Kenneth Clark [mailto:kenneth.clark_at_skyetech.co.za]
Sent: 31 October 2007 10:20
To: users_at_glassfish.dev.java.net
Subject: RE: Glassfish Oracle Mystery
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
---------------------------------------------------------------------
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