ranyeli
7/11/2018 - 2:03 PM

Native and Non-Native Queries

How to run a query using jpa syntax and db native syntax

package com.dominicana.ipack.dao;

import java.util.List;

import javax.persistence.Query;
import javax.persistence.TypedQuery;

import org.springframework.stereotype.Repository;

import com.dominicana.ipack.models.Usuario;

@Repository
public class UsuarioDao extends GenericDao<Usuario> {
	
	public List<Usuario> findUser(String usuario, String pass) {
		
	//NATIVE
	String sql = "select * from get_usuario('')";  

  //NON-NATIVE
	String sql3 = "from " + Usuario.class.getName() + " where f_codigo_usuario = 190";
	
	//NATIVE
  //Query query = entityManager.createNativeQuery(sql, Usuario.class);
  
  //NON-NATIVE
	Query query = entityManager.createQuery(sql3, Usuario.class);

	@SuppressWarnings("unchecked")
	List<Usuario> user = (List<Usuario>)query.getResultList();
	 
	return user;
	}
}