We're updating the issue view to help you get more done. 

"ORA-00904 invalid identifier" occur on a criteria ... sometime

Description

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

Environment

Spring 3.05 + Hibernate 3.6.9

Status

Assignee

Unassigned

Reporter

ChristopheL

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

3.6.9

Priority

Major