Databases
StackOverflow2013
Postsdbo
POSpring MVC and Hibernate: How to print out left joined fields?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSpring MVC and Hibernate: How to print out left joined fields?
    primarykey
    data
    text
    <p>I'm new to Spring (MVC) and Hibernate... I got the following problem:</p> <p>I'm developing a RSS App which in short parse a RSS feed, store the fields in a database and displays the RSS info on a web page.</p> <p>Some RSS feeds got an image. I have no problem parse and store it, but I got a problem displaying it together with the RSS info. The RSS info is stored in one table (fields: id, title, description, url, link, language, date) while the RSS image info is stored in another one (fields: id, title, description, url, height, width, rss_id). There should be a one-to-one relation. </p> <p>My Hibernate query for retriving all the RSS look like this and is working:</p> <pre><code>public List&lt;RSS&gt; getAllRSS() { return getHibernateTemplate().find("from RSS as rss left join fetch rss.rssImage as image"); } </code></pre> <p>For printing out the RSS info I use the following code:</p> <pre><code>RSSService rssService = (RSSService) ctx.getBean("rssService"); RSS rss = new RSS(); List list = rssService.listAllRSS(); Iterator i = list.iterator(); while(i.hasNext()){ rss = (RSS) i.next(); System.out.println("rss title:" + rss.getTitle()); } </code></pre> <p>And this is working. But how can I retrive the fields from the image?</p> <p>RSS class:</p> <pre><code>public class RSS { private Integer id; private String title; private Date dateCreated; private String description; private String link; private String url; private String language; private String rating; private Date dateModified; private Set rssItems; private Set rssImage; /** * @return the id */ public Integer getId() { return id; } /** * @param id the id to set */ public void setId(Integer id) { this.id = id; } public Date getDateCreated() { return dateCreated; } public void setDateCreated(Date dateCreated) { this.dateCreated = dateCreated; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } public Date getDateModified() { return dateModified; } public void setDateModified(Date dateModified) { this.dateModified = dateModified; } public String getDescription() { return description; } public void setDescription(String description) { this.description = description; } public String getLanguage() { return language; } public void setLanguage(String language) { this.language = language; } public String getLink() { return link; } public void setLink(String link) { this.link = link; } public String getRating() { return rating; } public void setRating(String rating) { this.rating = rating; } public String getUrl() { return url; } public void setUrl(String url) { this.url = url; } /** * @return the rssItems */ public Set getRssItems() { return rssItems; } /** * @param rssItems the rssItems to set */ public void setRssItems(Set rssItems) { this.rssItems = rssItems; } /** * @return the rssImage */ public Set getRssImage() { return rssImage; } /** * @param rssImage the rssImage to set */ public void setRssImage(Set rssImage) { this.rssImage = rssImage; } } </code></pre> <p>RSS Image class:</p> <pre><code>public class RSSImage { private Integer id; private String title; private String url; private String description; private String width; private String height; private Date dateCreated; private Date dateModified; private RSS rss; /** * @return the id */ public Integer getId() { return id; } /** * @param id the id to set */ public void setId(Integer id) { this.id = id; } /** * @return the title */ public String getTitle() { return title; } /** * @param title the title to set */ public void setTitle(String title) { this.title = title; } /** * @return the url */ public String getUrl() { return url; } /** * @param url the url to set */ public void setUrl(String url) { this.url = url; } /** * @return the description */ public String getDescription() { return description; } /** * @param description the description to set */ public void setDescription(String description) { this.description = description; } /** * @return the width */ public String getWidth() { return width; } /** * @param width the width to set */ public void setWidth(String width) { this.width = width; } /** * @return the height */ public String getHeight() { return height; } /** * @param height the height to set */ public void setHeight(String height) { this.height = height; } /** * @return the dateCreated */ public Date getDateCreated() { return dateCreated; } /** * @param dateCreated the dateCreated to set */ public void setDateCreated(Date dateCreated) { this.dateCreated = dateCreated; } /** * @return the dateModified */ public Date getDateModified() { return dateModified; } /** * @param dateModified the dateModified to set */ public void setDateModified(Date dateModified) { this.dateModified = dateModified; } /** * @return the rss */ public RSS getRss() { return rss; } /** * @param rss the rss to set */ public void setRss(RSS rss) { this.rss = rss; } } </code></pre> <p>Thanks :)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USjorgen
    1. USjorgen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSpring MVC and Hibernate: How to print out left joined fields?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSpring MVC and Hibernate: How to print out left joined fields?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSpring MVC and Hibernate: How to print out left joined fields?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat does your Hibernate mapping file look like? Given an RSS object called rss, you just need to configure it right for the fields in the other table to show up as rss.image.url etc.
      singulars
      1. POSpring MVC and Hibernate: How to print out left joined fields?
      1. USgatkin
    2. COYes, that's exactly what I need!
      singulars
      1. POSpring MVC and Hibernate: How to print out left joined fields?
      1. USjorgen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload