calendar object in preparedStatement

[Heather]

I have an object and its attribute is calendar type, now I want to run a query in database, so I create a preparedStatement, in the data base there is a field who its type is date.

But this error appears in the red line:


cannot find symbol

in interface preparedStatement
method setDate(int, java.util.Calendar)

 
Calendar d = new GregorianCalendar();
 d.set(2007,6,6);
String insertEvent = "INSERT INTO EVENTS(DATE,TYPE,COMMENT) VALUES(?,?,?);";
  ConnectionSingleton connection = ConnectionSingleton .getInstance();
  PreparedStatement preparedInsert = connection.getConnection().prepareStatement(insertEvent);
    [COLOR="Red"]    preparedInsert.setDate(1,ev.getDate().getTime());  [/COLOR]
        preparedInsert.setString(2,ev.getType());
  preparedInsert.setString(3,ev.getComment());

[Peter]

If you read API, the method getTime() of calendar class returns a java.util.Date
According to API the method setDate() of the interface PreparedStatement receive a java. sql.Date

I think that is the problem

[Jack]

Have you read the documentation?
What brings you rs.getDate?
What are your constructors for calendar?

[Heather]

thanks peter, you're right