SmartFilter 使用报错

ssoqyhm

如果查询动作是多张表关联的时候使用SmartFilter 报错查询失败！

fpj

报错？报什么错，将TOMCAT信息发一下看看。

ssoqyhm

fpj 发表于 2014-5-14 19:51
报错？报什么错，将TOMCAT信息发一下看看。

系统拼接KSQL 语法错了，好像没辙了

ssoqyhm

ssoqyhm 发表于 2014-5-14 20:52
系统拼接KSQL 语法错了，好像没辙了

开始报Tomcat错误 现在没有了 没法截信息，不过界面错一样的。  保存数据失败

ssoqyhm

ssoqyhm 发表于 2014-5-14 20:53
开始报Tomcat错误 现在没有了 没法截信息，不过界面错一样的。  保存数据失败 ...

{"code":"JUSTEP323000","message":"数据查询出错"}  是这个错误

fpj

打印一下KSQL看一下；
贴一下TOMCAT中信息，以及你的代码，帮你分析一下。

ssoqyhm

fpj 发表于 2014-5-15 08:20
打印一下KSQL看一下；
贴一下TOMCAT中信息，以及你的代码，帮你分析一下。

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT  StorageItemBatch.STOREOBJECT AS storeObject, StorageItemBatch.STORAGENO AS storageNo, StorageItemBatch.STORAGENAME AS storageName, StorageItemBatch.STORAGETYPE AS storageType, StorageItemBatch.FLOORNO AS floorNo, StorageItemBatch.ITEMNO AS itemNo, StorageItemBatch.ITEMDESCRIBE AS itemDescribe, StorageItemBatch.RATIONSIZE AS rationSize, StorageItemBatch.UNITCODE AS unitCode, StorageItemBatch.UNITNAME AS unitName, StorageItemBatch.FACTORYNO AS factoryNo, StorageItemBatch.FACTORYNAME AS factoryName, StorageItemBatch.ENTERPRISENO AS enterpriseNo, StorageItemBatch.ENTERPRISENAME AS enterpriseName, StorageItemBatch.USERID AS userId, StorageItemBatch.QUANTITYL AS quantityL, StorageItemBatch.PIECEQUANTITYL AS pieceQuantityL, StorageItemBatch.BATCHNO AS batchNo, StorageItemBatch.VERSION AS version, BatchItem.FIRSTSTOREDATE AS firstStoreDate, BatchItem.PRODUCEDATE AS produceDate, BatchItem.VALIDDATE AS validDate, BatchItem.CHECKOUTAGAINDATE AS checkoutAgainDate, BatchItem.LASTCHECKDATE AS lastCheckDate, BatchItem.BRAND AS brand, BatchItem.PLACEORIGIN AS placeOrigin, BatchItem.MANUFACTURER AS manufacturer, BatchItem.BATCHDESCRIBE AS batchDescribe, BatchItem.ITEMWEIGHT AS itemWeight, BatchItem.PRODUCENO AS produceNo, BatchItem.WORKCENTERNO AS workCenterNo, BatchItem.ROUTINGNO AS routingNo, BatchItem.PROCEDURENO AS procedureNo, BatchItem.PROCEDURENAME AS procedureName, StorageItemBatch.fID AS StorageItemBatch FROM StorageItemBatch StorageItemBatch LEFT JOIN BatchItem BatchItem ON  (StorageItemBatch.BATCHNO = BatchItem.BATCHNO) AND (StorageItemBatch.ITEMNO = BatchItem.ITEMNO)   WHERE  ( ( ( ( ( (UPPER(storageNo) LIKE ?) OR (UPPER(storageName) LIKE ?) ) OR (UPPER(itemNo) LIKE ?) ) OR (UPPER(itemDescribe) LIKE ?) ) OR (UPPER(enterpriseName) LIKE ?) ) OR (UPPER(batchNo) LIKE ?) ) AND (StorageItemBatch.QUANTITYL <> ?) ), binds: [%11%, %11%, %11%, %11%, %11%, %11%, 0]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 31 more
Caused by: java.sql.SQLException: 列名 'itemNo' 不明确。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 32 more

ssoqyhm

ssoqyhm 发表于 2014-5-15 08:33
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT  Sto ...

错误的select

select StorageItemBatch.*,BatchItem.firstStoreDate as firstStoreDate,BatchItem.produceDate as produceDate,BatchItem.validDate as validDate,BatchItem.checkoutAgainDate as checkoutAgainDate,BatchItem.lastCheckDate as lastCheckDate,BatchItem.brand as brand,BatchItem.placeOrigin as placeOrigin,BatchItem.manufacturer as manufacturer,BatchItem.batchDescribe as batchDescribe,BatchItem.itemWeight as itemWeight,BatchItem.produceNo as produceNo,BatchItem.workCenterNo as workCenterNo,BatchItem.routingNo as routingNo,BatchItem.procedureNo as procedureNo,BatchItem.procedureName as procedureName
    from StorageItemBatch StorageItemBatch
     optional  join BatchItem BatchItem on StorageItemBatch.batchNo = BatchItem.batchNo AND StorageItemBatch.itemNo = BatchItem.itemNo

ssoqyhm

ssoqyhm 发表于 2014-5-15 08:34
错误的select

select StorageItemBatch.*,BatchItem.firstStoreDate as firstStoreDate,BatchItem.prod ...

select StorageItemBatch.*
    from StorageItemBatch StorageItemBatch

这样就OK

fpj

ssoqyhm 发表于 2014-5-15 08:35
select StorageItemBatch.*
    from StorageItemBatch StorageItemBatch

你检查一下这个列  itemNo 名称是否正确？

在KSQL中概念名与关系名是区分大小写的；