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 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…
Sometimes we need to execute multiple update/insert queries on our DB. The performance of these queries can be critical for our application. We will see how we can improve performance of multiple update/insert queries on oracle. Create Index on the column/columns used in the WHERE clause for update queries. This…