Regarding mapping and code

sunkk · **Joined:** Thu May 15, 2008 11:58 am **Posts:** 2

Hi to all,

I am new to hibernate and myelcipse and could u pls let me know how to map two tables in Eclipse and how to retrieve data using hibernate .

As I mapped two tables using one2many relationship but I want the code how to retrieve the data using sql r hql query.

I am using myeclipse 6.0 using that only can u pls suggest me .

pls help me if u know the solution.

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

[quote][/quote]

Cameron McKenzie · **Posted:** Thu May 15, 2008 1:39 pm

Here's a neat little tutorial to show you how to work with one to many relationships:

http://www.hiberbook.com/HiberBookWeb/learn.jsp?tutorial=18mappingonetomanyassociations

This example uses the simple, A Team Has Many Players idea. The annotations are straight forward:

Code:

 
@OneToMany(mappedBy="team",  
              targetEntity=Player.class, 
    fetch=FetchType.EAGER, cascade = CascadeType.ALL)
 public List<Player> getPlayers() {return players;}

Code:

@ManyToOne
 @JoinColumn(name="team_id")      
 public Team getTeam() {return team;}

Here's the code of how to create and save instances of Team and Player. Here I use setters, but getting the information would be as simple as doing a find or get with the primary key, and then calling the getter methods:

Code:

    HibernateUtil.recreateDatabase();
    Session session=HibernateUtil.beginTransaction();

    Team team = new Team();
    Player p1 = new Player();
    Player p2 = new Player();

    session.save(team);
    session.save(p1);
    session.save(p2);

    team.setName("Pickering Atoms");
    p1.setNickName("Lefty");
    p1.setTeam(team);
    p2.setNickName("Blinky");
    p2.setTeam(team);
    HibernateUtil.commitTransaction();

Check out my signature links for more Hibernate examples and JPA tutorials.