Filemaker Server Advanced 11 as DataSource

[david.martinez]

Hi,

I have tried to set up a new database source to connect to a Filemaker 11 DB and Servoy always is returning me this kind of error:

Code: Select all

Could not load record
> com.servoy.j2db.dataprocessing.DataException: Borrow prepareStatement from pool failed


To set up I have created a new Windows ODBC and in Servoy I'm creating a new database server with this configuration:

URLjdbc:odbc:<nameDSN>
Driver:sun.jdbc.odbc.JdbcOdbcDriver

So my questions are:

1.- Is possible to read/write from filemaker11 DB?
2.- What is wrong with my configuration?

Thanks in advance!

[ROCLASI]

Hi David,

Just going on the error message I would say FMPro 11 doesn't support prepared statements. Something Servoy uses extensively.
I suggest you check with Filemaker Inc. to see if this is the case.

[dpriddle1331311432]

Assuming you've got FileMaker running and ODBC/JDBC sharing turned on, and have the JDBC driver .jar file you download from FileMaker's website in your application_server/drivers folder, then I think the problem is your url and driver strings.

To connect to a FileMaker file called MyFile.fp7 running on the same machine as Servoy, your URL would look like this:

Code: Select all

jdbc:filemaker://localhost/MyFile

And the driver string would be this:

Code: Select all

com.filemaker.jdbc.Driver

Note that if you're trying to connect with FileMaker using Servoy 5.2 and are on a Mac, you'll need to make the connection manually in the properties file. (See this post: https://www.servoy.com/forum/viewtopic.php?f=4&t=15549#p83801)

One other thing to be aware of: if there are tables across multiple files you want to connect with, you'll need to import those tables into a single .fp7 file. Otherwise, you'll see the connections, but you won't actually be able to access any of the data.