Chapter 9 of the FileMaker Training Series book (the Advanced one) describes how to set up the file, access and the DSN to get data out of FM:
It's dirt cheap and explains everything step by step. Once you have it working by getting data into Excel then it should just work from JoPP.
Hello! perhaps this will help?
And you can get the docs here:
FileMaker SQL Reference and FileMaker ODBC and JDBC Guide
I just wanted to chime in and say that I routinely use JDBC to access FileMaker's data using SQL.
It's super easy to do and using a remote program (I use a Java IDE), I not only use regular SQL (no ExecuteSQL()....), get real-time error messages for SQL (no "?"), code assist for SQL as you type, and all the SQL functions: UPDATE, INSERT, and DELETE, as well as SQL Select. Sounds good, right?
And, FileMaker includes the JDBC driver (which is excellent) for free. (ODBC driver too, of course.)
(For JDBC -- No DSN needed. You just set up a user / password.)
I posted some screenshots here: Consider using a remote Java console to create SQL Queries
I'll be glad to try to answer any questions you might have.