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;
}
}