Re: Filemaker und WebObjects?
Re: Filemaker und WebObjects?
- Subject: Re: Filemaker und WebObjects?
- From: Clark Mueller <email@hidden>
- Date: Thu, 9 Feb 2006 15:50:01 -0700
Ute,
I have used WO to interface with FileMaker on a couple of occasions.
If you search the list archives, you'll find a brief exchange from me
previously on the topic. Woof has only recently been upgraded to work
with FileMaker 7 databases, so I haven't tried it out yet, but my
rules of thumb when working without it are:
- Build your model manually; don't expect to be able to synchronize
it, either. The classpath issue you mention, I believe, is the result
of trying to have EOModeler build your model for you.
- Time related data types from FileMaker simply do not work
correctly; FM's JDBC driver expects them to be enclosed in {},
instead of in quotes (""), which is how EOF writes its SQL (it looks
like Woof7 does this; see below).
- Default values/serials don't work properly (again, Woof7 does this).
- Don't use batch faulting. This is very counter intuitive, I know,
but this results in EOF creating a SQL statement that uses a series
of OR qualifiers (as expected). FM7's JDBC driver completely chokes
on these queries, and in my experience, can time out or at least
create noticeable delays when dealing with tables containing upwards
of 50,000 records.
Those are the only big gotchas I've found. I suspect that Woof7 takes
care of the first three with no problems, but again, I haven't used
it personally just yet. I don't know of any way it would help you
with the last one, however, as that appears to be a bug in the FM
JDBC driver that I am able to reproduce outside of the EOF environment.
Regards,
Clark
On 9 Feb 06, at 3:00 PM, Ute Hoffmann wrote:
Hi,
there is a jdbc-Driver for filemaker now
(com.ddtek.jdbc.sequelink.SequeLinkDriver).
Has anyone had success in using it? I get a classpath error, but I
know it is in the classpath (had such issues, when driver was not
properly regognized before) so could someone please confirm that it
works with EOModeler?
Thanks a lot,
Regards,
Ute
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com
This email sent to email@hidden
_______________________________________________
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