Eclipse Community Forums: EclipseLink » I need to capture database warnings, which log level to use?

Home » Eclipse Projects » EclipseLink » I need to capture database warnings, which log level to use?(I'm debugging triggers, and I need to capture PostgreSQL warnings to get there)

I need to capture database warnings, which log level to use? [message #1001515]

Wed, 16 January 2013 16:20

Eclipse User

Hi!

I've a bunch of triggers in my PostgreSQL database, and I need to capture SQL Warnings issues to check the result of "RAISE NOTICE" statements inside the trigger.
I've tried even:

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

How can I achieve this when using Eclipse Link 2.4.1?

Thanks,

Edson

Re: I need to capture database warnings, which log level to use? [message #1001881 is a reply to message #1001515]

Thu, 17 January 2013 09:07

Eclipse User

EclipseLink prints warning on finest/all if they are returned by JDBC. Seems like your driver is not returning the warnings.

Re: I need to capture database warnings, which log level to use? [message #1058114 is a reply to message #1001881]

Sat, 11 May 2013 11:14

Eclipse User

You are right!

I had to change PostgreSQL driver to get warnings from it.

Thanks,

Edson.

Previous Topic:	eclipseLink inheritance joined and oneToMany
Next Topic:	Sorting by Date , I can't solve it

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 21:13:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter