[
https://issues.apache.org/jira/browse/OPENJPA-1598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12849342#action_12849342
]
Jeremy Bauer commented on OPENJPA-1598:
---------------------------------------
In the code you've posted for 2), there is no query execution. If it wasn't
mistakenly omitted in the JIRA, try:
q.executeUpdate();
-Jeremy
> How to set role using OpenJPA
> -----------------------------
>
> Key: OPENJPA-1598
> URL: https://issues.apache.org/jira/browse/OPENJPA-1598
> Project: OpenJPA
> Issue Type: Question
> Environment: Windows
> Reporter: Rajeev Chaudhary
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> I have weblogic system libraries having javax.persistence_1.0.0.0_1-0.jar and
> org.apache.openjpa_2.2.0.0_1-1-0.jar.
> EntityManager em = eClepRoleFactory.createEntityManager();
>
> 1. Connection c = (Connection)OpenJPAPersistence.cast(em).getConnection();
> String s = "SET ROLE "+role+" IDENTIFIED BY "+pass;
> Statement stmt = c.createStatement();
> stmt.execute(s);
> stmt.close();
> 2. em.getTransaction().begin();
> Query q = em.createNativeQuery("SET ROLE eclep_hpn_role IDENTIFIED BY
> role55");
> em.getTransaction().commit();
> Note: I am able to set the role using the steps in 1, but not with the
> steps in 2.
> Question: What is missing in steps 2, because of which I am not able to set
> the role. Doesn't createNatvieQuery support this feature. Please help me
> urgently.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
