java.text.ParseException

[Rajkumar balakrishnan]

I am developing an web application for RMA and use AJAX to generate reports. So i am in need to send some values to some JSP file and receive the data from JSP page and displayed it in the Page using AJAX. Things getting better when i use string type as parameter. When i use the date as a parameter to the JSP page it shows an java.text.parseException in the console. Please let me know what's wrong i made with it.
Here is my code....Please help me friends...

This is the code where i get the parameters passed by AJAX....

: Edited :

[Rene Larsen]

What DO the input dates look like?? are they in the format "yyyy-MM-dd"??

[Rene Larsen]

I will also suggest that you use a PreparedStatement instead of a hard coded SQL.

Like this:

SELECT * FROM tbl_rmadetails WHERE date BETWEEN ? AND ?

otherwise you need to know the right date format of the database.

[Rajkumar balakrishnan]

Originally posted by Rene Larsen:
What DO the input dates look like?? are they in the format "yyyy-MM-dd"??

they are in this format "yyyy/MM/dd"
and using prepared statement is also no use////

[Rene Larsen]

Well then you have answered your own question...

"yyyy/MM/dd" and "yyyy-MM-dd" don't have the same format.

[Rajkumar balakrishnan]

Originally posted by Rene Larsen:
Well then you have answered your own question...

"yyyy/MM/dd" and "yyyy-MM-dd" don't have the same format.

But yyyy-MM-dd is the default date format in MySQL and so i use this..... How this go wrong...? Please explain me....

[Rene Larsen]

You are getting the ParseException when you call "DATE_FORMAT.parse(..)" with a date format different from the one you have configured DATE_FORMAT (SimpleDateFormat object) with, which has the format "yyyy-MM-dd" - and you said that your input date has the format "yyyy/MM/dd"

These two date formats are not the same - and they have to.

[Rajkumar balakrishnan]

Originally posted by Rene Larsen:
You are getting the ParseException when you call "DATE_FORMAT.parse(..)" with a date format different from the one you have configured DATE_FORMAT (SimpleDateFormat object) with, which has the format "yyyy-MM-dd" - and you said that your input date has the format "yyyy/MM/dd"

These two date formats are not the same - and they have to.

If i put the DATE_FORMAT as yyyy/MM/dd , then in MYSQL the date added like this.... 0000-09-21.... And this is displayed in report,,, I want the MySQL to store whatever format i like....Please give me some hints or code snippets to achieve this...

[Rene Larsen]

When you use a PreparedStatement and set the date(s) on it with '?', it will always match the database's date format. The 'date' field in the database have to be of type DATE or TIMESTAMP.

The input parameter 'q' and 'x' must match the pattern given to SimpleDateFormat.

String raj = request.getParameter("q");
String raj1 = request.getParameter("x");
 
SimpleDateFormat DATE_FORMAT = new SimpleDateFormat("yyyy-MM-dd");
DATE_FORMAT.setLenient(false); // DATE_FORMAT will now throw an exception if the String is not formatted right
 
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
    con = null; // get connection
 
    ps = con.prepareStatement("SELECT * FROM tbl_rmadetails WHERE date BETWEEN ? AND ?");
    ps.setDate(1, new java.sql.Date(DATE_FORMAT.parse(raj).getTime()));
    ps.setDate(2, new java.sql.Date(DATE_FORMAT.parse(raj1).getTime()));
 
    rs = ps.executeQuery();
 
    while (rs.next()) {
       /* iterate over ResultSet */
    }
} catch (Exception e) {
 
} finally {
    /* close 'ResultSet', 'PreparedStatement' and 'Connection' */
}

[Rajkumar balakrishnan]

Ok.... i got it..But here the monster comes... When i retrieve the date from db it displays in the default date format and how do i make it to display in dd/MM/yyyy format...?
Sorry for such silly questions because i am a beginner to this....
[ September 15, 2008: Message edited by: Rajkumar balakrishnan ]

[Rene Larsen]

You need to use the SimpleDateFormat object - or a new one with another pattern, and then use the 'format(java.util.Date)' method instead.

To get a 'java.util.Date' from a 'java.sql.Date', you can do it like this

java.util.Date d = rs.getDate("SOME_NAME");

[ September 15, 2008: Message edited by: Rene Larsen ]

[Rajkumar balakrishnan]

Originally posted by Rene Larsen:
You need to use the SimpleDateFormat object - or a new one with another pattern, and then use the 'format(java.util.Date)' method instead.

To get a 'java.util.Date' from a 'java.sql.Date', you can do it like this

java.util.Date d = rs.getDate("SOME_NAME");

SimpleDateFormat DATE_FORMAT = new SimpleDateFormat("dd/MM/yyyy");
DATE_FORMAT.setLenient(false);
while(rs.next())
{
java.util.Date d = rs.getDate("date");
%>
<tr bgcolor="#CCCCCC">
<td align="center"><%=d%></td>

So, where to put the format code here.... Please help me...

[Rajkumar balakrishnan]

Fix the problem.... Thanks Rene for your kind help and time for me....

I love Javaranch...