Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version: 3.0
Mapping documents: 3.0
Code between sessionFactory.openSession() and session.close():
Spring Hibernate template support
Full stack trace of any exception that occurs:
No exception - Collection contains null value
Name and version of the database you are using:
Oracle 9i
The generated SQL (show_sql=true):
Debug level Hibernate log excerpt:
Constraint on table:
ALTER TABLE CHECK ADD (
CONSTRAINT CHK_CHECK_CAT_DEP_REG_FL CHECK (("CATEGORY" = 'F' AND "CODE" IS NOT NULL AND "FLIGHT" IS NOT NULL) OR
("CATEGORY" = 'D' AND "AIRPORT" IS NOT NULL ) OR
("CATEGORY" = 'R' AND "REGION" IS NOT NULL ) ));
CREATE TABLE CHECK
(
CODE VARCHAR2(5 BYTE) NOT NULL,
CATEGORY VARCHAR2(1 BYTE) NOT NULL,
REGION VARCHAR2(3 BYTE),
CARRIER VARCHAR2(3 BYTE),
FLIGHT VARCHAR2(5 BYTE),
AIRPORT VARCHAR2(5 BYTE),
MAXTIME NUMBER NOT NULL,
MINTIME NUMBER NOT NULL,
)
the contraints above and table design does not force certain fields to be filled in.
So in DB there can be some fields as null.
When getting the object, some elements in the collection are NULL