Examples of javax.persistence.EntityManager.createQuery()

javax.persistence.EntityManager.createQuery()
Create an instance of Query for executing an EJB QL statement. @param ejbqlString an EJB QL query string @return the new query instance @throws IllegalStateException if this EntityManager has been closed @throws IllegalArgumentException if query string is not valid

                d.setName("AAA2");
                em.flush();


                em.clear();
                d = (WikiDirectory)
                        em.createQuery("select d from WikiDirectory d where d.id = :id")
                                .setParameter("id", 1l)
                                .getSingleResult();
                assert d.getName().equals("AAA2");
            }
        }.run();

View Full Code Here

        new FacesRequest() {


            protected void invokeApplication() throws Exception {
                EntityManager em = (EntityManager) getInstance("restrictedEntityManager");
                WikiDirectory d = (WikiDirectory)
                        em.createQuery("select d from WikiDirectory d where d.id = :id")
                                .setParameter("id", 3l)
                                .getSingleResult();


                WikiDirectory newDir = new WikiDirectory();
                newDir.setName("FFF");

View Full Code Here

                em.persist(newDir);
                em.flush();


                em.clear();
                d = (WikiDirectory)
                        em.createQuery("select d from WikiDirectory d where d.id = :id")
                                .setParameter("id", 1l)
                                .getSingleResult();
                assert d.getName().equals("AAA");


                em.clear();

View Full Code Here

                                .getSingleResult();
                assert d.getName().equals("AAA");


                em.clear();
                d = (WikiDirectory)
                        em.createQuery("select d from WikiDirectory d where d.id = :id")
                                .setParameter("id", 3l)
                                .getSingleResult();
                assert d.getName().equals("CCC");


                em.clear();

View Full Code Here

                                .getSingleResult();
                assert d.getName().equals("CCC");


                em.clear();
                d = (WikiDirectory)
                        em.createQuery("select d from WikiDirectory d where d.id = :id")
                                .setParameter("id", newDir.getId())
                                .getSingleResult();
                assert d.getName().equals("FFF");
            }
        }.run();

View Full Code Here

        new FacesRequest() {


            protected void invokeApplication() throws Exception {
                EntityManager em = (EntityManager) getInstance("restrictedEntityManager");
                WikiDirectory d = (WikiDirectory)
                        em.createQuery("select d from WikiDirectory d where d.id = :id")
                                .setParameter("id", 4l)
                                .getSingleResult();


                List<WikiDirectory> parents = d.getParentsRecursive();

View Full Code Here

        new FacesRequest() {


            protected void invokeApplication() throws Exception {
                EntityManager em = (EntityManager) getInstance("restrictedEntityManager");
                WikiDirectory d = (WikiDirectory)
                        em.createQuery("select d from WikiDirectory d where d.id = :id")
                                .setParameter("id", 3l)
                                .getSingleResult();


                List<WikiDirectory> parents = d.getParentsRecursive();

View Full Code Here

    @Factory(value = "wikiRoot", scope = ScopeType.PAGE, autoCreate = true)
    public WikiDirectory loadWikiRoot() {
        log.debug("loading wiki root");
        EntityManager em = (EntityManager)Component.getInstance("entityManager");
        try {
            return (WikiDirectory) em
                    .createQuery("select d from WikiDirectory d left join fetch d.feed where d.parent is null")
                    .setHint("org.hibernate.comment", "Loading wikiRoot")
                    .setHint("org.hibernate.cacheable", false)
                    .getSingleResult();
        } catch (RuntimeException ex) {

View Full Code Here

    @Factory(value = "wikiStart", scope = ScopeType.CONVERSATION, autoCreate = true)
    public WikiDocument loadWikiStart() {
        log.debug("loading wiki start into current conversation");
        EntityManager em = (EntityManager)Component.getInstance("restrictedEntityManager");
        try {
            return (WikiDocument) em
                    .createQuery("select d from WikiDocument d where d.id = :id")
                    .setParameter("id", Preferences.instance().get(WikiPreferences.class).getDefaultDocumentId())
                    .setHint("org.hibernate.comment", "Loading wikiStart")
                    .setHint("org.hibernate.cacheable", false)
                    .getSingleResult();

View Full Code Here

    public WikiDirectory loadWikiRootRestricted() {
        log.debug("loading wiki root into restricted PC");
        EntityManager em = (EntityManager)Component.getInstance("restrictedEntityManager");
        WikiDirectory wikiroot = (WikiDirectory) Component.getInstance("wikiRoot");
        try {
            return (WikiDirectory) em
                    .createQuery("select d from WikiDirectory d left join fetch d.feed where d.id = :id")
                    .setParameter("id", wikiroot.getId())
                    .setHint("org.hibernate.comment", "Loading wikiRootRestricted")
                    .setHint("org.hibernate.cacheable", false)
                    .getSingleResult();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.