Sql logs with "?" instead of actual values

[sanjay_chaturvedi]

Parameterized  SQLs showing logs with "?" question mark in place of paramters.

Log category is org.teiid.COMMAND_LOG.

Server: JBoss

Clients: Different Java applications.

Any idea how can we have actual query in logs with actual params instead of "?" ?

Any configurable property in log4j ?

Its not a spring or hibernate application, so please suggest some basic approach.

Thanks.

[wdfink]

It's the responsibility of the logging component to add this values.

Most cases the prepared statement is logged with ? but the values are added programatically.

If you use JBoss datasources in AS7 you might enable "spy=true" for the datasource configuration, this will show more information if the DS is used. You might see the SQL, values and results.

As you use teiid you might ask in that forum for specific teiid informations