Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Unable to log bind parameters(Unable to log bind parameters)
Unable to log bind parameters [message #909840] Fri, 07 September 2012 22:25 Go to next message
Fericit Bostan is currently offline Fericit Bostan
Messages: 68
Registered: June 2010
Member
I'm using EclipseLink 2.4 and I have the following properties specified in persistence.xml:

    <property name="eclipselink.logging.parameters" value="true"/>
    <property name="eclipselink.logging.level.sql" value="FINEST" />


My SQL statements are being logged but the bind parameters are not. Instead I get the following:

FINE: SELECT ID ...
	bind => [5 parameters bound]


So why aren't the parameters being logged?

Thanks for the assistance.
Re: Unable to log bind parameters [message #911346 is a reply to message #909840] Tue, 11 September 2012 12:29 Go to previous messageGo to next message
James Sutherland is currently offline James Sutherland
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

Odd. Are you using the default logger?
Try setting the log level to finest, not just the sql log level.


James : Wiki : Book : Blog : Twitter
Re: Unable to log bind parameters [message #911505 is a reply to message #911346] Tue, 11 September 2012 18:49 Go to previous messageGo to next message
Fericit Bostan is currently offline Fericit Bostan
Messages: 68
Registered: June 2010
Member
I was using the JavaLogger when I started to experience this, but I have also tried the DefaultLogger and it produces the same result. I've got the following properties defined in my persistence.xml file.

            <property name="eclipselink.logging.logger" value="DefaultLogger"/>
            <property name="eclipselink.logging.level" value="FINEST" />
            <property name="eclipselink.logging.parameters" value="true"/>
            <property name="eclipselink.logging.level.sql" value="FINEST" />
            <property name="eclipselink.logging.level.cache" value="FINEST" />
            <property name="eclipselink.logging.exceptions" value="true" />
            <property name="eclipselink.logging.thread" value="true"/>


I also have the following defined in my logging.properties file.
org.springframework.transaction.level = FINEST
org.eclipse.persistence.level = FINEST
java.sql.level = FINEST


Regardless of what I try I don't see the bind parameters output in the log. I only see the following:

FINE: SELECT ID AS a1, ...
	bind => [5 parameters bound]


Thanks for the assistance..
Chris
Re: Unable to log bind parameters [message #911535 is a reply to message #911505] Tue, 11 September 2012 20:21 Go to previous message
Chris Delahunt is currently offline Chris Delahunt
Messages: 1034
Registered: July 2009
Senior Member
I can't tell much from what is provided, but you might try getting rid of the logging settings in the logging.properties file, and make sure that you don't have a Spring showSQL setting somewhere. The EclipseLinkVendorAdaptor seems to change the logging level to FINE if the spring showSQL property is set, and other logging options might conflict elsewhere. If that works, then start adding back what you might need until you find what is causing the issue.

Best Regards,
Chris
Previous Topic:UUIDSequence
Next Topic:Mysterious double insert (SOLVED, see reply)
Goto Forum:
  


Current Time: Thu Oct 23 11:20:21 GMT 2014

Powered by FUDForum. Page generated in 0.13891 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software