Re: advanced EOF: batch fetching relationship: can't fetch certain relationships
Re: advanced EOF: batch fetching relationship: can't fetch certain relationships
- Subject: Re: advanced EOF: batch fetching relationship: can't fetch certain relationships
- From: Jonathan Rochkind <email@hidden>
- Date: Wed, 18 Feb 2004 10:15:53 -0600
Would it be easier to make an MS SQL plug in? Well... I don't think
so. Making a plug in kind of scares me, and seems like a lot more
work. And briefly looking over the plug in API, there doesn't seem
any obvious place to fix this particular issue. (I think it may
require making a custom SQLExpression class, delivered by that custom
plug in, which is even more trouble).
Note that in my current setup, I _am_ using a custom JDBCPlugIn
class, but all it does is provide primary key generation support,
pretty much. The generic JDBCPlugIn generally works for MS SQL Server
7.
If I was using MS SQL Server 2K, I would use the Apple provided plug
in for this purpose; it's possible the Apple provided plug in would
work even with MS SQL Server 7 and the non-MS JDBC adaptor I'm using
(there is a free MS JDBC adaptor for SQL Server 2K)---I've never
tried it because I've been using my working setup since before it
existed. I don't think it would solve this problem anyhow. The fact
that the EOF code uses a 'select distinct' for batch fetching
(unneccesarily, as far as I can tell; I can't figure out what purpose
it serves) is not, I don't think, something controlled by the plugin.
--Jonathan
At 9:25 PM -0500 2/17/04, Arturo Pirez wrote:
On Feb 17, 2004, at 9:08 PM, Jonathan Rochkind wrote:
One idea I have:
Construct a fetch spec myself, and do the fetch myself, WITHOUT
using DISTINCT, then asssemble the results into appropriate
snapshots, and record them directly to the EODatabase myself
manually.
Doing such low level stuff always makes me nervous, but do the EOF
gurus think something like that will work? Is a good idea?
Would it be easier to make a MS-SQL plug-in to affect these sorts of things?
----
WO in philadelphia - wanna cheesesteak with that?
Please visit webobjects.meetup.com.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.