这个错误信息是什么意思？

Question

type Exception reportmessagedescription The server encountered an internal error () that prevented it from fulfilling this request.exceptionjavax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]???????? varchar ????? money ??????? 'Web.dbo.book_info'?? 'price'????? CONVERT ?????????
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.do_005fadmadd_jsp._jspService(do_005fadmadd_jsp.java:89)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)root causejava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]???????? varchar ????? money ??????? 'Web.dbo.book_info'?? 'price'????? CONVERT ?????????
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.executeUpdate(Unknown Source)
org.apache.jsp.do_005fadmadd_jsp._jspService(do_005fadmadd_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)note The full stack trace of the root cause is available in the Tomcat logs.

Answer 1

我知道是什么错误了，我把money类型改成varchar就可以了，不过这样的话对数据库会有影响吗

Answer 2

我的意思是说money类型可以用varchar替代吗，如果可以会不会产生数据写入不了的影响？

Answer 3

money改成varchar那要该好多代码啊

Answer 4

可以代替的
org.apache.jsp.do_005fadmadd_jsp._jspService(do_005fadmadd_jsp.java:89)
org.apache.jsp.do_005fadmadd_jsp._jspService(do_005fadmadd_jsp.java:70) 你先查查上面2处 看提示是字段类型不符合 再则插入的时候是乱码？？？？？
???????? varchar ????? money ??????? 'Web.dbo.book_info'?? 'price'????? CONVERT ?????????