Filemaker connection with Servoy 3.0 Beta1

Classic Servoy
1

I’m doing some test with the new filemaker “driver” in Servoy 3.0 which allows Servoy to connect to filemaker via filemaker web companion.

I got a connection to Filemaker and I can see all tables (files) from Filemaker in Servoy. But, if I’m creating new records or modifying records in Servoy, I’m getting the errors:

S1000 General error java.lang.NullPointerException in statement [insert into FMP01 ( MY_R_RECID, FIRMA, NAME, VORNAME, STRASSE, PLZ, ORT, RECID) values ( ? , ? , ? , ? , ? , ? , ? , ? )]

S1000 General error java.lang.NullPointerException in statement [update FMP01 set NAME = ? where FMP01.RECID = ?]

Is this a bug or a known issue?

Thanks
Hans-Peter

Servoy Developer
Version 3.0b1-build 362
Java version 1.5.0_06-b05 (Windows XP)

2

Hi Hans-Peter

I also tried to connect with Servoy 3 Beta1 to FileMaker 6 files, without success! What did you do and where did you put which driver in the file system to be able to see the FM tables/files?

Thanks in advance for your tips, Robert

hpmxxx:
I’m doing some test with the new filemaker “driver” in Servoy 3.0 which allows Servoy to connect to filemaker via filemaker web companion.

I got a connection to Filemaker and I can see all tables (files) from Filemaker in Servoy. But, if I’m creating new records or modifying records in Servoy, I’m getting the errors:

S1000 General error java.lang.NullPointerException in statement [insert into FMP01 ( MY_R_RECID, FIRMA, NAME, VORNAME, STRASSE, PLZ, ORT, RECID) values ( ? , ? , ? , ? , ? , ? , ? , ? )]

S1000 General error java.lang.NullPointerException in statement [update FMP01 set NAME = ? where FMP01.RECID = ?]

Is this a bug or a known issue?

Thanks
Hans-Peter

Servoy Developer
Version 3.0b1-build 362
Java version 1.5.0_06-b05 (Windows XP)

3

Hello Robert

To get a filemaker connection, you need 2 steps:

  1. Configure the Web Companion in Filemaker. The plugin and the companion-sharing has to be active.

  2. Configure a new DB-Server (Servoy-Preferences). Under the tab “DB Servers”. I’ve attached some screenshots.

You don’t need to install special drivers, at least on Windows. The driver comes with v3.0 beta 1. I didn’t test it yet on Mac, so I don’t know if it’s working on Mac.

Hans-Peter

screens.zip (35.2 KB)

4

I want to emphasise that it was an experiment to use hypersonic inmem database (as driver) on Filemaker to make FMP SQL92 compatible.
It’s currently slow on big FMP datafiles, does not (yet) support FMP container fields and it is not supported by Servoy at this moment.

5

Hi Jan

That’s ok with me if it’s an experiment. My problem is that I can’t connect to a FM DB at all with Beta1 (on Mac OS X 10.4.5 and Java 1.5.0_05-48), but it used to work in a former Alpha Release. Did anybody successful connect to FM with this Servoy Version and OS?

Best regards, Robert

Jan Blok:
I want to emphasise that it was an experiment to use hypersonic inmem database (as driver) on Filemaker to make FMP SQL92 compatible.
It’s currently slow on big FMP datafiles, does not (yet) support FMP container fields and it is not supported by Servoy at this moment.