Reading from SQL Server

[b rag]

I have a MS SQL Server DB I am reading data from and populating a bean.
I hace a DATETIME Field in the DB and I get a Classcast Exception when I try to read it off my ResultSet. If anybody can share the code of how to get around this, it would be very helpful.

(I never got this problem in Oracle's DATE datatype - rs.getDate(COLUMN_NAME))

[Steve Morrow]

Try java.sql.ResultSet.getTimestamp().

[Christopher Zinn]

I've run into various class-cast problems also with dates and timestamps in JDBC.

For me, most of my problems were because I had a java.util.Date on my bean and JDBC returns java.sql.Date (or Timestamp). (I know that java.sql.Date and Timestamp are subclasses of java.util.Date).

I use java.util.Date's only in my beans, and convert to and from Dates and Timestamps as needed when reading/writing to JDBC.

My code, generally looks like this:

...
 
MyBean record = new MyBean();
 
java.sql.Date sqlStartDate = results.getDate("START_DATE");
record.setStartDate(
     sqlStartDate == null ? 
     null : new java.util.Date(sqlStartDate.getTime()));
 
...

[Ernest Friedman-Hill]

Please stop posting new copies of this thread! Continue the discussion here.