------------jsp---------------
<%@ page contentType="text/html;charset=gb2312" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<sql:setDataSource url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyCRM"
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
var="ds"/>
<sql:query var="results" sql="select caption from D_serviceTree" dataSource='${ds}'/>--------------------------error---------------------
HTTP Status 500 - type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]?? '(null)' ???????: ???? SQL Server ??????"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.jsp6_jsp._jspService(jsp6_jsp.java:72)
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)
root cause javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]?? '(null)' ???????: ???? SQL Server ??????"
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
org.apache.jsp.jsp6_jsp._jspx_meth_sql_query_0(jsp6_jsp.java:110)
org.apache.jsp.jsp6_jsp._jspService(jsp6_jsp.java:62)
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)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.27 logs.Apache Tomcat/5.0.27
--------------------------------
请指点一二,谢谢.
讲明白一些,加分.
<%@ page contentType="text/html;charset=gb2312" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<sql:setDataSource url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyCRM"
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
var="ds"/>
<sql:query var="results" sql="select caption from D_serviceTree" dataSource='${ds}'/>--------------------------error---------------------
HTTP Status 500 - type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]?? '(null)' ???????: ???? SQL Server ??????"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.jsp6_jsp._jspService(jsp6_jsp.java:72)
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)
root cause javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]?? '(null)' ???????: ???? SQL Server ??????"
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(QueryTagSupport.java:276)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(QueryTagSupport.java:159)
org.apache.jsp.jsp6_jsp._jspx_meth_sql_query_0(jsp6_jsp.java:110)
org.apache.jsp.jsp6_jsp._jspService(jsp6_jsp.java:62)
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)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.27 logs.Apache Tomcat/5.0.27
--------------------------------
请指点一二,谢谢.
讲明白一些,加分.
连接数据库失败,检查一下连接串写的对不对,数据库驱动有没有装对位置。