2 Replies Latest reply on Mar 17, 2010 7:06 AM by oliver

    filemaker and jdbc

    grapevine

      Title

      filemaker and jdbc

      Your post

      I would like to use the JDBC driver to access FileMaker 8 Server Advanced. I have tried using the included JDBC driver, but I don't know what hibernate dialect to specify. You mention that your driver supports Hibernate, but you don't list what dialect to use either. I had a look at the documentation but couldn't find any information on using Hibernate with the SequeLinkDriver.

      We are using :
      DRIVER : com.ddtek.jdbc.sequelink.SequeLinkDriver
      URL : jdbc:sequelink://X.X.X.X:2399;user=XXX;serverDataSource=XXX

      However when we try to connect to the database the following exception is reported.

      "Hibernate Dialect must be explicitly set for database: FileMaker"

      Thanks in advance

        • 1. Re: filemaker and jdbc
          TSGal

          grapevine:

           

          Thank you for your post.

           

          Hibernate does not support FileMaker Pro.  A listing of databases that Hibernate supports can be found at http://www.hibernate.org/80.html.

           

          You can try some different dialects supported by Hibernate to find out which dialect comes closest to FileMaker.  In general, FileMaker does neither supports nor tests any object-relational mapping software.

           

          TSGal

          FileMaker, Inc.

          • 2. Re: filemaker and jdbc
            oliver

            Hi,

             

            I am trying to use JDBC to connect filemaker database in FMSA 11.

             

            Before that, i can make this work in  Filemaker 10 with the setting like below in FM 10.

             

            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.

             

            Is there something be changed from ver 10 to 11?

             

            Please help.

             

            Thanks,

            Oli