Mailing Lists: Apple Mailing Lists
 Image of Mac OS face in stamp
Re: Feedback about issue with MySQL and get primary key
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Feedback about issue with MySQL and get primary key

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 result (basically 2 results : data accepted or not)
2 - if result = data_accepted, I insert new data using raw sql
3 - write into a log entity (in any circumstances) using EOF aka create an object and insert it into an ec.

What I tried to explain is that when the EOUtilities.rawRowsForSQL is executed in step 2 (and it works, I don't have any issue here), the step 3 fails because he can't get a primary key. If the step 2 is not executed, the step 3 is executed successfully.

I put the simple code below that is executed, just in case but nothing weird I guess (I removed the try/catch).

Cheers,

Philippe

String aIpAdress = (String) userInfo.get(NotificationUserInfoEnum.IP_ADDRESS.toString());
String aRequest = notificationData.getSenderUri();
String aStatus = (String) userInfo.get(NotificationUserInfoEnum.STATUS.toString());

EOEditingContext ec = ERXEC.newEditingContext();
ec.lock();
NOApplication anApplication = null;
if (notificationData.getApplicationName() != null)
anApplication = NBCacheManager.getInstance().application(ec, notificationData.getApplicationName(), notificationData.getPlatform());

NONotificationRequestLog notificationLog = NONotificationRequestLog.createAndInsertNONotificationRequestLog(ec);


if (anApplication!=null)
{
notificationLog.setApplication(anApplication);
notificationLog.setApplicationName(anApplication.name());
}
else if (notificationData.getApplicationName() != null)
notificationLog.setApplicationName(notificationData.getApplicationName());

//If a notification is received, we don't know the platform
if (!(this instanceof NBNotificationReceivedRecorder))
notificationLog.setPlatform(notificationData.getPlatform());
notificationLog.setIpAddress(aIpAdress);
notificationLog.setRequest(aRequest);
notificationLog.setStatus(aStatus);

ec.saveChanges();



On 5 sept. 2011, at 01:08, Ray Kiddy wrote:


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, 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), MySQL v5.0.88

Context: 
DA where informations are checked, fetched then if everything is fine, informations are saved. At the end, we write into a log the request plus the result and some informations (IP address, …).

When informations are saved, I decided to use EOUtilities.rawRowsForSQL to execute an insert sql command in order to optimize the complete R-R.

Then I write into the log the request, result, … as I said.

If the insert command is executed, when the log is saved (through its editingContext), I got an exception when the adaptor tries to get a new primary key:

Sep 04 14:52:56 YNP_NOWebServicesApp[5000] DEBUG NSLog  - Searching for primary key value for NO_Sent_Notification_Request_Log_TEST
Sep 04 14:52:56 YNP_NOWebServicesApp[5000] DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor._MySQLPlugIn$MySQLExpression: "SELECT PK FROM EO_PK_TABLE WHERE NAME = 'NO_Sent_Notification_Request_Log_TEST' FOR UPDATE" withBindings: >
Sep 04 14:52:56 YNP_NOWebServicesApp[5000] INFO  er.extensions.ERXAdaptorChannelDelegate.sqlLogging  - "Unknown"@795485135 _expression_ took 232 ms: SELECT PK FROM EO_PK_TABLE WHERE NAME = 'NO_Sent_Notification_Request_Log_TEST' FOR UPDATE
Sep 04 14:52:56 YNP_NOWebServicesApp[5000] DEBUG NSLog  - fetch canceled
Sep 04 14:52:56 YNP_NOWebServicesApp[5000] DEBUG NSLog  - 0 row(s) processed
Sep 04 14:52:56 YNP_NOWebServicesApp[5000] INFO  er.transaction.adaptor.Exceptions  - Database Exception occured: java.lang.IllegalArgumentException: Array is empty

If I replace EOUtilities.rawRowsForSQL  with ERXEOAccessUtilities.insertRow(ec, NOAppOpenedAfterPushEvent.Keys.ENTITY_NAME, dic), everything works great.

For those who were wondering why I wanted to use EOUtilities.rawRowsForSQL(), the reason is that I wanted to use "INSERT DELAYED INTO ".

Have a good sunday.

Philippe



I used to know how to do this using only WebObjects classes, but I cannot remember any longer. But this works with Wonder classes. There may be a better way to get to the EOAdaptorChannel.Delegate, but I always seem to re-find the chain one has to follow. You can get the EODatabaseContext at any point that you have an eo and use that to get the EOAdaptorChannel. Once you have them, you do not need to find them again. In the code below, the setDelegate methods end up getting called more often than they need to be, but since I am using singletons for the delegate instances, this is harmless. I ran this and verified, after turning on the EOAdaptorDebugEnabled flag, I get:

Sep 04 15:07:54 TreeFul[51162] DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT DELAYED INTO c_tree_closure(down, up, distance) VALUES (?, ?, ?)" withBindings: 1:39(down), 2:39(up), 3:0(distance)>
eosqlexpression statement: INSERT DELAYED INTO c_tree_closure(down, up, distance) VALUES (?, ?, ?)
Sep 04 15:07:54 TreeFul[51162] DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "INSERT DELAYED INTO c_tree_closure(down, up, distance) VALUES (?, ?, ?)" withBindings: 1:39(down), 2:1(up), 3:1(distance)>

So, it does work. Anyway, good luck.

cheers - ray


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
References: 
 >Feedback about issue with MySQL and get primary key (From: Philippe Rabier <email@hidden>)
 >Re: Feedback about issue with MySQL and get primary key (From: Ray Kiddy <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2011 Apple Inc. All rights reserved.