Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: FileMaker JDBC Driver

  1. #1
    Join Date
    Nov 2013
    Posts
    3

    Default FileMaker JDBC Driver

    Can someone explain me how to add the FileMaker JDBC Driver (fmjdbc.jar) to the Kettle (v5) on Windows platform?

    I placed the jar in the folder \data-integration\libswt, and setup a connection type using Generic database by Native (JDBC)

    But I can't get it work and always receive the error listed below...

    > Error connecting to database [FMP] : org.pentaho.di.core.exception.KettleDatabaseException:
    > Error occured while trying to connect to the database

    > Driver class 'com.filemaker.jdbc.Driver' could not be found, make sure the 'Generic database' driver (jar file) is installed.
    > com.filemaker.jdbc.Driver

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Which version of PDI do you use?
    In PDI 5 you have to place the driver in lib (I think).
    -- Mick --

  3. #3
    Join Date
    Nov 2013
    Posts
    3

    Default

    using v5.0.1, the latest stable version. Any idea?

  4. #4
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Have you tried to copy the jar into \data-integration\lib instead of \data-integration\libswt?
    -- Mick --

  5. #5
    Join Date
    Nov 2013
    Posts
    3

    Default

    I have tried to copy the fmjdbc.jar into "\data-integration\lib", when i run a test to connect with FileMaker Server v11, Kettle prompted an errror as listed below..

    > Error connecting to database [FMP] : org.pentaho.di.core.exception.KettleDatabaseException:
    > Error occured while trying to connect to the database

    > Error connecting to database: (using class com.filemaker.jdbc.Driver)
    > [FileMaker][FileMaker JDBC] (802): Unable to open file

    > org.pentaho.di.core.exception.KettleDatabaseException:
    > Error occured while trying to connect to the database

    > Error connecting to database: (using class com.filemaker.jdbc.Driver)
    > [FileMaker][FileMaker JDBC] (802): Unable to open file


    > at org.pentaho.di.core.database.Database.normalConnect(Database.java:415)
    at org.pentaho.di.core.database.Database.connect(Database.java:353)
    at org.pentaho.di.core.database.Database.connect(Database.java:306)
    at org.pentaho.di.core.database.Database.connect(Database.java:294)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:84)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2459)
    at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:541)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
    at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:121)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:375)
    at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:301)
    at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62)
    at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:88)
    at org.pentaho.di.ui.spoon.Spoon.editConnection(Spoon.java:2545)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:26)
    at org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:88)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1227)
    at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7368)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8673)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:625)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class com.filemaker.jdbc.Driver)
    [FileMaker][FileMaker JDBC] (802): Unable to open file

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:540)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:399)
    ... 54 more
    Caused by: com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] (802): Unable to open file
    at com.filemaker.jdbc1.CommonJ1Connection.openConnection(Unknown Source)
    at com.filemaker.jdbc.Driver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:524)
    ... 55 more

  6. #6
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Well.. sorry but I'm out of ideas then!
    -- Mick --

  7. #7
    Join Date
    Nov 2008
    Posts
    777

    Default

    Whenever I get a weird error like this, the first thing I do is copy/paste the text of the error message into my browser and do a web search. The results for "[FileMaker][FileMaker JDBC] (802): Unable to open file" included several matches and you might find this one helpful:

    http://help.filemaker.com/app/answer...with-filemaker

    Oh, and the fact that the stack trace includes the following lines leads me to believe that PDI is finding the JDBC Driver just fine. You would be getting a "Class not found" exception if that wasn't the case.

    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class com.filemaker.jdbc.Driver)
    [FileMaker][FileMaker JDBC] (802): Unable to open file
    Last edited by darrell.nelson; 12-12-2013 at 11:00 AM. Reason: Oh, and...
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.