NetBeans Forums

FAQ

Memberlist

Profile

MySql query returns wrong result list: the first row is repeated

NetBeans Forums -> NetBeans Platform Users

View previous topic :: View next topic

Author

Message

Andre Uhres

Joined: 19 Oct 2008
Posts: 3

Posted: Thu Sep 23, 2010 8:29 am Post subject: MySql query returns wrong result list: the first row is repeated

My problem concerns a NetBeans Platform Application related to MySql. It executes a simple query on a MySql database.
But the query returns a wrong result list: the list contains the right number of rows, but only the first row has valid data.
All other rows are simple duplicates of the first row.
This is not correct according to data in the database (each row should have different data):

08 1/2004 AMO 40131 68182 44.50 AMO0104 AMORT. 01/04
08 1/2004 AMO 40131 68182 44.50 AMO0104 AMORT. 01/04
08 1/2004 AMO 40131 68182 44.50 AMO0104 AMORT. 01/04
08 1/2004 AMO 40131 68182 44.50 AMO0104 AMORT. 01/04
08 1/2004 AMO 40131 68182 44.50 AMO0104 AMORT. 01/04
...

What could be the origine of this problem? Here is my code and the NetBeans output when running the application:

Code:

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package cumaux.ui;

import cumaux.Ecrgenpf;
import java.util.List;
import java.util.logging.Logger;
import javax.persistence.EntityManager;
import javax.persistence.Persistence;
import javax.persistence.Query;
import org.openide.util.NbBundle;
import org.openide.windows.TopComponent;
import org.openide.windows.WindowManager;
//import org.openide.util.ImageUtilities;
import org.netbeans.api.settings.ConvertAsProperties;

/**
* Top component which displays something.
*/
@ConvertAsProperties(dtd = "-//cumaux.ui//Ecrgen//EN",
autostore = false)
public final class EcrgenTopComponent extends TopComponent {

private static EcrgenTopComponent instance;
/** path to the icon used by the component and its open action */
// static final String ICON_PATH = "SET/PATH/TO/ICON/HERE";
private static final String PREFERRED_ID = "EcrgenTopComponent";

public EcrgenTopComponent() {
initComponents();
setName(NbBundle.getMessage(EcrgenTopComponent.class, "CTL_EcrgenTopComponent"));
setToolTipText(NbBundle.getMessage(EcrgenTopComponent.class, "HINT_EcrgenTopComponent"));
// setIcon(ImageUtilities.loadImage(ICON_PATH, true));
EntityManager entityManager = Persistence.createEntityManagerFactory("CumAuxLibraryPU").createEntityManager();
Query query = entityManager.createQuery("SELECT c FROM Ecrgenpf c where c.cdste='08' "
+ "and c.noexg = 2004 and c.nocpg = '68182'");
List<Ecrgenpf> resultList = query.getResultList();
for (Ecrgenpf c : resultList) {
jTextArea1.append(""
+ " " + c.getCdste()//code société
+ " " + c.getNoprg()//période
+ "/" + c.getNoexg()//exercice
+ " " + c.getCdjna()//journal
+ " " + c.getDtpie()//date pièce
+ " " + c.getCdnax()//nature auxiliaire
+ " " + c.getNocpx()//compte auxiliaire
+ " " + c.getNocpg()//compte général
// + " " + c.getNopie()//numéro pièce
+ " " + c.getMtecr()//montant
+ " " + c.getLbrex()//libellé (extension)
+ " " + c.getLbecr()//libellé
+ "\n");
}
}

/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/

// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {

jScrollPane1 = new javax.swing.JScrollPane();
jTextArea1 = new javax.swing.JTextArea();

setLayout(new java.awt.BorderLayout());

jTextArea1.setColumns(20);
jTextArea1.setRows(5);
jScrollPane1.setViewportView(jTextArea1);

add(jScrollPane1, java.awt.BorderLayout.CENTER);
}// </editor-fold>
// Variables declaration - do not modify
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTextArea jTextArea1;
// End of variables declaration

/**
* Gets default instance. Do not use directly: reserved for *.settings files only,
* i.e. deserialization routines; otherwise you could get a non-deserialized instance.
* To obtain the singleton instance, use {@link #findInstance}.
*/
public static synchronized EcrgenTopComponent getDefault() {
if (instance == null) {
instance = new EcrgenTopComponent();
}
return instance;
}

/**
* Obtain the EcrgenTopComponent instance. Never call {@link #getDefault} directly!
*/
public static synchronized EcrgenTopComponent findInstance() {
TopComponent win = WindowManager.getDefault().findTopComponent(PREFERRED_ID);
if (win == null) {
Logger.getLogger(EcrgenTopComponent.class.getName()).warning(
"Cannot find " + PREFERRED_ID + " component. It will not be located properly in the window system.");
return getDefault();
}
if (win instanceof EcrgenTopComponent) {
return (EcrgenTopComponent) win;
}
Logger.getLogger(EcrgenTopComponent.class.getName()).warning(
"There seem to be multiple components with the '" + PREFERRED_ID
+ "' ID. That is a potential source of errors and unexpected behavior.");
return getDefault();
}

@Override
public int getPersistenceType() {
return TopComponent.PERSISTENCE_ALWAYS;
}

@Override
public void componentOpened() {
// TODO add custom code on component opening
}

@Override
public void componentClosed() {
// TODO add custom code on component closing
}

void writeProperties(java.util.Properties p) {
// better to version settings since initial version as advocated at
// http://wiki.apidesign.org/wiki/PropertyFiles
p.setProperty("version", "1.0");
// TODO store your settings
}

Object readProperties(java.util.Properties p) {
if (instance == null) {
instance = this;
}
instance.readPropertiesImpl(p);
return instance;
}

private void readPropertiesImpl(java.util.Properties p) {
String version = p.getProperty("version");
// TODO read your settings according to their version
}

@Override
protected String preferredID() {
return PREFERRED_ID;
}
}

Code:

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package cumaux;

import java.io.Serializable;
import java.math.BigDecimal;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Id;
import javax.persistence.Entity;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

/**
*
* @author uhrand
*/
@Entity
@Table(name = "ecrgenpf")
@NamedQueries({
@NamedQuery(name = "Ecrgenpf.findAll", query = "SELECT e FROM Ecrgenpf e"),
@NamedQuery(name = "Ecrgenpf.findByCdste", query = "SELECT e FROM Ecrgenpf e WHERE e.cdste = :cdste"),
@NamedQuery(name = "Ecrgenpf.findByCdetb", query = "SELECT e FROM Ecrgenpf e WHERE e.cdetb = :cdetb"),
@NamedQuery(name = "Ecrgenpf.findByCdjna", query = "SELECT e FROM Ecrgenpf e WHERE e.cdjna = :cdjna"),
@NamedQuery(name = "Ecrgenpf.findByNopie", query = "SELECT e FROM Ecrgenpf e WHERE e.nopie = :nopie"),
@NamedQuery(name = "Ecrgenpf.findByNolin", query = "SELECT e FROM Ecrgenpf e WHERE e.nolin = :nolin"),
@NamedQuery(name = "Ecrgenpf.findByNopcg", query = "SELECT e FROM Ecrgenpf e WHERE e.nopcg = :nopcg"),
@NamedQuery(name = "Ecrgenpf.findByNocpg", query = "SELECT e FROM Ecrgenpf e WHERE e.nocpg = :nocpg"),
@NamedQuery(name = "Ecrgenpf.findByCdnax", query = "SELECT e FROM Ecrgenpf e WHERE e.cdnax = :cdnax"),
@NamedQuery(name = "Ecrgenpf.findByNopcx", query = "SELECT e FROM Ecrgenpf e WHERE e.nopcx = :nopcx"),
@NamedQuery(name = "Ecrgenpf.findByNocpx", query = "SELECT e FROM Ecrgenpf e WHERE e.nocpx = :nocpx"),
@NamedQuery(name = "Ecrgenpf.findByNocx11", query = "SELECT e FROM Ecrgenpf e WHERE e.nocx11 = :nocx11"),
@NamedQuery(name = "Ecrgenpf.findByCdtyp", query = "SELECT e FROM Ecrgenpf e WHERE e.cdtyp = :cdtyp"),
@NamedQuery(name = "Ecrgenpf.findByLbrex", query = "SELECT e FROM Ecrgenpf e WHERE e.lbrex = :lbrex"),
@NamedQuery(name = "Ecrgenpf.findByLbecr", query = "SELECT e FROM Ecrgenpf e WHERE e.lbecr = :lbecr"),
@NamedQuery(name = "Ecrgenpf.findByMtecr", query = "SELECT e FROM Ecrgenpf e WHERE e.mtecr = :mtecr"),
@NamedQuery(name = "Ecrgenpf.findByCdsen", query = "SELECT e FROM Ecrgenpf e WHERE e.cdsen = :cdsen"),
@NamedQuery(name = "Ecrgenpf.findByCtsen", query = "SELECT e FROM Ecrgenpf e WHERE e.ctsen = :ctsen"),
@NamedQuery(name = "Ecrgenpf.findByCddev", query = "SELECT e FROM Ecrgenpf e WHERE e.cddev = :cddev"),
@NamedQuery(name = "Ecrgenpf.findByMtdev", query = "SELECT e FROM Ecrgenpf e WHERE e.mtdev = :mtdev"),
@NamedQuery(name = "Ecrgenpf.findByNopis", query = "SELECT e FROM Ecrgenpf e WHERE e.nopis = :nopis"),
@NamedQuery(name = "Ecrgenpf.findByCdjnr", query = "SELECT e FROM Ecrgenpf e WHERE e.cdjnr = :cdjnr"),
@NamedQuery(name = "Ecrgenpf.findByNopir", query = "SELECT e FROM Ecrgenpf e WHERE e.nopir = :nopir"),
@NamedQuery(name = "Ecrgenpf.findBySiech", query = "SELECT e FROM Ecrgenpf e WHERE e.siech = :siech"),
@NamedQuery(name = "Ecrgenpf.findByDtech", query = "SELECT e FROM Ecrgenpf e WHERE e.dtech = :dtech"),
@NamedQuery(name = "Ecrgenpf.findByCdrtv", query = "SELECT e FROM Ecrgenpf e WHERE e.cdrtv = :cdrtv"),
@NamedQuery(name = "Ecrgenpf.findByCdttv", query = "SELECT e FROM Ecrgenpf e WHERE e.cdttv = :cdttv"),
@NamedQuery(name = "Ecrgenpf.findByNoexg", query = "SELECT e FROM Ecrgenpf e WHERE e.noexg = :noexg"),
@NamedQuery(name = "Ecrgenpf.findByNoprg", query = "SELECT e FROM Ecrgenpf e WHERE e.noprg = :noprg"),
@NamedQuery(name = "Ecrgenpf.findByCdna2", query = "SELECT e FROM Ecrgenpf e WHERE e.cdna2 = :cdna2"),
@NamedQuery(name = "Ecrgenpf.findByNocg2", query = "SELECT e FROM Ecrgenpf e WHERE e.nocg2 = :nocg2"),
@NamedQuery(name = "Ecrgenpf.findByNopx2", query = "SELECT e FROM Ecrgenpf e WHERE e.nopx2 = :nopx2"),
@NamedQuery(name = "Ecrgenpf.findByNocx2", query = "SELECT e FROM Ecrgenpf e WHERE e.nocx2 = :nocx2"),
@NamedQuery(name = "Ecrgenpf.findByCdlet", query = "SELECT e FROM Ecrgenpf e WHERE e.cdlet = :cdlet"),
@NamedQuery(name = "Ecrgenpf.findByCdpoi", query = "SELECT e FROM Ecrgenpf e WHERE e.cdpoi = :cdpoi"),
@NamedQuery(name = "Ecrgenpf.findByNoexl", query = "SELECT e FROM Ecrgenpf e WHERE e.noexl = :noexl"),
@NamedQuery(name = "Ecrgenpf.findByNoprl", query = "SELECT e FROM Ecrgenpf e WHERE e.noprl = :noprl"),
@NamedQuery(name = "Ecrgenpf.findByCdetp", query = "SELECT e FROM Ecrgenpf e WHERE e.cdetp = :cdetp"),
@NamedQuery(name = "Ecrgenpf.findByCdnap", query = "SELECT e FROM Ecrgenpf e WHERE e.cdnap = :cdnap"),
@NamedQuery(name = "Ecrgenpf.findByCdfl1", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl1 = :cdfl1"),
@NamedQuery(name = "Ecrgenpf.findByCdfl2", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl2 = :cdfl2"),
@NamedQuery(name = "Ecrgenpf.findByCdfl3", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl3 = :cdfl3"),
@NamedQuery(name = "Ecrgenpf.findByCdfl4", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl4 = :cdfl4"),
@NamedQuery(name = "Ecrgenpf.findByCdfl5", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl5 = :cdfl5"),
@NamedQuery(name = "Ecrgenpf.findByCtex1", query = "SELECT e FROM Ecrgenpf e WHERE e.ctex1 = :ctex1"),
@NamedQuery(name = "Ecrgenpf.findByCtex2", query = "SELECT e FROM Ecrgenpf e WHERE e.ctex2 = :ctex2"),
@NamedQuery(name = "Ecrgenpf.findByCtex3", query = "SELECT e FROM Ecrgenpf e WHERE e.ctex3 = :ctex3"),
@NamedQuery(name = "Ecrgenpf.findByCtex4", query = "SELECT e FROM Ecrgenpf e WHERE e.ctex4 = :ctex4"),
@NamedQuery(name = "Ecrgenpf.findByCtex5", query = "SELECT e FROM Ecrgenpf e WHERE e.ctex5 = :ctex5"),
@NamedQuery(name = "Ecrgenpf.findByCtex6", query = "SELECT e FROM Ecrgenpf e WHERE e.ctex6 = :ctex6"),
@NamedQuery(name = "Ecrgenpf.findByCtex7", query = "SELECT e FROM Ecrgenpf e WHERE e.ctex7 = :ctex7"),
@NamedQuery(name = "Ecrgenpf.findByCtex8", query = "SELECT e FROM Ecrgenpf e WHERE e.ctex8 = :ctex8"),
@NamedQuery(name = "Ecrgenpf.findByCdtyc", query = "SELECT e FROM Ecrgenpf e WHERE e.cdtyc = :cdtyc"),
@NamedQuery(name = "Ecrgenpf.findByNolif", query = "SELECT e FROM Ecrgenpf e WHERE e.nolif = :nolif"),
@NamedQuery(name = "Ecrgenpf.findByCdcon", query = "SELECT e FROM Ecrgenpf e WHERE e.cdcon = :cdcon"),
@NamedQuery(name = "Ecrgenpf.findByDtpie", query = "SELECT e FROM Ecrgenpf e WHERE e.dtpie = :dtpie"),
@NamedQuery(name = "Ecrgenpf.findBySipie", query = "SELECT e FROM Ecrgenpf e WHERE e.sipie = :sipie"),
@NamedQuery(name = "Ecrgenpf.findByCdfl6", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl6 = :cdfl6"),
@NamedQuery(name = "Ecrgenpf.findByCdfl7", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl7 = :cdfl7"),
@NamedQuery(name = "Ecrgenpf.findByCdreg", query = "SELECT e FROM Ecrgenpf e WHERE e.cdreg = :cdreg"),
@NamedQuery(name = "Ecrgenpf.findByCdttp", query = "SELECT e FROM Ecrgenpf e WHERE e.cdttp = :cdttp"),
@NamedQuery(name = "Ecrgenpf.findByNolin1", query = "SELECT e FROM Ecrgenpf e WHERE e.nolin1 = :nolin1"),
@NamedQuery(name = "Ecrgenpf.findByCdfl0", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl0 = :cdfl0"),
@NamedQuery(name = "Ecrgenpf.findByCdfl9", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl9 = :cdfl9"),
@NamedQuery(name = "Ecrgenpf.findByCdfl10", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl10 = :cdfl10"),
@NamedQuery(name = "Ecrgenpf.findByCdfl11", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl11 = :cdfl11"),
@NamedQuery(name = "Ecrgenpf.findByCddev1", query = "SELECT e FROM Ecrgenpf e WHERE e.cddev1 = :cddev1"),
@NamedQuery(name = "Ecrgenpf.findByCddev2", query = "SELECT e FROM Ecrgenpf e WHERE e.cddev2 = :cddev2"),
@NamedQuery(name = "Ecrgenpf.findByCdfl12", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl12 = :cdfl12"),
@NamedQuery(name = "Ecrgenpf.findByCdfl13", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl13 = :cdfl13"),
@NamedQuery(name = "Ecrgenpf.findByCdfl14", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl14 = :cdfl14"),
@NamedQuery(name = "Ecrgenpf.findByCdfl15", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfl15 = :cdfl15"),
@NamedQuery(name = "Ecrgenpf.findByMtdevs", query = "SELECT e FROM Ecrgenpf e WHERE e.mtdevs = :mtdevs"),
@NamedQuery(name = "Ecrgenpf.findByCdfmt", query = "SELECT e FROM Ecrgenpf e WHERE e.cdfmt = :cdfmt"),
@NamedQuery(name = "Ecrgenpf.findByCdstl", query = "SELECT e FROM Ecrgenpf e WHERE e.cdstl = :cdstl"),
@NamedQuery(name = "Ecrgenpf.findByCdetl", query = "SELECT e FROM Ecrgenpf e WHERE e.cdetl = :cdetl"),
@NamedQuery(name = "Ecrgenpf.findByCdabo", query = "SELECT e FROM Ecrgenpf e WHERE e.cdabo = :cdabo")})
public class Ecrgenpf implements Serializable {

private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@Column(name = "CDSTE")
private String cdste;
@Column(name = "CDETB")
private String cdetb;
@Column(name = "CDJNA")
private String cdjna;
@Column(name = "NOPIE")
private Integer nopie;
@Column(name = "NOLIN")
private Integer nolin;
@Column(name = "NOPCG")
private String nopcg;
@Column(name = "NOCPG")
private String nocpg;
@Column(name = "CDNAX")
private String cdnax;
@Column(name = "NOPCX")
private String nopcx;
@Column(name = "NOCPX")
private String nocpx;
@Column(name = "NOCX11")
private String nocx11;
@Column(name = "CDTYP")
private String cdtyp;
@Column(name = "LBREX")
private String lbrex;
@Column(name = "LBECR")
private String lbecr;
@Column(name = "MTECR")
private BigDecimal mtecr;
@Column(name = "CDSEN")
private Character cdsen;
@Column(name = "CTSEN")
private Boolean ctsen;
@Column(name = "CDDEV")
private String cddev;
@Column(name = "MTDEV")
private BigDecimal mtdev;
@Column(name = "NOPIS")
private String nopis;
@Column(name = "CDJNR")
private String cdjnr;
@Column(name = "NOPIR")
private String nopir;
@Column(name = "SIECH")
private Boolean siech;
@Column(name = "DTECH")
private Integer dtech;
@Column(name = "CDRTV")
private Character cdrtv;
@Column(name = "CDTTV")
private Character cdttv;
@Column(name = "NOEXG")
private Short noexg;
@Column(name = "NOPRG")
private Short noprg;
@Column(name = "CDNA2")
private String cdna2;
@Column(name = "NOCG2")
private String nocg2;
@Column(name = "NOPX2")
private String nopx2;
@Column(name = "NOCX2")
private String nocx2;
@Column(name = "CDLET")
private Character cdlet;
@Column(name = "CDPOI")
private Character cdpoi;
@Column(name = "NOEXL")
private Short noexl;
@Column(name = "NOPRL")
private Short noprl;
@Column(name = "CDETP")
private Character cdetp;
@Column(name = "CDNAP")
private Character cdnap;
@Column(name = "CDFL1")
private Character cdfl1;
@Column(name = "CDFL2")
private Character cdfl2;
@Column(name = "CDFL3")
private Character cdfl3;
@Column(name = "CDFL4")
private Character cdfl4;
@Column(name = "CDFL5")
private Character cdfl5;
@Column(name = "CTEX1")
private Boolean ctex1;
@Column(name = "CTEX2")
private Boolean ctex2;
@Column(name = "CTEX3")
private Boolean ctex3;
@Column(name = "CTEX4")
private Boolean ctex4;
@Column(name = "CTEX5")
private Boolean ctex5;
@Column(name = "CTEX6")
private Boolean ctex6;
@Column(name = "CTEX7")
private Boolean ctex7;
@Column(name = "CTEX8")
private Boolean ctex8;
@Column(name = "CDTYC")
private String cdtyc;
@Column(name = "NOLIF")
private Short nolif;
@Column(name = "CDCON")
private Short cdcon;
@Column(name = "DTPIE")
private Integer dtpie;
@Column(name = "SIPIE")
private Boolean sipie;
@Column(name = "CDFL6")
private Character cdfl6;
@Column(name = "CDFL7")
private Character cdfl7;
@Column(name = "CDREG")
private String cdreg;
@Column(name = "CDTTP")
private Character cdttp;
@Column(name = "NOLIN1")
private Integer nolin1;
@Column(name = "CDFL0")
private Character cdfl0;
@Column(name = "CDFL9")
private Character cdfl9;
@Column(name = "CDFL10")
private Character cdfl10;
@Column(name = "CDFL11")
private Character cdfl11;
@Column(name = "CDDEV1")
private String cddev1;
@Column(name = "CDDEV2")
private String cddev2;
@Column(name = "CDFL12")
private Character cdfl12;
@Column(name = "CDFL13")
private Character cdfl13;
@Column(name = "CDFL14")
private Character cdfl14;
@Column(name = "CDFL15")
private Character cdfl15;
@Column(name = "MTDEVS")
private BigDecimal mtdevs;
@Column(name = "CDFMT")
private String cdfmt;
@Column(name = "CDSTL")
private String cdstl;
@Column(name = "CDETL")
private String cdetl;
@Column(name = "CDABO")
private String cdabo;

public Ecrgenpf() {
}

public String getCdste() {
return cdste;
}

public void setCdste(String cdste) {
this.cdste = cdste;
}

public String getCdetb() {
return cdetb;
}

public void setCdetb(String cdetb) {
this.cdetb = cdetb;
}

public String getCdjna() {
return cdjna;
}

public void setCdjna(String cdjna) {
this.cdjna = cdjna;
}

public Integer getNopie() {
return nopie;
}

public void setNopie(Integer nopie) {
this.nopie = nopie;
}

public Integer getNolin() {
return nolin;
}

public void setNolin(Integer nolin) {
this.nolin = nolin;
}

public String getNopcg() {
return nopcg;
}

public void setNopcg(String nopcg) {
this.nopcg = nopcg;
}

public String getNocpg() {
return nocpg;
}

public void setNocpg(String nocpg) {
this.nocpg = nocpg;
}

public String getCdnax() {
return cdnax;
}

public void setCdnax(String cdnax) {
this.cdnax = cdnax;
}

public String getNopcx() {
return nopcx;
}

public void setNopcx(String nopcx) {
this.nopcx = nopcx;
}

public String getNocpx() {
return nocpx;
}

public void setNocpx(String nocpx) {
this.nocpx = nocpx;
}

public String getNocx11() {
return nocx11;
}

public void setNocx11(String nocx11) {
this.nocx11 = nocx11;
}

public String getCdtyp() {
return cdtyp;
}

public void setCdtyp(String cdtyp) {
this.cdtyp = cdtyp;
}

public String getLbrex() {
return lbrex;
}

public void setLbrex(String lbrex) {
this.lbrex = lbrex;
}

public String getLbecr() {
return lbecr;
}

public void setLbecr(String lbecr) {
this.lbecr = lbecr;
}

public BigDecimal getMtecr() {
return mtecr;
}

public void setMtecr(BigDecimal mtecr) {
this.mtecr = mtecr;
}

public Character getCdsen() {
return cdsen;
}

public void setCdsen(Character cdsen) {
this.cdsen = cdsen;
}

public Boolean getCtsen() {
return ctsen;
}

public void setCtsen(Boolean ctsen) {
this.ctsen = ctsen;
}

public String getCddev() {
return cddev;
}

public void setCddev(String cddev) {
this.cddev = cddev;
}

public BigDecimal getMtdev() {
return mtdev;
}

public void setMtdev(BigDecimal mtdev) {
this.mtdev = mtdev;
}

public String getNopis() {
return nopis;
}

public void setNopis(String nopis) {
this.nopis = nopis;
}

public String getCdjnr() {
return cdjnr;
}

public void setCdjnr(String cdjnr) {
this.cdjnr = cdjnr;
}

public String getNopir() {
return nopir;
}

public void setNopir(String nopir) {
this.nopir = nopir;
}

public Boolean getSiech() {
return siech;
}

public void setSiech(Boolean siech) {
this.siech = siech;
}

public Integer getDtech() {
return dtech;
}

public void setDtech(Integer dtech) {
this.dtech = dtech;
}

public Character getCdrtv() {
return cdrtv;
}

public void setCdrtv(Character cdrtv) {
this.cdrtv = cdrtv;
}

public Character getCdttv() {
return cdttv;
}

public void setCdttv(Character cdttv) {
this.cdttv = cdttv;
}

public Short getNoexg() {
return noexg;
}

public void setNoexg(Short noexg) {
this.noexg = noexg;
}

public Short getNoprg() {
return noprg;
}

public void setNoprg(Short noprg) {
this.noprg = noprg;
}

public String getCdna2() {
return cdna2;
}

public void setCdna2(String cdna2) {
this.cdna2 = cdna2;
}

public String getNocg2() {
return nocg2;
}

public void setNocg2(String nocg2) {
this.nocg2 = nocg2;
}

public String getNopx2() {
return nopx2;
}

public void setNopx2(String nopx2) {
this.nopx2 = nopx2;
}

public String getNocx2() {
return nocx2;
}

public void setNocx2(String nocx2) {
this.nocx2 = nocx2;
}

public Character getCdlet() {
return cdlet;
}

public void setCdlet(Character cdlet) {
this.cdlet = cdlet;
}

public Character getCdpoi() {
return cdpoi;
}

public void setCdpoi(Character cdpoi) {
this.cdpoi = cdpoi;
}

public Short getNoexl() {
return noexl;
}

public void setNoexl(Short noexl) {
this.noexl = noexl;
}

public Short getNoprl() {
return noprl;
}

public void setNoprl(Short noprl) {
this.noprl = noprl;
}

public Character getCdetp() {
return cdetp;
}

public void setCdetp(Character cdetp) {
this.cdetp = cdetp;
}

public Character getCdnap() {
return cdnap;
}

public void setCdnap(Character cdnap) {
this.cdnap = cdnap;
}

public Character getCdfl1() {
return cdfl1;
}

public void setCdfl1(Character cdfl1) {
this.cdfl1 = cdfl1;
}

public Character getCdfl2() {
return cdfl2;
}

public void setCdfl2(Character cdfl2) {
this.cdfl2 = cdfl2;
}

public Character getCdfl3() {
return cdfl3;
}

public void setCdfl3(Character cdfl3) {
this.cdfl3 = cdfl3;
}

public Character getCdfl4() {
return cdfl4;
}

public void setCdfl4(Character cdfl4) {
this.cdfl4 = cdfl4;
}

public Character getCdfl5() {
return cdfl5;
}

public void setCdfl5(Character cdfl5) {
this.cdfl5 = cdfl5;
}

public Boolean getCtex1() {
return ctex1;
}

public void setCtex1(Boolean ctex1) {
this.ctex1 = ctex1;
}

public Boolean getCtex2() {
return ctex2;
}

public void setCtex2(Boolean ctex2) {
this.ctex2 = ctex2;
}

public Boolean getCtex3() {
return ctex3;
}

public void setCtex3(Boolean ctex3) {
this.ctex3 = ctex3;
}

public Boolean getCtex4() {
return ctex4;
}

public void setCtex4(Boolean ctex4) {
this.ctex4 = ctex4;
}

public Boolean getCtex5() {
return ctex5;
}

public void setCtex5(Boolean ctex5) {
this.ctex5 = ctex5;
}

public Boolean getCtex6() {
return ctex6;
}

public void setCtex6(Boolean ctex6) {
this.ctex6 = ctex6;
}

public Boolean getCtex7() {
return ctex7;
}

public void setCtex7(Boolean ctex7) {
this.ctex7 = ctex7;
}

public Boolean getCtex8() {
return ctex8;
}

public void setCtex8(Boolean ctex8) {
this.ctex8 = ctex8;
}

public String getCdtyc() {
return cdtyc;
}

public void setCdtyc(String cdtyc) {
this.cdtyc = cdtyc;
}

public Short getNolif() {
return nolif;
}

public void setNolif(Short nolif) {
this.nolif = nolif;
}

public Short getCdcon() {
return cdcon;
}

public void setCdcon(Short cdcon) {
this.cdcon = cdcon;
}

public Integer getDtpie() {
return dtpie;
}

public void setDtpie(Integer dtpie) {
this.dtpie = dtpie;
}

public Boolean getSipie() {
return sipie;
}

public void setSipie(Boolean sipie) {
this.sipie = sipie;
}

public Character getCdfl6() {
return cdfl6;
}

public void setCdfl6(Character cdfl6) {
this.cdfl6 = cdfl6;
}

public Character getCdfl7() {
return cdfl7;
}

public void setCdfl7(Character cdfl7) {
this.cdfl7 = cdfl7;
}

public String getCdreg() {
return cdreg;
}

public void setCdreg(String cdreg) {
this.cdreg = cdreg;
}

public Character getCdttp() {
return cdttp;
}

public void setCdttp(Character cdttp) {
this.cdttp = cdttp;
}

public Integer getNolin1() {
return nolin1;
}

public void setNolin1(Integer nolin1) {
this.nolin1 = nolin1;
}

public Character getCdfl0() {
return cdfl0;
}

public void setCdfl0(Character cdfl0) {
this.cdfl0 = cdfl0;
}

public Character getCdfl9() {
return cdfl9;
}

public void setCdfl9(Character cdfl9) {
this.cdfl9 = cdfl9;
}

public Character getCdfl10() {
return cdfl10;
}

public void setCdfl10(Character cdfl10) {
this.cdfl10 = cdfl10;
}

public Character getCdfl11() {
return cdfl11;
}

public void setCdfl11(Character cdfl11) {
this.cdfl11 = cdfl11;
}

public String getCddev1() {
return cddev1;
}

public void setCddev1(String cddev1) {
this.cddev1 = cddev1;
}

public String getCddev2() {
return cddev2;
}

public void setCddev2(String cddev2) {
this.cddev2 = cddev2;
}

public Character getCdfl12() {
return cdfl12;
}

public void setCdfl12(Character cdfl12) {
this.cdfl12 = cdfl12;
}

public Character getCdfl13() {
return cdfl13;
}

public void setCdfl13(Character cdfl13) {
this.cdfl13 = cdfl13;
}

public Character getCdfl14() {
return cdfl14;
}

public void setCdfl14(Character cdfl14) {
this.cdfl14 = cdfl14;
}

public Character getCdfl15() {
return cdfl15;
}

public void setCdfl15(Character cdfl15) {
this.cdfl15 = cdfl15;
}

public BigDecimal getMtdevs() {
return mtdevs;
}

public void setMtdevs(BigDecimal mtdevs) {
this.mtdevs = mtdevs;
}

public String getCdfmt() {
return cdfmt;
}

public void setCdfmt(String cdfmt) {
this.cdfmt = cdfmt;
}

public String getCdstl() {
return cdstl;
}

public void setCdstl(String cdstl) {
this.cdstl = cdstl;
}

public String getCdetl() {
return cdetl;
}

public void setCdetl(String cdetl) {
this.cdetl = cdetl;
}

public String getCdabo() {
return cdabo;
}

public void setCdabo(String cdabo) {
this.cdabo = cdabo;
}

@Override
public boolean equals(Object obj) {
if (obj == null) {
return false;
}
if (getClass() != obj.getClass()) {
return false;
}
final Ecrgenpf other = (Ecrgenpf) obj;
if ((this.cdste == null) ? (other.cdste != null) : !this.cdste.equals(other.cdste)) {
return false;
}
if ((this.cdetb == null) ? (other.cdetb != null) : !this.cdetb.equals(other.cdetb)) {
return false;
}
if ((this.cdjna == null) ? (other.cdjna != null) : !this.cdjna.equals(other.cdjna)) {
return false;
}
if (this.nopie != other.nopie && (this.nopie == null || !this.nopie.equals(other.nopie))) {
return false;
}
if (this.nolin != other.nolin && (this.nolin == null || !this.nolin.equals(other.nolin))) {
return false;
}
return true;
}

@Override
public int hashCode() {
int hash = 5;
hash = 97 * hash + (this.cdste != null ? this.cdste.hashCode() : 0);
hash = 97 * hash + (this.cdetb != null ? this.cdetb.hashCode() : 0);
hash = 97 * hash + (this.cdjna != null ? this.cdjna.hashCode() : 0);
hash = 97 * hash + (this.nopie != null ? this.nopie.hashCode() : 0);
hash = 97 * hash + (this.nolin != null ? this.nolin.hashCode() : 0);
return hash;
}

@Override
public String toString() {
return "cumaux.Ecrgenpf[ecrgenpfPK=" + cdste + " " + cdetb + " " + cdjna + " " + nopie + " " + nolin + "]";
}
}

Here is the NetBeans output when running the application:

branding:
files-init:
release:
Hidden modules: [Auto Update Services, Auto Update UI, Compatibility APIs, Core - Execution, Execution API, Favorites, MultiView Windows, Old Enumeration API, RCP Platform, Scripting API Integration, Settings Options API, Swing Layout Extensions integration, Visual Library API]
build:
cumaux4.taskdefs:
cumaux4.common-init:
cumaux4.projectized-common.basic-init:
cumaux4.basic-init:
cumaux4.files-init:
cumaux4.nbm-license-init:
cumaux4.build-init:
Scanning for modules in C:\Program Files\NetBeans 6.9.1\platform
Scanning for modules in suite W:\Files\PROJETS\NetBeansProjectsTest\CumAux
cumaux4.init:
cumaux4.up-to-date:
cumaux4.compile:
cumaux4.jar-prep:
cumaux4.jar:
cumaux4.netbeans-extra:
cumaux4.module-xml-regular:
cumaux4.module-xml-autoload:
cumaux4.module-xml-eager:
cumaux4.javahelp:
cumaux4.module-auto-deps:
cumaux4.release:
Copying 1 file to W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\cluster
cumaux4.chmod-executables:
cumaux4.verify-class-linkage:
0 file(s) have been successfully validated.
cumaux4.netbeans:
Generating information for Auto Update...
ec.taskdefs:
ec.common-init:
ec.projectized-common.basic-init:
ec.basic-init:
ec.files-init:
ec.nbm-license-init:
ec.build-init:
Scanning for modules in C:\Program Files\NetBeans 6.9.1\platform
Scanning for modules in suite W:\Files\PROJETS\NetBeansProjectsTest\CumAux
ec.init:
ec.up-to-date:
ec.compile:
ec.jar-prep:
ec.jar:
ec.netbeans-extra:
ec.module-xml-regular:
ec.module-xml-autoload:
ec.module-xml-eager:
ec.javahelp:
ec.module-auto-deps:
ec.release:
Copying 2 files to W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\cluster
ec.chmod-executables:
ec.verify-class-linkage:
Warning: commonj.sdo.impl.HelperProviderImpl cannot access commonj.sdo.helper.HelperContext
Warning: commonj.sdo.impl.HelperProviderImpl cannot access commonj.sdo.impl.ExternalizableDelegator
Warning: commonj.sdo.impl.HelperProviderImpl cannot access commonj.sdo.impl.ExternalizableDelegator$Resolvable
Warning: commonj.sdo.impl.HelperProviderImpl cannot access commonj.sdo.impl.HelperProvider
Warning: org.eclipse.persistence.eis.DOMRecord cannot access javax.resource.cci.Record
Warning: org.eclipse.persistence.eis.EISAccessor cannot access javax.resource.ResourceException
Warning: org.eclipse.persistence.eis.EISAccessor cannot access javax.resource.cci.Connection
Warning: org.eclipse.persistence.eis.EISAccessor cannot access javax.resource.cci.ConnectionMetaData
Warning: org.eclipse.persistence.eis.EISAccessor cannot access javax.resource.cci.Interaction
Warning: org.eclipse.persistence.eis.EISAccessor cannot access javax.resource.cci.InteractionSpec
(additional warnings not reported)
0 file(s) have been successfully validated.
ec.netbeans:
Generating information for Auto Update...
mysql.taskdefs:
mysql.common-init:
mysql.projectized-common.basic-init:
mysql.basic-init:
mysql.files-init:
mysql.nbm-license-init:
mysql.build-init:
Scanning for modules in C:\Program Files\NetBeans 6.9.1\platform
Scanning for modules in suite W:\Files\PROJETS\NetBeansProjectsTest\CumAux
mysql.init:
mysql.up-to-date:
mysql.compile:
mysql.jar-prep:
mysql.jar:
mysql.netbeans-extra:
mysql.module-xml-regular:
mysql.module-xml-autoload:
mysql.module-xml-eager:
mysql.javahelp:
mysql.module-auto-deps:
mysql.release:
Copying 1 file to W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\cluster
mysql.chmod-executables:
mysql.verify-class-linkage:
Warning: com.mysql.jdbc.integration.c3p0.MysqlConnectionTester cannot access com.mchange.v2.c3p0.C3P0ProxyConnection
Warning: com.mysql.jdbc.integration.c3p0.MysqlConnectionTester cannot access com.mchange.v2.c3p0.QueryConnectionTester
Warning: com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter cannot access org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
Warning: com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker cannot access org.jboss.resource.adapter.jdbc.ValidConnectionChecker
Warning: com.mysql.jdbc.log.CommonsLogger cannot access org.apache.commons.logging.Log
Warning: com.mysql.jdbc.log.CommonsLogger cannot access org.apache.commons.logging.LogFactory
Warning: com.mysql.jdbc.log.Log4JLogger cannot access org.apache.log4j.Level
Warning: com.mysql.jdbc.log.Log4JLogger cannot access org.apache.log4j.Logger
Warning: com.mysql.jdbc.log.Log4JLogger cannot access org.apache.log4j.Priority
0 file(s) have been successfully validated.
mysql.netbeans:
Generating information for Auto Update...
cumaux.ui.taskdefs:
cumaux.ui.common-init:
cumaux.ui.projectized-common.basic-init:
cumaux.ui.basic-init:
cumaux.ui.files-init:
cumaux.ui.nbm-license-init:
cumaux.ui.build-init:
Scanning for modules in C:\Program Files\NetBeans 6.9.1\platform
Scanning for modules in suite W:\Files\PROJETS\NetBeansProjectsTest\CumAux
Warning: cumaux.ui lacks a unit test dependency on org.netbeans.libs.junit4; using default dependencies for compatibility
cumaux.ui.init:
cumaux.ui.up-to-date:
cumaux.ui.compile:
cumaux.ui.jar-prep:
cumaux.ui.jar:
cumaux.ui.netbeans-extra:
cumaux.ui.module-xml-regular:
cumaux.ui.module-xml-autoload:
cumaux.ui.module-xml-eager:
cumaux.ui.javahelp:
cumaux.ui.module-auto-deps:
cumaux.ui.release:
cumaux.ui.chmod-executables:
cumaux.ui.verify-class-linkage:
1 file(s) have been successfully validated.
cumaux.ui.netbeans:
Generating information for Auto Update...
run:
run.run:
-------------------------------------------------------------------------------
>Log Session: Thursday, September 23, 2010 9:34:32 AM CEST
>System Info:
Product Version = CumAux 201007282301
Operating System = Windows XP version 5.1 running on x86
Java; VM; Vendor = 1.6.0_21; Java HotSpot(TM) Server VM 17.0-b17; Sun Microsystems Inc.
Runtime = Java(TM) SE Runtime Environment 1.6.0_21-b07
Java Home = C:\Program Files\Java\jdk1.6.0_21\jre
System Locale; Encoding = fr_LU (cumaux); Cp1252
Home Directory = C:\Documents and Settings\uhrand
Current Directory = W:\Files\PROJETS\NetBeansProjectsTest\CumAux
User Directory = W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\testuserdir
Installation = W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\cluster
C:\Program Files\NetBeans 6.9.1\platform
C:\Program Files\NetBeans 6.9.1\platform
Boot & Ext. Classpath = C:\Program Files\Java\jdk1.6.0_21\jre\lib\resources.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\rt.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\jce.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.6.0_21\jre\classes;C:\Program Files\Java\jdk1.6.0_21\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\ext\sunpkcs11.jar
Application Classpath = C:\Program Files\NetBeans 6.9.1\platform\lib\boot.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\org-openide-modules.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\org-openide-util-lookup.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\org-openide-util.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\boot_ja.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\boot_pt_BR.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\boot_zh_CN.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-modules_ja.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-modules_pt_BR.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-modules_zh_CN.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-util-lookup_ja.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-util-lookup_pt_BR.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-util-lookup_zh_CN.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-util_ja.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-util_pt_BR.jar;C:\Program Files\NetBeans 6.9.1\platform\lib\locale\org-openide-util_zh_CN.jar;C:\Program Files\Java\jdk1.6.0_21\lib\dt.jar;C:\Program Files\Java\jdk1.6.0_21\lib\tools.jar
Startup Classpath = C:\Program Files\NetBeans 6.9.1\platform\core\core.jar;C:\Program Files\NetBeans 6.9.1\platform\core\org-openide-filesystems.jar;C:\Program Files\NetBeans 6.9.1\platform\core\locale\core_ja.jar;C:\Program Files\NetBeans 6.9.1\platform\core\locale\core_pt_BR.jar;C:\Program Files\NetBeans 6.9.1\platform\core\locale\core_zh_CN.jar;C:\Program Files\NetBeans 6.9.1\platform\core\locale\org-openide-filesystems_ja.jar;C:\Program Files\NetBeans 6.9.1\platform\core\locale\org-openide-filesystems_pt_BR.jar;C:\Program Files\NetBeans 6.9.1\platform\core\locale\org-openide-filesystems_zh_CN.jar;W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\cluster\core\locale\core_cumaux.jar
-------------------------------------------------------------------------------
INFO [org.netbeans.core.startup.NbEvents]: Turning on modules:
org.openide.util.lookup [8.3.1 201007282301]
org.openide.util [8.6.1 201007282301]
org.openide.modules [7.17.1 201007282301]
org.openide.awt [7.23.1 201007282301]
org.netbeans.api.progress/1 [1.20.2 201007282301]
org.openide.dialogs [7.15.1 201007282301]
org.openide.nodes [7.16.1 201007282301]
org.openide.windows [6.33.1 201007282301]
org.netbeans.swing.tabcontrol [1.21.1 201007282301]
org.netbeans.swing.outline [1.9.1 201007282301]
org.openide.explorer [6.28.2 201007282301]
org.openide.filesystems [7.38.2 201007282301]
org.netbeans.modules.editor.mimelookup/1 [1.16.1 201007282301]
org.openide.text [6.30.1 201007282301]
org.openide.actions [6.16.1 201007282301]
org.netbeans.bootstrap/1 [2.33.1 201007282301]
org.netbeans.core.startup/1 [1.25.1 201007282301]
org.netbeans.modules.keyring [1.1.2 201007282301]
org.netbeans.modules.queries/1 [1.19.1 201007282301]
org.openide.loaders [7.16.1 201007282301]
org.openide.io [1.23.1 201007282301]
org.netbeans.swing.plaf [1.16.1 201007282301]
org.netbeans.core/2 [3.20.2 201007282301]
ec [1.0 100923]
cumaux4 [1.0 100923]
org.netbeans.spi.quicksearch [1.6.1 201007282301]
org.netbeans.modules.options.api/1 [1.18.1 201007282301]
org.netbeans.modules.settings/1 [1.26.1 201007282301]
org.netbeans.core.windows/2 [2.21.1 201007282301]
mysql [1.0 100923]
cumaux.ui [1.0 100923]
org.netbeans.modules.print [7.5.1 201007282301]
org.netbeans.libs.jna/1 [1.7.2 201007282301]
org.netbeans.core.nativeaccess/1 [1.7.1 201007282301]
org.netbeans.libs.osgi [1.1.1 201007282301]
org.netbeans.libs.felix [1.1.1 201007282301]
org.netbeans.modules.keyring.impl [1.0.1 201007282301]
org.netbeans.core.io.ui/1 [1.8.1 201007282301]
org.netbeans.modules.masterfs/2 [2.25.2 201007282301]
org.netbeans.core.netigso [1.4.2 201007282301]
org.netbeans.modules.progress.ui [1.12.1 201007282301]
org.netbeans.modules.editor.mimelookup.impl/1 [1.9.1 201007282301]
org.netbeans.modules.options.keymap [1.10.1 201007282301]
org.netbeans.core.output2/1 [1.18.2 201007282301]
org.netbeans.core.ui/1 [1.22.1 201007282301]
[EL Info]: 2010-09-23 09:34:39.11--ServerSession(19719540)--EclipseLink, version: Eclipse Persistence Services - 2.0.2.v20100323-r6872
[EL Info]: 2010-09-23 09:34:40.032--ServerSession(19719540)--file:/W:/Files/PROJETS/NetBeansProjectsTest/CumAux/build/cluster/modules/ext/CumAuxLibrary.jar_CumAuxLibraryPU login successful
WARNING [org.netbeans.core.TimableEventQueue]: too much time in AWT thread null
Diagnostic information
Input arguments:
-Dnetbeans.logger.console=true
-ea
-Djdk.home=C:\Program
Files\Java\jdk1.6.0_21
-Dnetbeans.home=C:\Program
Files\NetBeans
6.9.1\platform
-Dnetbeans.user=W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\testuserdir
-XX:+HeapDumpOnOutOfMemoryError
-XX:HeapDumpPath=W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\testuserdir\var\log\heapdump.hprof
-Dnetbeans.system_http_proxy=DIRECT
-Dsun.awt.keepWorkingSetOnMinimize=true
-Dnetbeans.dirs=W:\Files\PROJETS\NetBeansProjectsTest\CumAux\build\cluster;C:\Program
Files\NetBeans
6.9.1\platform
Compiler: HotSpot Tiered Compilers
Heap memory usage: initial 47,4MB maximum 673,8MB
Non heap memory usage: initial 18,2MB maximum 112,0MB
Garbage collector: PS Scavenge (Collections=6 Total time spent=0s)
Garbage collector: PS MarkSweep (Collections=0 Total time spent=0s)
Classes: loaded=4690 total loaded=4690 unloaded 0
INFO [org.netbeans.core.ui.warmup.DiagnosticTask]: Total memory 2 147 483 647
INFO [null]: Total physical memory 2 147 483 647
WARNING [org.openide.filesystems.Ordering]: Not all children in Menu/Window/ marked with the position attribute: [EcrgenAction.shadow], but some are: [org-netbeans-core-windows-actions-GlobalPropertiesAction.shadow, Output, SwitchToRecentDocumentAction.shadow, ProgressListAction.shadow, Separator3.instance, CloseWindowAction.shadow, MaximizeWindowAction.shadow, org-netbeans-core-windows-actions-UndockAction.shadow, Separator4.instance, CloneDocumentAction.shadow, CloseAllDocumentsAction.shadow, CloseAllButThisAction.shadow, DocumentsAction.shadow, Separator5.instance, org-netbeans-core-windows-actions-ResetWindowsAction.shadow]
BUILD SUCCESSFUL (total time: 36 seconds)

Andre Uhres

Joined: 19 Oct 2008
Posts: 3

Posted: Thu Sep 23, 2010 9:32 am Post subject:

I think I did not understand correctly the @Id annotations. I tried the following and it works! Since I am new to this, I would be pleased to get some explantions on this: @Id @Basic(optional = false) @Column(name = "CDSTE") private String cdste; @Id @Basic(optional = false) @Column(name = "CDETB") private String cdetb; @Id @Basic(optional = false) @Column(name = "CDJNA") private String cdjna; @Id @Basic(optional = false) @Column(name = "NOPIE") private Integer nopie; @Id @Basic(optional = false) @Column(name = "NOLIN")

Charles Bedon
Posted via mailing list.

Posted: Fri Sep 24, 2010 2:09 pm Post subject: [platform-dev] Re: MySql query returns wrong result list: the first row is repeated

Hello

This is the wrong place for your question, you should ask this in your persistence provider's mailing list, however, the Id annotation is used to mark a field as primary key, so it's not clear to me what are you trying to do, but maybe you'd like to check this:

http://www.coderanch.com/t/217911/ORM/java/JPA-mark-two-fields-Id

2010/9/23 Andre Uhres <address-removed ([email]address-removed[/email])>

Quote:

I think I did not understand correctly the @Id annotations. I tried the following and it works!
Since I am new to this, I would be pleased to get some explantions on this:

Javier.Ortiz
Posted via mailing list.

Posted: Fri Sep 24, 2010 5:56 pm Post subject: [platform-dev] Re: MySql query returns wrong result list: the first row is repeated

Did you try the equivalent query in MySQL first? Usually I make sure I have a query working as I want and then translate to JPA due to the lack of JPQL query support within the IDE. Code looks fine but is hard to tell without the actual table contents. Looks more like a query issue. Javier A. Ortiz Bultr

Andre Uhres

Joined: 19 Oct 2008
Posts: 3

Posted: Mon Sep 27, 2010 7:48 am Post subject:

Hello Charles, sorry for having put my question in the wrong place. When I started this thread, I didn't know that the problem was at persistence level. Your link to coderanch was helpful. I think it's clear for me now. I converted my compound primary key to an "EmbeddedId" which seems to be more elegant, and it works well. Thanks for your help. Cheers, André

Display posts from previous:

	NetBeans Forums -> NetBeans Platform Users	All times are GMT
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum