I have a problem: I want to analyze my log application, but it doesn´t show me the SQL instruction with their parameters. It shows only "?".

The current log as follow:

Hibernate: insert into Cliente (dcNome, dcCpfCnpj, dcWebsite, dcEmail, pnCliente) values (?, ?, ?, ?, ?)
Hibernate: insert into IdentificaCliente (dcChave, dcLogin, dcSenha, pnidentificacliente) values (?, ?, ?, ?)
Hibernate: insert into Telefone (dcContato, dcNumTel, fncliente, fntipotel, fnddd, pnTelefone) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into Telefone (dcContato, dcNumTel, fncliente, fntipotel, fnddd, pnTelefone) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into Telefone (dcContato, dcNumTel, fncliente, fntipotel, fnddd, pnTelefone) values (?, ?, ?, ?, ?, ?)

I need to analyze the value of ?. For example, I need the SQL instruction as follow:
Hibernate: insert into Cliente (dcNome, dcCpfCnpj, dcWebsite, dcEmail, pnCliente) values ('Rodrigo', '333333', 'HTTP:\\', 'rodrigo@teste.com.br', 5)

Therefore I don´t know how to configure my log hibernate.

Best regards,

Hi,

One way to do this is by using a connection wrapper that logs statements.

Just create a custom connection provider and plug your wrapper into hibernate.

See chapter 3.3 of the manual to see how to do this.

You won't be able to display the SQL with used values directly by only configuring Hibernate. Hibernate is using sql parametrized queries.

I mean, there are two ways I see :
* As camilosaurio says, it's possible to use a false jdbc wrapper that would display the real sql executed on the server. Don't remember the names of these products at the moment :-/
* a quick work-around, although I do not find it very readable, is to display the values that H3 passes in those parameters, activating org.hibernate.type in debug in log4j.properties (recall that org.hibernate.SQL=debug provides you with the same as show_sql=true in hbm properties).

You can try configuring the "org.hibernate.type" category to go to where ever you configured "org.hibernate.SQL" to log to.

This will give you a log that looks like this:


So you can see the bind values, but you have to figure out where they go in the statement yourself.

You can use a tool like P6Spy (unsupported these days, but still works) to show you an estimation of what the SQL as executed by the DB engine will look like.