Java SQL Time error in Constructor

[Kevin Olome]

Hello, I have an oracle database application.

There the constructor of an auction is:

public Auction(int auctionsID, DATE starttime, DATE endtime,
			double startprice, double differentialamount){...}

I can't somehow use the Constructor to create the object.

rset is the ResultSet:

while (rset.next()) {
						returnCollection.add(new Auction(
						rset.getInt(1),
						new java.sql.Date(rset.getDate(2).getTime()),
						new java.sql.Date(rset.getDate(3).getTime()),
						rset.getDouble(4),rset.getDouble(5)));
			}

I tried to convert java.util.date to java.sql.date but somehow the constructor does not recognize the new "sql" date.

The IDE wants that I change the java constructor to java.util.date

[Dave Tolls]

What is the DATE class in your constructor?
Or is that a typo?

[Kevin Olome]

It was a wrong Import.
I used oracle.sql.DATE;
and not java.sql.Date.

Is there a difference? Between the both Date's? I know that java.sql.Date and java.util.Date are different but between oracle and java?

Thanks for your answer,. It already solved my problem

[Dave Tolls]

java.sql.Date and java.util.Date are alsmost the same (the sql one is a subclass of the util one).

The oracle.sql.DATE is completely different and is (I believe) used by Oracles JDBC driver to do the conversion from the Oracle DATE/TIMESTAMP etc to the Java Date classes.