-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users (Français)

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 
  Previous topic | Next topic 
Author Message
dev_webapp
 Post subject: [Resolu] Erreur save/update
PostPosted: Thu Jun 11, 2009 8:44 am 
Newbie

Joined: Fri Jun 05, 2009 4:21 am
Posts: 5
Salut tout le monde,

J'ai un problème quand j'essaye de sauvgarder un objet dans ma base de données.
L'objet (la table) en question est en relation avec deux autres objets tel que :

repository_family_version à une clé étrangère de oms_javaclass_handler et de repository_family

voila les fichiers de mapping des ces tables :

Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 12 nov. 2008 11:00:56 by Hibernate Tools 3.2.2.GA -->
<hibernate-mapping>
    <class name="com.ul.extranet.module.ulnetadmin.model.RepositoryFamilyVersion" table="ul_repository_family_version">
        <id name="repositoryFamilyVersionId" type="int">
            <column name="repositoryFamilyVersionId" />
            <generator class="increment" />
        </id>
        <property name="version" type="string">
            <column name="version" length="50" />
        </property>
        <many-to-one name="repositoryFamily" class="com.ul.extranet.module.ulnetadmin.model.RepositoryFamily" fetch="select">
            <column name="repositoryFamilyId" not-null="true" />
        </many-to-one>
        <property name="description" type="string">
            <column name="description" length="200" />
        </property>
       
        <many-to-one name="repositoryHandlerClass" class="com.ul.extranet.module.ulnetadmin.model.UlNetAdminOMSJavaClassHandler" fetch="select">
            <column name="handlerId" not-null="true" />
        </many-to-one>
        <set name="repositories" inverse="true">
            <key>
                <column name="repositoryFamilyVersionId" not-null="true" />
            </key>
            <one-to-many class="com.ul.extranet.module.ulnetadmin.model.Repository" />
        </set>
        <set name="plateformes" inverse="true" table="ul_allowed_repository_family_version">
            <key>
                <column name="repositoryFamilyVersionId" not-null="true" />
            </key>
            <many-to-many entity-name="com.ul.extranet.module.ulnetadmin.model.Plateforme">
                <column name="plateformeId" not-null="true" />
            </many-to-many>
        </set>
    </class>
</hibernate-mapping>


Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 12 nov. 2008 11:00:56 by Hibernate Tools 3.2.2.GA -->
<hibernate-mapping>
    <class name="com.ul.extranet.module.ulnetadmin.model.UlNetAdminOMSJavaClassHandler"
          table="ul_oms_javaclass_handler" >
          
        <id name="handlerId" type="java.lang.Integer">
            <column name="handlerId" />
            <generator class="increment" />
        </id>

        <property name="handlerClass" type="string">
            <column name="handlerClass" length="150" />
        </property>
      
      <set name="repositoryFamilyVersions" inverse="true">
            <key>
                <column name="handlerId" not-null="true" />
            </key>
            <one-to-many class="com.ul.extranet.module.ulnetadmin.model.RepositoryFamilyVersion" />
        </set>
    </class>
</hibernate-mapping>


Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 12 nov. 2008 11:00:56 by Hibernate Tools 3.2.2.GA -->
<hibernate-mapping>
    <class name="com.ul.extranet.module.ulnetadmin.model.RepositoryFamily" table="ul_repository_family">
        <id name="repositoryFamilyId" type="java.lang.Integer">
            <column name="repositoryFamilyId" />
            <generator class="identity" />
        </id>
        <property name="name" type="string">
            <column name="name" length="50" />
        </property>
        <property name="description" type="string">
            <column name="description" length="200" />
        </property>
        <set name="repositoryFamilyVersions" inverse="true">
            <key>
                <column name="repositoryFamilyId" not-null="true" />
            </key>
            <one-to-many class="com.ul.extranet.module.ulnetadmin.model.RepositoryFamilyVersion" />
        </set>
    </class>
</hibernate-mapping>


Et donc j'essaye de sauvegarder un objet de la premier table
avec la fonction suivante

Code:
public void update(RepositoryFamilyVersion instance) {
      log.debug("attaching dirty RepositoryFamilyVersion instance");
      try {
         this.getSessionFactory().getCurrentSession().saveOrUpdate(instance);
//         this.getHibernateTemplate().flush();
         log.debug("attach successful");
      } catch (RuntimeException re) {
         log.error("attach failed", re);
         throw re;
      }
   }


et voila l'exception que je recois
Code:
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
   at com.ul.extranet.core.acegi.OpenSessionInViewPhaseListener.closeSession(OpenSessionInViewPhaseListener.java:340)
   at com.ul.extranet.core.acegi.OpenSessionInViewPhaseListener.cleanupSession(OpenSessionInViewPhaseListener.java:213)
   at com.ul.extranet.core.acegi.OpenSessionInViewPhaseListener.afterPhase(OpenSessionInViewPhaseListener.java:189)
   at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:280)
   at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
   at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:18)
   at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.renderCycle(ReceiveSendUpdates.java:94)
   at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.service(ReceiveSendUpdates.java:54)
   at com.icesoft.faces.webapp.http.core.RequestVerifier.service(RequestVerifier.java:26)
   at com.icesoft.faces.webapp.http.common.standard.PathDispatcherServer.service(PathDispatcherServer.java:24)
   at com.icesoft.faces.webapp.http.servlet.MainSessionBoundServlet.service(MainSessionBoundServlet.java:160)
   at com.icesoft.faces.webapp.http.servlet.SessionDispatcher$1.service(SessionDispatcher.java:38)
   at com.icesoft.faces.webapp.http.servlet.ThreadBlockingAdaptingServlet.service(ThreadBlockingAdaptingServlet.java:19)
   at com.icesoft.faces.webapp.http.servlet.EnvironmentAdaptingServlet.service(EnvironmentAdaptingServlet.java:63)
   at com.icesoft.faces.webapp.http.servlet.SessionDispatcher.service(SessionDispatcher.java:55)
   at com.icesoft.faces.webapp.http.servlet.SessionVerifier.service(SessionVerifier.java:19)
   at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:23)
   at com.icesoft.faces.webapp.http.servlet.MainServlet.service(MainServlet.java:91)
   at com.ul.extranet.core.servlet.ULExtranetServlet.service(ULExtranetServlet.java:45)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.service(BlockingServlet.java:56)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
   at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
   at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: Field 'repositoryHandlerClass' doesn't have a default value
   at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1693)
   at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1108)
   at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
   ... 64 more
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
   at com.ul.extranet.core.acegi.OpenSessionInViewPhaseListener.closeSession(OpenSessionInViewPhaseListener.java:340)
   at com.ul.extranet.core.acegi.OpenSessionInViewPhaseListener.cleanupSession(OpenSessionInViewPhaseListener.java:213)
   at com.ul.extranet.core.acegi.OpenSessionInViewPhaseListener.afterPhase(OpenSessionInViewPhaseListener.java:189)
   at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:280)
   at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
   at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:18)
   at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.renderCycle(ReceiveSendUpdates.java:94)
   at com.icesoft.faces.webapp.http.core.ReceiveSendUpdates.service(ReceiveSendUpdates.java:54)
   at com.icesoft.faces.webapp.http.core.RequestVerifier.service(RequestVerifier.java:26)
   at com.icesoft.faces.webapp.http.common.standard.PathDispatcherServer.service(PathDispatcherServer.java:24)
   at com.icesoft.faces.webapp.http.servlet.MainSessionBoundServlet.service(MainSessionBoundServlet.java:160)
   at com.icesoft.faces.webapp.http.servlet.SessionDispatcher$1.service(SessionDispatcher.java:38)
   at com.icesoft.faces.webapp.http.servlet.ThreadBlockingAdaptingServlet.service(ThreadBlockingAdaptingServlet.java:19)
   at com.icesoft.faces.webapp.http.servlet.EnvironmentAdaptingServlet.service(EnvironmentAdaptingServlet.java:63)
   at com.icesoft.faces.webapp.http.servlet.SessionDispatcher.service(SessionDispatcher.java:55)
   at com.icesoft.faces.webapp.http.servlet.SessionVerifier.service(SessionVerifier.java:19)
   at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:23)
   at com.icesoft.faces.webapp.http.servlet.MainServlet.service(MainServlet.java:91)
   at com.ul.extranet.core.servlet.ULExtranetServlet.service(ULExtranetServlet.java:45)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at com.icesoft.faces.webapp.xmlhttp.BlockingServlet.service(BlockingServlet.java:56)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
   at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
   at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
   at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
   at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
   at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
   at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.BatchUpdateException: Field 'repositoryHandlerClass' doesn't have a default value
   at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1693)
   at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1108)
   at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
   ... 64 more
   
   
   




le champ repositoryHandlerClass dans ma table sql ne contient effectivement pas de valeur par défaut, mais c'est normal puisque c'est un Integer et que c'est une clé étrangère ...

Auriez vous une idée d'où ça peut venir


Merci bq


Last edited by dev_webapp on Thu Jun 11, 2009 10:27 am, edited 1 time in total.

Top
 Profile  
 
dev_webapp
 Post subject: Re: Erreur save/update
PostPosted: Thu Jun 11, 2009 10:26 am 
Newbie

Joined: Fri Jun 05, 2009 4:21 am
Posts: 5
resolu, j'avais une erreur dans mon fichier hbm au niveau de la définition d'une clé étrangère
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 2 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users (Français)

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.