Connecting Pro 11 to Server 10 through JDBC

[RobinDC]

I would like to connect FileMaker Pro Adv 11 client to FileMaker Server Adv 10 using JDBC. I've been using Pro 11 is a JDBC client to MySQL just fine. FMSA is configured to share ODBC & JDBC, and so is the file. I am using360Works JDBC plugin v1.74, and the 'JDBC Example.fp7' file from that plugin for testing. The 'fmjdbc.jar' driver is from the FileMaker 11 v2 dmg image, and loaded by the connection script from a container field.

jdbcLoadDriver( "com.filemaker.jdbc.Driver" ; fmjdbc.jar )

jdbcOpenDatabase( "jdbc:filemaker://myfmserver:2399/mydatabase" ; username ; password )

The driver seems to load fine, but as soon as the script gets to the jdbcOpenDatabase step, the FileMaker client freezes. Several minutes later, I Force Quit and restart. Should I be using a different driver like DataDirect SequeLink from FileMaker 10? WooF seems a bit complicated to me. Perhaps there is a problem with my configuration commands. Insight and recommendations are greatly appreciated.

[Wim Decorte]

The obvious question is "why not just connect FM to FMS? Why try to use JDBC for this?"

What problem are you trying to solve?

[RobinDC]

I know it sounds silly, it's really just an easy proof-of-concept. Of course, after a day of research, I figured it out 2 hours after my post. I was installing the fmjdbc.jar driver on my client machine, but not on the server. Once I loaded the .jar file into /Library/Java/Extensions the connection worked fine. This worked with my mini FMSA 11v3 test server, I'll still need to get it working on the Win 2003 FMSA 10 production machine, but that will be a different post I'm sure.