0 Replies Latest reply on Jun 30, 2006 11:13 AM by Anders Carlsen

    SQLException: ORA-00972: identifier is too long with Oracle

    Anders Carlsen Newbie

      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

      I get the following error:

      ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.WorkTime#findByJobIdUsernameWorkDayAndStatus] Find failed
      java.sql.SQLException: ORA-00972: identifier is too long

      Can anybody tell me what I am doing wrong?