Ò»¸öSqlÎÊÌâ - Java / Java SE

ʹÓÃhibernateÓ³ÉäÎļþÅäÖÃÊý¾Ý¿â±íµÄ¹Øϵ£¬Ö´ÐÐʱ±¨£ºSQL ÃüÁîδÕýÈ·½áÊø ´íÎó

---

¶î ÎÊÌâÏÖÏóÃèÊö²»Ïêϸ

  ÊÇSQLдµÄÓÐÎÊÌâ.

---

Ó¦¸ÃÊÇHQLÓï·¨³ö´í

---

ÈçÌâÕâÑù Ë­Äܸø³ö´ð°¸ ÎÒ¾ÍÊÇÅå·þ

---

Hibernate: select user0_.Óû§±àºÅ as Óû§±àºÅ10_, user0_.Óû§Ãû as Óû§Ãû10_, user0_.ÃÜÂë as ÃÜÂë10_, user0_.ÐÕÃû as ÐÕÃû10_, user0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ10_, user0_.µØÖ· as µØÖ·10_, user0_.״̬ as ״̬10_, user0_.´´½¨ÈÕÆÚ as ´´½¨ÈÕÆÚ10_ from system.wz_user user0_ where user0_.Óû§Ãû='system' and user0_.ÃÜÂë='system'
Hibernate: select userrole0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ13_0_, userrole0_.½ÇÉ«Ãû³Æ as ½ÇÉ«Ãû³Æ13_0_, userrole0_.½ÇÉ«ÃèÊö as ½ÇÉ«ÃèÊö13_0_, userrole0_.½Çɫ״̬ as ½Çɫ״̬13_0_ from system.wz_userrole userrole0_ where userrole0_.½ÇÉ«±àºÅ=?
Hibernate: select sysrolerig0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ1_, sysrolerig0_.ȨÏÞ±àºÅ as ȨÏÞ±àºÅ1_, userright1_.ȨÏÞ±àºÅ as ȨÏÞ±àºÅ11_0_, userright1_.ȨÏÞ¸¸¼¶±àºÅ as ȨÏÞ¸¸¼¶±àºÅ11_0_, userright1_.ȨÏÞÀàÐÍ as ȨÏÞÀàÐÍ11_0_, userright1_.ȨÏÞ as ȨÏÞ11_0_, userright1_.ȨÏÞÁ¬½ÓµØÖ· as ȨÏÞÁ¬½ÓµØÖ·11_0_, userright1_.ȨÏÞÃèÊö as ȨÏÞÃèÊö11_0_ from system.wz_role_right sysrolerig0_ left outer join system.userright userright1_ on sysrolerig0_.ȨÏÞ±àºÅ=userright1_.ȨÏÞ±àºÅ where sysrolerig0_.½ÇÉ«±àºÅ=?
2010-4-12 14:41:38 org.apache.catalina.core.StandardWrapperValve invoke
ÑÏÖØ: Servlet.service() for servlet action threw exception
java.sql.SQLException: ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø

at oracl