KSQL join 出错

WolfFang

业务模块想和system的SA_OPPerson联查，已经在业务data的model中加入了<include>/system/data</include>
测试ksql时，报错如下。
其中kpi是业务模块名称。

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT  KPI_DETAIL.KPI_TYPE AS kpi_type, KPI_DETAIL.KPI_NUMBER AS kpi_number, KPI_DETAIL.KPI_NAME AS kpi_name, SA_OPPerson.SNAME AS sName FROM KPI_DETAIL KPI_DETAIL JOIN SA_OPPerson SA_OPPerson ON KPI_DETAIL.USER_ID = SA_OPPerson.SCODE  WHERE KPI_DETAIL.KPI_REF_ID =  ? ), binds: [83D8AA88D5924D6F8D4BB5C66ED9A933]出错
    at com.justep.exception.BusinessException.create(Unknown Source)
    at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
    ... 31 more
Caused by: java.sql.SQLException: Table 'kpi.sa_opperson' doesn't exist
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    ... 32 more

fengwei

表不存在  你去数据库看下有这个表吗'kpi.sa_opperson

jishuang

参考http://bbs.justep.com/forum.php? ... 7&pid=165051043

WolfFang

jishuang 发表于 2014-4-9 11:50
参考http://bbs.justep.com/forum.php?mod=redirect&goto=findpost&ptid=56627&pid=165051043

非常感谢，看来跨库查询要特别注意。这个问题已经解决了。