Hibernate Community • View topic - Formula with standard MySQL function

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Formula with standard MySQL function

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

dma_k

Post subject: Formula with standard MySQL function

Posted: Fri Dec 16, 2005 2:57 pm

Beginner

Joined: Sat Sep 17, 2005 6:50 am
Posts: 23

Hibernate version: 3.0.5

The mapping:

Code:

<property name="xmlOutputFormatEnabled" column="'xml' = lower(output_format)" type="boolean" />

produces the SQL:

Code:

this_.'xml' = lower(output_format) as column31_52_0_

while

Code:

<property name="xmlOutputFormatEnabled" column="lower(output_format) = 'xml'" type="boolean" />

produces the SQL:

Code:

this_.lower(output_format) = 'xml' as column31_52_0_

Both SQL samples are wrong, as soon as Hibernate puts a table alias before the string constant or the standart SQL function. I have checked up the Hibernate sources: the function is there:

Code:

./org/hibernate/dialect/MySQLDialect.java:55:           registerFunction("lower", new StandardSQLFunction("lower") );

Please, give a hint, how to use standard SQL function in formula-attribute like above.

Top

anar

Post subject:

Posted: Sat Dec 17, 2005 8:52 pm

Senior

Joined: Wed Jul 13, 2005 4:31 pm
Posts: 142
Location: Seattle, WA

I think you should be using

formula='lower(output_format)'

instead of column=...

Top

dma_k

Post subject:

Posted: Mon Dec 19, 2005 5:38 am

Beginner

Joined: Sat Sep 17, 2005 6:50 am
Posts: 23

Thank you very much! Of course, I've made a silly mistake.

Top

Page 1 of 1

[ 3 posts ]

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