ORA-00904: "DTYPE": 标识符无效


   
  2013-06-14 08:41:08,781 ERROR [taskExecutorForMsgLoad-1] (MsgLoadManageServiceImpl.java:222) - 报文加载时出错:org.hibernate.exception.SQLGrammarException: ORA-00904: "DTYPE": invalid identifier
  

Hibernate: select count(*) from (select msg.*, tmporg.sorgname as sorgname from sino_msg msg left outer join sino_org tmporg on tmporg.sorgcode = msg.sorgcode where 1=1 and to_char(duploadtime, 'yyyy-mm-dd') >= ? order by msg.duploadtime desc) nx
Hibernate: select * from ( select t.*, rownum rn from ( select msg.*, tmporg.sorgname as sorgname from sino_msg msg left outer join sino_org tmporg on tmporg.sorgcode = msg.sorgcode where 1=1 and to_char(duploadtime, 'yyyy-mm-dd') >= ? order by msg.duploadtime desc ) t where rownum <=30 ) where rn >= 1
2013-06-14 08:41:08,796 ERROR [taskExecutorForMsgLoad-1] (MsgLoadJob.java:181) - com.sino.common.exception.SinoServiceException: org.hibernate.exception.SQLGrammarException: ORA-00904: "DTYPE": invalid identifier

hibernate oracle

福尔着哩水 11 years, 1 month ago

Your Answer