# Logging query elides where clause

**URL:** <https://discourse.hibernate.org/t/logging-query-elides-where-clause/1392>\
**Category:** Hibernate ORM\
**Created:** [September 12, 2018, 2:58pm UTC](https://discourse.hibernate.org/t/logging-query-elides-where-clause/1392 "2018-09-12T14:58:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tharpa](https://avatars.discourse-cdn.com/v4/letter/t/7c8e57/32.png) [@tharpa](https://discourse.hibernate.org/u/tharpa)\
**Post date:** [September 12, 2018, 2:58pm UTC](https://discourse.hibernate.org/t/logging-query-elides-where-clause/1392/1 "2018-09-12T14:58:11Z")

</div>

FWIW, I am using Eclipse. I have set

```auto
 <property name="hibernate.show_sql">true</property>

        <!-- Pretty print the SQL in the log and console -->
        <property name="hibenate.format_sql">true</property>

```

But the queries that get output to the console and the log are elided, e.g.

> [database=maps, query=SELECT gid FROM mapdata.states WHERE ST\_Intersects(the\_geom, ST\_GeometryFromText…]

Is there any way to have it output the full query without the elision (…)?

---

<div class="post-metadata">

**Author:** ![vlad](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/vlad/32/658_2.png) [@vlad](https://discourse.hibernate.org/u/vlad)\
**Post date:** [September 12, 2018, 3:21pm UTC](https://discourse.hibernate.org/t/logging-query-elides-where-clause/1392/2 "2018-09-12T15:21:23Z")

</div>

That query does not look like one coming from Hibernate.

You might want to consider a [JDBC logging tool](https://vladmihalcea.com/the-best-way-to-log-jdbc-statements/) if you want more complex logs, like embedding parameters next to the query or display if batching is used.