org.springframework.web.util.NestedServletException: Request processing failed,jpetstore异常
发布时间:2010-06-05 12:24:34 文章来源:www.iduyao.cn 采编人员:星星草
------解决方法--------------------------------------------------------sql-schema.sql//网上有的说是3个导入文件,只见过两个
更改jdbc.properties对应数据库,
在samples\jpetstore\attributes运行warfile,在dist生成jpetstore.war,
布署到tomcat5.5 webapp下
有个页面可以访问,有的不可以,郁闷.明显就是数据库异常,找了很久也不知道怎么解决,网上能查都做了
HTTP Status 500 -
type Exception report
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1000]; error code [0];
--- The error occurred in org/springframework/samples/jpetstore/dao/ibatis/maps/Item.xml.
--- The error occurred while applying a parameter map.
--- Check the getItemListByProduct-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Unknown type '246 in column 1 of 14 in binary-encoded result set.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in org/springframework/samples/jpetstore/dao/ibatis/maps/Item.xml.
--- The error occurred while applying a parameter map.
--- Check the getItemListByProduct-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Unknown type '246 in column 1 of 14 in binary-encoded result set.
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:411)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:354)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1000]; error code [0];
--- The error occurred in org/springframework/samples/jpetstore/dao/ibatis/maps/Item.xml.
--- The error occurred while applying a parameter map.
--- Check the getItemListByProduct-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Unknown type '246 in column 1 of 14 in binary-encoded result set.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in org/springframework/samples/jpetstore/dao/ibatis/maps/Item.xml.
--- The error occurred while applying a parameter map.
--- Check the getItemListByProduct-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Unknown type '246 in column 1 of 14 in binary-encoded result set.
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:196)
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:219)
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:266)
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。
其他相似内容:
-
我在页面上用 <s:datetimepicker name = "start_time" displayFormat = "yyyy-MM-dd"/>做日期选择器,当提交以后,在action返回...
-
ERROR 1064(42000) You have an error in your SQL syntax:check the corresponds to your MySQL server version for the rig...
-
我将代码贴出来
目录结构
自定义异常:
PasswordException.java
Java code
package exception;
public cla...
-
黑莓blackberry联网时候在Connector.open(url)时候报错:
java.io.IOException:Credentials do not exist的错
我不管...
-
出现 org.apache.jasper.JasperException 异常
代码如下:
File reportFile = new File(application.getRealPath("/rep...
-
面试老头问我:系统在运行时出现异常怎么处理?(就是系统已经做好了,在使用时出现异常)
回答:要和用户有好的交互。
问: 这...
-
初学struts,用的是struts(用的版本是1.2.9),开发工具是tomcat6.0,myeclipse7.0
我明明已经引入了struts包,可是还是在tomcat启动...
-
想手动搭建SSH2框架,编译的时候报如下错误(包是从利用myeclipse7.5搭建成功的LIB目录下COPY过来的)
错误如下:
严重: Excep...
-
此问题如下:
在公司程序中,有可能web服务器的内存小了,出现java.lang.OutOfMemoryError
本人检查了程序,有以下几行认为会...
-
抛异常:
public class ExceptionTest {
public static Integer i = 0;
public static void main(String[] args...