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 21: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 14: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 15: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: Sat Sep 20 16:20:28 GMT 2014

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

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