Hi, It's possible that the SQL state is still incorrect, I will check in about two weeks.
Regards, Thomas Am 10.04.2011 01:24 schrieb "cowwoc" <[email protected]>: > > 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. > -- 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.
