我用HIBERNATE HQL左外连接时,HIBERNATE生成的语句是:
select * from ( select sysenterpr0_.ENTERPRISEID as ENTERPRI1_35_0_, sysmember1_.USERID as USERID60_1_, sysenterpr0_.USERID as USERID35_0_, sysenterpr0_.COMMERCENUM as COMMERCE3_35_0_, sysenterpr0_.FIRMNAME as FIRMNAME35_0_, sysenterpr0_.COUNTRY as COUNTRY35_0_, sysenterpr0_.PROVINCE as PROVINCE35_0_, sysenterpr0_.CITY as CITY35_0_, sysenterpr0_.EMAIL as EMAIL35_0_, sysenterpr0_.QQ as QQ35_0_, sysenterpr0_.LOGO as LOGO35_0_, sysenterpr0_.SIGN as SIGN35_0_, sysenterpr0_.CHARTERPIC as CHARTERPIC35_0_, sysenterpr0_.PHONE as PHONE35_0_, sysenterpr0_.MOBILE as MOBILE35_0_, sysenterpr0_.FAX as FAX35_0_, sysenterpr0_.POSTCODE as POSTCODE35_0_, sysenterpr0_.CHARTER as CHARTER35_0_, sysenterpr0_.CONTACTER as CONTACTER35_0_, sysenterpr0_.ADDRESS as ADDRESS35_0_, sysenterpr0_.NETWORK as NETWORK35_0_, sysenterpr0_.ACCOUNTBANK as ACCOUNT21_35_0_, sysenterpr0_.ACCOUNTER as ACCOUNTER35_0_, sysenterpr0_.ACCOUNT as ACCOUNT35_0_, sysenterpr0_.TYPE as TYPE35_0_, sysenterpr0_.INTRO as INTRO35_0_, sysmember1_.USERNAME as USERNAME60_1_, sysmember1_.PASSWORD as PASSWORD60_1_, sysmember1_.TYPE as TYPE60_1_, sysmember1_.COMMERCENUM as COMMERCE5_60_1_, sysmember1_.APPLYDATE as APPLYDATE60_1_, sysmember1_.UPDATETIME as UPDATETIME60_1_, sysmember1_.UPDATETYPE as UPDATETYPE60_1_, sysmember1_.PRINTER as PRINTER60_1_, sysmember1_.STATE as STATE60_1_, sysmember1_.VOUCH as VOUCH60_1_, sysmember1_.ISOLDPRODUCE as ISOLDPR12_60_1_, sysmember1_.OLDTYPE as OLDTYPE60_1_, sysmember1_.PASSDATE as PASSDATE60_1_ from HKXY_TEST.SYSENTERPRISE sysenterpr0_ left outer join HKXY_TEST.SYSMEMBER sysmember1_ on sysenterpr0_.USERID=sysmember1_.USERID where 1=1 and sysmember1_.VOUCH=1 ) where rownum <= ?但是运行的时候发生 javax.el.ELException: can't convert 'sysmember' to long.异常,请问一下是什么原因造成的?
select * from ( select sysenterpr0_.ENTERPRISEID as ENTERPRI1_35_0_, sysmember1_.USERID as USERID60_1_, sysenterpr0_.USERID as USERID35_0_, sysenterpr0_.COMMERCENUM as COMMERCE3_35_0_, sysenterpr0_.FIRMNAME as FIRMNAME35_0_, sysenterpr0_.COUNTRY as COUNTRY35_0_, sysenterpr0_.PROVINCE as PROVINCE35_0_, sysenterpr0_.CITY as CITY35_0_, sysenterpr0_.EMAIL as EMAIL35_0_, sysenterpr0_.QQ as QQ35_0_, sysenterpr0_.LOGO as LOGO35_0_, sysenterpr0_.SIGN as SIGN35_0_, sysenterpr0_.CHARTERPIC as CHARTERPIC35_0_, sysenterpr0_.PHONE as PHONE35_0_, sysenterpr0_.MOBILE as MOBILE35_0_, sysenterpr0_.FAX as FAX35_0_, sysenterpr0_.POSTCODE as POSTCODE35_0_, sysenterpr0_.CHARTER as CHARTER35_0_, sysenterpr0_.CONTACTER as CONTACTER35_0_, sysenterpr0_.ADDRESS as ADDRESS35_0_, sysenterpr0_.NETWORK as NETWORK35_0_, sysenterpr0_.ACCOUNTBANK as ACCOUNT21_35_0_, sysenterpr0_.ACCOUNTER as ACCOUNTER35_0_, sysenterpr0_.ACCOUNT as ACCOUNT35_0_, sysenterpr0_.TYPE as TYPE35_0_, sysenterpr0_.INTRO as INTRO35_0_, sysmember1_.USERNAME as USERNAME60_1_, sysmember1_.PASSWORD as PASSWORD60_1_, sysmember1_.TYPE as TYPE60_1_, sysmember1_.COMMERCENUM as COMMERCE5_60_1_, sysmember1_.APPLYDATE as APPLYDATE60_1_, sysmember1_.UPDATETIME as UPDATETIME60_1_, sysmember1_.UPDATETYPE as UPDATETYPE60_1_, sysmember1_.PRINTER as PRINTER60_1_, sysmember1_.STATE as STATE60_1_, sysmember1_.VOUCH as VOUCH60_1_, sysmember1_.ISOLDPRODUCE as ISOLDPR12_60_1_, sysmember1_.OLDTYPE as OLDTYPE60_1_, sysmember1_.PASSDATE as PASSDATE60_1_ from HKXY_TEST.SYSENTERPRISE sysenterpr0_ left outer join HKXY_TEST.SYSMEMBER sysmember1_ on sysenterpr0_.USERID=sysmember1_.USERID where 1=1 and sysmember1_.VOUCH=1 ) where rownum <= ?但是运行的时候发生 javax.el.ELException: can't convert 'sysmember' to long.异常,请问一下是什么原因造成的?
解决方案 »
- 一个关于decode 函数的问题 求教
- Web工程部署问题
- 大虾们帮帮忙~我的boolean b=stmt.execute() b怎么返回false,我这段程序那里错了
- 求教,情况紧急,请struts高手进来,拉兄弟一把
- javabean怎么获取不到cookie的时间
- 如何通过循环将<logic:iterate>中循环的内容填写到ActionForm的JAVA Bean中,在线等待,着急啊!!!
- jsp中服务器的行为
- 高手别见笑呀!下面是我总结的一点关于服务器 RESIN ,TOMCAT,WEBLOGIC 中的一些JSP和CLASS文件配置.请多多指教.
- 在jsp中有没有办法执行客户端程序?
- AOP -- XML配置的一个问题
- 大家帮我解释下“面向接口编程”这句话吧,进者有分
- AJAX中文问题
String abc = new String();
abc=sysmember;