Mapping Oracle DATE to java.sql.Date ?

[achana chan]

Hi I am getting inconsistent results in the the mapping.
Im the Oracle table, I have a date field which I retrieve using j2sdk1.4 getDate() method. Here is the code snippet from the applet :
[code]
...
import java.util.Date;
...
showHireDate(thisEmpRec.hiredate, HireDate);
...
public void showHireDate(Date hiredate, TextField HireDate)
{ HireDate.setText(hiredate.getDate() + "-" +
hiredate.getMonth() + "-" +
hiredate.getYear());
}
Sometimes, I get the correct display e.g. 21-12-91
Othertimes, I get odd results e.g. 21-7-102
I know it is deprecated, but it should work...

[achana chan]

Wrong forum again, Dirk moves me around so fast I get dizzy.
I tried something new, but get my typical "cannot resolve symbol" error:

import java.util.Date;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
...
String myDateFormat = "dd-MM-yyyy"; //
...
  if (thisOraRecord != null)
  { ...
    String sdte = toStringDate(thisOraRecord.hireDate, myDateFormat);
    ...
   }
...
public static string toStringDate(Date inputDate, String myDateFormat)
{
  String dteFmt = myDateFormat;
  SimpleDateFormat formattedDate = new SimpleDateFormat(dteFmt);
  return formattedDate.myDateFormat(inputDate);
}

javac throws this error
cannot resolve symbol
symbol : method myDateFormat (java.util.Date)
location : class java.text.SimpleDateFormat
return formattedDate.myDateFormat(inputDate);
^

One would think I should get the hang of JAVA after 4 months of JAVA-ing, but, no...

[achana chan]

Hi.
I spotted the error, should be

...
return formattedDate.format(inputDate);
...

Thanks anyway.