The conversion from LocalDateTime to the database form is going via DateTime, which is using the time zone.
Ideally PersistentLocalDateTime should handle this, although exactly what it should do is open to question. Stephen D.M. wrote: > When attempting to save a LocalDateTime to the database, I am > receiving an error (included below). My database is Oracle 10g, in > UTC. My java client is 1.6+, and is running in U.S. Central time > zone. The time which fails to insert is LocalDateTime(2008,3,9,2,30). > This time, in the local time zone of the java client, exists in the > DST cutover where 2:00 becomes 3:00. When toDateTime() is called from > within PersistentLocalDateTime.nullSafeSet(), the instant cannot be > created because that instant does not exist in the U.S. Central time > zone. > > So, is this behaving as intended, or is it a bug? The description of > LocalDateTime from the javadoc is "a datetime without a time zone". > Is there an additional implication (as the name of the class would > seem to indicate) that the LocalDateTime occurs in the local time zone > of the client that creates it? Or should a client be able to save a > LocalDateTime object to the database that represents a local time > somewhere other than the client's default time zone? > > The error is: > java.lang.IllegalArgumentException: Illegal instant due to time zone > offset transition: 2008-03-09T08:30:00.000 > at > org.joda.time.chrono.ZonedChronology.localToUTC(ZonedChronology.java:143) > at > org.joda.time.chrono.ZonedChronology.getDateTimeMillis(ZonedChronology.java:119) > at > org.joda.time.chrono.AssembledChronology.getDateTimeMillis(AssembledChronology.java:133) > at org.joda.time.base.BaseDateTime.<init>(BaseDateTime.java:254) > at org.joda.time.DateTime.<init>(DateTime.java:293) > at org.joda.time.LocalDateTime.toDateTime(LocalDateTime.java:634) > at org.joda.time.LocalDateTime.toDateTime(LocalDateTime.java:619) > at > org.joda.time.contrib.hibernate.PersistentLocalDateTime.nullSafeSet(PersistentLocalDateTime.java:99) > at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:146) > at > org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997) > at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2243) > at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660) > at > org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56) > at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) > at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) > at > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) > > ------------------------------------------------------------------------------ > Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are > powering Web 2.0 with engaging, cross-platform capabilities. Quickly and > easily build your RIAs with Flex Builder, the Eclipse(TM)based development > software that enables intelligent coding and step-through debugging. > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com > _______________________________________________ > Joda-interest mailing list > Joda-interest@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/joda-interest > ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Joda-interest mailing list Joda-interest@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/joda-interest
