Hi,
I am currently involved in working with Hibernate against a upcoming database platform called SQLFire. The problem I have is that SQLFire requires custom entries within the DDL create statements. I have looked in the org.hibernate.mapping.Table and org.hibernate.dialect.Dialect (I have also checked org.hibernate.DerbyDialect which SQLFire impersonates by default) and cannot see any obvious way of extending how the create statements are generated. Can anyone advise if I have missed some way of doing this?
A create statement in this case could look like the following. However there are other entries that might also be needed in some situations.
Code:
CREATE TABLE HOTELAVAILABILITY
( HOTEL_ID INT NOT NULL,
BOOKING_DATE DATE NOT NULL,
ROOMS_TAKEN INT DEFAULT 0,
PRIMARY KEY (HOTEL_ID, BOOKING_DATE)
) PARTITION BY PRIMARY KEY
Thanks in advance,
Jamie
Login
FAQ
Search