求助急jdbc 数据库连不上去!
不知道为什么啊! jdbc-odbc能连!但下面这个就报异常
------------------------------------下面是Pubs.jsp--------------------------------------------------
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1" import="java.util.*,accp.*,java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<table>
<tr>
<td>Author ID</td>
</tr>
<%
PubsBean bean=new PubsBean();
ArrayList<String> ids=bean.getIDs();
for(String id:ids)
{
//out.print("<tr><td><a href='show.jsp?au_id="+id+"'>"+id+"</a></td></tr>");
//out.print("<tr><td>"+id+"</td></tr>");
out.print("<tr><td><a href='show.jsp?"+id+"'>"+id.substring(id.indexOf("=")+1,id.indexOf("&"))+"</a></td></tr>");
}
%>
</table>
</body>
</html>
---------------------------------------下面是PubsBean类------------------------------------------------
package accp;
import java.awt.List;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
public class PubsBean {
Connection conn=null;
Statement stat=null;
ResultSet rset=null;
public ArrayList<String> getIDs() throws Exception
{
ArrayList<String> ids=new ArrayList<String>();
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:19888;DatabaseName=pubs","sa","sa");
stat=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rset=stat.executeQuery("select au_id,au_fname,au_lname from authors");
while(rset.next())
ids.add("au_id="+rset.getString(1)+"&au_fullname="+rset.getString(2)+"."+rset.getString(3));
rset.close();
stat.close();
conn.close();
return ids;
}
public String getFullNameById(String id) throws Exception
{
String fullname="";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:19888;DatabaseName=pubs","sa","sa");
stat=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rset=stat.executeQuery("select au_fname+'.'+au_lname from authors where au_id='"+id+"'");
rset.next();
fullname=rset.getString(1);
rset.close();
stat.close();
conn.close();
return fullname;
}
----------------------------------报的异常-----------------------------------------------
严重: Servlet.service() for servlet jsp threw exception
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at accp.PubsBean.getIDs(PubsBean.java:18)
at org.apache.jsp.pubs_jsp._jspService(pubs_jsp.java:70)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
谢谢高手指教!
[解决办法]
确定你的端口是19888？？？
看看数据库服务启动了没有
确定下数据库有没有打sp4补丁
。。。
