mercredi 15 avril 2015

How do i find the exceptional column at mysql when using hibernate?

i have a exception with my hibernate application:



WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - SQL Error: 0, SQLState: S1009
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - Invalid value for getInt() - 'none'


So i try to find the problem with some inefficient method (like trace my commit log) and take a long time to solve it. Finally this problem is caused by a column defined 'varchar' at mysql when the mapped property defined 'int' at hibernate at java code.


That make me feel bad. Why don't hibernate show me the message that specified property has type error or other clear error.Should i set up something?


I try



hibernate.show_sql=true
hibernate.format_sql=true
hibernate.use_sql_comments=true

log4j.logger.org.hibernate.type=trace


but it does not show the exceptional property/colunm.



Is there other tip can show me useful message to debug this exceptional property?Thanks a lot.


Aucun commentaire:

Enregistrer un commentaire