Package javax.persistence

Examples of javax.persistence.EntityManager.createNamedQuery()

93
94
95
96
97
98
99
100
101
102
103
     * @return the groups the given member belogs to, or an empty list if
     * the member does not belong to any groups
     */
    public List<GroupEntity> findGroupsForMember(String memberId) {
        EntityManager em = emf.createEntityManager();
        Query q = em.createNamedQuery("groupsForMember").setParameter("memberId", memberId);

        return (List<GroupEntity>) q.getResultList();
    }

    /**
 
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
        }
    }
   
    public Users getUserByUser(String username){
        EntityManager em = getEntityManager();
        Query q = em.createNamedQuery("Users.findByUser");
            q.setParameter("user", username);
        List<Users> resultList = q.getResultList();
       
        if(resultList.isEmpty()) return null;
        else return resultList.get(0);
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
                .getResultList();

        assertNotNull(ret);
        assertEquals(1, ret.size());

        ret = em.createNamedQuery("setParam1")
            .setParameter("fld", "string1")
            .getResultList();

        assertNotNull(ret);
        assertEquals(1, ret.size());
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
        javax.persistence.Query result = null;
        if (isNotEmpty(query.named()))
        {
            if (!context.hasQueryStringPostProcessors())
            {
                result = params.applyTo(entityManager.createNamedQuery(query.named()));
            }
            else
            {
                javax.persistence.Query namedQuery = entityManager.createNamedQuery(query.named());
                String named = factory.extract(namedQuery);
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
            {
                result = params.applyTo(entityManager.createNamedQuery(query.named()));
            }
            else
            {
                javax.persistence.Query namedQuery = entityManager.createNamedQuery(query.named());
                String named = factory.extract(namedQuery);
                String jpqlQuery = context.applyQueryStringPostProcessors(named);
                result = params.applyTo(entityManager.createQuery(jpqlQuery));
            }
        }
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
    Mouse mouse = new Mouse();
    mouse.setName( "mickey" );
    em.getTransaction().begin();
    em.persist( as );
    em.persist( mouse );
    assertEquals( 1, em.createNamedQuery( "allMouse" ).getResultList().size() );
    Lighter lighter = new Lighter();
    lighter.name = "main";
    lighter.power = " 250 W";
    em.persist( lighter );
    em.flush();
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
    el.setName( "Dumbo" );
    carpet.setCountry( "Turkey" );
    em.getTransaction().begin();
    em.persist( carpet );
    em.persist( el );
    assertEquals( 1, em.createNamedQuery( "allCarpet" ).getResultList().size() );
    assertNotNull( carpet.getId() );
    em.remove( carpet );
    em.getTransaction().commit();
    em.close();
    emf.close();
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
            start = System.currentTimeMillis();
        try {
            // invoke underlying entity manager method and if not running in a tx
            // return a Query wrapper around the result.
            EntityManager entityManager = getEntityManager();
            return detachTypedQueryNonTxInvocation(entityManager,entityManager.createNamedQuery(name, resultClass));
        } finally {
            if (isTraceEnabled) {
                long elapsed = System.currentTimeMillis() - start;
                ROOT_LOGGER.tracef("createNamedQuery name '%s', resultClass '%s' took %dms", name, resultClass.getName(), elapsed);
            }
View Full Code Here
351
352
353
354
355
356
357
358
359
360
361
            start = System.currentTimeMillis();
        try {
            // invoke underlying entity manager method and if not running in a tx
            // return a Query wrapper around the result.
            EntityManager entityManager = getEntityManager();
            return detachQueryNonTxInvocation(entityManager, entityManager.createNamedQuery(name));
        } finally {
            if (isTraceEnabled) {
                long elapsed = System.currentTimeMillis() - start;
                ROOT_LOGGER.tracef("createNamedQuery name '%s' took %dms", name, elapsed);
            }
View Full Code Here
578
579
580
581
582
583
584
585
586
587
588
    protected void cleanUpDBTables() throws StoreException {
        CoordinatorStore store = new CoordinatorStore(false);
        EntityManager entityManager = store.getEntityManager();
        store.beginTrx();

        Query q = entityManager.createNamedQuery("GET_WORKFLOWS");
        List<WorkflowJobBean> wfjBeans = q.getResultList();
        int wfjSize = wfjBeans.size();
        for (WorkflowJobBean w : wfjBeans) {
            entityManager.remove(w);
        }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.