Oracle and java.sql.Date

[rafonso]

Hello:

I am using JBoss 3.0.4 with Oracle 9i. In Oracle I have a table with a column DATE. I created a CMP entity from this table (I lie, it was JBuilder that created). My DATE column generated a java.sql.Date attribute. When I create a new bean, I insert a Date object (like 2002-01-28 17:26:30, for example). When I get this created bean, Date attribute has day but not hour (like 2002-01-28 0:00:00.0). In database is the same thing. Can anyone explain this? How do I correct this?

Thanks,

Rafael U. C. Afonso

[h2o_polo]

I do not think java.sql.Date stores the time.
Make jbuilder generate either java.util.Date, or java.sql.Timestamp (I think)

[rafonso]

According java.sql.date definition (see http://java.sun.com/j2se/1.3/docs/api/java/sql/Date.html): "To conform with the definition of SQL DATE, the millisecond values wrapped by a java.sql.Date instance must be 'normalized' by setting the hours, minutes, seconds, and milliseconds to zero in the particular time zone with which the instance is associated.". So hours were zeroed by java.sql.Date itself.
I changed attribute type from java.sql.Date to java.sql.Timestamp (see http://java.sun.com/j2se/1.3/docs/api/java/sql/Timestamp.html). Now hours are regisred correctly. Actually, according

Thanks,

Rafael U. C. Afonso

[rafonso]

h2o_polo:

You are right. I changed my attribute type to java.sql.Timestamp and now hours are registered.

Thanks,

Rafael U. C. Afonso