当你使用WEB浏览器调用存储过程时,且时GET方式并且含有中文信息,存储过程有可能会返回如下错误信息
Transcoding failure.STP: A failure occurred in execution set up in context.
解决办法:
找到storedprocess WEB所在目录,更改如下文件:
web-inf/web.xml
把其中的输出编码改为中文编码即可,如GB2312,如下:
<servlet>
<servlet-name>
storedprocessservlet
</servlet-name>
<servlet-class>
com.sas.services.storedprocess.webapp.StoredProcessServlet
</servlet-class>
<init-param>
<param-name>InputEncoding</param-name>
<!--
<param-value>utf-8</param-value>
-->
<param-value>GB2312</param-value>
</init-param>
<init-param>
<param-name>OutputEncoding</param-name>
<!--
<param-value>utf-8</param-value>
-->
<param-value>GB2312</param-value>
</init-param>
<init-param>
<param-name>AuthMechanism</param-name>
<param-value>host</param-value>
</init-param>
</servlet>