（SQL报错）DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null

whht195444

如题：
select *
from (select rownumber() over() as rownumber_, INNER_QUERY_PREFIX.* FROM (SELECT
b.medical_treatment_link_id, a.list_number, a.medical_name, a.sort, a.spec,
  a.unit, a.betake_genre, b.restrictions_drugs, 1 as medical_management_id,
   COALESCE(b.liable_expense, a.liable_expense) liable_expense, COALESCE(
   b.remark, a.remark) remark, COALESCE(b.update_time, a.update_time)
    update_time, c.employee_name FROM t_medical_treatment_list a LEFT OUTER JOIN
     t_medical_treatment_link b ON (a.list_number = b.list_number and
      b.medical_management_id = 1) LEFT OUTER JOIN t_employee c ON c.employee_id
       = b.update_employee_id) INNER_QUERY_PREFIX) as temp_
where rownumber_ between 0 + 1 and  70
在DB2中执行，没有问题，

以下是我用JDBC执行的SQL
[2009-12-19 14:48:51] DEBUG: java.sql.PreparedStatement:27 - {pstm-100004} Executing Statement:
select * from ( select rownumber() over() as rownumber_, INNER_QUERY_PREFIX.* FROM (         SELECT b.medical_treatment_link_id, a.list_number, a.medical_name, a.sort,         a.spec, a.unit, a.betake_genre, b.restrictions_drugs,         ? as medical_management_id,         COALESCE (b.liable_expense, a.liable_expense) liable_expense,         COALESCE (b.remark, a.remark) remark,         COALESCE (b.update_time, a.update_time) update_time, c.employee_name         FROM t_medical_treatment_list a LEFT OUTER JOIN t_medical_treatment_link b         ON (a.list_number = b.list_number  and b.medical_management_id=?)         LEFT OUTER JOIN t_employee c ON c.employee_id = b.update_employee_id     ) INNER_QUERY_PREFIX ) as temp_ where rownumber_ between ?+1 and ?
[2009-12-19 14:48:51] DEBUG: java.sql.PreparedStatement:27 - {pstm-100004} Parameters: [1, 1, 0, 75]
[2009-12-19 14:48:51] DEBUG: java.sql.PreparedStatement:27 - {pstm-100004} Types: [java.lang.Integer, java.lang.Integer, java.lang.Integer, java.lang.Integer]

执行后报错：
[14:48:51.546] {http--80-3$15223454} --- The error occurred while applying a parameter map.  
[14:48:51.546] {http--80-3$15223454} --- Check the MedicalTreatmentLinkDAOIbatisImpl.getMedicalLinkAll-InlineParameterMap.  
[14:48:51.546] {http--80-3$15223454} --- Check the statement (query failed).  
[14:48:51.546] {http--80-3$15223454} --- Cause: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null

请师兄门，提供宝贵意见

在线等

biti.vector

?+1换成?， java传值的时候+1

unixnewbie

个人认为是这个“？”

b.restrictions_drugs,         ? as medical_management_id

select list中不能有“？”吧

whht195444

对，结果集里，不能传参数

itpubblossom

Parameter markers can never be used:

    * in a statement that is not a prepared statement
    * in the fullselect of a CREATE VIEW statement
    * in the triggered action of a CREATE TRIGGER statement
    * in a query captured by DB2 Query Patroller

The statement cannot be processed.

User Response: Correct the syntax of the statement. If untyped parameter markers are not allowed, use the CAST specification to give the parameter marker a data type.

这是DB2的错误信息中摘出来的。
我觉得是结果集里的“？”出的问题。