Hi, I'm desperately trying to get JBoss and PostgreSQL working together with foreign keys. I'm using JBoss 3.2.3 and PostgreSQL 7.3.4.
I want to map the following two tables: CREATE Table kv ( pkey serial not null, kvid int2 not null, nummer integer not null, passwort varchar(63), patientanzahl int2, pzf int2, daz int2, CONSTRAINT id_kv UNIQUE (kvid), CONSTRAINT pk_kv PRIMARY KEY(pkey) ); CREATE Table teilnehmer ( pkey serial not null, teilnehmer_id integer not null, fk_kv int4, firma varchar(255), nachname varchar(255), vorname varchar(255), titel varchar(63), anrede int2 , strasse varchar(255), plz varchar(255), ort varchar(255), mail varchar(255), telefon varchar(255), fax varchar(255), CONSTRAINT id_teilnehmer UNIQUE (teilnehmer_id), CONSTRAINT pk_teilnehmer PRIMARY KEY(pkey), CONSTRAINT rel_teilnehmer_kv FOREIGN KEY (fk_kv) REFERENCES kv (pkey) on delete cascade ); Do you have any hints for me? And please be kind and do not answer "google is your friend" or similar. I searched not only on the mailing list archive but in the forums and the whole web. ;) I think I'm confused with how to do this because of the different JBoss versions (when searching for help in the JBoss persistence forum e.g.) and workarounds posted for them. For clarity I uploaded my two beans and their dds here: http://www.user.fh-stralsund.de/~sestgran/temp/ Can anyone help me on this issue? I can't get it to work correctly. Thanks in advance Steffen Gransow ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user