[hibernate-dev] TableGenerator missing "not null"
Juraci Costa
jcosta at redhat.com
Fri Dec 12 10:34:48 EST 2008
----- "Steve Ebersole" <steve at hibernate.org> escreveu:
> I am surprised that DB2 does not allow nulls and yet forces you to
> specify "not null" since it is totally redundant: PK cannot be null
> on
> DB2 by definition yet it forces user to explicitly specify "not null"
Not only that: they even have a very specific error message about it :-) Look for "SQLSTATE: 42831".
One more reference: http://publib.boulder.ibm.com/infocenter/cscv/v10r1/index.jsp?topic=/com.ibm.cloudscape.doc/rrefsqlj81859.html
"Just as in CREATE TABLE, if the column definition includes a unique or primary key constraint, the column cannot contain null values, so the NOT NULL attribute must also be specified (SQLSTATE 42831)."
> The patch looks fine to me in this case.
Ok, I'll commit it.
And you also won Czech beer or Moravian wine. Make your choice :-)
- Juca.
More information about the hibernate-dev
mailing list