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

Query Cloudera Hadoop Hive using Oracle SQL Developer.

Note: DBeaver free SQL editor is a far better tool than Oracle SQL developer and it connects to 80+ different databases. It is easier to get working with Hive/Impala. Check out the instructions in the link below: https://plenium.wordpress.com/2019/10/15/connect-dbeaver-sql-tool-to-cloudera-hive-impala-with-kerberos/ Environment: Oracle SQL Developer¬†Version 18.1.0.095 on Windows 64bit and Hive on Cloudera Hadoop CDH 5.12.x. Config steps: … Continue reading Query Cloudera Hadoop Hive using Oracle SQL Developer.