[show] java.sql.SQLException: Conversion failed when converting the nvarchar value
'index.html' to data type int.
javax.servlet.ServletException: org.springframework.dao.DataIntegrityViolationException:
SqlMapClient operation; SQL [];
--- The error occurred in com/infofoundry/dao/sql/BookstoreSQL.xml.
--- The error occurred while applying a parameter map.
--- Check the getBookSubjectCountBySubject-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Conversion failed when converting the
nvarchar value 'index.html' to data type int.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/infofoundry/dao/sql/BookstoreSQL.xml.
--- The error occurred while applying a parameter map.
--- Check the getBookSubjectCountBySubject-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Conversion failed when converting the
nvarchar value 'index.html' to data type int.
at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
at com.infofoundry.bookstore.requestFilter.BookstoreTilesRequestProcessor.process(BookstoreTilesRequestProcessor.java:26)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:95)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
at com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.java:112)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:293)
at com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:111)
at org.tuckey.web.filters.urlrewrite.Rule.handleAction(Rule.java:133)
at com.infofoundry.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:135)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:169)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.infofoundry.urlrewrite.UriHistoryFilter.doFilter(UriHistoryFilter.java:154)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.infofoundry.cas.AcceptOfferedTicketFilter.doFilter(AcceptOfferedTicketFilter.java:18)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:192)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:436)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662)
at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.dao.DataIntegrityViolationException: SqlMapClient
operation; SQL [];
--- The error occurred in com/infofoundry/dao/sql/BookstoreSQL.xml.
--- The error occurred while applying a parameter map.
--- Check the getBookSubjectCountBySubject-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Conversion failed when converting the
nvarchar value 'index.html' to data type int.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/infofoundry/dao/sql/BookstoreSQL.xml.
--- The error occurred while applying a parameter map.
--- Check the getBookSubjectCountBySubject-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Conversion failed when converting the
nvarchar value 'index.html' to data type int.
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:114)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
at com.bentleylib.dao.SqlMapBaseDAO.getObject(SqlMapBaseDAO.java:87)
at com.infofoundry.bookstore.BookstoreService.getBookSubjectCountBySubject(BookstoreService.java:501)
at com.infofoundry.struts.bookstore.actions.LoadResourcePageAction.execute(LoadResourcePageAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
at com.infofoundry.bookstore.requestFilter.BookstoreTilesRequestProcessor.process(BookstoreTilesRequestProcessor.java:26)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:95)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
at com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.java:112)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:293)
at com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:111)
at org.tuckey.web.filters.urlrewrite.Rule.handleAction(Rule.java:133)
at com.infofoundry.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:135)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:169)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.infofoundry.urlrewrite.UriHistoryFilter.doFilter(UriHistoryFilter.java:154)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.infofoundry.cas.AcceptOfferedTicketFilter.doFilter(AcceptOfferedTicketFilter.java:18)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:192)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:436)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662)
at java.lang.Thread.run(Unknown Source)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/infofoundry/dao/sql/BookstoreSQL.xml.
--- The error occurred while applying a parameter map.
--- Check the getBookSubjectCountBySubject-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: Conversion failed when converting the
nvarchar value 'index.html' to data type int.
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
at com.bentleylib.dao.SqlMapBaseDAO.getObject(SqlMapBaseDAO.java:87)
at com.infofoundry.bookstore.BookstoreService.getBookSubjectCountBySubject(BookstoreService.java:501)
at com.infofoundry.struts.bookstore.actions.LoadResourcePageAction.execute(LoadResourcePageAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
at com.infofoundry.bookstore.requestFilter.BookstoreTilesRequestProcessor.process(BookstoreTilesRequestProcessor.java:26)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:95)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
at com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.java:112)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:293)
at com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:111)
at org.tuckey.web.filters.urlrewrite.Rule.handleAction(Rule.java:133)
at com.infofoundry.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:135)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:169)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.infofoundry.urlrewrite.UriHistoryFilter.doFilter(UriHistoryFilter.java:154)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.infofoundry.cas.AcceptOfferedTicketFilter.doFilter(AcceptOfferedTicketFilter.java:18)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:192)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:436)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Conversion failed when converting the
nvarchar value 'index.html' to data type int.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.isDataInResultSet(TdsCore.java:795)
at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:146)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:609)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:559)
at com.caucho.sql.UserPreparedStatement.execute(UserPreparedStatement.java:124)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
at com.bentleylib.dao.SqlMapBaseDAO.getObject(SqlMapBaseDAO.java:87)
at com.infofoundry.bookstore.BookstoreService.getBookSubjectCountBySubject(BookstoreService.java:501)
at com.infofoundry.struts.bookstore.actions.LoadResourcePageAction.execute(LoadResourcePageAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
at com.infofoundry.bookstore.requestFilter.BookstoreTilesRequestProcessor.process(BookstoreTilesRequestProcessor.java:26)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:95)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103)
at com.caucho.server.webapp.DispatchFilterChain.doFilter(DispatchFilterChain.java:112)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:293)
at com.caucho.server.webapp.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:111)
at org.tuckey.web.filters.urlrewrite.Rule.handleAction(Rule.java:133)
at com.infofoundry.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:135)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:169)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.infofoundry.urlrewrite.UriHistoryFilter.doFilter(UriHistoryFilter.java:154)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.infofoundry.cas.AcceptOfferedTicketFilter.doFilter(AcceptOfferedTicketFilter.java:18)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:192)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:436)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662)
at java.lang.Thread.run(Unknown Source)