Posts

Showing posts from May, 2013

Spring - Repeated column in mapping for collection:

Problem:


Caused by: org.hibernate.MappingException: Repeated column in mapping for collection: xxx.xxx.xxx.xxx: ID
Cause by:
<listname="value"table="QUESTION_VALUE"cascade="save-update, delete"fetch="join"lazy="true"> <keycolumn="ID"/> <indexcolumn="ID"></index> <one-to-manyclass="com.mkyong.common.model.QuestionValue"/> </list>

Solution: User a field other than "ID", in my case i created a "ORDER"  and filled its value explicity.

ORACLE - Cambiar próxima fecha de ejecución de un job

Listar los Oracle jobs existentes:

select * from dba_jobs;

Obtener la próxima fecha de ejecución:

select to_char( next_date, 'YYYYMMDD:HH24MI') from dba_jobs where job = 181;

Testar la próxima fecha de ejecución:

select to_char( trunc(SYSDATE) + ((16*60)+50)/1440 , 'YYYYMMDD:HH24MI') from dual;
Aplicar los cambios:

exec DBMS_JOB.next_date ( <JOB_ID>, trunc(SYSDATE) + ((16*60)+50)/1440);
Commit a los cambios:

Commit;