hi.
who can help me.
when I update a table i get this error.
javax.servlet.ServletException: Database error in EmbeddedData.fetchData java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.jsp.po.request_005fdetail_005fupdate_jsp._jspService(request_005fdetail_005fupdate_jsp.java:903)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.dbforms.servlets.Controller.process(Controller.java:356)
org.dbforms.servlets.Controller.doPost(Controller.java:107)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.dbforms.util.external.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:190)
root cause
javax.servlet.jsp.JspException: Database error in EmbeddedData.fetchData java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
org.dbforms.taglib.EmbeddedData.doStartTag(EmbeddedData.java:307)
org.apache.jsp.jsp.po.request_005fdetail_005fupdate_jsp._jspService(request_005fdetail_005fupdate_jsp.java:529)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.dbforms.servlets.Controller.process(Controller.java:356)
org.dbforms.servlets.Controller.doPost(Controller.java:107)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.dbforms.util.external.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:190)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi.
who can help me.
when I update a table i get this error.
javax.servlet.ServletException: Database error in EmbeddedData.fetchData java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.jsp.po.request_005fdetail_005fupdate_jsp._jspService(request_005fdetail_005fupdate_jsp.java:903)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.dbforms.servlets.Controller.process(Controller.java:356)
org.dbforms.servlets.Controller.doPost(Controller.java:107)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.dbforms.util.external.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:190)
root cause
javax.servlet.jsp.JspException: Database error in EmbeddedData.fetchData java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
org.dbforms.taglib.EmbeddedData.doStartTag(EmbeddedData.java:307)
org.apache.jsp.jsp.po.request_005fdetail_005fupdate_jsp._jspService(request_005fdetail_005fupdate_jsp.java:529)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.dbforms.servlets.Controller.process(Controller.java:356)
org.dbforms.servlets.Controller.doPost(Controller.java:107)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.dbforms.util.external.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:190)
Write a test program to access the driver directly. If the error happens again you have an driver problem
Henner
I'm use ms jdbc drivers.
If this problem happens again .
What jdbc is good dirver for ms sqlserver2000?
I do not know. I am not working with ms sqlserver.
Please write this question to the mailing list
Henner
I use jtds, it's fast, reliable and open source.
This is the adress:
http://jtds.sourceforge.net/
bye
Luigi
Thank you !