Pessoal, bom dia ! estou com um problema muito estranho "não é impotência" ! e outra coisa ! estou migrando um sistema do Governo para Postgresql... ele funciona normal em MySQL, mas não gera os relatórios em Postgres..
Segue ó código:
package br.com.catequese.dao;
import br.com.caelum.vraptor.interceptor.download.InputStreamDownload;
import br.com.caelum.vraptor.ioc.Component;
import br.com.catequese.to.Aluno;
//import com.mysql.jdbc.Connection;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperRunManager;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
@Component
public class AlunoDao {
private final Session session;
public AlunoDao(Session session) {
this.session = session;
}
public void salva(Aluno aluno){
Transaction tx = session.beginTransaction();
session.save(aluno);
tx.commit();
}
public void excluir(Aluno aluno) throws Exception{
try{
Transaction tx = session.beginTransaction();
session.delete(aluno);
tx.commit();
}catch(Exception ex){
throw new Exception("Erro ao excluir Aluno. <br />O mesmo tem referência a outros dados.");
}
}
public List<Aluno> listaTudo(){
return this.session.createCriteria(Aluno.class).addOrder(Order.asc("nome")).list();
}
public Aluno carrega(Integer id) {
return (Aluno) this.session.load(Aluno.class, id);
}
public void atualiza(Aluno aluno) {
Transaction tx = session.beginTransaction();
this.session.update(aluno);
tx.commit();
}
public List<Aluno> busca(String nome) {
return session.createCriteria(Aluno.class)
.add(Restrictions.ilike("nome", nome, MatchMode.ANYWHERE))
.list();
}
public Aluno carregaCodigo(long d) throws Exception {
Transaction tx = session.beginTransaction();
String sql = "FROM Aluno WHERE codigo = " + d;
Aluno aluno = null;
Object object;
try{
object = (Aluno) session.createQuery(sql).uniqueResult();
}catch(Exception e){
throw new Exception("erro");
}
if(object == null)
throw new Exception("erro");
return (Aluno) object;
}
public long ultimaPosicao() throws Exception {
Criteria c = this.session.createCriteria(Aluno.class);
c.setProjection(Projections.max("idAluno"));
int num = (Integer) c.uniqueResult();
long codigo = (12301 * num);
return codigo;
}
private Connection getConexao() throws SQLException, ClassNotFoundException{
Connection con = null;
try{
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://localhost:5432/nutec";
String usuario = "root";
String senha = "debian23";
con = (Connection) DriverManager.getConnection(url,usuario,senha);
}catch(SQLException sql){
System.out.println("erro ao conectar");
sql.printStackTrace();
}
return con;
}
public InputStreamDownload relAlunos(String turma) throws JRException, SQLException, ClassNotFoundException {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relAlunos.jasper");
Map parametros = new HashMap();
parametros.put("turma", turma);
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioAlunos.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relAlunosCarteirinhas(String turma) throws JRException, SQLException, ClassNotFoundException {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/carteirinha.jasper");
Map parametros = new HashMap();
parametros.put("turma", turma);
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioCarterinhas.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relChamada(String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamada.jasper");
Map parametros = new HashMap();
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioChamadaGeral.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relChamadaDecGeral(String nome, String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamadaDecGeral.jasper");
Map parametros = new HashMap();
parametros.put("decanato", nome);
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioDecanatoGeral.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relChamadaDecanatoV(String nome, String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamadaDecanatoV.jasper");
Map parametros = new HashMap();
parametros.put("decanato", nome);
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioPresencaDecanato.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relChamadaDecanatoF(String nome, String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamadaDecanatoF.jasper");
Map parametros = new HashMap();
parametros.put("decanato", nome);
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioFaltaDecanato.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relChamadaParGeral(String nome, String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamadaParGeral.jasper");
Map parametros = new HashMap();
parametros.put("paroquia", nome);
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioParoquiaGeral.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relChamadaParoquiaV(String nome, String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamadaParoquiaV.jasper");
Map parametros = new HashMap();
parametros.put("paroquia", nome);
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioPresencaParoquia.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relChamadaParoquiaF(String nome, String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamadaParoquiaF.jasper");
Map parametros = new HashMap();
parametros.put("paroquia", nome);
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioFaltaParoquia.pdf", true, os.toByteArray().length);
}
public String formataData(String data)throws Exception{
String retorno = "";
try{
retorno = data.substring(6,10)+"-" + data.substring(3,5) + "-" +data.substring(0,2);
}
catch(Exception e) {
throw new Exception("Erro na conversão da data" +
"\nMensagem original: " + e.getMessage());
}
return retorno;
}
public InputStreamDownload relChamadaSoma(String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamadaDetalhe.jasper");
Map parametros = new HashMap();
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioChamadaDetalhe.pdf", true, os.toByteArray().length);
}
public InputStreamDownload relChamadaPeF(String turma, String dtInicio, String dtFim) throws JRException, SQLException, ClassNotFoundException, Exception {
InputStream file = getClass().getClassLoader().getResourceAsStream("/br/com/catequese/relatorio/relChamadaVF.jasper");
Map parametros = new HashMap();
parametros.put("turma", turma);
parametros.put("dtInicio", formataData(dtInicio));
parametros.put("dtFim", formataData(dtFim));
ByteArrayOutputStream os = new ByteArrayOutputStream();
JasperRunManager.runReportToPdfStream(file, os, parametros, getConexao());
InputStream document = new ByteArrayInputStream(os.toByteArray());
return new InputStreamDownload(document, "application/pdf", "relatorioChamadaPresencaeFalta.pdf", true, os.toByteArray().length);
}
}
