Re: Entity Modeler and Filemaker
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