Steps to configure log4j in spring & struts 2 application

Steps to configure log4j in spring application
***********************************************

Step 1: log4j.properties - needs to place under class path
============================================

#loggging file details for Log4jProperties
log4j.rootCategory=DEBUG,fileAppender
log4j.appender.fileAppender=org.apache.log4j.RollingFileAppender
log4j.appender.fileAppender.File=${jboss.server.home.dir}/log/myAppLog.log
log4j.appender.fileAppender.Encoding=UTF-8
log4j.appender.fileAppender.layout.ConversionPattern=%-4d %-C : %M - %m%n
log4j.appender.fileAppender.layout=org.apache.log4j.PatternLayout


Step 2: Add jars to lib folder
=======================================

Step 3: web.xml - Log4jConfigListener configuration
=======================================

<listener>
   <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
</listener>

Step 4: Declare Member Log variable in java calss
======================================
 private final Log       logger  = LogFactory.getLog(getClass());

Step 5: Following logger methods is used to log logger-messages
=================================================
logger.debug("Controller method");
logger.error("Controller method");
logger.warn("Controller method");
logger.info("Controller method");


Struts 2 Application Log4j Configuration:
*****************************************

Do steps 1, 2, 4, 5

SQL_PL_SQL

Nth max salary query:

Select salary
From Employee E1
Where (N-1) = (
                                 Select Count(Distinct(E2.Salary))
                                 From Employee E2
                                 Where E2.Salary > E1.Salary

                              )

Partitioned tables:

Oracle allow to divide the rows of a table into multiple parts. Dividing a tables data in this manner is called partitioned table.

Creating table: To create a partitioned table, you have to specify how to set up the partitions of the tables data as part of the create command.

Typically tables are partitioned by range of values. To partition the tables records use the "partition by range" clause. The range will determine the values stored in each of the table partition.

Syntax:

create table table_name (column1 data_type(size), column2 data_type(size),.............)
partition by range (column1)
(partition partition_name1 values < some_value,
partition partition_name2 values < some_value,
partition partition_name2 values < some_value,
-----------------------------------------------
-----------------------------------------------);
You do not need to specify a maximum value for the last partition.

Syntax to select data from partition:

select * from table_name partition(partition_name);

Adding Partition:

Adding new partition to table.

Syntax: alert table table_name add partition partition_name values < value;


Dropping  partition:

Removing partition.

Syntax: alert table table_name drop partition partition_name

Splitting partition:

Splitting one partition into two partitions.

Syntax: alter table table_name split partition partition_name at (value) into (partition partition_name1,partition partition_name2);


Moving partitions:

The move clause of the alter table statement is used to move a partition from a most active table space to different table space in order to balance I/O operations.

Syntax: alter table table_name move partition partition_name tablespace table_space_name;


Work load capturing  

sys> begin
         dbms_wokload_capture.start_capture(name=>'Test_cature_1', dir=>'db_reply_1',     
         duration=>null)
         end;
         /
sys> create user test_1 identified by test_1;

sys> grant connect resource1.create table to test_1;

sys> conn test_1/test_1

test_1> create table db_replay(id number, description varchar2(50), constraint db_replay primary 
              key (id));

test_1> begin
              for i in 1..500000 loop
              insert into db_replay(id, description) values (i,'description_test');
              end loop;
              commit;
              end;
              /
Finishing capture process

conn as sysdba

sys> begin
         dbms_workload_capture.finish_capture;
         end;
         /

Selecting work load capture 

sys> dbms_workload_capture.get_capture_info('DB_REPLAY') from dual;

sys> select id,name from dba_workload_captures;


SQL * Loader
===================================

SQL Loader loads data from external files into tables in oracle data base.

It requires the following files.
1. Data file
2. Control file


Data File: It contains the information to be loaded
Control File: It tells oracle how to read and load the data. It contains the information on the format of the data, the records and fields within the file, The order in which they are to be loaded. It is created at the OS level.

SQL Loader creates the following files.
1. Log file
2. Bad file

Log File: It records the status of the load, such as the number of rows processed and the number of rows committed.

Bad File: It contains rows that are rejected during the load due to data errors.

Syntax:

LOAD DATA
INFILE 'file_name.extension'
BADFILE 'PATH/bad_file_name.bad'
[TRUNCATE | APPEND| INSERT | REPLACE]
INTO TABLE table_name  fields terminated by "," // instead of "," you can specify your delimiter
( column1, column2, column3,.................)

Here column1, column2, column3...................... are names of table column name.
These must be equal to table field names.

TRUNCATE: This clause truncates the table before starting.
APPEND: This clause adds the rows to the table.
INSERT:  This clause adds the rows to an empty table. The load will abort with an error if the table is not empty.
REPLACE: This clause empties the table and then adds the new rows. The user must have DELETE privilege on the table.


Checkpoint Process

CKPT updates the headers of all data files to record the details of the check point.

System Monitor Process  

It performs recovery and also responsible for clean up temporary segments that are no longer in use and for unite contiguous free extents within dictionary managed table spaces. It checks regularly to see whether recovery is needed.

BULK COLLECT AND FORALL

BULK COLLECT: It retrieve multiple rows at a time in single fetch

FORALL: it performes multiple INSERTs | UPDATEs | DELETEs at a time.

Example:

Procedure insertempproc() is
   CURSOR emp_cur IS
      SELECT employee_id
        FROM emp;
cur_limit PLS_INTEGER := 1000;
TYPE multi_cols_pslqltable IS RECORD
(
emp_id   emp.emp_id%TYPE,
emp_name emp.ename%TYPE,
sal        emp.sal%TYPE
);
TYPE multi_cols_pslqltab IS TABLE OF multi_cols_pslqltable;
multi_cols_pslqltab_varr   multi_cols_pslqltab;
BEGIN
open emp_cur;
LOOP
begin
FETCH employees_cur
BULK COLLECT INTO multi_cols_pslqltab_varr
LIMIT c_limit;
       EXIT WHEN multi_cols_pslqltab_varr.COUNT = 0;
FORALL IND IN multi_cols_pslqltab_varr.FIRST..multi_cols_pslqltab_varr.LAST  SAVE              EXCEPTIONS
INSERT INTO EMP_NEW(EMPID,NAM, SAL, CMANE ) VALUES
(multi_cols_pslqltab_varr(IND).emp_id,multi_cols_pslqltab_varr(IND).emp_name,multi_c                  ols_pslqltab_varr(IND).'xyz');
EXCEPTION
  WHEN DUP_VAL_ON_INDEX THEN
  NULL;
end;
   END LOOP;
insertempproc END;

Hibernate Interceptor & query with parameter

Hibernate Interceptor

Hibernate interceptor allows application to change properties of a entity object before save, update, delete, or load. It allows to control follow or stop.

 
Attaching interceptor reference to hibernate session
==============================================

public int additeam(Item item) {
        Integer itemCode = 0;
        try {
            ItemInterceptor itemInterceptor = new ItemInterceptor();
            session = sessionFactory.openSession(itemInterceptor);
            transaction = session.beginTransaction();
            log.info("Before addItem - Dao");
            itemCode = (Integer) session.save(item);
            transaction.commit();
        } catch (HibernateException hibernateException) {
            transaction.rollback();
            log.info(hibernateException.getMessage());
        } finally {
            session.close();
        }
        return itemCode;
    }

Hibernate Interceptor -  Class Implementation:
=======================================
package com.xyz.interceptor;

import java.io.Serializable;
import org.hibernate.EmptyInterceptor;
import org.hibernate.type.Type;
import com.xyz.dto.Item;

public class ItemInterceptor extends EmptyInterceptor {
    /**
     * Pedababu M
     */
    private static final long serialVersionUID = 1L;
    private final Log   log  = LogFactory.getLog(getClass());
    public boolean onSave(Object entity, Serializable id, Object[] state,
            String[] propertyNames, Type[] types) {
        log.info("Before the  "+entity.getClass()+"   onSave....");
        log.info("getName "+entity.getClass().getName()+"   onSave....");
        log.info("getModifiers "+entity.getClass().getModifiers()+"   onSave....");
        log.info("S ID :" + id);
        for (int index = 0; index < state.length; index++) {
            log.info(state[index]);
        }
        //chnaging discount before saving - in interceptor
        if (entity instanceof Item) {
            ((Item) entity).setDiscount(10);
        }
        return super.onSave(entity, id, state, propertyNames, types);
    }
}

onDelete – This method is called before delete entity object

onLoad – This method is called before entity object initialization.

etc.

Query with parameter
================

        List<Item> itemList = null;
        Session session = null;
        try {
            session = sessionFactory.openSession();
            session.beginTransaction();
             Query query =session.createQuery("from Item item where item.itemId=:itemId");
             query.setParameter("itemId", itemNo);
             itemList =query.list();
            log.info("itemList size::::" + itemList.size());
            Iterator<Item> it = itemList.iterator();
            while (it.hasNext()) {
                Item t = it.next();
                log.info(t.getItemId() + "   " + t.getItemName());
            }
        } catch(Exception exception){
            exception.printStackTrace();
        }
        finally {
            session.close();
        }

Configuration of Hibernate session factory and JPA entity manager factory – in standalone and spring applications:

Configuration of Hibernate session factory and JPA entity manager factory – in standalone and spring applications:

 

Note: Place “hibernate.cfg.xml”,“persistence.xml” and etc configuration files under class path.

Creating session factory using Configuration class in standalone application:

private static final SessionFactory sessionFactory;
    static {
        try {
            sessionFactory = new Configuration().configure()
                    .buildSessionFactory();
        } catch (Throwable exception) {
            System.err.println("Initial SessionFactory creation failed." + exception);
            throw new ExceptionInInitializerError(exception);
        }
    }

Creating session factory using LocalSessionFactoryBean in spring application:

    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/test_db" />
        <property name="username" value="root" />
        <property name="password" value="root1" />
    </bean>

    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation">
            <value>classpath:hibernate.cfg.xml</value>
        </property>
        <property name="configurationClass">
            <value>org.hibernate.cfg.AnnotationConfiguration</value>
        </property>
    </bean>

Creating JPA Entity Manager Factory in standalone application:

        EntityManagerFactory entityManagerFactory=Persistence.createEntityManagerFactory("PersistenceUnitName");
        EntityManager entityManager=entityManagerFactory.createEntityManager();

Creating JPA Entity Manager Factory using LocalContainerEntityManagerFactoryBean in spring application:

        <bean
        class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"
        id="entityManagerFactory">
        <property name="dataSource"> <ref local="dataSource" /></property>
    </bean>

        <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/test_db" />
        <property name="username" value="root" />
        <property name="password" value="root1" />
    </bean>