Hi,
I have a batch running using the following criteria :
public MarketingLeg findMarketingLeg(ISession session, String flightNumber, String departureStation, Date departureUt) { Criteria criteria = ((SessionImpl) session).getSession().createCriteria(MarketingLeg.class); criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY); criteria.add(Restrictions.eq(FLIGHT_NUMBER, flightNumber)); criteria.add(Restrictions.eq(DEPARTURE_STATION, departureStation)); criteria.add(Restrictions.eq(FLIGHT_DEPARTURE_UT, departureUt)); return (MarketingLeg) criteria.uniqueResult(); }
Most of the time, there is no problemwith the request generated.
But sometime (once a week), for a reason I am not able to determine, the batch crash and throw an "ORA-00904 invalid identifier" (I joined the log trace)
Best regards.
Christophe