Canalblog
Editer l'article Suivre ce blog Administration + Créer mon blog
Publicité
Notre Temps
7 juin 2010

<span class='bodytext'>The information you

<span class='bodytext'>
The information you provided does not match an existing account. Make sure you do not have "CAPS LOCK" turned on.
If the problem continues, a network server may be temporarily unavailable. Try again in a few minutes, or contact your helpdesk.</span>

public void write(List<? extends FactureDepense> listFactureDepense) throws Exception {
}

@SuppressWarnings("unchecked")
@Transactional(propagation=Propagation.REQUIRES_NEW,readOnly=true)

@Transactional(propagation=Propagation.REQUIRES_NEW,readOnly=false,rollbackFor=Exception.class)

Enum Constant Summary
MANDATORY
          Support a current transaction, throw an exception if none exists.
NESTED
          Execute within a nested transaction if a current transaction exists, behave like PROPAGATION_REQUIRED else.
NEVER
          Execute non-transactionally, throw an exception if a transaction exists.
NOT_SUPPORTED
          Execute non-transactionally, suspend the current transaction if one exists.
REQUIRED
          Support a current transaction, create a new one if none exists.
REQUIRES_NEW
          Create a new transaction, suspend the current transaction if one exists.
SUPPORTS
          Support a current transaction, execute non-transactionally if none exists.

Does JDBC Driver support ALTER USER userid IDENTIFIED BY

** Ajout d’un « NamedQuery : listUserBatch» dans la config hibernate :
- creation d’un fichier hibernate mapping *.hbm.xml
<hibernate-mapping >
  <sql-query name=”myQuery”>
   <return alias="deprectiation" class="com….model.MyClass”/>

   select itrid,ideordre,iruordre,idedtdeb,idedtfin
   from myTable
   where idedtfin is null and itrid=:trancheid and iruordre=:iruordre

  </sql-query>
 
  <sql-query>
 
  </sql-query>
 
  <!--  Requête d'insertion pour l'historisation -->
  <sql-query name="requete_historisation">
   insert into DEV.interfaceE3F (e3Ffacid,e3Fdepid,queryType,updateDate)values (:facid,:depid,:queryType,:updateDate)
  </sql-query>
 
</hibernate-mapping >
- ajout de ce fichier de mapping dans hibernate.cfg.xml dans la session factory
<mapping resource="***.hbm.xml"/>

** in the DAOClass

public Depreciation getLastDepreciation(final Avac avac){
final Query query = super.getSession().getNamedQuery("req_select_last_argus");
query.setLong("trancheid", avac.getItrid());
query.setLong("iruordre", avac.getIruordre());
return (Depreciation) query.uniqueResult();
}

public List<Avac> getListAvac() {
final Query query = super.getSession().getNamedQuery("req_select_avac_lines");
query.setResultTransformer(new ToAvacLine());
return (List<Avac>) query.list();
}

query = session.getNamedQuery("req_insert_crevt");
query.setLong("trancheId", avac.getItrid());
query.setLong("identifiant", identifiant);
query.executeUpdate();

catch(HibernateException e){
// Remontée de l'erreur.
throw new Exception("Erreur lors de la requête : " + query.getQueryString() + " - " +e.getMessage(),e) ;

public class AvacDao extends HibernateDaoSupport
    implements IAvacDao{

/** Logger */
private static final Logger LOGGER = Logger.getLogger(AvacDao.class);

create table DEV.UserBatchInfo(
    id_          NUMBER(3),
    userId VARCHAR2(15),
    pwdFileEntry VARCHAR2(100),
    fileName VARCHAR2(100),
    fileLocation VARCHAR2(200),
    lastPwdChangeDate DATE,
    constraint UserBatchInfo_pk primary key (id_)
);

Publicité
Publicité
Commentaires
Notre Temps
Publicité
Albums Photos
Publicité