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

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.