How do I configure OpenJPA SQL logging?

Question

What is the OpenJPA configuration to view SQL query executed in a database? I would like to view the query with all parameters executed in log or console instead of viewing the JPQL query

Answer 1

<property name="openjpa.Log" value="SQL=Trace" />

Enables logging of all SQL statements, minus parameter values.

<property name="openjpa.ConnectionFactoryProperties" value="PrintParameters=true" />

Enables logging of SQL parameters.

Logging documentation