Here is the testcase class, previously attached in the zip file:
package org.hilo.testcase;

import java.io.File;
import java.util.Date;

import junit.framework.TestCase;

import org.hibernate.cfg.Configuration;
import org.hibernate.cfg.Environment;
import org.hibernate.dialect.Dialect;
import org.hibernate.dialect.Oracle10gDialect;
import org.hibernate.dialect.SQLServer2008Dialect;

public class TableHiLoSchemaGenerationTest extends TestCase
{
private long id;

private Date modifydate;

private String value;

public long getId()

public void setId(long id)

public Date getModifydate()

public void setModifydate(Date modifydate)

public String getValue()

public void setValue(String value)

private void prepare(Dialect dialect, String type)
{
Configuration cfg = new Configuration();
cfg.addDirectory(new File("./src"));
cfg.setProperty(Environment.DIALECT, dialect.getClass()
.getCanonicalName());
String[] res = cfg.generateSchemaCreationScript(dialect);
for (String s : res)
{
if (s.startsWith("create table hibernate_unique_key"))

}
}

public void testOracle()

public void testMssql()

}

And here is the relevant hbm file;
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="org.hilo.testcase"
default-lazy="false">
<class name="TableHiLoSchemaGenerationTest" table="SYS_PARAMS">
<cache usage="read-write" />
<id name="id" column="ID">
<generator
class="org.hibernate.id.TableHiLoGenerator">
<param name="sequence">SEQ_SYS_PARAMS</param>
<param name="max_lo">99</param>
</generator>
</id>
<!-- version name="modifyDate" column="MODIFY_DATE" /-->
<property name="value" column="VALUE" />
</class>
</hibernate-mapping>