For now I solved using my custom dialect that add DATE() funcion in this
way:
registerFunction("date", new StandardSQLFunction("truncate",
StandardBasicTypes.DATE));Inserisci qui il codice...
I'm waiting for a reply from Hibernate guys.
Il giorno giovedì 24 luglio 2014 12:02:41 UTC+2, Daniele Renda ha scritto:
>
> Ok, the corrispondent function in H2 is TRUNCATE():
> http://www.h2database.com/html/functions.html#truncate
>
> So is possibile the bug is on the Hibernate Dialect.
>
> Il giorno giovedì 24 luglio 2014 11:58:45 UTC+2, Daniele Renda ha scritto:
>>
>> Thanks Noel,
>> my hibernate configuration works fine with Mysql.
>>
>> I think I'm using the correct dialect:
>>
>> <property name="databasePlatform" value="org.hibernate.dialect.H2Dialect"
>> />
>>
>> Howewer you confirm that there is not a function DATE() in H2? This is
>> what date function do:
>> http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date
>>
>> Thanks
>>
>> Il giorno giovedì 24 luglio 2014 10:53:38 UTC+2, Noel Grandin ha scritto:
>>>
>>> You should probably ask on the Hibernate mailing list. It sounds like
>>> either
>>> (a) you have incorrectly configured Hibernate and it using the wrong
>>> mapping layer for SQL commands
>>> (b) there is a bug in Hibernate.
>>>
>>> On 2014-07-24 09:44 AM, Daniele Renda wrote:
>>> > Hi,
>>> > I'm migrating my app made with Java + Spring + Hibernate + Mysql to
>>> H2. Unfortunally the first problem I noticed is this:
>>> >
>>>
>>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
