Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 Go to next message
Edson Richter is currently offline Edson Richter
Messages: 3
Registered: July 2009
Junior Member
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 Go to previous messageGo to next message
James Sutherland is currently offline James Sutherland
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

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


James : Wiki : Book : Blog : Twitter
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 Go to previous message
Edson Richter is currently offline Edson Richter
Messages: 3
Registered: July 2009
Junior Member
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:
  


Current Time: Wed Jul 23 01:50:35 EDT 2014

Powered by FUDForum. Page generated in 0.04031 seconds