We have many FileMaker databases and want to be able to use FileMaker as a data provider so the data can be shown in Servoy (until we convert all the databases to mySQL).
I have been working on this for about a week with no success. I have the JDBC driver setup correctly. I can add the FileMaker server as a DB Server, and the databases and tables will show when I go into data providers, but it errors out after clicking “ok”. The message errors because there is no primary key in the FileMaker tables.
I really need to get this working and would appreciate any help.
I have no information for you yet but I would be interested in a walk through of how you set up the FM source as a database server - particulary with regard to the driver jar file used for Servoy
Armed with this info I will be keen to try to set up a link and report back
You have to tell Servoy what column the row identifier is. In other words what field holds a unique value that Servoy can use as row identifier.
What to do?
You can assign row idents in Servoy’s Dataprovider window. You select the table there and in the grid you will see the columns with their properties.
You can assign a column by just clicking in the column of the Row Ident.
It involves installing the xDBC plugin on the FileMaker Server, Enabling JDBC connections through FM Server Admin, and turning on JDBC on the individual database. Then, you just put the JDBC driver in Servoy, and use the connection URL to point it to the FM Server, and it sill show the database and tables in Servoy.
I have attempted to assign the row idents in Servoy’s Dataprovider window as you have suggested, but when clicking the “ok” button, it gives the error the the datasource not having a primary key…so thats the spot where I get stuck.
goldcougar:
I have attempted to assign the row idents in Servoy’s Dataprovider window as you have suggested, but when clicking the “ok” button, it gives the error the the datasource not having a primary key…so thats the spot where I get stuck.
I just tested it on a new database (in PostgreSQL).
I didn’t define any primary key and Servoy complained about it. So I told it what the row identifier is and it worked fine.
You’re sure you did this for every table in your database?
Servoy Developer
Version R2 2.2.3-build 335
Java version 1.5.0_05-48 (Mac OS X)
Hi Scott,
I am attempting to set this up on my PowerBook using a local FM8 file.
I have the xDBC plugin activated and am sharing the FM8 file via JDBC to all users.
I have downloaded the FM update archive with a driver jar file named: ‘ddsljc.jar’ and placed this inside the Servoy driver folder.
I am having difficulty creating the DB Server entry and am wondering could I impose on you to outline the entries which you made in Servoy DB Server setup or post a screen shot of the server entry - maybe outline that sctual driver choices which you made too !
I attempted to set it up for all of the tables/databases, but it would not let me. After you click the arrow on the FM Server name to show all of the tables, and then you click on 1 table, it takes about a minute to load. Then, if you attempt to click on another table it will not load. And, you can’t click OK because you get that error.
I think the JDBC driver in FileMaker just sucks.
I’m not exactly sure how to do it in FM 8, since I was working with FM 7, and I think the drivers have been changed since…at lest the URL connection string is different.
