Re: Feedback about issue with MySQL and get primary key

2011-09-07 Thread Philippe Rabier
You should be right. I gonna try using evaluateSQLWithEntityNamed to put the DELAYED instruction. (Ray'solution is interesting but I'm using an AUTO_INCREMENT pk to avoid a round trip to the database.) BTW if a Mysql guru read this email (Kieran?) is there a real gain to use DELAYED instructio

Re: Feedback about issue with MySQL and get primary key

2011-09-07 Thread Chuck Hill
Hi Philippe, On 2011-09-04, at 7:49 AM, Philippe Rabier wrote: > Hi all, > > Not a question but a feedback if you have the same issue but I don't have > explanation and I didn't look for any. > > Env: > WO 5.4.3, java 6 on Mac OS X 10.6.7, Eclipse 3.4, Wonder a bit old (several > months), M

Re: Feedback about issue with MySQL and get primary key

2011-09-05 Thread Cheong Hee (Gmail)
WHERE NAME = 'NO_Sent_Notification_Request_Log_TEST' Just another curiosity.. ;-) Cheers Cheong Hee - Original Message - From: Philippe Rabier To: WebObjects (Group) Sent: Tuesday, September 06, 2011 3:51 AM Subject: Re: Feedback about issue with MySQL and get primary key

Re: Feedback about issue with MySQL and get primary key

2011-09-05 Thread Philippe Rabier
t; Cheers >> >> Cheong Hee >> >> >> - Original Message - >> From: Philippe Rabier >> To: Ray Kiddy >> Cc: WebObjects (Group) >> Sent: Monday, September 05, 2011 4:55 PM >> Subject: Re: Feedback about issue with MySQL and

Re: Feedback about issue with MySQL and get primary key

2011-09-05 Thread Cheong Hee Ng
> - Original Message - > *From:* Philippe Rabier > *To:* Ray Kiddy > *Cc:* WebObjects (Group) > *Sent:* Monday, September 05, 2011 4:55 PM > *Subject:* Re: Feedback about issue with MySQL and get primary key > > Hi Ray, > > Thank you for the tip. That's some

Re: Feedback about issue with MySQL and get primary key

2011-09-05 Thread Philippe Rabier
Rabier > To: Ray Kiddy > Cc: WebObjects (Group) > Sent: Monday, September 05, 2011 4:55PM > Subject: Re: Feedback about issue withMySQL and get primary key > > Hi Ray, > > Thank you for the tip. That's something interesting to change the sql > exp

Re: Feedback about issue with MySQL and get primary key

2011-09-05 Thread Cheong Hee (Gmail)
ay need to invalidate all objects in the ec and try to save the log object again. Cheers Cheong Hee - Original Message - From: Philippe Rabier To: Ray Kiddy Cc: WebObjects (Group) Sent: Monday, September 05, 2011 4:55 PM Subject: Re: Feedback about issue with MySQL and get p

Re: Feedback about issue with MySQL and get primary key

2011-09-05 Thread Philippe Rabier
Hi Ray, Thank you for the tip. That's something interesting to change the sql expression on the fly. I was looking for that too. But you don't get me so I gonna try to be explain with more concise explanations. The algorithm is the following: 1 - get data from the DA, check data and return a r

Re: Feedback about issue with MySQL and get primary key

2011-09-04 Thread Ray Kiddy
Your rawRowsForSql call through an exception because you are completely bypassing the primary key generation process, so it you want to insert rows using this call, you need to generate the primary keys yourself. There is a better way to do this. See below. - ray On Sep 4, 2011, at 7:49 AM, P

Feedback about issue with MySQL and get primary key

2011-09-04 Thread Philippe Rabier
Hi all, Not a question but a feedback if you have the same issue but I don't have explanation and I didn't look for any. Env: WO 5.4.3, java 6 on Mac OS X 10.6.7, Eclipse 3.4, Wonder a bit old (several months), MySQL v5.0.88 Context: DA where informations are checked, fetched then if everyth