Re: Filemaker und WebObjects?
Re: Filemaker und WebObjects?
- Subject: Re: Filemaker und WebObjects?
- From: Sam Barnum <email@hidden>
- Date: Fri, 17 Feb 2006 09:08:26 -0800
If you run into any other issues with Filemaker, please post them
here or send email to the WooF support team, we'll do our best to get
them answered. Since WooF7 uses XML to query the database, there are
some unexpected issues with regards to speed and equality searches.
Doing an equals search on a TEXT field is not speedy, for example,
since Filemaker XML publishing is more geared towards "contains"
searches.
On Feb 9, 2006, at 2:50 PM, Clark Mueller wrote:
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:
40prometheus-systems.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