Re: errors with derby and hsqldb (i need to switch from mysql to an embedded db)

From: Steave (stefanonafet..mail.com)
Date: Thu Sep 18 2008 - 15:52:40 EDT

  • Next message: Andrey Razumovsky: "Re: errors with derby and hsqldb (i need to switch from mysql to an embedded db)"

    ps, no rows in Canvass have id column = null ,
    and the table reflects the ddl written in my last mail

    2008/9/18 Steave <stefanonafet..mail.com>

    > For schema, do you intend the db schema?
    > If it is,
    >
    > well, this is the CREATE statement generated by modeler for hsqldb:
    >
    > CREATE CACHED TABLE Canvass (id BIGINT NOT NULL, title VARCHAR(150) NULL,
    > PRIMARY KEY (id)
    > ;
    >
    > In the modeler, both "Pk" and "Mandarory" are checked for id column.
    >
    >
    > 2008/9/18 Scott Anderson <sanderso..irvana.com>
    >
    > > Null value for 'id'.
    >>
    >> Is id set to NULL in the schema, but MANDATORY in the Cayenne map? I'm
    >> not sure if I'm interpreting the error correctly, but it sounds like
    >> Cayenne sees a NULL where it doesn't expect one.
    >>
    >
    >

    This archive was generated by hypermail 2.0.0 : Thu Sep 18 2008 - 15:53:20 EDT