Eclipse Community Forums: EclipseLink » JPA/JTA eclipselink oracle proxy authentication problem

Home » Eclipse Projects » EclipseLink » JPA/JTA eclipselink oracle proxy authentication problem(JPA/JTA eclipselink oracle proxy authentication not working)

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

JPA/JTA eclipselink oracle proxy authentication problem [message #520044]

Wed, 10 March 2010 22:44

Karl

Messages: 4
Registered: March 2010

Junior Member

Couldn't find the answer to this in the forum so thought I'd just ask.

My problem is with proxy authentication to an oracle database using eclipselink JTA with an injected Persistence Context / Entity Manager.

Proxy authentication doesn't work when I try to run a JPQL query. The problem appears to be that the entity manager is injected and does not allow for the setting of properties. The JPQL query just runs as the default user.

I guess my question is, does eclipselink support Proxy Authentication to an oracle database using JTA and an injected persistence context?

I don't have immediate access to the exact error at the minute but I think this initial question is to determine if it's an avenue worth continuing with.

The code I'm using to try and authenticate is:

Map emProperties = new HashMap();
emProperties.put("eclipselink.oracle.proxy-type", oracle.jdbc.OracleConnection.PROXYTYPE_USER_NAME);
emProperties.put(oracle.jdbc.OracleConnection.PROXY_USER_NAM E, username);
((org.eclipse.persistence.internal.jpa.EntityManagerImpl)em. getDelegate()).setProperties(emProperties);
//JPQL Query

Report message to a moderator