EclipseLink JPA - ManyToMany Selects @ tutorials.de: Tutorials, Forum & Hilfe

Andyx1975 · 22.12.11 15:07

Hallo,

ich habe gerade angefangen mich mit JPA auseinander zu setzen. Ich habe mir 2 Entity Klassen gebaut und diese über ManyToMany miteinander verbunden. Funktioniert auch soweit.

DEmail

Code java:

package com.uds.webadmin.data;
 
import static javax.persistence.TemporalType.TIMESTAMP;
 
import java.io.Serializable;
import java.util.Date;
import java.util.List;
 
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.NamedQuery;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.xml.bind.annotation.XmlRootElement;
 
/**
 * Entity implementation class for Entity: DEmail
 */
@Entity
@XmlRootElement
@Table( name = "email_sended" )
@NamedQuery( name = "findEmails", query = "SELECT e FROM DEmail e ORDER BY e.creation_date DESC" )
public class DEmail
    implements Serializable
{
 
    @Id
    @GeneratedValue( strategy = GenerationType.AUTO )
    @SequenceGenerator( name = "email_sended_id_seq", sequenceName = "email_sended_id_seq", allocationSize = 1 )
    @Column( columnDefinition = "SERIAL" )
    private long email_id;
 
    @Column( columnDefinition = "TEXT" )
    private String to_recipients;
 
    @Column( columnDefinition = "TEXT" )
    private String cc_recipients;
 
    @Column( columnDefinition = "TEXT" )
    private String bcc_recipients;
 
    @Column
    private String headline;
 
    @Column( columnDefinition = "TEXT" )
    private String email_text;
 
    @Column
    private int email_type;
 
    @Column
    private Boolean self_copy;
 
    @Column
    private String creator;
 
    @Column
    @Temporal( TIMESTAMP )
    private Date creation_date;
 
    @ManyToMany
    @JoinTable( name = "assignments_emails_uploads", joinColumns = @JoinColumn( name = "email_id", referencedColumnName = "email_id" ), inverseJoinColumns = @JoinColumn( name = "upload_id", referencedColumnName = "upload_id" ) )
    private List<DUpload> uploads;
 
    private static final long serialVersionUID = 1L;
 
    public DEmail()
    {
        super();
    }
 
    public long getEmail_id()
    {
        return email_id;
    }
 
    public void setEmail_id( long email_id )
    {
        this.email_id = email_id;
    }
 
    public String getTo_recipients()
    {
        return to_recipients;
    }
 
    public void setTo_recipients( String to_recipients )
    {
        if ( to_recipients.trim().equals( "null" ) )
        {
            to_recipients = null;
        }
 
        this.to_recipients = to_recipients;
    }
 
    public String getCc_recipients()
    {
        return cc_recipients;
    }
 
    public void setCc_recipients( String cc_recipients )
    {
        if ( cc_recipients.trim().equals( "null" ) )
        {
            cc_recipients = null;
        }
 
        this.cc_recipients = cc_recipients;
 
    }
 
    public String getBcc_recipients()
    {
        return bcc_recipients;
    }
 
    public void setBcc_recipients( String bcc_recipients )
    {
        if ( bcc_recipients.trim().equals( "null" ) )
        {
            bcc_recipients = null;
        }
        this.bcc_recipients = bcc_recipients;
    }
 
    public String getHeadline()
    {
        return headline;
    }
 
    public void setHeadline( String headline )
    {
        if ( headline.trim().equals( "null" ) )
        {
            headline = null;
        }
        this.headline = headline;
    }
 
    public String getEmail_text()
    {
        return email_text;
    }
 
    public void setEmail_text( String email_text )
    {
        if ( email_text.trim().equals( "null" ) )
        {
            email_text = null;
        }
        this.email_text = email_text;
    }
 
    public int getEmail_type()
    {
        return email_type;
    }
 
    public void setEmail_type( int email_type )
    {
        this.email_type = email_type;
    }
 
    public Boolean getSelf_copy()
    {
        return self_copy;
    }
 
    public void setSelf_copy( Boolean self_copy )
    {
        this.self_copy = self_copy;
    }
 
    public String getCreator()
    {
        return creator;
    }
 
    public void setCreator( String creator )
    {
        this.creator = creator;
    }
 
    public Date getCreation_date()
    {
        return creation_date;
    }
 
    public void setCreation_date( Date creation_date )
    {
        this.creation_date = creation_date;
    }
 
    public List<DUpload> getUploads()
    {
        return uploads;
    }
 
    public void setUploads( List<DUpload> uploads )
    {
        this.uploads = uploads;
    }
 
    public static long getSerialversionuid()
    {
        return serialVersionUID;
    }
 
    public void addUpload( DUpload upload )
    {
        if ( !getUploads().contains( upload ) == false)
        {
            getUploads().add( upload );
        }
        if ( upload.getEmails().contains( this ) == false)
        {
            upload.getEmails().add( this );
        }
    }
    
    public void removeUpload( DUpload upload )
    {
        if ( getUploads().contains( upload ) == true)
        {
            getUploads().remove( upload );
        }
        if ( upload.getEmails().contains( this ) == true)
        {
            upload.getEmails().remove( this );
        }
    }
 
}

DUploads

Code java:

package com.uds.webadmin.data;
 
import java.io.Serializable;
import java.lang.String;
import java.util.Date;
import java.util.List;
 
import javax.persistence.*;
 
import static javax.persistence.TemporalType.TIMESTAMP;
import javax.xml.bind.annotation.XmlRootElement;
 
/**
 * Entity implementation class for Entity: email_uploads
 */
@Entity
@Table( name = "email_uploads" )
@XmlRootElement
@NamedQuery( name = "findUploads", query = "SELECT e FROM DUpload e ORDER BY e.creation_date DESC" )
public class DUpload
    implements Serializable
{
 
    @Id
    @GeneratedValue( strategy = GenerationType.AUTO )
    @SequenceGenerator( name = "email_uploads_id_seq", sequenceName = "email_uploads_id_seq", allocationSize = 1 )
    @Column( columnDefinition = "SERIAL" )
    private long upload_id;
 
    @Column
    private String upload_name;
 
    @Column
    private int upload_type;
 
    @Column
    private String creator;
 
    @Column
    private String upload_link;
 
    @Column
    private Boolean status;
 
    @Column
    @Temporal( TIMESTAMP )
    private Date creation_date;
 
    @Column
    private String editor;
 
    @Column
    @Temporal( TIMESTAMP )
    private Date edit_date;
 
    @ManyToMany( mappedBy = "uploads" )
    private List<DEmail> emails;
 
    private static final long serialVersionUID = 1L;
 
    public DUpload()
    {
 
    }
 
    public DUpload( long upload_id, String upload_name, int upload_type, String creator, String upload_link,
                     Boolean status, Date creation_date, String editor, Date edit_date )
    {
        this.upload_id = upload_id;
        this.upload_name = upload_name;
        this.upload_type = upload_type;
        this.creator = creator;
        this.upload_link = upload_link;
        this.status = status;
        this.creation_date = creation_date;
        this.editor = editor;
        this.edit_date = edit_date;
    }
 
    public long getUpload_id()
    {
        return upload_id;
    }
 
    public void setUpload_id( long upload_id )
    {
        this.upload_id = upload_id;
    }
 
    public String getUpload_name()
    {
        return upload_name;
    }
 
    public void setUpload_name( String upload_name )
    {
        this.upload_name = upload_name;
    }
 
    public int getUpload_type()
    {
        return upload_type;
    }
 
    public void setUpload_type( int upload_type )
    {
        this.upload_type = upload_type;
    }
 
    public String getCreator()
    {
        return creator;
    }
 
    public void setCreator( String creator )
    {
        this.creator = creator;
    }
 
    public String getUpload_link()
    {
        return upload_link;
    }
 
    public void setUpload_link( String upload_link )
    {
        this.upload_link = upload_link;
    }
 
    public Boolean getStatus()
    {
        return status;
    }
 
    public void setStatus( Boolean status )
    {
        this.status = status;
    }
 
    public Date getCreation_date()
    {
        return creation_date;
    }
 
    public void setCreation_date( Date creation_date )
    {
        this.creation_date = creation_date;
    }
 
    public String getEditor()
    {
        return editor;
    }
 
    public void setEditor( String editor )
    {
        this.editor = editor;
    }
 
    public Date getEdit_date()
    {
        return edit_date;
    }
 
    public void setEdit_date( Date edit_date )
    {
        this.edit_date = edit_date;
    }
 
    public static long getSerialversionuid()
    {
        return serialVersionUID;
    }
 
    public List<DEmail> getEmails()
    {
        return emails;
    }
 
    public void setEmails( List<DEmail> emails )
    {
        this.emails = emails;
    }
    
}

Wenn ich jetzt aber den Select "SELECT e FROM DEmail e ORDER BY e.creation_date DESC" abfuere werden die zugewiesenen Uploads aus der "List<DUpload> uploads" nicht mit aufgeführt. Mein Ergbnis sieht wie folgt aus, also ohne die Uploads:

Code xml:

<dEmails>
    <dEmail>
        <creation_date>2011-12-22T14:44:25.045+01:00</creation_date>
        <creator>Andy</creator>
        <email_id>151</email_id>
        <email_text>test test</email_text>
        <email_type>1</email_type>
        <headline>testAW</headline>
        <self_copy>false</self_copy>
        <to_recipients>test@web.de</to_recipients>
    </dEmail>
</dEmails>

ich möchte aber haben, dass die zugewiesenen Uploads auch aufgelistet werden. Sollte also wie folgt ausehen:

Code xml:

<dEmails>
    <dEmail>
        <creation_date>2011-12-22T14:44:25.045+01:00</creation_date>
        <creator>Andy</creator>
        <email_id>151</email_id>
        <email_text>test test</email_text>
        <email_type>1</email_type>
        <headline>testAW</headline>
        <self_copy>false</self_copy>
        <to_recipients>test@web.de</to_recipients>
        <dUploads>
            <dUpload>
                <creation_date>2011-12-22T14:41:28.613+01:00</creation_date>
                <creator>Andy</creator>
                <edit_date>2011-12-22T14:41:28.613+01:00</edit_date>
                <editor>Andy</editor>
                <status>true</status>
                <upload_id>1</upload_id>
                <upload_link>2011_12_22_14_41_28_test.java</upload_link>
                <upload_name>test</upload_name>
                <upload_type>1</upload_type>
            </dUpload>
            <dUpload>
                <creation_date>2011-12-22T14:41:28.613+01:00</creation_date>
                <creator>Andy</creator>
                <edit_date>2011-12-22T14:41:28.613+01:00</edit_date>
                <editor>Andy</editor>
                <status>true</status>
                <upload_id>2</upload_id>
                <upload_link>2011_12_22_14_41_28_test2.java</upload_link>
                <upload_name>test2</upload_name>
                <upload_type>1</upload_type>
            </dUpload>
        </dUploads>
    </dEmail>
</dEmails>

Wie bekome ich das hin? Sorry ist vielleicht recht einfach zu lösen, bin aber recht neu in dem Thema JPA.

Danke
Andy

Andyx1975 · 09.01.12 11:12

kann keiner weiter helfen? Danke******

sebastianb · 17.01.12 15:45

Hi,

vll hilft ja folgendes:

Code java:

1	@ManyToMany(mappedBy = "uploads", fetch=FetchType.EAGER)

Gruß Sebastian

tut orials.de	tut verbinden	tut dir helfen	tut kooperieren
©2000-2012 tutorials.de Alle Rechte vorbehalten	tut informieren » Impressum » Nutzungsregeln » Netiquette » Team » Redaktion	» Tutorials » Videotutorials » Showroom » Events & Contests » Chat » RSS-Feed » Blogs	» der-webdesigner.net » DesignerInAction » Design Nation » Directorforum » Flashhilfe » PHP-Resource » PHPwelt » PSD-Tutorials

Themen-Optionen

Anzeige

Ähnliche Themen

JPA EclipseLink HashMap persistieren

EclipseLink Mapping und Polymorphie

Hibernate 3 Tabellen in manytomany

Problem mit Hibernate ManyToMany Mapping

@ManyToMany mit sich selbst

E-Mail:

Abonnieren Abbestellen