当前位置: 代码迷 >> Java Web开发 >> [分享]jsp连接数据库大全
  详细解决方案

[分享]jsp连接数据库大全

热度:226   发布时间:2005-11-08 16:34:00.0

----------------解决方案--------------------------------------------------------
顶.......
----------------解决方案--------------------------------------------------------

不错,我们现在正在JSP实训呢,今天才看见,谢谢!!


----------------解决方案--------------------------------------------------------
DING
----------------解决方案--------------------------------------------------------

感觉java对中文的支持实在有问题,我现在在弄一个东西,数据库是由linux下的mysql提供的,编码采用utf8,结果我怎么在java中转换都不能转换成功,真郁闷


----------------解决方案--------------------------------------------------------
很不错的说
----------------解决方案--------------------------------------------------------
good
----------------解决方案--------------------------------------------------------

我试过,好像不行啊。


----------------解决方案--------------------------------------------------------
我用JSP连接SQL Server 2000 会出现如下问题:

HTTP Status 500 -


type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
	org.apache.jsp.testsqlserver_jsp._jspService(testsqlserver_jsp.java:86)
	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

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
	com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
	com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
	com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
	com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
	com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
	com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
	java.sql.DriverManager.getConnection(DriverManager.java:512)
	java.sql.DriverManager.getConnection(DriverManager.java:171)
	org.apache.jsp.testsqlserver_jsp._jspService(testsqlserver_jsp.java:52)
	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.28 logs.


Apache Tomcat/5.0.28


----------------解决方案--------------------------------------------------------
不知道是什么原因啊?谁可以帮帮我啊,本人感激不尽啊!!!
----------------解决方案--------------------------------------------------------
  相关解决方案