Hello:
JayeshJ, I did follow your suggestion, although the "..composite-id, Id to a seperate class..", I don't know how is it. I just was following a example from hibernate in Action, where it use one inner class.
Again, I did make
Alumno - one-to-many ---> RamoAlumno<---- many-to-one - Ramo
but more simple.
RamoAlumno.hbm
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="encuestas">
<class name="RamoAlumno" table="RAMO_ALUMNO" mutable="false">
<composite-id name="id"
class="RamoAlumno$Id"
access="field">
<key-property name="alumnoId"
access="field"
column="ALUMNO_ID"/>
<key-property name="ramoId"
access="field"
column="RAMO_ID"/>
</composite-id>
<!--
-->
<version name="version"
column="VERSION"
access="org.hibernate.property.DirectPropertyAccessor"/>
<property name="dateAdded"
column="ADDED_ON"
type="timestamp"
not-null="true"
access="field"/>
<property name="semestre"
type="string"
not-null="true"
update="false"
access="field">
<column name="SEMESTRE"/>
</property>
<many-to-one
name="alumno"
column="ALUMNO_ID"
not-null="true"
access="field"
insert="false"
update="false"
/>
<many-to-one
name="ramo"
column="RAMO_ID"
not-null="true"
access="field"
insert="false"
update="false"/>
</class>
</hibernate-mapping>
Alumno.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="encuestas.Alumno"
table="ALUMNO"
lazy="true"
abstract="true">
<id name="id"
type="long"
column="ALUMNO_ID"
access="field">
<generator class="native"/>
</id>
<property name="rut"
type="long"
not-null="true">
<column name="RUT"/>
</property>
<property name="password"
type="string"
not-null="true">
<column name="PASSW"/>
</property>
<set name="ramosAlumno"
lazy="true"
inverse="true"
cascade="all, delete-orphan"
fetch="subselect"
access="field">
<key foreign-key="FK1_RAMO_ALUMNO_ID">
<column name="alumnoID" not-null="true"/>
</key>
<one-to-many class="encuestas.RamoAlumno"/>
</set>
</class>
</hibernate-mapping>
Ramo.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="encuestas.Ramo" table="RAMO" lazy="true">
<id name="id"
type="long"
column="RAMO_ID"
unsaved-value="null"
access="field">
<!-- <meta attribute="finder-method">findByID</meta> -->
<generator class="native"/>
</id>
<version name="version"
column="VERSION"
access="org.hibernate.property.DirectPropertyAccessor"/>
<property name="nombre"
type="string"
not-null="true"
access="field">
<column name="NOMBRE"/>
</property>
<set name="ramosAlumno"
lazy="true"
inverse="true"
cascade="all, delete-orphan"
access="field">
<key foreign-key="FK2_RAMO_ALUMNO_ID">
<column name="ramoID" not-null="true"/>
</key>
<one-to-many class="encuestas.RamoAlumno"/>
</set>
</class>
</hibernate-mapping>
RamoAlumno.java
public class RamoAlumno implements Serializable {
public static class Id implements Serializable {
private Long alumnoId;
private Long ramoId;
public Id() {}
public Id(Long alumnoId, Long ramoId) {
this.alumnoId = alumnoId;
this.ramoId = ramoId;
}
public boolean equals(Object o) {
if (o instanceof Id) {
Id that = (Id)o;
return this.alumnoId.equals(that.alumnoId) &&
this.ramoId.equals(that.ramoId);
} else {
return false;
}
}
public int hashCode() {
return alumnoId.hashCode() + ramoId.hashCode();
}
}
private Id id = new Id();
//private Date fechaTomado = new Date();
private int version = 0;
private Date dateAdded = new Date();
private String semestre;
private Ramo ramo;
private Alumno alumno;
public RamoAlumno() {};
public RamoAlumno(String semestre, Alumno alumno, Ramo ramo ) {
this.semestre = semestre;
this.alumno = alumno;
this.ramo = ramo;
// Set identifier values
this.id.alumnoId = alumno.getId();
this.id.ramoId = ramo.getId();
// Guarantee referential integrity
alumno.getRamosAlumno().add(this);
ramo.getRamosAlumno().add(this);
}
public Id getId() { return id; }
//public Date getFechaTomado() { return fechaTomado; }
public int getVersion(){
return version;
}
public Date getDateAdded() { return dateAdded; }
public String getSemestre(){
return semestre;
}
public void setSemestre(String sem){
this.semestre = sem;
}
public Alumno getAlumno() { return alumno; }
public Ramo getRamo() { return ramo; }
// ********************** Common Methods ********************** //
public int compareTo(Object o) {
// CategorizedItems are sorted by date
if (o instanceof RamoAlumno)
return getDateAdded().compareTo( ((RamoAlumno)o).getDateAdded() );
return 0;
}
public String toString() {
return "Added by: '" + getAlumno() + "', " +
"On Date: '" + getDateAdded();
}
public boolean equals(Object o) {
String cadena = null;
if (this == o) return true;
if (!(o instanceof RamoAlumno)) return false;
final RamoAlumno r = (RamoAlumno) o;
cadena = String.valueOf(getId().alumnoId) + String.valueOf(getId().ramoId);
if (cadena != null ? !cadena.equals(String.valueOf(r.getId().alumnoId)+String.valueOf(r.getId().ramoId)) : (String.valueOf(r.getId().alumnoId)+String.valueOf(r.getId().ramoId)) != null) return false;
return true;
}
public int hashCode() {
int result;
result = ((String.valueOf(getId().alumnoId) + String.valueOf(getId().ramoId)) != null ? (String.valueOf(getId().alumnoId) + String.valueOf(getId().ramoId)).hashCode() : 0);
return result;
}
}
Alumno.java
public class Alumno implements Serializable {
private Long id;
private Long rut;
private String password;
private Set ramosAlumno = new HashSet();
public Alumno() {}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Long getRut() {
return rut;
}
public void setRut(Long rut) {
this.rut = rut;
}
public String getPassword() {
return password;
}
public void setPassword(String pass) {
this.password = pass;
}
public Set getRamosAlumno(){
return ramosAlumno;
}
public void setRamo_alumno(Set ramo_al){
this.ramosAlumno = ramo_al;
}
public void addRamoAlumno(RamoAlumno ramAl) {
if (ramAl == null)
throw new IllegalArgumentException("No se puede agregar un null RamoAlumno.");
this.getRamosAlumno().add(ramAl);
}
public int compareTo(Object o) {
if (o instanceof Alumno) {
return this.getRut().compareTo( ((Alumno)o).getRut() );
}
return 0;
}
}
Ramo.java
public class Ramo implements Serializable {
private Long id;
private int version = 0;
private String nombre;
private Set ramosAlumno = new HashSet();
public Ramo() {};
public Ramo(String nombre, int numero,int semestre_correspdte, int horas_catedra,int horas_lab,String tipo, Set ramAl, Set ramProf, Set fr) {
this.nombre = nombre;
this.ramosAlumno = ramAl;
}
public Long getId(){
return id;
}
/* public void setId(Long id){
this.id = id;
}*/
public int getVersion(){
return version;
}
public String getNombre(){
return nombre;
}
public void setNombre(String nombre){
this.nombre = nombre;
}
//
public Set getRamosAlumno(){
return ramosAlumno;
}
public void setRamosAlumno(Set ramal){
this.ramosAlumno = ramal;
}
public void addRamoAlumno(RamoAlumno ramAl) {
if (ramAl == null)
throw new IllegalArgumentException("No add a null RamoAlumno.");
this.getRamosAlumno().add(ramAl);
}
public boolean equals(Object o) {
if (this == o) return true;
if (!(o instanceof Ramo)) return false;
final Ramo r = (Ramo) o;
if (nombre != null ? !nombre.equals(r.nombre) : r.nombre != null) return false;
return true;
}
public int hashCode() {
int result;
result = (nombre != null ? nombre.hashCode() : 0);
return result;
}
public String toString() {
return "Item ('" + getId() + "'), " +
"Name: '" + getNombre() + "' ";
}
public int compareTo(Object o) {
if (o instanceof Ramo) {
return this.getNombre().compareTo( ((Ramo)o).getNombre() );
}
return 0;
}
}
And a manager class: EncuestaManager
public class EncuestaManager {
public static void main(String[] args) {
EncuestaManager mgr = new EncuestaManager();
if (args[0].equals("store")) {
mgr.createAndStoreAlumnos(new Long(14104), "pola");
mgr.createAndStoreAlumnos(new Long(15006), "jero");
mgr.createAndStoreRamos("BD");
mgr.createAndStoreRamos("topicos");
mgr.addRamosDelAl("II",new Long(1),new Long(1));
}
else if (args[0].equals("list")) {
List alumnos = mgr.listAlumnos();
List ramos = mgr.listRamos();
for (int i = 0; i < alumnos.size(); i++) {
Alumno un_al = (Alumno) alumnos.get(i);
System.out.println("Id Alumno: " + un_al.getId() +
" Rut Alumno: " + un_al.getRut() +
" Pass: " + un_al.getPassword());
}
for (int i = 0; i < ramos.size(); i++) {
Ramo un_r = (Ramo) ramos.get(i);
System.out.println("IdRamo: " + un_r.getId() +
" Ramo: " + un_r.getNombre());
}
}
HibernateUtil.getSessionFactory().close();
}
private void createAndStoreAlumnos(Long rut, String pass) {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
Alumno al = new Alumno();
al.setRut(rut);
al.setPassword(pass);
session.save(al);
session.getTransaction().commit();
}
private void createAndStoreRamos(String nom) {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
Ramo r = new Ramo();
r.setNombre(nom);
session.save(r);
session.getTransaction().commit();
}
private void addRamosDelAl(String sem, Long idal, Long idr) {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
Alumno el_al = (Alumno) session.load(Alumno.class, idal);
Ramo el_r = (Ramo) session.load(Ramo.class, idr);
RamoAlumno rp = new RamoAlumno(sem,el_al,el_r);
//session.save(rp);
session.getTransaction().commit();
}
private List listAlumnos() {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
List result = session.createQuery("from Alumno").list();
session.getTransaction().commit();
return result;
}
private List listRamos() {
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
List result = session.createQuery("from Ramo").list();
session.getTransaction().commit();
return result;
}
}
Well. I did save fine Alumno and Ramo. But When I did try to do persist RamoAlumno, I did have the next errors:
Case 1: In addRamosDelAl(String sem, Long idal, Long idr)
without
session.save(rp); (commented //session.save(rp))
...
[java] 16:09:49,312 INFO SessionFactoryImpl:154 - building session factory
[java] 16:09:50,319 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] Hibernate: select alumno0_.ALUMNO_ID as ALUMNO1_0_0_, alumno0_.RUT as RUT0_0_, alumno0_.PASSW as PASSW0_0_ from ALUMNO alumno0_ where alumno0_.ALUMNO_ID=?
[java] Hibernate: select ramo0_.RAMO_ID as RAMO1_1_0_, ramo0_.VERSION as VERSION1_0_, ramo0_.NOMBRE as NOMBRE1_0_ from RAMO ramo0_ where ramo0_.RAMO_ID=?
[java] Hibernate: select ramosalumn0_.alumnoID as alumnoID1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_1_, ramosalumn0_.RAMO_ID as RAMO2_1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_2_0_, ramosalumn0_.RAMO_ID as RAMO2_2_0_, ramosalumn0_.VERSION as VERSION2_0_, ramosalumn0_.ADDED_ON as ADDED4_2_0_, ramosalumn0_.SEMESTRE as SEMESTRE2_0_ from RAMO_ALUMNO ramosalumn0_ where ramosalumn0_.alumnoID=?
[java] Hibernate: select ramosalumn0_.ramoID as ramoID1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_1_, ramosalumn0_.RAMO_ID as RAMO2_1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_2_0_, ramosalumn0_.RAMO_ID as RAMO2_2_0_, ramosalumn0_.VERSION as VERSION2_0_, ramosalumn0_.ADDED_ON as ADDED4_2_0_, ramosalumn0_.SEMESTRE as SEMESTRE2_0_ from RAMO_ALUMNO ramosalumn0_ where ramosalumn0_.ramoID=?
[java] Hibernate: select ramoalumno_.ALUMNO_ID, ramoalumno_.RAMO_ID, ramoalumno_.VERSION as VERSION2_, ramoalumno_.ADDED_ON as ADDED4_2_ from RAMO_ALUMNO ramoalumno_ where ramoalumno_.ALUMNO_ID=? and ramoalumno_.RAMO_ID=?
[java] Hibernate: insert into RAMO_ALUMNO (VERSION, ADDED_ON, SEMESTRE, ALUMNO_ID, RAMO_ID) values (?, ?, ?, ?, ?)
[java] Exception in thread "main" org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
[java] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
[java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
...
Case 2: addRamosDelAl(String sem, Long idal, Long idr)
with session.save(rp); (no commented)
...
[java] 16:13:24,972 INFO SessionFactoryImpl:154 - building session factory
[java] 16:13:25,952 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] Hibernate: select alumno0_.ALUMNO_ID as ALUMNO1_0_0_, alumno0_.RUT as RUT0_0_, alumno0_.PASSW as PASSW0_0_ from ALUMNO alumno0_ where alumno0_.ALUMNO_ID=?
[java] Hibernate: select ramo0_.RAMO_ID as RAMO1_1_0_, ramo0_.VERSION as VERSION1_0_, ramo0_.NOMBRE as NOMBRE1_0_ from RAMO ramo0_ where ramo0_.RAMO_ID=?
[java] Hibernate: select ramosalumn0_.alumnoID as alumnoID1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_1_, ramosalumn0_.RAMO_ID as RAMO2_1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_2_0_, ramosalumn0_.RAMO_ID as RAMO2_2_0_, ramosalumn0_.VERSION as VERSION2_0_, ramosalumn0_.ADDED_ON as ADDED4_2_0_, ramosalumn0_.SEMESTRE as SEMESTRE2_0_ from RAMO_ALUMNO ramosalumn0_ where ramosalumn0_.alumnoID=?
[java] Hibernate: select ramosalumn0_.ramoID as ramoID1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_1_, ramosalumn0_.RAMO_ID as RAMO2_1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_2_0_, ramosalumn0_.RAMO_ID as RAMO2_2_0_, ramosalumn0_.VERSION as VERSION2_0_, ramosalumn0_.ADDED_ON as ADDED4_2_0_, ramosalumn0_.SEMESTRE as SEMESTRE2_0_ from RAMO_ALUMNO ramosalumn0_ where ramosalumn0_.ramoID=?
[java] Hibernate: insert into RAMO_ALUMNO (VERSION, ADDED_ON, SEMESTRE, ALUMNO_ID, RAMO_ID) values (?, ?, ?, ?, ?)
[java] 16:13:27,081 WARN JDBCExceptionReporter:71 - SQL Error: 1364, SQLState: HY000
[java] 16:13:27,082 ERROR JDBCExceptionReporter:72 - Field 'alumnoID' doesn't have a default value
[java] 16:13:27,085 ERROR AbstractFlushingEventListener:300 - Could not synchronize database state with session
[java] org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
[java] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
...
Case 3: addRamosDelAl(String sem, Long idal, Long idr)
with session.saveOrUpdate(rp); (no commented)
[java] 16:14:46,565 INFO SessionFactoryImpl:154 - building session factory
[java] 16:14:47,549 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
[java] Hibernate: select alumno0_.ALUMNO_ID as ALUMNO1_0_0_, alumno0_.RUT as RUT0_0_, alumno0_.PASSW as PASSW0_0_ from ALUMNO alumno0_ where alumno0_.ALUMNO_ID=?
[java] Hibernate: select ramo0_.RAMO_ID as RAMO1_1_0_, ramo0_.VERSION as VERSION1_0_, ramo0_.NOMBRE as NOMBRE1_0_ from RAMO ramo0_ where ramo0_.RAMO_ID=?
[java] Hibernate: select ramosalumn0_.alumnoID as alumnoID1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_1_, ramosalumn0_.RAMO_ID as RAMO2_1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_2_0_, ramosalumn0_.RAMO_ID as RAMO2_2_0_, ramosalumn0_.VERSION as VERSION2_0_, ramosalumn0_.ADDED_ON as ADDED4_2_0_, ramosalumn0_.SEMESTRE as SEMESTRE2_0_ from RAMO_ALUMNO ramosalumn0_ where ramosalumn0_.alumnoID=?
[java] Hibernate: select ramosalumn0_.ramoID as ramoID1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_1_, ramosalumn0_.RAMO_ID as RAMO2_1_, ramosalumn0_.ALUMNO_ID as ALUMNO1_2_0_, ramosalumn0_.RAMO_ID as RAMO2_2_0_, ramosalumn0_.VERSION as VERSION2_0_, ramosalumn0_.ADDED_ON as ADDED4_2_0_, ramosalumn0_.SEMESTRE as SEMESTRE2_0_ from RAMO_ALUMNO ramosalumn0_ where ramosalumn0_.ramoID=?
[java] Hibernate: select ramoalumno_.ALUMNO_ID, ramoalumno_.RAMO_ID, ramoalumno_.VERSION as VERSION2_, ramoalumno_.ADDED_ON as ADDED4_2_ from RAMO_ALUMNO ramoalumno_ where ramoalumno_.ALUMNO_ID=? and ramoalumno_.RAMO_ID=?
[java] Hibernate: insert into RAMO_ALUMNO (VERSION, ADDED_ON, SEMESTRE, ALUMNO_ID, RAMO_ID) values (?, ?, ?, ?, ?)
[java] Exception in thread "main" org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
[java] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
...
Case 4: addRamosDelAl(String sem, Long idal, Long idr)
with
Alumno el_al = (Alumno) session.load(Alumno.class, idal);
Ramo el_r = (Ramo) session.load(Ramo.class, idr);
el_al.getId();
el_r.getId();
System.out.println("id al:"+el_al.getId());
System.out.println("id r:"+el_r.getId());
RamoAlumno rp = new RamoAlumno(sem,el_al,el_r);
el_al.getRamosAlumno().add(rp);
el_r.getRamosAlumno().add(rp);
session.saveOrUpdate(rp);
....
[java] Hibernate: select ramoalumno_.ALUMNO_ID, ramoalumno_.RAMO_ID, ramoalumno_.VERSION as VERSION2_, ramoalumno_.ADDED_ON as ADDED4_2_ from RAMO_ALUMNO ramoalumno_ where ramoalumno_.ALUMNO_ID=? and ramoalumno_.RAMO_ID=?
[java] Hibernate: insert into RAMO_ALUMNO (VERSION, ADDED_ON, SEMESTRE, ALUMNO_ID, RAMO_ID) values (?, ?, ?, ?, ?)
[java] Exception in thread "main" org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
...
Case 5: Without version in RamoAlumno
Without version and with session.saveOrUpdate(rp);
<!--
<version name="version"
column="VERSION"
access="org.hibernate.property.DirectPropertyAccessor"/>
-->
session.saveOrUpdate(rp);
[java] Hibernate: select ramoalumno_.ALUMNO_ID, ramoalumno_.RAMO_ID, ramoalumno_.ADDED_ON as ADDED3_2_ from RAMO_ALUMNO ramoalumno_ where ramoalumno_.ALUMNO_ID=? and ramoalumno_.RAMO_ID=?
[java] Hibernate: insert into RAMO_ALUMNO (ADDED_ON, SEMESTRE, ALUMNO_ID, RAMO_ID) values (?, ?, ?, ?)
[java] Exception in thread "main" org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Well. I hope your help again. Please.
Best Regards.
Paola
Login
FAQ
Search
