MySql get full name from last first mid name

Using CONCAT_WS to extract full name from first , middle and last name. 

It also handles the case that the mid_name can be empty or null or even have multiple spaces!

SELECT id, email,
    CASE WHEN mid_name IS NULL OR TRIM(mid_name) ='' THEN
        CONCAT_WS( " ", first_name, last_name )
    ELSE
        CONCAT_WS( " ", first_name, mid_name, last_name )
    END AS full_name
FROM USER;

JPA EntityManager get Session Object in Hibernate

How to get Session object from JPA EntityManager

With Hibernate (JPA 2.0 implementation), you would do:

Steps:

//1. Inject/Autowire Entity Manager
@Inject 

private EntityManager entityManager;    //javax.persistence.EntityManager 

//2. Get Session Object 

Session session = entityManager.unwrap(Session.class);  //org.hibernate.Session