unable to connect to MS Sqlserver thru jsp
Hello Sir,
I tried to fetch the data from MS Sql server 2000 database.
i put the sqldriver related jar files under lib dir correctly.
when i browse the jsp
it throws this error:
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]End of stream was detected on a read.
my code is:
<html>
<head>
<title>Content DashBoard</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<%
Connection con;
//try{
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//}catch(ClassNotFoundException e){out.print(e.getMessage()+"<br>");}
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://localhost:8080;DatabaseName=trax;User=;Password=");
Statement stmt = conn.createStatement();
ResultSet columns = stmt.executeQuery("select * from content");
while(columns.next())
{
String provider = columns.getString("content");
String batchId = columns.getString("ID");
String status = columns.getString("Status");
%>
<%=provider%>
<%=batchId%>
<%=status%>
<%}%>
