1 Enable the Web Companion;
2 Set it to listen on port 591
3 Make sure that the db's sharing is set to share via the Web Companion
4 Place the FileMaker JDBC driver in the /Library/Java/Extensions directory
5 Add something similar to following to the users jdbc.ini file (and the server's)
<DataSource ID="FileMakerDBs">
<DSN>FileMakerDBs</DSN>
<DriverClass>com.fmi.jdbc.JdbcDriver</DriverClass>
<URL>jdbc:fmpro:http://127.0.0.1:591/properties?fetchsize=10</URL>
<Properties />
</DataSource>
6 Start up the Dev Studio
7 All the FileMaker dbs that are shared will be under this datasource.
A bit of advice when using FileMaker JDBC calls:
Count is not supported in the current JDBC driver (needed for the previous and next button syntax of the search builder)
Build your databases without extensions in the filename as it may be interpreted as the owner.tablename in SQL Syntax.
The Witango server does try to compensate for the ".FP5" extension when generating the SQL.
Do not use spaces or special characters in field (column) names.
The sql syntax is limited to the following so you may see SQL errors if you create a SQL action that moves outside this syntax:
SELECT
SELECT { { * | field_name .,.. } [ , RECORDID [ , MODID ] ] }
FROM database_name [ LAYOUT layout_name ]
[ WHERE { predicate [ { { AND | OR } predicate } ... ] } ]
[ ORDER BY { field_name [ASC | DESC] } .,.. ]
Where predicateequals { field_name { = | <> | > | >= | < | <= | LIKE } { value | ? } } | {field_name IS NULL} | {RECORDID = {value | ?}}
INSERT
INSERT INTO database_name [ LAYOUT layout_name ] ( field_name .,.. ) VALUES ( { value | NULL | ? } .,.. )
UPDATE
UPDATE database_name [ LAYOUT layout_name ]
SET { field_name = { value | NULL | ? } } .,..
[ WHERE { predicate [ { { AND | OR } predicate } ... ] } ]
Where predicateequals { field_name { = | <> | > | >= | < | <= | LIKE } { value | ? } } | {field_name IS NULL} | {RECORDID = {value | ?} [ AND MODID = { value | ? } ] }
?
DELETE
DELETE FROM database_name
[ WHERE { predicate [ { { AND | OR } predicate } ... ] } ]
Where predicateequals { field_name { = | <> | > | >= | < | <= | LIKE } { value | ? } } | {field_name IS NULL} | {RECORDID = {value | ?} }
CALL
{ CALL script_name ( database_name [ , { layout_name procedure (a script) | password } ] ) }
The outermost curly brackets { } are part of the CALL statement syntax.
Syntax Definitions
square brackets [ ] means an optional parameter
vertical bar | means “or.”
ellipsis (…) means repetition any number of times.
periods and a comma (.,..) means repetition separated by commas.
Using the RecordID pseudo column
The FileMaker JDBC Driver provides a RecordID pseudo column (in place of a primary key used by other types of databases)that can be specified in the column name list of a SELECT statement or in the WHERE clause of SELECT, UPDATE or DELETE statements.?This lets you guarantee that the statement will operate on a specific record.
UPDATE "Employees.fp5" SET department='engineering' WHERE recordid=4
NOTE:?All other columns are ignored when the RecordID pseudo column is used in a WHERE clause.
As an aside, JDBC looks like it will become a standard interface for FileMaker 7 so it is a good time to start getting familiar with it.
The following is taken from a recently published article as we are not allowed to say anything about FileMaker 7 ;)
http://www.thinksecret.com/news/filemaker7specialreport.html
...
FileMaker 7 will include more intuitive password management that will be "far easier" for new users, sources said. "The clumsy system used in current versions is gone." The new options, accessible from FileMaker 7's "Define Accounts & Privileges" dialog, will offer users more power and flexibility; administrators will be able to assign "extended privileges" to individual privilege sets, including access via Instant Web Publishing, ODBC/JDBC, FileMaker Network, or FileMaker Mobile.
...
Sources said FileMaker 7 will boast significant performance improvements, with one source describing the new version's speed as "SQL-like." While Think Secret couldn't obtain specific performance numbers, one informant said that "it's noticeably faster than FileMaker 6 running on the same hardware."
...
Phil
On 19/02/2004, at 7:08 AM, Jason Pamental wrote:
> Hello all,
>
> I'm trying to help get JDBC connectivity set up between Witango on OS
> X (Dev Studio) to Witango on OS X (FMP DB server). Before I go into
> lots of info about what I've tried so far (obviously without too much
> success) - is anyone currently doing this and can you share your JDBC
> INI settings?
>
> Thanks,
>
> Jason
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
