Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Firebird JDBC

  1. #1
    Join Date
    Jun 2011
    Posts
    102

    Default Firebird JDBC

    Hi all,
    i've received a Firebird DB from a client and i was trying to collect data from it by my kettle's job/transformation.
    I've worked with those type of db in the past, but this time kettle isn't able to connect to it. I've found that the problem is the jdbc driver. I'm able to connect to the db with dbvisualizer and the newest jdbc (2.2.0). Kettle is using the 2.1.0, so i've replaced it but nothing changed.
    Am i forgetting something?
    Thanks in advance,
    Andrea

    Kettle 4.1.0
    MS SQL SERVER 2008
    Java 7

  2. #2
    Join Date
    Dec 2009
    Posts
    609

    Default

    Hi,

    telling us "isn't able to connect" is not enough to help you.
    Please provide more details about the error message...

    Cheers,

    Tom

  3. #3
    Join Date
    Jun 2011
    Posts
    102

    Default

    Hi,
    yeah, sorry, i've forgot to post the error message...
    There it is:
    Errore di connessione al database [Firebird] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class org.firebirdsql.jdbc.FBDriver)
    GDS Exception. 335544344. I/O error for file CreateFile (open) "C:\tmp\GIOTTO.FDB"
    Error while trying to open file
    null
    Reason: I/O error for file CreateFile (open) "C:\tmp\GIOTTO.FDB"
    Error while trying to open file
    null

    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database
    Error connecting to database: (using class org.firebirdsql.jdbc.FBDriver)
    GDS Exception. 335544344. I/O error for file CreateFile (open) "C:\tmp\GIOTTO.FDB"
    Error while trying to open file
    null
    Reason: I/O error for file CreateFile (open) "C:\tmp\GIOTTO.FDB"
    Error while trying to open file
    null
    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(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    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.Widget.sendEvent(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.editConnection(SpoonDBDelegate.java:77)
    org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2727)
    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.Widget.sendEvent(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(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Nome dell'host: localhost
    Porta:3050
    Nome database: C:\tmp\GIOTTO.FDB
    Thanks,
    Andrea
    Last edited by Lomior; 09-19-2012 at 07:58 AM.

  4. #4
    Join Date
    Mar 2011
    Posts
    257

    Default

    is the database located at
    C:\tmp\GIOTTO.FDB ?
    I usually create an Alias and connect to the alias in stead of using the path in the connection string...


  5. #5
    Join Date
    Jun 2011
    Posts
    102

    Default

    Hi,
    thanks for the answer.
    Yes, the databse is located there.
    Can you explain me how to create an Alias? i've give it a try, hope it works.
    Andrea

  6. #6
    Join Date
    Dec 2009
    Posts
    609

    Default

    Hi Andrea,

    I never used Firebird, but asking Google for "firebird create alias" returns some interesting results.
    Among them this little PDF: http://www.ibobjects.com/docs/ti_fb15_aliases.pdf

    It points to an "alias.conf" file inside your firebird installation....

    HTH,

    Tom

  7. #7
    Join Date
    Jun 2011
    Posts
    102

    Default

    Thanks guys, the "alias trick" has worked!!
    I was able to use the old version of the jdbc driver to keep it working.
    Thanks again!!
    Andrea

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.