Hi,

I am using Hibernate 2.1.3 with Hypersonic. When I want to use sequences as ID generator hibernate tells me:

et.sf.hibernate.MappingException: Dialect does not support sequences
but in documentation to Hypersonic they say they have sequences.

What can be wrong ? Is Hibernate not updated for this feature of Hypersonic ?

The mapping file where exception occures is:


<hibernate-mapping>
<class
name="HotList"
table="hotlist"
dynamic-update="false"
dynamic-insert="false"
>
<cache usage="read-only" />

<id
name="id"
column="hotId"
type="java.lang.Long"
unsaved-value="null"
>
<generator class="sequence">
<param name="sequence">hotlist_sequence</param>
</generator>
</id>

<property
name="maxLength"
type="int"
update="true"
insert="true"
access="property"
column="hotMaxLen"
/>
...

The dialect currently supports identity columns.

If the database feature set has changed - then we need to know when, version numbers a reference to the page that has the information etc.
Alternatively, you could create or extend the current dialect and provide an appropriate patch.

If you unpack latest version HSQLDB 1.7.2 and go to


/doc/guide/guide.html#N104BA

there it is. Is there any chance that hibernate team will do the patch soon ? :)

Why don't you patch it yourself? Should not be too difficult.

I think in this case we need two dialects covering the feature changes.
It would be a relatively simple job to create a new dialect for the later version. Community help and contributions are always appreciated.