Yes, the necessary column has been set to auto increment in each table.
Alex
----- Original Message -----
From: "Stein M. Eliassen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 25, 2003 3:49 PM
Subject: Re: [castor-dev] SQLException caused by key-generator in mapping
file
> alex.smith31 wrote:
> >
> > java.sql.SQLException: General error, message from server: "Column
'user_profile_id' cannot be null"
> > at com.mysql.jdbc.MysqlIO.checkErrorPacket...
> > ....
> >
> > I have identified the problem but don't know why it occurs or how to
overcome it. In the mapping file I have defined the UserProfile object with
a key-generator:
> >
> > <mapping>
> > <class name="UserProfile" identity="id" key-generator="IDENTITY">
> > .....
> >
> > When I remove this attribute (key-generator="IDENTITY") from the mapping
file it all works fine and inserts the new Subscription as I would like but
it is vital to have the key generation at other points. Any help on this
matter would be greatly appreciated.
> >
>
> Did you declare the database-field with auto_increment?
>
> Stein
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
> unsubscribe castor-dev
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
