title: Connecting JSP with MS SQL Server
body: <p>I am writing a JSP to retrieve data from the SQL server and i am getting the following error.  </p>
  
  <blockquote>
    <p>org.apache.jasper.JasperException: An exception occurred processing
    JSP page /connectiontoserver.jsp at line 10</p>
    
    <p>9:    10: &lt;%
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");</p>
  </blockquote>
  
  <p>JSP code that i created is:</p>
  
  <pre><code>&lt;% Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433/signin");
      Statement statement = con.createStatement() ; 
  ResultSet resultset = statement.executeQuery("select username from signintable") ;
  %&gt;
  </code></pre>