Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Add new JDBC driver

  1. #1
    Join Date
    Oct 2009
    Posts
    8

    Default Add new JDBC driver

    I've run into instructions for getting PDI to talk to Filemaker. Unfortunately the info.plist entry for PDI looks very different and FM Pro has a differently named jdbc connector so I don't have a lot of confidence that this will work.

    I've put in fmjdbc.jar /Library/Java/Extensions but I'm pretty sure something needs to be done on the PDI end. Does anybody know what it is?

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Put file "fmjdbc.jar" in libext/JDBC

    Then create a Generic database connection.

  3. #3
    Join Date
    Oct 2009
    Posts
    8

    Default

    Thanks for the answer. Unfortunately I remain stuck. Following your directions I dropped a copy of the driver to /Applications/data-integration/libext/JDBC and then restarted PDI (64 bit). I'm using jdbc:filemaker://127.0.0.1/INHouseSale as the URL and com.filemaker.jdbc as the class name. user and password are blank


    here's the error message.

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

    Exception while loading class
    com.filemaker.jdbc

    org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
    org.pentaho.di.core.database.Database.connect(Database.java:315)
    org.pentaho.di.core.database.Database.connect(Database.java:277)
    org.pentaho.di.core.database.Database.connect(Database.java:267)
    org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:76)
    org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2443)
    org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:510)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:135)
    org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
    org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
    org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.notifyListeners(Unknown Source)
    org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    org.eclipse.jface.window.Window.open(Window.java:796)
    org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
    org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
    org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:98)
    org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:51)
    org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:471)
    org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:456)
    org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2712)
    org.pentaho.di.ui.spoon.Spoon.access$2000(Spoon.java:293)
    org.pentaho.di.ui.spoon.Spoon$23.widgetDefaultSelected(Spoon.java:5038)
    org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    org.eclipse.swt.widgets.Widget.notifyListeners(Unknown Source)
    org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1161)
    org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6725)
    org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:545)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:597)
    apple.launcher.LaunchRunner.run(LaunchRunner.java:116)
    apple.launcher.LaunchRunner.callMain(LaunchRunner.java:51)
    apple.launcher.JavaApplicationLauncher.launch(JavaApplicationLauncher.java:52)

    Hostname :
    Port : 1521
    Database name :
    Last edited by TMLutas; 07-23-2011 at 03:21 PM. Reason: realized that there's a relevant part at bottom of error

  4. #4
    Join Date
    Oct 2009
    Posts
    8

    Default

    Turns out that I just had a stupid typo. The current solution works.

    To review for the next fellow:
    When connecting Filemaker 11+ to PDI
    1. put fmjdbc.jar in /Library/Java/Extensions
    2. put fmjdbc.jar in /Applications/data-integration/libext/JDBC
    3. create a database connection inside PDI using generic database, Native (JDBC), connect string of jdbc:filemaker://127.0.0.1/{databasename}, class name = com.filemaker.jdbc.Driver, do not leave user and password blank
    4. inside of FM, turn Sharing> ODBC/JDBC on, set security account with appropriate rights (fmxdbc) with password

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.