Hibernate Community • View topic - Call SQL functions by using registerFunction

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Call SQL functions by using registerFunction

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

agadkari

Post subject: Call SQL functions by using registerFunction

Posted: Thu Jul 12, 2007 4:42 pm

Newbie

Joined: Mon Jan 09, 2006 11:12 am
Posts: 6

Hibernate version:3.2.4.sp1

I am trying to format DB2 timestamp value where I want to convert space to "-" and ":" to "." To do so I am extending DB2390Dialect and using following method

Code:

registerFunction("timestamp", new StandardSQLFunction("char(?1)"));

I am expecting that hibernate will convert my following SQL statement

Code:

TABLE_A.FIELD_A as H110_1_,
    from
        TABLE_A 
    where
        TABLE_A.FIELD_B = XYZ

into

char(TABLE_A.FIELD_A) as H110_1_,
    from
        TABLE_A 
    where
        TABLE_A.FIELD_B = XYZ

In my POJO I have declared mapping field to String.

I am getting IllegalArgumentException occurred while calling setter method. Is this the correct way to solve timestamp conversion issue?

Read this: http://hibernate.org/42.html

Top