How can I solve IllegalArgumentException

[Elahe Shafie]

I am facing this error
"String: java.lang.IllegalArgumentException"
and don't know how can I solve it?any advice or hint would be appriciated.
Many thanks,
Elahe

package com.srs.bugtrack.model;
import java.sql.*;
public class Bug {
  public static final String DBFLD_NUMBER = "bugNumber";
  private int bugNumber;
  public static final String DBFLD_FIXED = "fixedDate";
  private Date fixedDate;
  public static final String DBFLD_DESC = "bdesc";
  private String desc;
  public static final String DBFLD_CONTACT = "contact";
  private String contact;
  public static final String DBFLD_SUBMITTED = "submittedDate";
  private Date submittedDate;
  public static final String DBFLD_STATUS = "ID";
  private String status;
  /** Holds value of property userInitials. */
  public static final String DBFLD_USER = "userID";
  private String userInitials;
  public Bug() {
  }
  public String getStatus() { return status; }
  public void setStatus(String s) { status=s; }
  public String getDesc() { return desc;}
  public void setDesc(String desc){ this.desc=desc;}
  public String getContact() { return contact;}
  public void setContact(String acontact){ contact=acontact;}
  public int getBugNumber() { return bugNumber;}
  public void setBugNumber(int abugNumber){ bugNumber=abugNumber;}
  public Date getFixedDate() { return fixedDate;}
  public void setFixedDate(Date afixedDate){ fixedDate=afixedDate;}
  public Date getSubmittedDate() { return submittedDate;}    
  public void setSubmittedDate(Date asubmittedDate){ submittedDate=asubmittedDate;}
  /** Getter for property userInitials.
   * @return Value of property userInitials.
   */
  public String getUserInitials() {
    return userInitials;
  }
  /** Setter for property userInitials.
   * @param userInitials New value of property userInitials.
   */
  public void setUserInitials(String userInitials){
    this.userInitials = userInitials;
  }
  /** Update the database with the new value of the bug.
   * @throws SQLException if bug, user, or status does not exist
   */
  public void update( Connection conn ) throws SQLException {
    int nUserId;
    int nStatusId;
    
    nStatusId = StatusTable.lookupName( conn, status );
    nUserId = UserTable.lookupUserInitials( conn, userInitials );
      
    PreparedStatement stmt = conn.prepareStatement("update bug set ID=?,bdesc=?,fixedDate=?,userID=?,contact=? where bugNumber=?");
    stmt.setInt(1,nStatusId);
    stmt.setString(2,desc);
    stmt.setDate(3,fixedDate);
    stmt.setInt(4,nUserId);
    stmt.setString(5,contact);
    stmt.setInt(6,bugNumber);
    stmt.executeUpdate();
    stmt.close();
    
    return;
  }
 /** Insert into the database */
   public void insertBug(Connection conn ) throws SQLException {
    int nUserId=0;
    int nStatusId=0;
    int ID =1;
    
    PreparedStatement stmt =conn.prepareStatement("insert into bug values (?,?,?,?,?,?,?)");
    stmt.setInt(1,ID); 
    stmt.setString(2,desc);
    stmt.setDate(3,submittedDate);
    stmt.setDate(4,fixedDate); 
    stmt.setInt(5,nUserId); 
    stmt.setString(6,contact);
    stmt.setInt(7,bugNumber); 
    
    stmt.executeUpdate();
    
    stmt.close();
    
    return;
   }
} // eoc

[Rob Ross]

On what line number is the exception being thrown? Can you please lable that in your source code?

[Jim Yingst]

...and then, assuming it comes from one of the stmt.setInt(), setString(), setDate(), etc. methods - look up the declared type of that column in the database, and compare it to the type you're asking for. Use this table to see if the method you're using makes sense, and let us know what you come up with.

[Elahe Shafie]

DearRob and Jim,
Thanks for your input the problem was just format of date and I have to enter fixedDate like this format 2002/2/2 instead of 2002-2-2 (in table fixedDate is date type)
any way to solve this problem I like to show user fixedDate with this format 2002/2/2 and here is my part of code but it gives me this error:
Any advice?
Many thanks,
Elahe
Incompatible type for =. Can't convert String to Date.
dDate = formatter.format(dDate);
^
1 error
----Code-----
java.sql.Date dDate= null;
while (rs.next()) {
C_BugList xobj=new C_BugList();
xobj.setName(rs.getString("name")); SimpleDateFormat formatter = new SimpleDateFormat("yy/M/d");
dDate = rs.getDate("fixedDate");
dDate = formatter.format(dDate);
xobj.setFixedDate(dDate);
v.addElement(xobj);
}

[Jamie Robertson]

Elahe: just a reminder that java.util.Date and java.sql.Dates do not have formatting. They are actually a long value that counts the milliseconds from a point in time. This being said, there are a couple of problems with this line of code:
since dDate is a java.sql.Date, your argument for SimpleDateFormat.format( java.util.Date ) of the wrong type. To fix this, convert dDate to a java.util.Date before you format it to a String. The second part that is wrong is that SimpleDateFormat.format( java.util.Date ) method returns a String object. You have a java.sql.Date accepting the String as a return value. To correct this part, create a String to hold the formatted date on the return of the method:

String string_date = formatter.format( new java.util.Date( dDate.getTime() ) );

but I think the problem is in your concept of a date. A date object has no format, it is only a number. When you need to display a date, you create a visual representation ( String representation ) of the date to display it. You determine the way the date will be visually represented in this string by using a SimpleDateFormat object to parse the date value into the representation you want. This also works in the reverse way. If you have a visual representation of a date ( such as user input ), and you want to convert it to a date object (to write to the database or something), you define how the date is represented in the string using a SimpleDateFormat object, then you use this SimpleDateFormat object to convert your visual representation of the date into an actual date object. Again, I must stress that the date object you just created has no formatting, it is only a number.
Jamie

[Elahe Shafie]

Dear Jamie THANK YOU SO MUCH for you useful information and your absolutly right I hope I can get ride of this task finaly so soon...
Jamie I want to forget use all those and make it simple and read from table and put slash between and show user that's it because I know if I put slash(/) it will work(I hope...)
Just could you please correct me if I am wrong is sintax?
Many thanks,
Elahe
----------
S2=2002-04-09
s2 = (s1.substring(1,4)).concat("/").concat(s1.substring(6,2)).concat("/").concat(s1.substring(9,2));
and then I will update you about the result...

[Jamie Robertson]

Jamie I want to forget use all those and make it simple and read from table and put slash between and show user that's it because I know if I put slash(/) ...
----------
S2=2002-04-09
s2 = (s1.substring(1,4)).concat("/").concat(s1.substring(6,2)).concat("/").concat(s1.substring(9,2));
and then I will update you about the result...

OK here's the code set --> if table column is of type Date:

ResultSet rs = statement.executeQuery("select date_column....");
while ( rs.next() )
{
//read from table:
java.sql.Date sql_date = rs.getDate( "date_column" );
//convert sql date to util date
java.util.Date util_date = new java.util.Date( sql_date.getTime() );
//create the formatted date String for viewing:
SimpleDateFormat sdf = new SimpleDateFormat( "yyyy/M/d" );
String formatted_date_string = sdf.format( util_date );
//use the formatted_date_string as you please...
}

OK here's the code set --> if table column is of type String in the format: "yyyy-MM-dd" ( 2002-04-09 )

ResultSet rs = statement.executeQuery("select string_column....");
while ( rs.next() )
{
//read from table:
String string_date = rs.getString( "string_column" );
//parse in the string date to create a util date object
SimpleDateFormat sdf = new SimpleDateFormat( "yyyy-MM-dd" );
java.util.Date util_date = sdf.parse ( string_date );
//re-format the util date with the new pattern "yyyy/M/d"
sdf.applyPattern( "yyyy/M/d" );
string_date = sdf.format( util_date );
//string_date is now in the format of "yyyy/M/d"
//use the formatted_date_string as you please...
}

good luck, Jamie

[Elahe Shafie]

Jamie I guess I am almost close with your BIG HELP
just I don't know how can I convert "formatted_date_string" to date type since "FixedDate" is date type...and I guess I am done...
Again thanks for your big help,
Elahe

  
 while (rs.next()) {
  C_BugList xobj=new C_BugList();
  java.sql.Date sql_date= rs.getDate("fixedDate");
  java.util.Date util_date = new java.util.Date(sql_date.getTime() );
  SimpleDateFormat sdf = new SimpleDateFormat("yyyy/M/d");
  String formatted_date_string = sdf.format(util_date);
//I have to convert string to date..? 
 xobj.setFixedDate(formatted_date_string);
v.addElement(xobj);
      }

[Elahe Shafie]

Jamie for my answer I used:
java.util.Date myDate=sdf.parse(formatted_date_string);
xobj.setFixedDate(myDate);
in my code to convert but it gives me this error:
Exception java.text.ParseException must be caught, or it must be declared in the throws clause of this method
java.util.Date myDate=sdf.parse
(formatted_date_string);
^
1 error
how can I solve this?
Thanks,
Elahe

while (rs.next()) {
C_BugList xobj=new C_BugList(); 
java.sql.Date sql_date= rs.getDate("fixedDate");  java.util.Date util_date = new java.util.Date(sql_date.getTime() );
SimpleDateFormat sdf = new SimpleDateFormat("yyyy/M/d");  
String formatted_date_string = sdf.format(util_date);
java.util.Date myDate=sdf.parse(formatted_date_string); 
xobj.setFixedDate(myDate);
v.addElement(xobj);
      }

[Elahe Shafie]

Sorry for too much forwarded okay I added this catch as well no I don't have any error but it didn't the template to show data...
Any advice?
Thanks,
Elahe
catch( Exception x ) {
formatted_date_string = "-";
}

[Elahe Shafie]

Let me update you when I debug the program it stopped right before this line and catch thrown...
SimpleDateFormat sdf = new SimpleDateFormat("yyyy/M/d");
Any advice?!!!
Elahe

[Elahe Shafie]

Okay Jamie I guess I fixed those part and now "formatted_date_string" has a value like 2002/3/15 but I really don't know how can I convert it to date and put it back since "setSubmittedDate" is date type I need to convet would you please help me on this part?(what a day...whole day I was on this issue..)
Mant thanks,
Elahe

while (rs.next()) {
C_BugList xobj=new C_BugList();
xobj.setSubmittedDate(rs.getDate("submittedDate"));
java.sql.Date sql_date= rs.getDate("submittedDate");
java.util.Date util_date = new java.util.Date(sql_date.getTime());
SimpleDateFormat sdf = new SimpleDateFormat("yyyy/M/d");
formatted_date_string = sdf.format(util_date);
System.out.println("formatted_date_string" + formatted_date_string);
//I have to convert it to date type and then...
xobj.setSubmittedDate(formatted_date_string);
xobj.setStatus(rs.getString("text"));
v.addElement(xobj);
}

[Jamie Robertson]

Originally posted by elahe shafie:
Okay Jamie I guess I fixed those part and now "formatted_date_string" has a value like 2002/3/15 but I really don't know how can I convert it to date and put it back since "setSubmittedDate" is date type I need to convet would you please help me on this part?(what a day...whole day I was on this issue..)

From the above information it seems to me that you don't need to convert this to a string at all. if setSubmittedDate takes a java.util.Date as an input parameter, just skip the conversion of the date to a string:

while (rs.next()) {
C_BugList xobj=new C_BugList();
xobj.setSubmittedDate(rs.getDate("submittedDate"));
java.sql.Date sql_date= rs.getDate("submittedDate");
java.util.Date util_date = new java.util.Date(sql_date.getTime());
SimpleDateFormat sdf = new SimpleDateFormat("yyyy/M/d");
formatted_date_string = sdf.format(util_date);
System.out.println("formatted_date_string" + formatted_date_string);
//I have to convert it to date type and then...
//we already have it as a date from above ( the
//date that created your formatted_date_string )
//if the date is actually a java.sql.Date then use
//the sql_date variable instead of util_date
xobj.setSubmittedDate( [B]util_date[/B] );
xobj.setStatus(rs.getString("text"));
v.addElement(xobj);
}

if you do not use the formatted_date_string for anything, you can just remove that code until you need to display the date in some sort of format

while (rs.next()) 
{
C_BugList xobj=new C_BugList();
xobj.setSubmittedDate(rs.getDate("submittedDate"));
java.sql.Date sql_date= rs.getDate("submittedDate");
java.util.Date util_date = new java.util.Date(sql_date.getTime());
//set the submitted date to the date taken from the
//database ( it has no formatting because it is a date! )
xobj.setSubmittedDate( [B]util_date[/B] );
xobj.setStatus(rs.getString("text"));
v.addElement(xobj);
}

if you need to display the submittedDate in a certain format, then you use the SimpleDateFormat when you need to display it. But as of right now in your code, it looks like you don't need it.
Jamie
[ April 24, 2002: Message edited by: Jamie Robertson ]

[Elahe Shafie]

Dear Jamie I am speechless and odn't know how you figured out my confusion and solved it!!! BIG BIG THANKS.
I am done with the date issue now it is working what wa that!!! my God.
Many many Thanks,
Elahe

[Elahe Shafie]

And thanks every body.

[Jamie Robertson]

bet you won't get stuck on that one again! I'm glad you solved it, and learned how to avoid it in the future! You'll have to help the next person with this problem

[Elahe Shafie]

Sure Jamie I will.We have to help each other...
Have great evening,
Elahe