Forum post
Hi,
Did someone know the changes of JDBC driver in FM 11?
i used to use the following setup in Coldfusion but not after upgrade to 11.
Could someone help? I read the FM document and looks like the driver has upgraded or changed.
Following is the current setup.
In Filemaker FMpro database needs to be open! Enable ODBC/JDBC sharing in FMpro. Create a Username/password for coldfusion in your database. Install the JDBC drvier from the FM CD - run the .jar file from the CD, it's an installer which will prompt for an install location, create and choose ~/desktop/newfolder/ and when the installer is finished copy the contents of ~/desktop/newfolder/driver/lib/ (sljc.jar and sljcne.rar) to your CF7 /lib/ folder
In Coldfusion: create a data source using 'other' as the driver type.
JDBC URL= 'jdbc:sequelink://127.0.0.1:2399;serverdatasource=test'
Driver class= com.ddtek.jdbc.sequelink.SequeLinkDriver
Driver name= whatever you want, 'FM Pro' or something
User Name= the user you created earlier in your
FM database Password= the pass for the FM user you made.
Thanks,
Oliver
Answer
The values used for URL and Class Name have changed in FM 11. For your example, should use:
URL: jdbc:filemaker://127.0.0.1/test
Class: com.filemaker.jdbc.Driver
There is no .jar file installer to run. Instead you manually place the fmjdbc.jar file from the CD in a folder in your "classpath", as directed by the FM documentation.
Everything else (setting up FM, user name, password) should be the same.
Jonathan Monroe
Actual Technologies
Be the first to like this
|
Sign in to "Like"
Thanks Jonathan,
Should port number 2399 be added to the
URL: jdbc:filemaker://127.0.0.1/test
URL: jdbc:filemaker://127.0.0.1:2399/test
?
Be the first to like this
|
Sign in to "Like"
> Should port number 2399 be added to the URL?
FM 11 ODBC / JDBC *only* uses port 2399. I believe it is ignored if you specify it in the URL. Regardless, I would remove it.
Jonathan Monroe
Actual Technologies
Be the first to like this
|
Sign in to "Like"
Thanks Jonathan,
I've got the error below after a trial. No clue on what causing this. Any hints on solving this type of problem.
Connection verification failed for data source: fmsa_data com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Driver requires a more recent version of xDBC listener The root cause was that: com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Driver requires a more recent version of xDBC listener
Oliver
Be the first to like this
|
Sign in to "Like"
Hello,
Following is the dump error from terminal running from ColdFusion
Already put the driver file named "fmjdbc.jar" to Applications\ColdFusion\lib\
SQLException while attempting to connect: com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] Driver requires a more recent version of xDBC listener.
[FileMaker][FileMaker JDBC] Driver requires a more recent version of xDBC listener
[FileMaker][FileMaker JDBC] Driver requires a more recent version of xDBC listener
Great if someone can help.
The setting for Filemaker 10 is tested okay.
Thanks,
Oliver
Be the first to like this
|
Sign in to "Like"
> [FileMaker][FileMaker JDBC] Driver requires a more recent version of xDBC listener
What edition of FileMaker are you connecting to, and on what platform is FM running (i.e. FM Server 11 on Win Vista)?
Jonathan Monroe
Actual Technologies
Be the first to like this
|
Sign in to "Like"
Thanks Jonathan,
We are working on FM Pro 11 advance on Mac OS X.
Oliver
Be the first to like this
|
Sign in to "Like"
bump.
Please help...
oliver
Be the first to like this
|
Sign in to "Like"
Oliver,
I sent you a private message to your forum account. Could you please check that message? I have a few questions about your configuration.
Jonathan Monroe
Actual Technologies
Be the first to like this
|
Sign in to "Like"