Preferred way for fetching with given SQL select statement?
Preferred way for fetching with given SQL select statement?
- Subject: Preferred way for fetching with given SQL select statement?
- From: Markus Ruggiero <email@hidden>
- Date: Thu, 24 Sep 2015 16:22:32 +0200
| Folks,
What is the preferred way to fetch EOs when you have a db vendor specific "select id from ... where ....." statement?
I need to interface with a legacy system where I have to incorporate the functionality of an external java tool into a Wonder app. This external tool executes raw SQL select statements which it reads from a file. All the statements are in the form given above and return a list of primary key values (single column fortunately). The tool then iterates through that list and does whatever it has to do (issuing tons of more raw sql). My problem is that these select statements are rather complex and there are many of them. It is just not feasible to replace those with proper EOQualifiers. In addition these statements are parameterized with ? so they can be precompiled and then used with different query values. However everything can be done with standard EOs as soon as I have those corresponding to the returned list of ids.
Thanks a lot ---markus--- |
_______________________________________________
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