HSQLDB Constraint Violation & SQL Query Log for an HSQLDB in-memory setup
- by shipmaster
We have a setup where we are using an embedded HSQLDB for backing Hibernate/JPA unit tests in java, and we are using the in-memory database mode since we simply want the database thrown away after the test run. My problem is that one of the tests is failing due to a constraint violation and HSQLDB lists the column as SYS_CT_286, and the query that appears in the log is the prepared statement where I cant see what the actual parameter values are (they are replaced by '?'). My questions are:
1- Is there a way in which I can see the actual SQL being executed? (like the mysql query log for example?).
2- What exactly is SYS_CT_286? it is not one of my columns, is it a generated column? is there something obvious that may be wrong with it?
Thanks.