Download the FileMaker Pro 14 xDBC package for Mac and copy the file
fmjdbc.jar
to the project directory.
Edit FilemakerJDBCTest.java
and enter credentials.
javac FilemakerJDBCTest.java
CLASSPATH=fmjdbc.jar:. java FilemakerJDBCTest
Edit fmjdbc.py
and enter credentials.
pip install -r requirements.txt
CLASSPATH=fmjdbc.jar:. python fmjdbc.py
In the Python example I get the column name and column type for each column from the metadata and this is stored in an array of tuples.
Thank you.