Using DataDirect SequeLink JDBC 5.4 - FileMaker Server 8v4

[Javier.Valencia]

I am using DataDirect SequeLink for JDBC 5.4 to connect to FileMaker.
I can get the connection, see the tables, and create a form.

Database Server URL:
jdbc:sequelink://mytestserver:2399;serverDataSource=TestJdbc;HUser=test;HPassword=test

When I try to retrieve data I get this error:
com.servoy.j2db.persistence.RepositoryException: Cannot work without primaryKey on table ‘testjdbc’

Could we do the same as in Oracle for table views to define the Primary Key using the Data Providers tool…?

Thanks,
Javier

[sbutler]

There are several methods in the JDBC API specification that the DataDirect FMP driver does not implement…one of those is getPrimaryKey(), which happens to be critical for Servoy. There is no way around that…that I have seen. You can however use their JDBC driver with the RawSQL plugin…but Forms cannot be based off of FMP tables with that driver.

If you have FileMaker advanced, I suggest you check out my driver at http://goldcougar83.googlepages.com/home2 which uses XML and specifies a the primary key as part of the URL.

FYI, here was a comparison I showed at servoy world.