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? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3954687#3954687 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3954687 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user