Oracle Interval Datatype

mahikty · **Posted:** Mon Aug 29, 2005 3:52 pm

How do i map Interval datatype in Hibernate Mapping.
I encountered errors if i use long or string.

Any thoughts are highly appreciated.

Hibernate version:
3.01.
Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

mahikty · **Posted:** Mon Aug 29, 2005 4:45 pm

Only String works, rest of them does not work.

tads · **Posted:** Fri Sep 15, 2006 3:33 pm

Hi,

I´m using Hibernate 2.1.4 with Oracle 9.

I´m trying to use Interval data type, and I create a TO com String
data type attribute to represents the interval, like this:

Code:

Class:

public class OsTO implements Serializable 
{
   private Long id;
   
   private Calendar nextExecutionDate;
   
   private String executionDsFrequency;
   
   private String executionYmFrequency;
.
.
.
}

Mapping file:

<hibernate-mapping>
    <class name="ta.j2ee.sitename.model.to.OsTO" table="os_test">
        <id name="id" column="os_id">
         <generator class="assigned"/>
      </id>    
        <property name="nextExecutionDate" column="NEXT_EXECUTION_DT"/>        
        <property name="executionDsFrequency" column="EXECUTION_DS_FREQ"/>        
        <property name="executionYmFrequency" column="EXECUTION_YM_FREQ"/>
    </class>   
</hibernate-mapping>

The table is like this:

Code:

Nome                                      Nulo?    Tipo
----------------------------------------- -------- ----------------------------
OS_ID                                              NUMBER(10)
NEXT_EXECUTION_DT                                  DATE
EXECUTION_DS_FREQ                                  INTERVAL DAY(2) TO SECOND(6)
EXECUTION_YM_FREQ                                  INTERVAL YEAR(2) TO MONTH

What do I must to do to mapping Intervals?

thanx!!!!