I have SQL Server 2005 installed on my server machine and SQl server 2005 client component on my client machine...now I want to connect to the database placed at server using JSP remotely....I have installed JDBC Driver for SQL Server 2005 on my machine bcoz I want to connect to SQL Server remotely.......Now I have written code in JSP as
Code:
<%@page import="java.sql.*"%>
<%!public Connection con = null;%>
<%
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.10.5:1433","sa","123456");
}catch(ClassNotFoundException ce){out.println(ce);}
%>
But when I run the page I got error as
Quote:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:370)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:362)
root cause
java.lang.NullPointerException
org.apache.jsp.index_jsp._jspService(index_jsp.jav a:89)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:362)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
|
Kindly help me what to do bcoz I am new to JSP and SQL Server
SQL SERVER 2005 + JSP
