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.
