Re: Problems getting started with mysql

[Michael Burke <mb...@bestweb.net>]

I've got the same problem as Raymond:

> 
> I've ignored the database error for now, and am looking at the table
> creation error. The problem is (as you can see from the error
> message) is that the primary key includes some fields that are marked
> as nullable. What I did for now is to just make those fields not null
> (it the fields REP_ID,REF_FK,REFA_FK,REFB_FK are now ALL not null in
> the table REF_REPOSITORY_FK). Not knowing the internals of OJB, I
> don;t know if this'll break anything. Would it be better, instead,
> for me to implement a unique index over these fields?
> 
> Regards, Raymond Barlow

Is the solution just to change the fields not marked as required to 
required to satisfy mysql's requirements for a pk?