there is an exception in inserting date into database
String Fname= request.getParameter("txtfname"); String Lname= request.getParameter("txtlname"); String Uname=request.getParameter("txtuname"); String Pass=request.getParameter("txtpass"); String Email=request.getParameter("txtemail"); String Gender=request.getParameter("group1"); String Add=request.getParameter("txtadd"); java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime()); //out.println(""+Fname+Lname+Uname+Pass+Email+Gender+Add); Connection con= null; //if(Fname != null && Lname != null && Uname != null && Pass != null && Email != null && Gender != null && Add != null) try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:SQL","sa","mith1234"); String insert="insert into sign_up values(?,?,?,?,?,?,?,?)"; PreparedStatement ps= con.prepareStatement(insert); ps.setString(1,Fname); ps.setString(2,Lname); ps.setString(3,Uname); ps.setString(4,Pass); ps.setString(5,Email); ps.setString(6,Gender); ps.setString(7,Add); ps.setDate(8,sqlDate); // ps.setDate(9, null); int rt= ps.executeUpdate(); Cookie c= new Cookie("Cuname", Uname); response.addCookie(c); response.sendRedirect("Home.jsp"); } catch(ClassNotFoundException e) { out.println("Class not found :"+e.getMessage()); } catch(SQLException s) { out.println("Sql exception: "+s.getMessage()); } catch(Exception ex) { out.println(ex); } }
Exception: Sql exception: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented