-->
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.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Supprimer une occurence d'une table geré par hibernate
PostPosted: Thu Dec 03, 2009 5:17 pm 
Newbie

Joined: Thu Dec 03, 2009 5:07 pm
Posts: 2
je veux supprimer une occurence de la table BCN dans la base de données

Hibernate a creé la classe correspondante a la table et voila son code :


package stt;

import stt.base.BaseBcn;



public class Bcn extends BaseBcn {
private static final long serialVersionUID = 1L;

/*[CONSTRUCTOR MARKER BEGIN]*/
public Bcn () {
super();
}

/**
* Constructor for primary key
*/
public Bcn (stt.BcnPK id) {
super(id);
}

/**
* Constructor for required fields
*/
public Bcn (
stt.BcnPK id,
java.lang.Integer nfin,
java.util.Date dtBcn,
java.lang.Integer cdart,
java.lang.Integer nbcn,
java.lang.String cddep,
java.lang.String logincreateur,
java.util.Date datecreation,
java.lang.String loginModificateur,
java.util.Date dateModification) {

super (
id,
nfin,
dtBcn,
cdart,
nbcn,
cddep,
logincreateur,
datecreation,
loginModificateur,
dateModification);
}

/*[CONSTRUCTOR MARKER END]*/




aussi que la classe BCNPK :

package stt;

import stt.base.BaseBcnPK;

public class BcnPK extends BaseBcnPK {
private static final long serialVersionUID = 1L;

/*[CONSTRUCTOR MARKER BEGIN]*/
public BcnPK () {}

public BcnPK (
java.lang.String serie,
java.lang.Integer ndebut,
java.lang.String idTitre) {

super (
serie,
ndebut,
idTitre);
}
/*[CONSTRUCTOR MARKER END]*/


}


j'ai créer une classe SuppressionBcn dont le code est le suivant :



import java.util.Date;
import java.util.Iterator;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

import stt.Bcn;
import stt.BcnPK;
import stt.dao.BcnDAO;
import stt.dao._RootDAO;

public class SuppressionBcnBean

{
private String Titre;
private String serie;
private int ndeb;
private int nfin;
private int qte;
private int numbcn;
private Date dtbcn;
private int cdart;
private String cddep;
private String logincre;
private Date datecre;
private String loginmod;
private Date datemod;
private String msg;
public SuppressionBcnBean(){}

public String getMsg() {
return msg;
}

public void setMsg(String msg) {
this.msg = msg;
}

public String getLogincre() {
return logincre;
}

public void setLogincre(String logincre) {
this.logincre = logincre;
}

public Date getDatecre() {
return datecre;
}

public void setDatecre(Date datecre) {
this.datecre = datecre;
}

public String getLoginmod() {
return loginmod;
}

public void setLoginmod(String loginmod) {
this.loginmod = loginmod;
}

public Date getDatemod() {
return datemod;
}

public void setDatemod(Date datemod) {
this.datemod = datemod;
}

public int getCdart() {
return cdart;
}
public void setCdart(int cdart) {
this.cdart = cdart;
}
public String getCddep() {
return cddep;
}
public void setCddep(String cddep) {
this.cddep = cddep;
}



public String getTitre() {
return Titre;
}
public void setTitre(String titre) {
Titre = titre;
}
public String getSerie() {
return serie;
}
public void setSerie(String serie) {
this.serie = serie;
}
public int getNdeb() {
return ndeb;
}
public void setNdeb(int ndeb) {
this.ndeb = ndeb;
}
public int getNfin() {
return nfin;
}
public void setNfin(int nfin) {
this.nfin = nfin;
}
public int getQte() {
return qte;
}
public void setQte(int qte) {
this.qte = qte;
}
public int getNumbcn() {
return numbcn;
}
public void setNumbcn(int numbcn) {
this.numbcn = numbcn;
}
public Date getDtbcn() {
return dtbcn;
}
public void setDtbcn(Date dtbcn) {
this.dtbcn = dtbcn;
}

public String supprimer()
{

SessionFactory sessionfactory = new Configuration().configure().buildSessionFactory();
Session session = sessionfactory.openSession();
try
{
BcnDAO dao = new BcnDAO();
Query q= session.createQuery
("from bcn as b where b.Id.idTitre=:idt and b.Id.serie=:s and b.Id.ndebut=: nd and b.nfin=: nf and b.dtBcn=:dt and b.nbcn=:nb");
q.setString("idt", this.Titre);
q.setString("s",this.serie);
q.setInteger("nd",this.ndeb);
q.setInteger("nf",this.nfin);
q.setDate("dt",this.dtbcn);
q.setInteger("nb",this.numbcn);
Iterator it = q.iterate();
while (it.hasNext())
{
Bcn b = (Bcn) it.next();
this.cdart=b.getCdart();
this.cddep=b.getCddep();
this.logincre=b.getLogincreateur();
this.datecre=b.getDatecreation();
this.loginmod=b.getLoginModificateur();
this.datemod=b.getDateModification();
}

Bcn bb = new Bcn(new BcnPK(this.serie,this.ndeb,this.Titre),this.nfin,this.dtbcn,this.cdart,this.numbcn,this.cddep,this.logincre,this.datecre,this.loginmod,this.datemod);
dao.delete(bb);
this.msg="Suppression effectué";
return "ok";


}

catch(HibernateException e)
{
this.msg="Suppression non effectue";
return "nok";

}
finally
{
session.close();
}

}

}



et j'ai conçu une page jsp dont le code est le suivant :



<h1 style="font-size: 30px; font-family: arial; color:blue">SUPPRESSION B.C.N</h1>

<h:panelGrid columns="2" border="5" style="background-color:Orange">

<h:outputText value="Titre"></h:outputText>
<h:inputText id="title" value="#{suppressionBcnBean.titre}"></h:inputText>
<h:outputText value="Serie"></h:outputText>
<h:inputText id="serie" value="#{suppressionBcnBean.serie}"></h:inputText>
<h:outputText value="Premier N° B.C.N"></h:outputText>
<h:inputText id="premier" value="#{suppressionBcnBean.ndeb}"></h:inputText>
<h:outputText value="Dernier N° B.C.N"></h:outputText>
<h:inputText id="dernier" value="#{suppressionBcnBean.nfin}"></h:inputText>
<h:outputText value="Quantité"></h:outputText>
<h:inputText id="quantity" value="#{suppressionBcnBean.qte}"></h:inputText>
<h:outputText value="Numero B.C.N"></h:outputText>
<h:inputText id="numbcn" value="#{suppressionBcnBean.numbcn}"></h:inputText>
<h:outputText value="Date B.C.N"></h:outputText>
<h:inputText id="datebcn" value="#{suppressionBcnBean.dtbcn}"><f:convertDateTime pattern="yyyy-MM-dd"/></h:inputText><h:message for="datebcn" id="mess1"></h:message>

</h:panelGrid>

<br/><br/>

<h:panelGrid columns="2">

<center>

<h:commandButton value="Supprimer" type="submit"style="font-size: 18px; background-color: Orange" action="#{suppressionBcnBean.supprimer}"></h:commandButton>

<h:commandButton value="Reinitialiser" type="reset" style=" font-size:18px; background-color: Orange"></h:commandButton>

</center>

</h:panelGrid>

<br/>

<h:panelGrid columns="1">

<h:outputText value="#{suppressionBcnBean.msg}"></h:outputText>

</h:panelGrid>

</h:form>
</center>
</body>
</f:view>
</html>



le console affiche les erreurs suivantes et la suppression ne s'effectue pas :



39 [http-8080-1] INFO org.hibernate.cfg.Environment - Hibernate 3.3.0.SP1
47 [http-8080-1] INFO org.hibernate.cfg.Environment - hibernate.properties not found
53 [http-8080-1] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
64 [http-8080-1] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
210 [http-8080-1] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
210 [http-8080-1] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
341 [http-8080-1] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : Bcn.hbm.xml
470 [http-8080-1] INFO org.hibernate.cfg.HbmBinder - Mapping class: stt.Bcn -> bcn
507 [http-8080-1] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : Prix.hbm.xml
532 [http-8080-1] INFO org.hibernate.cfg.HbmBinder - Mapping class: stt.Prix -> prix
532 [http-8080-1] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : StkRvt.hbm.xml
563 [http-8080-1] INFO org.hibernate.cfg.HbmBinder - Mapping class: stt.StkRvt -> stk_rvt
564 [http-8080-1] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : DefBcn.hbm.xml
579 [http-8080-1] INFO org.hibernate.cfg.HbmBinder - Mapping class: stt.DefBcn -> def_bcn
579 [http-8080-1] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
943 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
943 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
943 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
949 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/transtu
949 [http-8080-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=****}
1271 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 4.1.9-max
1271 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.10 ( Revision: ${svn.Revision} )
1306 [http-8080-1] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
1317 [http-8080-1] INFO org.hibernate.transaction.TransactionFactoryFactory - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
1322 [http-8080-1] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1322 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
1322 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
1322 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
1322 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
1324 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
1324 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
1324 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
1325 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
1325 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
1325 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
1325 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
1325 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
1326 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1331 [http-8080-1] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
1331 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
1331 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
1331 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
1331 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
1331 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
1331 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
1331 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
1345 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
1345 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
1346 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
1346 [http-8080-1] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
1434 [http-8080-1] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
1884 [http-8080-1] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured



que dois je faire comme rectification ?


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

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.