Error Connecting To Database Using Class Oracle.jdbc.driver.oracledriver
View Site Leaders Advanced Search Forum Pentaho Users Pentaho Data Integration [Kettle] A problem when creating a ORACLE connection If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: A problem when creating a ORACLE connection Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-24-2008,09:50 PM #1 philins View Profile View Forum Posts Private Message Junior Member Join Date Mar 2008 Posts 8 A problem when creating a ORACLE connection I tried to create a ORACLE connection,but when I test the connection after filling the connection parameters correctly, it report the error message like below. I think it may be the problem about the classpath or the uncompatible JDBC driver(I installed the ORACLE 9i Database Server and kettle on the same machine). I tried to change the driver to the same, but the problem is still exist. So what's the problem? Error Message--------------------------------------------------------------------------- Error connecting to database [ora] : 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) oracle/i18n/text/converter/CharacterConverterOGS 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) oracle/i18n/text/converter/CharacterConverterOGS at be.ibridge.kettle.core.database.Database.normalConnect(Database.java:289) at be.ibridge.kettle.core.database.Database.connect(Database.java:238) at be.ibridge.kettle.core.database.Database.connect(Database.java:200) at be.ibridge.kettle.core.database.Database.connect(Database.java:190) at be.ibridge.kettle.core.dialog.DatabaseDialog.test(DatabaseDialog.java:1752) at be.ibridge.kettle.core.dialog.DatabaseDialog.test(DatabaseDialog.java:1697) at be.ibridge.kettle.core.dialog.DatabaseDialog$4.handleEvent(DatabaseDialog.java:297) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3673) at org.eclipse.swt.widget
Java C# C++ SAS Visual Studio Visio PowerPoint Financial IT Bloomberg FactSet Interactive Brokers Connecting to Oracle 12c Database from Pentaho Data Integration (Kettle) Community Edition Introduction Pentaho Data Integration (DI) tools (also known as Kettle) contain a powerful assortment of data filtering and transformation tools that can be used to carry out Extraction, Transformation and Load processes. The Pentaho DI Community Edition comes with a collection of database drivers that can access many different database systems as either a data source (input) or a target (output). However, the community edition may not ship with drivers for Oracle database. The following notes assume Pentaho DI (Kettle) has http://forums.pentaho.com/showthread.php?60567-A-problem-when-creating-a-ORACLE-connection been installed according to these Pentaho DI Installation Notes. Installing Oracle JDBC Drivers To use Oracle data sources with Pentaho DI, you must first make sure the Oracle JDBC drivers are installed. If not, obtain them from Oracle and install them in the lib folder for Pentaho DI. The Oracle JDBC drivers are shipped with every Oracle Server installation and can be found in the \jdbc folder of the Oracle http://holowczak.com/oracle-12c-database-pentaho-data-integration/ home. If you do not have access to the Oracle server, you may download the latest drivers from Oracle's JDBC web site. Be sure to download the JDBC drivers that match the version of Java Runtime Environment (JRE) you are running. Copy the Oracle JDBC Drivers to Pentaho\data-integration\lib folder. When running Pentaho DI with Java7, use the Java 7 versions of the JDBC drivers as shown in the figure below: Running Pentaho DI and Creating a Table Output transformation Run Spoon and create a new transformation for a Table Output Get the Properties of the table output as shown below: For the Connection, click on the New… button to create a new connection. Give your new database connection a name and then select Oracle as the Connection Type. Choose JDBC (Native) as the Access type. Fill in the Host Name or IP address of the server currently running Oracle. If you are running Oracle on your own local computer, use the localhost IP address 127.0.0.1. Set the port number to where the Oracle database listener is running. By default this is port 1521. Fill in the Database Name according to either your Oracle Service Name or SID. If your Oracle 12c database is configured with pluggable databases, use
oracle via Pentaho. 'oracle.jdbc.driver.OracleDriver' cou Results 1 to 1 of http://queforum.com/programming-languages-basics/410058-java-unable-connect-oracle-via-pentaho-oracle-jdbc-driver-oracledriver-cou.html 1 Thread: Java - Unable to connect to oracle via Pentaho. 'oracle.jdbc.driver.OracleDriver' cou LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Email this Page… Subscribe to this error connecting Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-05-2013,08:00 AM #1 Bandhavi Senior Member Join Date May 2012 Posts 173,037 Java - Unable to connect to oracle via Pentaho. 'oracle.jdbc.driver.OracleDriver' cou Hi I've just installed Pentaho Data Integration v. 5.01 error connecting to and I'm trying to connect to a database. However, I'm unable to test the connection as I get the error (pasted below). I have JDK 1.7 installed on the system as well, however I can't seem to locate ojdbc14.jar anywhere. I downloaded that and pasted it in pentaho's \lib folder but I still get the same error. Any solutions to this problem? Error connecting to database [test] : org.pentaho.di.core.exception.KettleDatabaseExcept ion: Error occured while trying to connect to the databaseDriver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed.oracle.jdbc.driver.OracleDriverorg.penta ho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the databaseDriver class 'oracle.jdbc.driver.OracleDriver' could not be found, make sure the 'Oracle' driver (jar file) is installed.oracle.jdbc.driver.OracleDriver at org.pentaho.di.core.database.Database.normalConnec t(Database.java:415) at org.pentaho.di.core.database.Database.connect(Data base.java:353) at org.pentaho.di.core.database.Database.connect(Data base.java:306) a