1 Reply Latest reply on Aug 21, 2014 8:11 AM by Wolf-Dieter Fink

    Sql logs with "?" instead of actual values

    Sanjay Chaturvedi Novice

      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.

        • 1. Re: Sql logs with "?" instead of actual values
          Wolf-Dieter Fink Master

          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