------解决方法--------------------------------------------------------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)
