users@glassfish.java.net

Re: view exact sql in glassfish love

From: Mitesh Meswani <mitesh.meswani_at_oracle.com>
Date: Mon, 28 Mar 2011 20:15:38 -0700

I assume you are using JPA and EclipseLink is the persistence provider.
Add <property name="eclipselink.logging.parameters" value="true"/> to
your persistence.xml to see values of parameters

On 3/28/2011 7:25 PM, forums_at_java.net wrote:
> Hello -
>
> Is it possible to view the FULL sql running through a JDBC connection
> configured on Glassfish going to a MySQL server?
>
> In the server.log now I see this type of select:
>
> "SELECT Username, LastName, Password, Email, UpdatedDt, FirstName,
> CreatedDt
> FROM User WHERE (Username = ?)")
>
> I know it is passing in a username and not a question mark but I would
> like
> to view the full detail inside the log... is this possible?
>
> Thank you in advance!
>
>
> --
>
> [Message sent by forum member 'dpace32']
>
> View Post: http://forums.java.net/node/786167
>
>