在做javaweb时,用到ibatis老报sql错误,但是把解析出来的弄到mysql中又可以得到想要的数据，请问这是怎么回事?

[qq272936993]

querySQL:

select job.ID as jid,job.MEMEO as jmemeo,job.CONFIG_PATH as jconfigPath,job.JOB_XML as jjobXml,conf.SQL_CONTENT as csqlCoilentent,input.FILE_NAME as ifileName,exp.FILE_NAME as efileName,exp.FILE_PATH as efPath,conf.TIME_LAG as ctimeLag,syscode.isValidator_Id as jisValidateId,syscode.isValidator_Name as jisValidatorName,syscode.type_Id as jTypeId,syscode.type_Name as jTypeName,syscode.cycle_Id as ccycleId,syscode.cycle_Name as ccycleName 

    from 

    (select cycle.cjobName as cycle_Name,cycle.cjobId as cycle_Id,type.cjobName as type_Name,type.cjobId as type_Id,validator.cjobName as isValidator_Name,validator.cjobId as isValidator_Id 

      from (

        select codes.ITEM_NAME as cjobName,codes.ITEM_VALUE as cjobId from mng.t_sys_codeset as codeset,mng.t_sys_code as codes where codeset.ID=codes.CS_ID and codeset.CN_NAME='任务周期' and codes.ITEM_VALUE='1'

       ) as cycle,

       (

        select codes.ITEM_NAME as cjobName,codes.ITEM_VALUE as cjobId from mng.t_sys_codeset as codeset,mng.t_sys_code as codes where codeset.ID=codes.CS_ID and codeset.CN_NAME='任务类型' and codes.ITEM_VALUE='0'

       ) as type,

       (

        select codes.ITEM_NAME as cjobName,codes.ITEM_VALUE as cjobId from mng.t_sys_codeset as codeset,mng.t_sys_code as codes where codeset.ID=codes.CS_ID and codeset.CN_NAME='是否模式' and codes.ITEM_VALUE='1'

       ) as validator

    )as syscode,MNG.T_HADOOPETL_JOB as job,mng.t_cloudetl_jobconf as conf,mng.t_cloudetl_jobinput as input,mng.t_cloudetl_jobexp as exp 

    where 1=1 and job.ID=conf.JOB_ID and job.ID=input.JOB_ID and job.ID=exp.JOB_ID and job.IS_VALIDATE=syscode.isValidator_Id and job.JOB_TYPE = syscode.type_Id and conf.CYCLE=syscode.cycle_Id and job.ID =32

错误是:


org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar


com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as validator )as syscode,mng.t_hadoopetl_job as job,mng.t_cloudetl_jobconf ' at line 1



求高手帮忙解答....

[javastatic]

你的sql语句有错，复查一下

[qq272936993]

不是我的Sql写错了...发现是内部封装程序对分页的sql有所改变