Test JDBC connectivity to Oracle using Java

This blogs shows how to connect to Oracle database to test a JDBC connection: https://www.quickprogrammingtips.com/java/connecting-to-oracle-database-in-java.html Put the below java code in a text file in linux called: OracleSample.java -------------------------------------------------------------------------------------------------------------------- // Example Java Program - Oracle Database Connectivity import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class OracleSample { public static final … Continue reading Test JDBC connectivity to Oracle using Java

Advertisements

Streamsets install Oracle JDBC driver in External Library

This blog will show how to install the Oracle JDBC driver to the Streamsets External Library.  Environment: Cloudera CDH 5.12, Streamsets 3.1.2 TASK: Update the Oracle JDBC driver inside Streamsets https://streamsets.com/documentation/datacollector/latest/help/#datacollector/UserGuide/Configuration/ExternalLibs.html#concept_pdv_qlw_ft Step 1. Set Up an External Directory  Setting Up for Cloudera Manager In Cloudera Manager, select the StreamSets service and then click Configuration. On the Configuration page, in the Data … Continue reading Streamsets install Oracle JDBC driver in External Library

Query Cloudera Hadoop Hive using Oracle SQL Developer.

Environment: Oracle SQL Developer Version 18.1.0.095 on Windows 64bit and Hive on Cloudera Hadoop CDH 5.12.x. Config steps: First download and install the popular free tool Oracle SQL Developer for Windows from Oracle website. Read this blog for a good idea about connecting Oracle SQL Developer to Hadoop Hive:   https://blogs.oracle.com/bigdataconnectors/move-data-between-apache-hadoop-and-oracle-database-with-sql-developer Note when configuring Cloudera-Hive JDBC drivers … Continue reading Query Cloudera Hadoop Hive using Oracle SQL Developer.