Hibernate Community • View topic - Dynamic instatiation with native sql function

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Dynamic instatiation with native sql function

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

mguillem

Post subject: Dynamic instatiation with native sql function

Posted: Tue Dec 07, 2004 1:26 pm

Newbie

Joined: Fri Mar 26, 2004 8:41 am
Posts: 9

Hibernate version: 2.1.7c

Name and version of the database you are using: MySql 4.0.21

I'm trying to use dynamic instantiation to generate some reports and have problem using native sql function in the select clause.

Tracking the problem, I use 2 constructor

Code:

MyClass(somefields)

and

Code:

MyClass(somefields, Object o)

Using

Code:

select new MyClass(..., sum(60*60)) from ...

the 2nd constructor is used with Integer 3600 as parameter what is correct.

Using

Code:

select new MyClass(..., sum(UNIX_TIMESTAMP(EndDate))) from ...

the 1st constructor is used!!!.

I could understand that Hibernate complains about the native sql function or something like that but it seems that it is simply discarded.

Any explaination?

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