Eclipse Community Forums: EclipseLink » Unable to log bind parameters

Help

Home

Home » Eclipse Projects » EclipseLink » Unable to log bind parameters(Unable to log bind parameters)

Show: Today's Messages :: Show Polls :: Message Navigator

Unable to log bind parameters [message #909840]

Fri, 07 September 2012 22:25

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.

Report message to a moderator

Re: Unable to log bind parameters [message #911346 is a reply to message #909840]

Tue, 11 September 2012 12:29

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

Report message to a moderator

Re: Unable to log bind parameters [message #911505 is a reply to message #911346]

Tue, 11 September 2012 18:49

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

Report message to a moderator

Re: Unable to log bind parameters [message #911535 is a reply to message #911505]

Tue, 11 September 2012 20:21

Chris Delahunt

Messages: 1294
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

Report message to a moderator

Previous Topic:	UUIDSequence
Next Topic:	Mysterious double insert (SOLVED, see reply)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 26 02:24:51 GMT 2018

.:: Contact :: Home ::.