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