PDA

View Full Version : connect to oracle



kettle_anonymous
04-19-2006, 12:43 PM
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

shassan2
04-19-2006, 12:52 PM
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..

MattCasters
04-19-2006, 02:57 PM
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

kettle_anonymous
04-20-2006, 01:07 AM
Thank you for your answer ,
I made a mistake between service and tnsname

Now it&#39;s OK

Bye