General questions.

robertsv · **Joined:** Thu Apr 19, 2007 5:10 am **Posts:** 5

Hello,

some general questions

1) how cann i make hibernate.cfg.xml configurable.
for example:
<many-to-one name="user" class="User"
insert="false" update="false">
<column name="user_id"/>
<formula>'TYPE'</formula>
</many-to-one>
the string 'TYPE' should be readed from property file. it should not be hardcoded in cfg.

2) is it possible to see all queries with values, which are executed by hibernate.

thx a lot in advance!

batmat · **Posted:** Sun Jun 10, 2007 11:46 am

robertsv wrote:

1) how cann i make hibernate.cfg.xml configurable.
for example:
<many-to-one name="user" class="User"
insert="false" update="false">
<column name="user_id"/>
<formula>'TYPE'</formula>
</many-to-one>
the string 'TYPE' should be readed from property file. it should not be hardcoded in cfg.

Don't know for this one. Not sure it's possible.

robertsv wrote:

2) is it possible to see all queries with values, which are executed by hibernate.

Two solutions :
* activate org.hibernate.type package logs. You'll see what value is attached to each parameter (see the reference documentation for more details about this).
* configure p6spy proxy jdbc driver (search p6spy on google for more infos about this)

Anstar · **Joined:** Wed Apr 26, 2006 10:06 am **Posts:** 7

robertsv wrote:

2) is it possible to see all queries with values, which are executed by hibernate.

thx a lot in advance!

in hibernate.cfg.xml:

<property name="show_sql">true</property>