I also can't find information about SQLState 23507. Isn't SQLState 23502 "An insert or update value is null, but the column cannot contain null values" more appropriate in this case?
Thanks, Gili On Apr 10, 1:09 am, cowwoc <[email protected]> wrote: > Hi Thomas, > > When I attempt to insert data that violates a foreign key using > 1.3.154 I now get this exception: > > org.h2.jdbc.JdbcSQLException: Referential integrity constraint > violation: "CONSTRAINT_5E47: PUBLIC.QUEUE_DOCTORS FOREIGN > KEY(DOCTOR_ID) REFERENCES PUBLIC.DOCTORS(ID)"; SQL statement: > insert into QUEUE_DOCTORS(DOCTOR_ID, QUEUE_ID) > values (?, ?) [23506-154] > > I couldn't any find any reliable explanation for SQLState 23506 (where > did you find it?) but I did notice that SQLState 23503 is defined as > "The insert or update value of a foreign key is invalid". Shouldn't H2 > use SQLState 23503 in this case? > > Thanks, > Gili > > On Apr 6, 4:37 pm, Thomas Mueller <[email protected]> > wrote: > > > > > > > > > Hi, > > > > How will I know when this fix is committed? Is there a specific bug > > > report or release version I should watch? > > > The change is included in the version 1.3.154. > > > Regards, > > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
