Java. SQL. sqlexception reported in ibatis: Invalid column type exception

Error Message

Description the server encountered an internal error () that prevented it from fulfilling This  Request. exceptionorg. springframework. Web. util. nestedservletexception: Request Processing failed; Nested exception is org. springframework. JDBC. uncategorizedsqlexception: sqlmapclient operation; uncategorized sqlexception  For SQL []; SQL State [ Null ]; Error code [17004 ]; --- The error occurred While  Applying a parameter map. --- Check the ESS. viewapply. getesspersonalinfolist- Inlineparametermap. --- Check the parameter mapping For The 'dept _ no' Property. --- Cause: Java. SQL. sqlexception: Invalid column type; Nested exception is com. ibatis. Common. JDBC. Exception. nestedsqlexception: --- The error occurred While  Applying a parameter map. --- Check the ESS. viewapply. getesspersonalinfolist- Inlineparametermap. --- Check the parameter mapping For The 'dept _ no' Property. ---Cause: Java. SQL. sqlexception: Invalid column type org. springframework. Web. servlet. frameworkservlet. processrequest (frameworkservlet. Java: 894 ) Org. springframework. Web. servlet. frameworkservlet. doget (frameworkservlet. Java: 778 ) Javax. servlet. http. httpservlet. Service (httpservlet. Java: 617 ) Javax. servlet. http. httpservlet. Service (httpservlet. Java: 717 ) COM. Ait. Web. Filter. userauthenfilter. dofilter (userauthenfilter. Java: 77 ) Org. springframework. Web. Filter. characterencodingfilter. dofilterinternal (characterencodingfilter. Java: 88) Org. springframework. Web. Filter. onceperrequestfilter. dofilter (onceperrequestfilter. Java: 76)

Key Point XML SQL

 
<![CDATA [and exists (select * From hr_department B1 where b1.deptno = B. deptno start with b1.deptno =# Dept_no #Connect by prior b1.deptno = b1.parent _ dept_no)]]>
 

Parameter Value passing

{Interlanguage = ZH, intercpnyid = C11, orderfield =, orderdirection = ASC, specialparam =Special, ar_supervisior_info= 30044292, userno = 36911,Deptno= C114, Admin_id = 30044292, created_by = 30044292, updated_by = 30044292, person_id = 30044292, cpny_id = C11}
 

Public class viewapplyserimpl implements viewapplyser {

Line 55 parammap. Put ("dept_no", admin. getdeptno ());

Problem

The parameter names in the yellow part do not match

Therefore