连接人大金仓数据库之后KSQL查询问题

Sunner

数据库连接正常，也把数据库进行了初始化，项目也可以正常运行，进入组织机构或者角色管理时出现异常“不能确定参数类型”
ksql如下：
刷新数据失败！ 执行ksql:SELECT SA_OPOrg.*,SA_OPPerson as personID,SA_OPPerson.sName as personName,SA_OPPerson.sCode as personCode,SA_OPPerson.sNumb as personNumb,SA_OPPerson.sLoginName as personLoginName,SA_OPPerson.sPassword as personPassword,SA_OPPerson.sMainOrgID as personMainOrgID,SA_OPPerson.sIDCard as personIDCard,SA_OPPerson.sValidState as personValidState,SA_OPPerson.version as personVersion,SA_OPPerson.sSex as personSex,'' as ognName,'' as dptName,'' as posName FROM SA_OPOrg SA_OPOrg optional join SA_OPPerson SA_OPPerson on SA_OPOrg.sPersonID = SA_OPPerson WHERE ((1=0) AND (SA_OPOrg.sValidState = 1) AND (SA_OPOrg.sOrgKindID in ('ogn','dpt','pos','psm'))) ORDER BY SA_OPOrg.sSequence asc LIMIT 0, 20

初步断定为 人大金仓数据库无法将KSQL中的SA_OPPerson识别为SA_OPPerson.sId

这个怎么解决，大神求解！

jishuang

参考http://bbs.justep.com/forum.php? ... 4&pid=165004035把sql打出来看看

Sunner

jishuang 发表于 2013-10-15 15:04
参考http://bbs.justep.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035把sql打出来看 ...

我上面发的那段异常报告里就是sql语句

Sunner

jishuang 发表于 2013-10-15 15:04
参考http://bbs.justep.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035把sql打出来看 ...

sql语句打出来是：
SELECT  SA_OPOrg.SNAME AS sName, SA_OPOrg.SCODE AS sCode, SA_OPOrg.SLONGNAME AS sLongName, SA_OPOrg.sFName AS sFName, SA_OPOrg.SFCODE AS sFCode, SA_OPOrg.sFID AS sFID, SA_OPOrg.SORGKINDID AS sOrgKindID, SA_OPOrg.SSEQUENCE AS sSequence, SA_OPOrg.SVALIDSTATE AS sValidState, SA_OPOrg.sParent AS sParent, SA_OPOrg.SLEVEL AS sLevel, SA_OPOrg.SPHONE AS sPhone, SA_OPOrg.SFAX AS sFax, SA_OPOrg.SADDRESS AS sAddress, SA_OPOrg.SZIP AS sZip, SA_OPOrg.SDESCRIPTION AS sDescription, SA_OPOrg.SPERSONID AS sPersonID, SA_OPOrg.SNODEKIND AS sNodeKind, SA_OPOrg.VERSION AS version, ? AS ognName, ? AS dptName, ? AS posName, SA_OPPerson.sID AS personID, SA_OPPerson.SNAME AS personName, SA_OPPerson.SCODE AS personCode, SA_OPPerson.SNUMB AS personNumb, SA_OPPerson.SLOGINNAME AS personLoginName, SA_OPPerson.SPASSWORD AS personPassword, SA_OPPerson.SMAINORGID AS personMainOrgID, SA_OPPerson.SIDCARD AS personIDCard, SA_OPPerson.SVALIDSTATE AS personValidState, SA_OPPerson.VERSION AS personVersion, SA_OPPerson.SSEX AS personSex, SA_OPOrg.sID AS SA_OPOrg FROM SA_OPOrg SA_OPOrg LEFT JOIN SA_OPPerson SA_OPPerson ON SA_OPOrg.SPERSONID = SA_OPPerson.sID  WHERE  (SA_OPOrg.SORGKINDID <> ?) AND (SA_OPOrg.SVALIDSTATE = ?) AND (SA_OPOrg.sParent IS NULL)   ORDER BY SA_OPOrg.SSEQUENCE ASC

jishuang

把sql拿到人大金仓的数据库中执行一下看看

Sunner

jishuang 发表于 2013-10-15 15:24
把sql拿到人大金仓的数据库中执行一下看看

不行，在人大金仓数据库里，字段名都要加上""才能识别，不然会出这样的错误，可是x5平台自动执行的不是ksql么，而且sql也是自动生成的，怎么让它在生成sql的时候加上""号呢

jishuang

把as 以及取的别名都去掉

Sunner

jishuang 发表于 2013-10-15 16:44
把as 以及取的别名都去掉

嗯 我先弄弄 如果弄不好的话明天帮我远程看一下吧 谢谢

Sunner

jishuang 发表于 2013-10-15 16:44
把as 以及取的别名都去掉

去掉了也不行，唉，明天帮我远程一下吧，谢谢大神

jishuang

X5用的什么版本？