Eclipse Community Forums: EclipseLink » Auditing for Oracle with EclipseLink JPA

Home » Eclipse Projects » EclipseLink » Auditing for Oracle with EclipseLink JPA (oracle with eclipselink auditing issues)

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

Auditing for Oracle with EclipseLink JPA [message #539429]

Thu, 10 June 2010 13:07

enrique
Messages: 4
Registered: May 2010

Junior Member

Hello everybody i am using EclipseLink and i have to audit in oracle so i can audit using pure JDBC with the V$session and i can audit the application name in oracle in this way but here in EclipseLink JPA i cannot set the application name to be audited, the way in which i have been trying is by setting dinamically the session param i want using the SessionCustomizer but it does not do what is supposed to do..... no error is shown but does not audit the name in oracle.... i have time struggling with this and no result, the code i am using is:

the customizer class is:

package com.util;

import org.eclipse.persistence.config.SessionCustomizer;
import org.eclipse.persistence.sessions.Session;

/**
*
* @author xkalibur
*/
public class ProgramCustomizer implements SessionCustomizer{
public void customize(Session s) throws Exception {
//s.getDatasourceLogin().setProperty("v$session.program","Employees ");----------- tried with this method
//s.getLogin().setProperty("v$session.program","Employees "); ----------------------- tried with this one as well
}
}

by using one of the commented lines above which are supposed to work, did not work...

also tried changing those lines instead these ones:

DatabaseLogin login= (DatabaseLogin) s.getDatasourceLogin();
login.setProperty("v$session.program","Clients");

did not work too.

i was reading the eclipse link http://wiki.eclipse.org/Configuring_a_Session_(ELUG) and it is done in this way ...

the method to edit is:

public void edit(Employee employee) {

emProperties.put(PersistenceUnitProperties.SESSION_CUSTOMIZE R, "com.util.ProgramCustomizer");
factory = Persistence.createEntityManagerFactory("EJBLocalPU", emProperties);
em = factory.createEntityManager();
em.merge(employee);

}

it performs the merge very well but does not audit the application name i want into the database.

Do you have any idea on how to solve this issue...

thanks in advance.-

Report message to a moderator

[Message index]

		Auditing for Oracle with EclipseLink JPA By: enrique on Thu, 10 June 2010 13:07
		Re: Auditing for Oracle with EclipseLink JPA By: James Sutherland on Mon, 14 June 2010 10:24

Previous Topic:	potential memory leak persisting objects with eclipselink 2
Next Topic:	PluralAttribute.getJavaType returns element type instead of collection type

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 23:14:57 EDT 2013