<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_)
);