本帖最后由 Jarod 于 2014-6-6 19:20 编辑
【R2.5-sp10 19962】打开我的工作报错
23:24:59,555 INFO AbstractDocStaticTblDAO:2721 - MS SQL Server: SELECT COUNT(*)
FROM (SELECT DISTINCT * FROM (select pen.docid from (select distinct docid,flo
wid from DBO.T_NODERT,(select nodert_id from DBO.T_ACTORRT where actorid = '11e3
-cac4-d1defee0-835b-87ed365c68ca' and actor.pending = 1) as tba where id=tba.nod
ert_id) fs,DBO.T_FLOW_INTERVENTION pen where fs.docid = pen.docid UNION select p
en.docid from (select distinct docid,flowid from DBO.T_RELATIONHIS,(select nodeh
is_id from DBO.T_ACTORHIS where actorid = '11e3-cac4-d1defee0-835b-87ed365c68ca'
) as tba where id=tba.nodehis_id) fs,DBO.T_FLOW_INTERVENTION pen,DBO.T_DOCUMENT
doc where fs.docid = pen.docid and fs.docid = doc.id) tab ) table_0
java.sql.SQLException: 无法绑定由多个部分组成的标识符 "actor.pending"。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement
.java:477)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPrep
aredStatement.java:777)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Dele
gatingPreparedStatement.java:93) |