I have not seen the drop off of connections on or Digital forest box but have seen it here on my own development system. I don’t know if that has something to do with the other stuff I am running on my development machine and have not been able to trace down a good reason.
I managed to crash the server with a is in query when there were enough values ( I think over 100).
I have not used a union I have done the unions and intersections with witango instead of the ODBC.
There is plenty of other behavior you need to watch out for I am preparing a paper I hope to have done next week or so.
But some of the highlights.
Filemaker ODBC and I’ll bet JDBC uses Unicode and so all searches are case sensitive. There is no way to turn this off.
Filemaker ODBC does not really tolerate searches that involved unstored calcs.
This is a problem because in 7 you can do an auto enter calc and index it but the indexing must not be real indexing or must not translate to the ODBC JDBC part of the engine. Searches or joins involving these type of fields will time out or be so slow as to be useless.
There seems to be no way to directly insert a date into the date field. It keeps getting translated as YYYY-MM-DD which Filemaker will not accept.
If you start to pound on the thing with multiple users doing searches it will pin the processor. The only way to avoid that is to get cache up to 256 meg at least and flush it over 10 or 15 minutes. This brings the disk I/O way down and allows cache for the searches to build so performance improves.
I guess that’s enough secrets for now or no one will want to read my paper.
Dan
on 2/17/05 16:09, Peter Link at [EMAIL PROTECTED] wrote:
Shannon,
Would you mind including your jdbc.ini entries to give us a better starting point? I upgraded to the latest FMPro xDBC plugin and I'm getting some slightly different errors now. I just want to make sure my jdbc file is configured properly. Thanks.
We're using Filemaker Server 7 Advanced and Witango 5 Server on OS X with JDBC.
If you're getting a connection refused error, it sounds like you have the parts in the right places. First, be sure the server is set to accept ODBC/jDBC connections on the Configuration tab of Filemaker Server Admin. Then, using a 7 client, you need to open the file (not while served) and turn ODBC/JDBC sharing on using Filemaker Pro>Sharing>ODBC/JDBC... Select your file from the list of currently open files and select the user access level. If you don't see the ODBC/JDBC option, you either have the wrong version of Filemaker 7 client or you need to install the xDBC.fmplugin. If you're still getting that error, you might check that port 2399 is set to accept connections.
I hope that helps.
On a different note, we've noticed some fairly unfortunate instability on our Filemaker Server 7 Advanced server. Notably, it just stops accepting new connections every now and then. I'm not sure that is related to Witango. I would be interested in knowing if other folks see similar behavior.
One additional note, I did manage to crash the Filemaker Server by using an UNION via JDBC(Filemaker says this is unsupported, but I did not listen. :-))
--------------------------------------------------------------------
Shannon Henderson
Web and System Services
Reed College
Portland, OR 97202-8199
503.517.7745
[EMAIL PROTECTED]
--------------------------------------------------------------------
On Feb 4, 2005, at 11:22 AM, Michael Dittbrenner wrote:
Has anyone gotten Filemaker Server advanced 7 on mac to hook up with witango. Every time we try to hook up the jdbc connection we get connection refused error.
If you have gotten this to work how were you able to get this to?
Any help would be greatly appreciated.
Mike D
****************************************
Educational Directories Unlimited, Inc.
Michael Dittbrenner
Systems Administrator
http://www.StudyAbroad.com
http://www.GradSchools.com
A service of EDU, Inc... http://www.EDUdirectories.com
A partner of EDU Internet Strategies: http://www.EDUInternetStrategies.com/
[Phone] 610-499-9200
[Fax] 610-499-9205
[E-mail] [EMAIL PROTECTED] or [EMAIL PROTECTED]
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000, MySQL, CWP
[EMAIL PROTECTED]
www.dss-db.com
"When you are born, you cry and those who love you rejoice. And if you
live your life as you should, when you die, you rejoice and those who
love you cry."
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
