I am converting my application to run on Oracle Express edition.
I know Oracle doesnt support column names/identifiers that are longer than 30 chars, so I have converted all my tables/code to make sure that is not problem.
However, when I the following EJB is run, I get an error.
SELECT DISTINCT OBJECT(o) FROM WorkTime o WHERE o.jobInInterval.workDayInterval.workDay.workDayId = ?3 AND o.jobInInterval.job.jobId = ?2 AND o.jobInInterval.workDayInterval.workDay.employee.username = ?1 AND ((?4 = 0 AND (o.status IS NULL OR o.status = ?4)) OR o.status = ?4) ORDER BY o.startTime
ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.WorkTime#findByJobIdUsernameWorkDayAndStatus] Find failed java.sql.SQLException: ORA-00972: identifier is too long