Hello list,
I'm getting started with cayenne 3.2M1. Until now serveral things are
working fine, like expected.
My user object has a list of roleGroups. If i add a roleGroup to its list
and call commitChanges() and SQL Exception is thrown:
org.postgresql.util.PSQLException: FEHLER: NULL-Wert in Spalte »id«
verletzt Not-Null-Constraint
Generally calling the sequence for next id, is no problem, look the
statments for inserting a new user:
Information: SELECT nextval('user_id_seq')
Information: INSERT INTO "public"."user" ("changepasswort",
"displayname", "id", "lastchanged", "loginname", "password", "validfrom",
"validuntil") VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Information: [batch bind: 1->changepasswort:NULL, 2->displayname:'xy',
3->id:9, 4->lastchanged:'2013-12-10 10:41:03.812', 5->loginname:'xyz',
6->password:'geheim', 7->validfrom:NULL, 8->validuntil:NULL]
But no sequence is called when commiting the new relationship.
Information: SELECT "t0"."changepasswort", "t0"."displayname",
"t0"."lastchanged", "t0"."loginname", "t0"."password", "t0"."validfrom",
"t0"."validuntil", "t0"."id" FROM "public"."user" "t0" WHERE "t0"."id" = ?
[bind: 1->id:1] - prepared in 94 ms.
Information: SELECT DISTINCT "t0"."description", "t0"."lastchanged",
"t0"."name", "t0"."id" FROM "public"."rolegroup" "t0" JOIN
"public"."joinuserrolegroup" "t1" ON ("t0"."id" = "t1"."rolegroupid") WHERE
"t1"."userid" = ? [bind: 1->userid:1] - prepared in 15 ms.
Information: SELECT "t0"."description", "t0"."lastchanged", "t0"."name",
"t0"."id" FROM "public"."rolegroup" "t0" WHERE "t0"."id" = ? [bind: 1->id:3]
Information: INSERT INTO "public"."joinuserrolegroup" ("id",
"rolegroupid", "userid") VALUES (?, ?, ?)
Information: [batch bind: 1->id:NULL, 2->rolegroupid:3, 3->userid:1]
Information: *** error.
org.postgresql.util.PSQLException: FEHLER: NULL-Wert in Spalte »id«
verletzt Not-Null-Constraint
Is this default-behaviour? Is no id column in jointables intended?
The db-entity from my datamap.map.xml
<db-entity name="joinuserrolegroup" schema="public">
<db-attribute name="id" type="INTEGER" isMandatory="true"
length="10"/>
<db-attribute name="rolegroupid" type="INTEGER" length="10"/>
<db-attribute name="userid" type="INTEGER" length="10"/>
<db-key-generator>
<db-generator-type>ORACLE</db-generator-type>
<db-generator-name>joinuserrolegroup_id_seq</db-generator-name>
</db-key-generator>
</db-entity>
As you can see, i'm using a postgres database 9.1
Here are the three table definitions:
Table "public.user"
Column | Type |
Modifiers
----------------+-----------------------------+---------------------------------------------------
id | integer | not null default
nextval('user_id_seq'::regclass)
loginname | character varying(100) |
displayname | character varying(100) |
password | character varying(100) |
validfrom | timestamp without time zone |
validuntil | timestamp without time zone |
lastchanged | timestamp without time zone |
changepasswort | boolean |
Indexes:
"user_pkey" PRIMARY KEY, btree (id)
Table "public.rolegroup"
Column | Type | Modifiers
-------------+-----------------------------+--------------------------------------------------------
id | integer | not null default
nextval('rolegroup_id_seq'::regclass)
name | character varying(100) |
description | character varying(100) |
lastchanged | timestamp without time zone |
Indexes:
"rolegroup_pkey" PRIMARY KEY, btree (id)
AND FINALLY THE JOINTABLE
Table "public.joinuserrolegroup"
Column | Type | Modifiers
-------------+---------+----------------------------------------------------------------
id | integer | not null default
nextval('joinuserrolegroup_id_seq'::regclass)
userid | integer |
rolegroupid | integer |
Indexes:
"joinuserrolegroup_pkey" PRIMARY KEY, btree (id)
Best regards, Johannes
