How to set 'NOT NULL' primary key in mySql

[chris70]

Hi,

I'm using JBoss 3.0 alpha with mySql. Can't get CMP2 to work as it could not create table without 'NOT NULL' in primary key clause.

Please help.

Chris.

[dsundstrom]

MySQL is lame, so you will have to add NOT NULL to the end of the SQL-TYPE for your primary key colums. This will be addressed in a furtue release, but it is not a high priority.

[gkanel]

try to use the mysqlFront. It is one of the third party tools that you can find it the MySQL site. I believe it is an excellect client for such things. Be carefull it is not the best for administration.

regards
George