Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: connect to oracle

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default connect to oracle

    Hi!


    I use kettle and i try to connect to a oracle database






    Connection name : Oracle test
    Connection type : Oracle
    Methode of access : Native (JDBC)
    Server host name : dmr (tnsname)
    Database name : mydatabasename
    Port number : 1521
    Username : myusername
    Password : mypassword



    After a test i see in a windows :



    Error occured while trying to connect to the database



    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Exception d'E/S: The Network Adapter could not establish the connection



    be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database



    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Exception d'E/S: The Network Adapter could not establish the connection



    at be.ibridge.kettle.core.database.Database.connect(Database.java:175)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(DatabaseDialog.java:970)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(DatabaseDialog.java:949)
    at be.ibridge.kettle.core.dialog.DatabaseDialog$4.handleEvent(DatabaseDialog.java:654)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.open(DatabaseDialog.java:718)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog$1.widgetSelected(RepositoryDialog.java:173)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
    at be.ibridge.kettle.repository.dialog.RepositoryDialog.open(RepositoryDialog.java:306)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog$2.widgetSelected(RepositoriesDialog.java:208)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:347)
    at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:4303)
    Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
    Exception d'E/S: The Network Adapter could not establish the connection



    at be.ibridge.kettle.core.database.Database.connect(Database.java:212)
    at be.ibridge.kettle.core.database.Database.connect(Database.java:165)
    ... 23 more
    Caused by: java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(Database.java:208)
    ... 24 more









    Can you help me?
    Thank you



    Lionel

  2. #2

    Default RE: connect to oracle

    Hello lionel,


    I have been using Kettle for now 2 months and every 10 min i schedule Kettle Jobs which connect to oracle (10) database.



    I don't have any pb.



    In fact,
    i use the IP adresse in the server hostname et the next ..is like you..
    Samatar

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

    Default RE: connect to oracle

    This is not a Kettle problem but I&#39;ll take a stab at it anyway:

    1) ping the specified host name
    2) see if the port is indeed 1521. Some companies like to mess with this and set it to 1525 or something other.
    3) verify the database name

    Last 2 settings can be checked if you have entries in TNSNAMES.ORA. In that case issue command "tnsping SID-SERVICENAME" and you&#39;ll get the connection detailes.

    HTH,
    Matt

  4. #4
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: connect to oracle

    Thank you for your answer ,
    I made a mistake between service and tnsname

    Now it&#39;s OK

    Bye

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.