Javatpoint Logo

insert date exception, sql Exception

By: vinay9*** On: Mon Apr 20 17:40:33 IST 2015     Question Reputation0 Answer Reputation0 Quiz Belt Series Points0  0Blank User
Exception in code :
java.text.ParseException: Unparseable date: "2015-04-14T00:00:00+05:30"
org.postgresql.util.PSQLException: No value specified for parameter 6.
at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:216)


try
{
System.out.println("enteed date "+user.getDob());
SimpleDateFormat format = new SimpleDateFormat();
java.util.Date utildate = format.parse("dd/MM/yyyy");
System.out.println("utildate "+utildate);
System.out.println(format.format(utildate));
java.sql.Date sqldate=new java.sql.Date(utildate.getTime());
String date=user.getDob();
System.out.println("sql "+date);
stmt.setDate(6, sqldate);
}
catch(Exception e){System.out.println(e);}
stmt.setInt(7, user.getId());
status = stmt.executeUpdate();
System.out.println(status+" records updated");
}catch(Exception e){e.printStackTrace();}
Up0Down