Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2

I am trying to use a function in the formula tag in an object, but while execution it appends the table name as alias for that function by which it fails to execute the query.

Ex:
@hibernate.class table="TTABLE"
...
...
@hibernate.property formula="(SELECT MYFUNC FROM DUAL)"
public String get..() {
...
}
public void set..() {
..
}

while execution the query looks as follows:
SELECT ttable.id, (select ttable.MYFUNC from dual) from ttable

instead of
SELECT ttable.id, (select MYFUNC from dual) from ttable

Any suggestion regarding this would be appreciated.

Thank you
Prasasd

Specify the schema in your formula. For SQLServer, this would be
For postgres, it would be I'm not sure about other DBs.

Thank you tenwit, that works if we qualify the function with scema name.