• 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: Entity Modeler and Filemaker
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Entity Modeler and Filemaker


  • Subject: Re: Entity Modeler and Filemaker
  • From: Clark Mueller <email@hidden>
  • Date: Wed, 24 Jun 2009 12:02:30 -0700

I definitely understand the legacy FileMaker problem. To elaborate a bit... I have used FileMaker with WO on two projects, sans WooF. I don't recall the reason for not using WooF in my application - it was certainly around at the time, but it was still commercial. My use of FileMaker was always limited to transferring data from a larger WO- based application to an existing FileMaker database for archival and reporting purposes.

The main things I remember as being problematic were manipulating dates and numbers. I also remember that conjunctive SQL queries with FileMaker's JDBC driver took so long as to be laughable (it was faster to perform X individual queries). I never found that indices made a difference with that. It's possible that's fixed in newer versions of the driver (the MD5 of the driver hasn't changed since FileMaker 7, even though they keep telling you it's required to upgrade). That said, the solutions I developed worked well in spite of these limitations (and continue to, so far as I know).

Clark

On 2009-06-24, at 11:48 AM, Sherry Tirko wrote:


I really don't have a choice. I have to connect to an existing Filemaker database that is actively being used. I do currently use WOOF with Filemaker 6 which works well, but the database is being upgraded to Filemaker 10. I couldn't get any information saying that WOOF supported 10. I was going to use the default driver, but maybe I should test out the WOOF driver and see what happens.


Thanks,
Sherry


On Jun 24, 2009, at 2:26 PM, David Holt wrote:

Hi Sherry,

There is also an opensource framework <https://woof.dev.java.net/> that will allow you to connect WebObjects to Filemaker. I don't know how well it works, but it used to be a commercial product. If you could tell us which option you choose and how successful it is, that would be much appreciated. Thanks!

David


On 24-Jun-09, at 11:11 AM, Chuck Hill wrote:

Hi Sherry,

From Oracle to FileMaker. You sure do run the gamut of tools there! :-)

If you just need to work with a snapshot, FrontBase has a FileMaker to FrontBase migration tool. That would give you a real SQL92 database to work with.


Chuck


On Jun 24, 2009, at 11:06 AM, Clark Mueller wrote:

You'd be happier if you went CamelCase, but I recommend against FileMaker + WO. There are lots of gotchas; the FileMaker JDBC driver is pretty weak.

Clark

On 2009-06-24, at 10:59 AM, Sherry Tirko wrote:


Hello,

I have to interface with a Filemaker database which has spaces in a majority of the attribute names. Entity Modeler does not like this. My thought is to replace the spaces with underscores. Does anyone have any recommendations/suggestions or know if this will work?

Is there anyone else out there that uses Filemaker with WO?

Thanks,
Sherry




Sherry Tirko SOAR Project Outreach Technology Services 814-865-9068 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

_______________________________________________ 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


-- Chuck Hill Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects







_______________________________________________ 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


_______________________________________________ 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

_______________________________________________ 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
References: 
 >Entity Modeler and Filemaker (From: Sherry Tirko <email@hidden>)
 >Re: Entity Modeler and Filemaker (From: Clark Mueller <email@hidden>)
 >Re: Entity Modeler and Filemaker (From: Chuck Hill <email@hidden>)
 >Re: Entity Modeler and Filemaker (From: David Holt <email@hidden>)
 >Re: Entity Modeler and Filemaker (From: Sherry Tirko <email@hidden>)

  • Prev by Date: Re: Entity Modeler and Filemaker
  • Next by Date: How do get WOLips to revalidate bindings?
  • Previous by thread: Re: Entity Modeler and Filemaker
  • Next by thread: Re: Entity Modeler and Filemaker
  • Index(es):
    • Date
    • Thread