How do I configure OpenJPA SQL logging?

openjpa
user1400965 picture user1400965 · May 24, 2012 · Viewed 19.6k times · Source

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

Rick picture Rick · May 24, 2012 
<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

Related questions

What is referencedColumnName used for in JPA?

In JPA there is an attribute called referencedColumnName that can be set on @JoinColumn, @PrimaryKeyJoinColumn what is the idea behind this setting, can someone give a good example of where this can be used?

Read More
Can a JPA Query return results as a Java Map?

We are currently building a Map manually based on the two fields that are returned by a named JPA query because JPA 2.1 only provides a getResultList() method: @NamedQuery{name="myQuery",query="select c.name, c.number from Client c"} HashMap&…

Read More
selecting all rows from a database using JPA in WebSphere

I am trying to implement a web service that uses open JPA to access the data layer. I am using websphere v7.0 and JPA 2.0. This service is going to get all rows out of a small db (about 6 rows and …

Read More