OrientDB supports encrypting database content to prevent unauthorized users from accessing the data. The encryption support is available from version 2.2. To create/access an encrypted database, we need to provide a base64 encoded encryption key. OrientDB supports encryption at a database level and each database can be encrypted with different…
We will see how to Create, Use and Drop a database in Hive. Create a Database #List all the databases 0: jdbc:hive2://localhost:10000> show databases; +—————-+-+ | database_name | +—————-+-+ | default | +—————-+-+ #Create a new Database 0: jdbc:hive2://localhost:10000> create database mydb; #List all the databases 0: jdbc:hive2://localhost:10000> show databases;…
We will see how to load data from a file in an oracle table using sqlldr. Table We have a table EMPLOYEE in the oracle database with the following schema:- SQL> desc EMPLOYEE; Name Null? Type —————————————- ——- —————————- EMP_ID NOT NULL NUMBER(38) EMP_NAME VARCHAR2(500) EMP_AGE NUMBER(38) Data File We…
JDBC(Java Database Connectivity) provides a standard Java API (Application Programming Interface) for accessing different database systems. JDBC provides a simple, database-independent set of APIs. Using the same APIs we can access a number of database systems in Java. Components of JDBC 1) Driver For connecting to the database we need…
Basics We will see how to execute a simple SQL SELECT query in Java using JDBC Statement. Step 1 - Load Driver Class For connecting to the database we need to have a suitable Driver class loaded. This Driver class helps us to get the Connection to the corresponding database.…
Problem Statement :- While working on one of the project, we came across the following requirement:- Given a list of unique IDs, check whether for each ID the data is exactly the same in the database tables of two different systems. For non-matching data dump the unique ID in a…
Sometimes our application needs to fetch a large amount of data from database systems and do some in memory processing on top of it. The SELECT query to fetch the data may contain a WHERE clause, IN operator etc and the query may return millions of rows. Our application and…