ORACLE JDBC JAR FILE DRIVER
Now, we can define the Oracle JDBC driver dependency like this: Installing d:\projects\ojdbc8.jar to C:\Users\mkyong\.m2\repository\com\oracle\ojdbc8\19.3\ojdbc8-19.3.jar maven-install-plugin:2.4:install-file (default-cli) standalone-pom.
You can try it out by trying to connect to the DB using sqlplus:Īs suggested tried to connect with XE database name and the error is as followsĪt (NativeMethodAccessorImpl.java:57)Īt .invoke(Method.java:606)Īt .(AbstractXulComponent.C:\> mvn install:install-file -Dfile=d:/projects/ojdbc8.jar -DgroupId=com.oracle -DartifactId=ojdbc8 -Dversion=19.3 -Dpackaging=jar It says that the Oracle database ID (SID) you have used when configuring the connection in PDI is wrong. Last edited by gutlez 02-25-2016 at 07:01 PM.ĭatabase name : MYDBAs gutlez mentions, this is not a PDI error it is an Oracle error. Still I am also getting following error.Īlso tried with /MYDB as suggested below. Placed in C:\pentaho_etl\data-integration\lib folder. I have downloaded the Oracle JDBC driver.
:Īt .(Database.java:459)Īt .(Database.java:357)Īt .(Database.java:328)Īt .(Database.java:318)Īt .(DatabaseFactory.java:80)Īt .(DatabaseMeta.java:2734)Īt .(DataHandler.java:588)Īt 0(Native Method)Īt (NativeMethodAccessorImpl.java:62)Īt (DelegatingMethodAccessorImpl.java:43)Īt .invoke(Method.java:483)Īt .(AbstractXulDomContainer.java:313)Īt .(AbstractXulComponent.java:157)Īt .(AbstractXulComponent.java:141)Īt .access$500(SwtButton.java:43)Īt .$4.widgetSelected(SwtButton.java:136)Īt .TypedListener.handleEvent(Unknown Source)Īt .ndEvent(Unknown Source)Īt .ndEvent(Unknown Source)Īt .nDeferredEvents(Unknown Source)Īt .Display.readAndDispatch(Unknown Source)Īt .nEventLoop(Window.java:820)Īt .Window.open(Window.java:796)Īt .show(SwtDialog.java:389)Īt .show(SwtDialog.java:318)Īt .ui.open(XulDatabaseDialog.java:116)Īt .ui.open(DatabaseDialog.java:60)Īt .ui.(SpoonDBDelegate.java:470)Īt .ui.(SpoonDBDelegate.java:457)Īt .ui.(Spoon.java:3051)Īt .ui.(Spoon.java:3021)Īt .ui.$2400(Spoon.java:347)Īt .ui.spoon.Spoon$27.widgetDefaultSelected(Spoon.java:6064)Īt .ui.(Spoon.java:1339)Īt .ui.(Spoon.java:7939)Īt .ui.(Spoon.java:9214)Īt .ui.(Spoon.java:653)Īt .Launcher.main(Launcher.java:92)Ĭaused by: .:Īt .(Database.java:572)Īt .(Database.java:443)Ĭaused by: : Listener refused the connection with the following error:Īt 4CConnection.logon(T4CConnection.java:489)Īt .(PhysicalConnection.java:553)Īt 4CConnection.(T4CConnection.java:254)Īt 4CDriverExtension.getConnection(T4CDriverExtension.java:32)Īt .connect(OracleDriver.java:528)Īt (DriverManager.java:664)Īt (DriverManager.java:208)Īt .(Database.java:569)Ĭaused by: .NetException: Listener refused the connection with the following error:Īt .nnect(NSProtocol.java:399)Īt nnect(T4CConnection.java:1140)Īt 4CConnection.logon(T4CConnection.java:340) ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Listener refused the connection with the following error:
I put "ojdbc6.jar" in the folder "C:\opt\data-integration\lib"Įrror connecting to database : .:Įrror occurred while trying to connect to the databaseĮrror connecting to database: (using class )