Re: [Middlegen-user] In reservation entity FKs repeated two timesin insert query

[Scott Walters]

I'm having this exact same problem with composite keys except it's in my own code, not the sample. Has anyone resolved it? I'm using jboss 3.0.3 and have duplicated it on postgres and sql server. I saw it first when jboss tried to create the table. I made a small change in the jboss src (SQLUtil.java) which fixed it then, but now I see it on the inserts and I don't really want to try and track it down this time since it's more complicated. With the create table, there was only one column list so that was an easy fix. On the insert, the column list & data both contain duplicate values.

I tried setting the fkcmp=false and this produced different invalid sql (the where clause was empty) when it tried to check the fk relationship.

Thanks,
Scott

I have implemented InsertReservationAction method, but during save have the
following exception:

Why person_id_fk and flight_id_fk are repeated two times?

INFO  [jbossweb] ActionServlet: Create error: javax.ejb.CreateException:
Could not create entity:java.sql.SQLException: Try to insert null into a
non-nullable column in statement [INSERT INTO RESERVATIONS (reservation_id,
person_id_fk, flight_id_fk, registration_utc, comment, person_id_fk,
flight_id_fk) VALUES (5, NULL, NULL, '2002-11-11 11:11:11.0', 'jgkgjgh',
NULL, NULL)]

Best regards,
 Dev Zero G Ltd team http://devzerog.com
 mailto:[EMAIL PROTECTED]

-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing your web site with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate: http://www.gothawte.com/rd524.html
_______________________________________________
middlegen-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user