Hi,

I'm using Hibernate to save data into a database table from a message driven bean that's acting as a log data collector service for the entire organization. Any application can post log data to the queue and this data can be arbitrary. If the data is larger than the the table field, right now I'm getting a "Data truncation: Data too long for column" exception. Really, I don't care if the data is too large, I just want to be able to save truncating data if necessary. I would also like to avoid hardcoding field lengths into the code. Is there any way I can have Hibernate automatically trim the data to the appropriate field lengths (since this data is available in the JDBC meta data which Hibernate has access to)?

Thanks
Dmitry

Well, if it's a POJO that has a setter being called, you could just do a trim of the data in the setter of the POJO. But you did say you didn't want to do it programatically? A trim is pretty easy - it might be the best way.

What about changing the datatype in the system? CLOB or BLOB or something? Might that work?

it's not the question or hard or easy. I don't want the definition of a field's length to live in two places: in the code and in the database. Then if it changes, it'll need to be changed twice (remembered to be changed twice). Since the value is already in the database and I want to reuse it.



Not for data is normally small, like event category name.

I have the same problem.

I don't want the definition of a field's length to live in two places: in the code and in the database.

I would like to use the database definition to do the trim(). Is it possible to retrieve the field definition ?

dberansky have you found a solution ?

Regards