Hibernate ORM: Mapping issue

I

im_berzki2011-06-19 12:13:36

Java

im_berzki, 2011-06-19 12:13:36

Good day!

For several weeks, I have been unsuccessfully trying to solve the problem with hibernate ((I

re-read a bunch of documentation, googled everything I could ...

Tell me, please, what is the mistake? What am I doing wrong?

DB schema:

Mapping:
(to generate getters/setters I use the lombok library)

User.java

Copy Source | Copy HTML @Entity @Table(name = "users") public @Data class User { // Base Mapping @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "user_id") @Getter @Setter Long user_id; @Column(name = "user_name") private @Getter @Setter String user_name; @Column(name = "login") private @Getter @Setter String login; @Column(name = "password") private @Getter @Setter String password; // Releations Mapping // Releations With Project @ManyToMany(cascade={CascadeType.ALL}) @JoinTable(name="users_on_projects", [email protected](name="user_id"), [email protected](name="project_id") ) private @Getter @Setter List projects = new Vector(); @OneToMany @JoinTable(name="users_on_projects", [email protected](name="user_id"), [email protected](name="users_on_projects_id") ) private @Getter @Setter List intervals = new Vector(); } Project.java Copy Source | Copy HTML @Entity @Table(name = "projects") public @Data class Project { // Base Mapping @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name ="project_id") private @Getter @Setter Long project_id; @Column(name ="project_name") private @Getter @Setter String project_name; // Releations Mapping // Releations With User @ManyToMany(cascade={CascadeType.ALL}) @JoinTable(name="users_on_projects", [email protected](name="project_id"), [email protected](name="user_id") ) private @Getter @Setter List users = new Vector(); @OneToMany @JoinTable(name="users_on_projects", [email protected](name="project_id"), [email protected](name="users_on_projects_id") ) private @Getter @Setter List intervals = new Vector(); Interval.java Copy Source | Copy HTML @Entity @Table(name = "intervals") public class Interval { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "interval_id") @Getter @Setter Long interval_id; @Column(name ="start_time") private @Setter @Getter @Temporal(javax.persistence.TemporalType.TIMESTAMP) Date start_time; @Column(name ="finish_time") private @Setter @Getter @Temporal(javax.persistence.TemporalType.TIMESTAMP) Date FinishTime; @ManyToOne(cascade={CascadeType.ALL}) @JoinTable(name="users_on_projects", [email protected](name="users_on_projects_id"), [email protected](name="user_id") ) private @Getter @Setter User user; @JoinTable(name="users_on_projects", [email protected](name="users_on_projects_id"), [email protected](name="project_id") ) private @Getter @Setter @ManyToOne Project project; @ManyToOne(cascade = CascadeType.ALL) @JoinColumn(name="interval_type_id") private @Getter @Setter IntervalType intervalType; } IntervalType.java Copy Source | Copy HTML @Entity @Table(name = "interval_type") public class IntervalType { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "interval_type_id") @Getter @Setter Long interval_type_id; @Column(name = "interval_type_name") private @Getter @Setter String interval_type_name; } Заранее благодарен! UPD: На чтение все заработало. Но, осталась проблема с записью интервалов (intervals).. Подскажите, что не так ?.. Корректный маппинг файла User.java : Copy Source | Copy HTML @Entity @Table(name = "users") public @Data class User { // Base Mapping @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "user_id") @Getter @Setter Long user_id; @Column(name = "user_name") private @Getter @Setter String user_name; @Column(name = "login") private @Getter @Setter String login; @Column(name = "password") private @Getter @Setter String password; // Releations Mapping // Releations With Project @ManyToMany(cascade={CascadeType.ALL}) @JoinTable(name="users_on_projects", [email protected](name="user_id"), [email protected](name="project_id") ) private @Getter @Setter List projects = new Vector(); < @OneToMany @JoinTable(name="intervals", [email protected](name="users_on_projects_id"), [email protected](name="interval_id") ) private @Getter @Setter List intervals = new Vector(); }

Reply

Answer the question

In order to leave comments, you need to log in

6 answer(s)

A

Alexey Pomogaev, 2011-06-21
@Foror

I can recommend to you to simplify communications by adding classes. For example, in your case, make the UserOnProject class and I think the problem will be resolved immediately. And later, perhaps this class will also come in handy for new attributes.

A

Alexey Pomogaev, 2011-06-21
@Foror

And in general, hibernate eats a lot of memory. Very dofiga, compared to the same solutions on django, for example, just orders of magnitude. Over time, I think about using something from NoSQL, the same MongoDB, to see what happens ...

A

asm0dey, 2011-06-22
@asm0dey

Sorry for the crooked suggestion, but you can do this:
Install Spring Roo, configure it for our database, then say database reverse engineer
Or NetBins can also generate database mappings.

A

asm0dey, 2011-06-22
@asm0dey

As an option, send me a database schema, I'll generate it myself.

I

Igor Petrov, 2011-06-19
@KriegeR

I'm sorry if I'm wrong (I haven't dealt with Gibernate for a very long time), but shouldn't mapping classes have a default constructor?

I

im_berzki, 2011-06-19
@im_berzki

Problem solved, thank you all for your help!
Correct description of the relationship I was thinking, maybe write an article about mapping complex relationships? And about mapping on annotations / a simple example? (like there isn't one) Users--->Intervals
@OneToMany @JoinTable(name="intervals", [email protected](name="users_on_projects_id"), [email protected](name="interval_id") ) private @Getter @Setter List intervals = new Vector();