HP Integrity NonStop J-Series - Manual (Page 225)

alter table PERSON_EMAIL_ADDR add constraint FKA54215FEB0A1327A foreign key (PERSON_ID)
references PERSON;
alter table PERSON_EVENT add constraint FKAD91D910A8B41A9A foreign key
(EVENT_ID) references EVENTS;
create unique index eventcat_person on PERSON(PERSON_ID) LOCATION <$datavol>
ATTRIBUTE EXTENT (16, 64), MAXEXTENTS 160;
create unique index eventcat_person_event on PERSON_EVENT(EVENT_ID, PERSON_ID)
LOCATION <$datavol> ATTRIBUTE EXTENT (16, 64), MAXEXTENTS 160;
create unique index eventcat_emails on PERSON_EMAIL_ADDR(PERSON_ID)
LOCATION <$datavol> ATTRIBUTE EXTENT (16, 64), MAXEXTENTS 160;
create table hibernate_unique_key (next_hi integer ) LOCATION <$datavol>
ATTRIBUTE EXTENT (16, 64), MAXEXTENTS 160;
insert into hibernate_unique_key values (1);
Modified File
Hibernate.cfg.xml
(<My SASH Home>\hibernate\samples\web\src\main\resources)
This is the hibernate configuration file for EventManager that contains hibernate connection
properties and hbm resource mapping.
Changes to the Hibernate.cfg.xml file
This file was modified to remove the default connection-related hibernate properties.
Before the change:
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
org.hsqldb.jdbcDriver
jdbc:hsqldb:hsql://localhost
sa
2
org.hibernate.dialect.HSQLDialect
org.hibernate.context.ManagedSessionContext
org.hibernate.cache.NoCacheProvider
true
create
Customizing EventManager 225