Hibernate Community • View topic - How to declare an index with an sql function

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to declare an index with an sql function

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

emerout

Post subject: How to declare an index with an sql function

Posted: Wed Mar 19, 2008 11:35 am

Newbie

Joined: Wed Mar 19, 2008 11:19 am
Posts: 1

Hibernate version:
3.2.5GA

Mapping documents:

Code:

@Entity
@Table(appliesTo="SessionInst", 
  indexes = {@Index(name="year_idx", columnNames="extract(year from dateChargement)")})
public class SessionInst {
...
}

Full stack trace of any exception that occurs:

Code:

org.hibernate.MappingException: Unable to find column with logical name: SessionInst.extract(year from datechargement)
        at org.hibernate.cfg.Mappings.getPhysicalColumnName(Mappings.java:493)
        at org.hibernate.cfg.IndexSecondPass.addIndexToColumn(IndexSecondPass.java:49)
        at org.hibernate.cfg.IndexSecondPass.doSecondPass(IndexSecondPass.java:39)

Name and version of the database you are using:
Oracle 10g

Question
Is it possible to declare an index built with an sql function ?

This declaration is valid in Oracle :

Code:

create index year_idx on SessionInst (extract(year from dateChargement));

How to declare it in hbm mapping ?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum