I am getting exception which is as follow -
Exception[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedjava.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
This is exception is coming when I am trying to login from by JSP page and my Login.java file contain following code I already created the DSN by name ITMNGMNT
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
Connection c=null;
String loginid=request.getParameter("loginid");
String pswd=request.getParameter("pswd");
response.setContentType("text/html");
HttpSession session=request.getSession(true);
PrintWriter out = response.getWriter();
try{
Class.forName(getContext("Driver"));
c= DriverManager.getConnection(getContext("Url"),getContext("User"),getContext("Password"));
Statement st =c.createStatement();
String query = new String("select * from Customer where loginid='" +loginid+ "' and pswd='"+pswd+"'");
System.out.println("Query :"+query);
ResultSet rs= st.executeQuery(query);
if(rs.next()){
session.setAttribute("Member",loginid);
response.sendRedirect("index.jsp");
} else {
request.setAttribute("Response","Invalid User name and password");
getServletContext().getNamedDispatcher("member").forward(request,response);
}
}
catch(Exception e){
out.println("Exception"+e.getMessage()+e.toString());
}....
My WEB_INF contain following instructions -
...
<web-app>
<context-param>
<param-name>Driver</param-name>
<param-value>sun.jdbc.odbc.JdbcOdbcDriver</param-value>
</context-param>
<context-param>
<param-name>Url</param-name>
<param-value>jdbc:odbc:ITMNGMNT</param-value>
</context-param>
<context-param>
<param-name>User</param-name>
<param-value>grandtour</param-value>
</context-param>
<context-param>
<param-name>Password</param-name>
<param-value>grandtour</param-value>
</context-param>
<servlet>
<servlet-name>UserLogin</servlet-name>
<servlet-class>Login</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>UserLogin</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>member</servlet-name>
<jsp-file>/Pages/Login.jsp</jsp-file>
</servlet>
<servlet-mapping>
<servlet-name>member</servlet-name>
<url-pattern>/members</url-pattern>
</servlet-mapping> ...
Aucun commentaire:
Enregistrer un commentaire