Eclipse Community Forums: EclipseLink » Unable to log bind parameters

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 18:25

Eclipse User

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 08:29

Eclipse User

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

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

Tue, 11 September 2012 14:49

Eclipse User

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 16:21

Eclipse User

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:

-=] Back to Top [=-

Current Time: Sat Jul 12 16:46:25 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter