Been digging for the answer to my problem for the past hour. Was trying to insert a row into a table. I have a field with a size CHAR(1), unknowingly was passing it 3 characters instead. Hibernate Insert was showing up on the debug screen but nothing in the DB. Finally, compared db fields to what I was passing and voilla, insert was successful.

There were NO exceptions thrown whatsoever. Does anyone have an explanation for this?

Thanks

Some databases silently trim character data. Why do you believe that this would be Hibernate-specific??

I don't think it has anything to do with Hibernate. It's probably the JDBC driver. I don't use Oracle, but tracing the problem in my hand is telling me that. If you want Hibernate to throw an exception, I suggest you specify the Hibernate type. To be honest, I've never used char(1) with Hiberante before (just with other applications). If you stored this is a string, I don't think Hibernate would know that the underlying type is really a single char. Perhaps use type="char" instead? That would add the necessary type checking. If you decided to use a string, I'm sure Hibernate would throw something in that case. Just experiment to find the answer really.

For me, I try and put all of my validation in the domain layer so this sort of stuff doesn't happen when it reaches the db.

I meant to say trace the problem with my mind.
This board could use edits :/

Gavin,

I copied generated sql into a sql editor and executed it against Oracle, I got an exception. Perhaps JDBC driver swallowed the error.

Is there a way to tell hibernate that a single character database column is of type Boolean?

Thanks