Hibernate SQL Execution Log

Question

I´m using hibernate in my web project. I have also set to true the <property name="hibernate.show_sql" value = "true" /> in order to show the SQL logs

It works fine; I can see the logs and the commands executed. But every now and then some SQL statements fails due to error in my code.

The problem is that these errors are not shown in the output window.

Example

LOG

Hibernate: create table abcdefghijklmnaaaaaaaaaaaaaaaaaaaaaaa (uniqueId number(10,0) not null, accepted number(3,0) not null, simulationId number(10,0), primary key (uniqueId))

Executing this statement directly in oracle database

*Cause: An identifier with more than 30 characters was specified.

Any idea of how can I print not only the SQL statement, but the result message returned by the database?

stackoverflow.com/questions/6055790/…

aioobe
– aioobe

2014-09-18 12:29:33 +00:00
Commented Sep 18, 2014 at 12:29 — aioobe
– aioobe, Commented Sep 18, 2014 at 12:29

Petar Butkovic · Accepted Answer · 2014-09-18 12:30:42Z

1

Exception that is thrown has message from database, you need to log it or print it in console or whatever you want to do with it.

answered Sep 18, 2014 at 12:30

Petar Butkovic

1,91016 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate SQL Execution Log

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related