10 Replies Latest reply on Dec 1, 2013 10:18 PM by aminechrif

    JDBC driver setting for Filemaker 11

    oliver

      Title

      JDBC driver setting for Filemaker 11

      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

       

       

        • 1. Re: JDBC driver setting for Filemaker 11
          actualjon

           

          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

          • 2. Re: JDBC driver setting for Filemaker 11
            oliver

            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

             

            ?

             


            • 3. Re: JDBC driver setting for Filemaker 11
              actualjon

              > 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

              • 4. Re: JDBC driver setting for Filemaker 11
                oliver

                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

                • 5. Re: JDBC driver setting for Filemaker 11
                  oliver

                  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

                   

                  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

                  • 6. Re: JDBC driver setting for Filemaker 11
                    actualjon

                    > [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

                    • 7. Re: JDBC driver setting for Filemaker 11
                      oliver

                      Thanks Jonathan,

                       

                      We are working on FM Pro 11 advance on Mac OS X.

                       

                       

                       

                      Oliver

                      • 8. Re: JDBC driver setting for Filemaker 11
                        oliver

                        bump.

                         

                        Please help...

                         

                        oliver

                        • 9. Re: JDBC driver setting for Filemaker 11
                          actualjon

                          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

                          • 10. Re: JDBC driver setting for Filemaker 11
                            aminechrif

                                 Hi,

                                 Would you give me please a link where i can download the fmjdbc.jar driver. I would write a java client application that interacts with a filemaker DB.

                                  

                                 Thank you guys !