Campo do relátório dando erro estranho

Assuntos Gerais
#1

Tenho 3 tabelas com mapeadas com annotations. Duas delas funcionam perfeitamente, agora essa tabela aqui não consegue gerar o relatório. Mas eu segui o mesmo padrão que fiz nos outros relatórios :roll:

Dá esse erro
Error evaluating expression $F{id1}

Tabela

import javax.persistence.*;
/**
 * <pre><cod>
 create table tabela3(
        id integer auto_increment,
        id_tabela1 integer,
        id_tabela2 integer,
        constraint primary key(id),
        constraint id_tabela1fk foreign key(id_tabela1) references tabela1(id)
        on update cascade
        on delete cascade,
        constraint id_tabela2fk foreign key(id_tabela2) references tabela2(id)
        on update cascade
        on delete cascade
);
 * </pre></cod>
 */
@Entity
@Table(name="tabela3")
public class Tabela3 {

    @Id
    @Column(name="id")
    @GeneratedValue
    private int id = 0;

    @Basic
    @Column(name="id_tabela1")
    private int id1 = 0;

    @Basic
    @Column(name="id_tabela2")
    private int id2 = 0;
    

    public Tabela3(){

    }

    public Tabela3(int id, int id_tabela1, int id_tabela2){
        this.id = id;
        this.id1 = id_tabela1;
        this.id2 = id_tabela2;
    }

//gets e sets
}

Relatório jrxml

<?xml version="1.0" encoding="UTF-8"  ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
		 name="novo"
		 columnCount="1"
		 printOrder="Vertical"
		 orientation="Portrait"
		 pageWidth="595"
		 pageHeight="842"
		 columnWidth="535"
		 columnSpacing="0"
		 leftMargin="30"
		 rightMargin="30"
		 topMargin="20"
		 bottomMargin="20"
		 whenNoDataType="NoPages"
		 isTitleNewPage="false"
		 isSummaryNewPage="false">
	<property name="ireport.scriptlethandling" value="0" />
	<property name="ireport.encoding" value="UTF-8" />
	<import value="java.util.*" />
	<import value="net.sf.jasperreports.engine.*" />
	<import value="net.sf.jasperreports.engine.data.*" />


	<field name="id1" class="java.lang.Long"/>
	<field name="id2" class="java.lang.Long"/>

		<background>
			<band height="0"  isSplitAllowed="true" >
			</band>
		</background>
		<title>
			<band height="50"  isSplitAllowed="true" >
			</band>
		</title>
		<pageHeader>
			<band height="50"  isSplitAllowed="true" >
			</band>
		</pageHeader>
		<columnHeader>
			<band height="30"  isSplitAllowed="true" >
				<staticText>
					<reportElement
						x="141"
						y="5"
						width="86"
						height="19"
						key="staticText-1"/>
					<box></box>
					<textElement>
						<font/>
					&lt;/textElement&gt;
				&lt;text&gt;&lt;![CDATA[Tab3]]&gt;&lt;/text&gt;
				&lt;/staticText&gt;
				&lt;staticText&gt;
					&lt;reportElement
						x="238"
						y="6"
						width="98"
						height="18"
						key="staticText-2"/&gt;
					&lt;box&gt;&lt;/box&gt;
					&lt;textElement&gt;
						<font/>
					&lt;/textElement&gt;
				&lt;text&gt;&lt;![CDATA[Tab1]]&gt;&lt;/text&gt;
				&lt;/staticText&gt;
				&lt;staticText&gt;
					&lt;reportElement
						x="366"
						y="3"
						width="116"
						height="21"
						key="staticText-3"/&gt;
					&lt;box&gt;&lt;/box&gt;
					&lt;textElement&gt;
						<font/>
					&lt;/textElement&gt;
				&lt;text&gt;&lt;![CDATA[Tab2]]&gt;&lt;/text&gt;
				&lt;/staticText&gt;
			&lt;/band&gt;
		&lt;/columnHeader&gt;
		&lt;detail&gt;
			&lt;band height="100"  isSplitAllowed="true" &gt;
				&lt;textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" &gt;
					&lt;reportElement
						x="238"
						y="16"
						width="104"
						height="31"
						key="textField-2"/&gt;
					&lt;box&gt;&lt;/box&gt;
					&lt;textElement&gt;
						<font/>
					&lt;/textElement&gt;
				&lt;textFieldExpression   class="java.lang.Long"&gt;&lt;![CDATA[$F{id1}]]&gt;&lt;/textFieldExpression&gt;
				&lt;/textField&gt;
				&lt;textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" &gt;
					&lt;reportElement
						x="371"
						y="15"
						width="106"
						height="32"
						key="textField-3"/&gt;
					&lt;box&gt;&lt;/box&gt;
					&lt;textElement&gt;
						<font/>
					&lt;/textElement&gt;
				&lt;textFieldExpression   class="java.lang.Long"&gt;&lt;![CDATA[$F{id2}]]&gt;&lt;/textFieldExpression&gt;
				&lt;/textField&gt;
			&lt;/band&gt;
		&lt;/detail&gt;
		&lt;columnFooter&gt;
			&lt;band height="30"  isSplitAllowed="true" &gt;
			&lt;/band&gt;
		&lt;/columnFooter&gt;
		&lt;pageFooter&gt;
			&lt;band height="50"  isSplitAllowed="true" &gt;
			&lt;/band&gt;
		&lt;/pageFooter&gt;
		&lt;lastPageFooter&gt;
			&lt;band height="50"  isSplitAllowed="true" &gt;
			&lt;/band&gt;
		&lt;/lastPageFooter&gt;
		&lt;summary&gt;
			&lt;band height="50"  isSplitAllowed="true" &gt;
			&lt;/band&gt;
		&lt;/summary&gt;
&lt;/jasperReport&gt;
#2

Ninguém…?? :roll:

Talvez vc possa me perguntar "onde está seu mapeamento de uma lista ou conjunto para retornar o resultado?"

Essa tabela tem relacionamento 1:N com mais duas tabelas, por isso, a anotação está sendo feita só “nas tabelas das pontas”.

#3

Ainda não solucionei o problema :cry: :cry: :cry:

Dentro da minha lista tem os dados que preciso mostrar no relatório e no relatório tem todos os campos para mostrar esses dados, no entanto ainda aparece esse erro:

[ID tabela 3: 1, ID tabela 1: 1, ID tabela 2: 1] INFO: Named query checking : enabled 14/05/2009 10:19:23 org.hibernate.impl.SessionFactoryImpl &lt;init&gt; INFO: building session factory 14/05/2009 10:19:24 org.hibernate.impl.SessionFactoryObjectFactory addInstance INFO: Not binding factory to JNDI, no JNDI name configured Error evaluating expression : Source text : $F{id2} CONSTRUÍDO COM SUCESSO (tempo total: 4 segundos)

E estranho que o erro é só no último parametro, nos demais não acusa nada.

#4