• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Filemaker und WebObjects?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Follow-Ups:
    • Re: Filemaker und WebObjects?
      • From: Clark Mueller <email@hidden>
References: 
 >Re: Filemaker und WebObjects? (From: Clark Mueller <email@hidden>)

  • Prev by Date: Help with: org.apache.xmlrpc.XmlRpcException: out of threads
  • Next by Date: Re: Help with: org.apache.xmlrpc.XmlRpcException: out of threads
  • Previous by thread: Re: Filemaker und WebObjects?
  • Next by thread: Re: Filemaker und WebObjects?
  • Index(es):
    • Date
    • Thread