[Hibernate][error] Could not execute JDBC batch update

Version imprimable

Bonjour à tous,

lors de l'execution d'une réquete j'ai l'erreur suivante :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
exception 
javax.servlet.ServletException: Could not execute JDBC batch update
    org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
cause mère 
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
    org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
    org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
    org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
    org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
    org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
    org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
    org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
    org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
    org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
    be.qspin.qats.business.HibernateUtility.setRow(HibernateUtility.java:99)
    be.qspin.qats.business.Applicants.createApplicant(Applicants.java:53)
    be.qspin.qats.struts.action.CreateApplicantAction.execute(CreateApplicantAction.java:84)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)

le .hbm:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<hibernate-mapping default-lazy="false">
    <class name="be.qspin.qats.entities.Applicant" table="APPLICANTS">
        <meta attribute="class-description">
            Define an "Applicant" entity.
        </meta>
        <id name="id" type="integer" column="ID">
            <generator class="increment">
            </generator>            
        </id>
        <property name="lastname" type="string" not-null="true">
            <column name="LASTNAME" length="20" not-null="true"/>
        </property>
        <property name="firstname" type="string" not-null="true">
            <column name="FIRSTNANE" length="20" not-null="true"/>
        </property>
        <property name="gender" type="string" not-null="true">
            <column name="GENDER" length="20" not-null="true"/>
        </property>        
        <property name="birthday" type="timestamp" not-null="true">
            <column name="BIRTHDAY" length="20" not-null="true"/>
        </property>
        <property name="nationality" type="string" not-null="true">
            <column name="NATIONALITY" length="20" not-null="true"/>
        </property>
        <property name="address" type="string" not-null="true">
            <column name="ADDRESS" length="20" not-null="true"/>
        </property>
        <property name="PC" type="string" not-null="true">
            <column name="PC" length="20" not-null="true"/>
        </property>        
        <property name="city" type="string" not-null="true">
            <column name="CITY" length="20" not-null="true"/>
        </property>    
        <property name="country" type="string" not-null="true">
            <column name="COUNTRY" length="20" not-null="true"/>
        </property>  
        <property name="phone" type="string" not-null="true">
            <column name="PHONE" length="20" not-null="true"/>
        </property>    
        <property name="gsm" type="string" not-null="true">
            <column name="GSM" length="20" not-null="true"/>
        </property>  
        <property name="email" type="string" not-null="true">
            <column name="EMAIL" length="20" not-null="true"/>
        </property>   
        <property name="interest" type="string" not-null="true">
            <column name="INTEREST" length="1" not-null="true"/>
        </property>  
 
        <many-to-one name="jobTitle" column="TITLE" class="be.qspin.qats.entities.JobTitle" cascade="none" not-null="true"/>
 
    </class>
</hibernate-mapping>

le .java :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
    public static Applicant createApplicant(String lastname, String firstname, String selectJobTitle, String jobTitle, String interest, String gender, Date birthday, String nationality, String address, String PC, String city, String country, String phone, String gsm, String mail){
        Applicant appl = new Applicant();
        JobTitle jT = new JobTitle();
        jT.setTitle(jobTitle);
 
        appl.setLastname(lastname);
        appl.setFirstname(firstname);
        appl.setGender(gender);
        appl.setBirthday(birthday);
        appl.setNationality(nationality);
        appl.setAddress(address);
        appl.setPC(PC);
        appl.setCity(city);
        appl.setCountry(country);
        appl.setPhone(phone);
        appl.setGsm(gsm);
        appl.setEmail(mail);
 
        appl.setInterest(interest);
 
        System.out.println(appl.toString());
 
        if (selectJobTitle.equals("new"))
            HibernateUtility.setRow(jT);
        jT = (JobTitle) HibernateUtility.getRow(JobTitle.class, "title", jT.getTitle());
        appl.setJobTitle(jT);   
        HibernateUtility.setRow(appl); 
 
        return appl;
    }

et l'insertion Hibernate :

Code:

1
2
3
4
5
6
7
      public static void setRow(Object obj) {
        Session session = getHibernateSession();
        Transaction tx = session.beginTransaction();
        session.saveOrUpdate(obj);
        tx.commit();
        session.close();
    }

pouvez vous m'aider et me dire d'ou vient l'erreur

merci

31/05/2007, 10h37
CPI_en_mousse

ha zut, je viens de m'apercevoir qu'il existe un forum Hibernate. comment faire pour déplacer son post?
31/05/2007, 13h16
manblaizo

Salut,
Et si dans le mapping de "Applicant" tu mettais cascade="save-update" pour la relation many-to-one avec "JobTitle" ?

Code:

<many-to-one name="jobTitle" column="TITLE" class="be.qspin.qats.entities.JobTitle" cascade="save-update" not-null="true"/>
31/05/2007, 14h07
CPI_en_mousse

ca ne change rien, j'ai toujours la meme erreur
31/05/2007, 14h53
manblaizo

OK, alors le problème pourrait venir du fait que tu as not-null="true" dans cette relation many-to-one. Donc soit tu mets not-null=false, soit tu t'assures d'affecter un JobTitle à ton objet Applicant avant de le sauvegarder.
Voilà, j'espère que ça t'avance à quelque chose.
31/05/2007, 15h08
CPI_en_mousse

j'obtiens l'erreur suivante maintenant

Code:

org.hibernate.PropertyValueException: not-null property references a null or transient value: be.qspin.qats.entities.JobTitle.title
31/05/2007, 15h24
manblaizo

Tu as effectivement plein de not-null="true" sur toutes les propriétés de tes beans. Donc il faut s'assurer que tous les champs not-null=true sont renseignés pour sauvegarder l'objet, comme je l'ai dit avant. Pour le reste, concernant la relation many-to-one, essaie de mettre aussi bien cascade="save-update" et not-null="false", pour voir ce que ça donne. En tout cas, c'est juste un problème d'intégrité de la base de données.

j'ai trouvé,

la soluce en vrac:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    public static Applicant createApplicant(String lastname, String firstname, String selectJobTitle, String jobTitle, String interest, String gender, Date birthday, String nationality, String address, String PC, String city, String country, String phone, String gsm, String mail){
        Applicant appl = new Applicant();
        JobTitle jT = new JobTitle();
        JobTitle jT2 = new JobTitle();
 
 
        System.out.println("ici tous va bien :");
 
        appl.setLastname(lastname);
        appl.setFirstname(firstname);
        appl.setGender(gender);
        //appl.setBirthday(birthday);
        appl.setNationality(nationality);
        appl.setAddress(address);
        appl.setPC(PC);
        appl.setCity(city);
        appl.setCountry(country);
        appl.setPhone(phone);
        appl.setGsm(gsm);
        appl.setEmail(mail);
        appl.setInterest(interest);
 
        System.out.println("ici tous va mal : affiche appl\n");
        System.out.println(appl.toString());
 
        if (selectJobTitle.equals("new")){
            System.out.println("on as un new");
 
            jT = (JobTitle) HibernateUtility.getRow(JobTitle.class, "title", jobTitle);
            System.out.println("on regarde  si il existe pas deja");
            if (jT == null){
                 System.out.println("il existe pas alors on sauvegarde");
                jT2.setTitle(jobTitle);
                System.out.println("on affihche le job title");
                System.out.println("jT=" + jT2.getTitle());
                HibernateUtility.setRow(jT2);
            }}
 
        jT = (JobTitle) HibernateUtility.getRow(JobTitle.class, "title", jobTitle);
        if (jT == null){
            System.out.println("pas de JT correspondant");
        } else{
            System.out.println("on passe dans le else");
            appl.setJobTitle(jT);
            System.out.println(appl.getLastname());
            System.out.println(appl.getFirstname());
            System.out.println(appl.getGender());
            //System.out.println(appl.getBirthday());
            System.out.println(appl.getNationality());
            System.out.println(appl.getAddress());
            System.out.println(appl.getPC());
            System.out.println(appl.getCity());
            System.out.println(appl.getCountry());
            System.out.println(appl.getPhone());
            System.out.println(appl.getGsm());
            System.out.println(appl.getEmail());
            System.out.println("on affihche le job title");
            System.out.println(appl.getJobTitle().getTitle());
            //HibernateUtility.setRow(appl);
        }
 
 
        return appl;
    }