Package javax.persistence

Examples of javax.persistence.EntityManager.createNativeQuery()

66
67
68
69
70
71
72
73
74
75
76
  public void testIteratorSingleResultQuery() throws Exception {
    begin();
    EntityManager em = createEntityManager();

    String nativeQuery = "MATCH ( n:" + TABLE_NAME + " { name:'Portia', author:'Oscar Wilde' } ) RETURN n";
    OscarWildePoem poem = (OscarWildePoem) em.createNativeQuery( nativeQuery, OscarWildePoem.class ).getSingleResult();

    assertAreEquals( portia, poem );

    commit();
    close( em );
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
  public void testListMultipleResultQuery() throws Exception {
    begin();
    EntityManager em = createEntityManager();
    String nativeQuery = "MATCH ( n:" + TABLE_NAME + " { author:'Oscar Wilde' } ) RETURN n ORDER BY n.name";
    @SuppressWarnings("unchecked")
    List<OscarWildePoem> results = em.createNativeQuery( nativeQuery, OscarWildePoem.class ).getResultList();

    assertThat( results ).as( "Unexpected number of results" ).hasSize( 2 );
    assertAreEquals( athanasia, results.get( 0 ) );
    assertAreEquals( portia, results.get( 1 ) );
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
  public void testSingleResultQueryUsingParameter() throws Exception {
    begin();
    EntityManager em = createEntityManager();

    String nativeQuery = "MATCH ( n:" + TABLE_NAME + " { name:{name}, author:'Oscar Wilde' } ) RETURN n";
    Query query = em.createNativeQuery( nativeQuery, OscarWildePoem.class );
    query.setParameter( "name", "Portia" );
    OscarWildePoem poem = (OscarWildePoem) query.getSingleResult();

    assertAreEquals( portia, poem );
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
  public void testSingleResultQueryUsingDateParameter() throws Exception {
    begin();
    EntityManager em = createEntityManager();

    String nativeQuery = "MATCH ( n:" + TABLE_NAME + " { dateOfCreation:{creationDate}, author:'Oscar Wilde' } ) RETURN n";
    Query query = em.createNativeQuery( nativeQuery, OscarWildePoem.class );
    query.setParameter( "creationDate", new GregorianCalendar( 1810, 3, 10 ).getTime() );
    OscarWildePoem poem = (OscarWildePoem) query.getSingleResult();

    assertAreEquals( athanasia, poem );
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
  private Long executeQuery(String queryString) throws Exception {
    getTransactionManager().begin();
    final EntityManager em = getFactory().createEntityManager();
    @SuppressWarnings("unchecked")
    List<Object> results = em.createNativeQuery( queryString ).getResultList();
    Long uniqueResult = null;
    if ( !results.isEmpty() ) {
      uniqueResult = (Long) results.get( 0 );
    }
    commitOrRollback( true );
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
        try {
            String queryStr =
                    "SELECT id AS idparent, longVal AS idchild, CAST(NULL AS CHAR)  as missing FROM EGENERIC";
                    //"SELECT 1 as idparent, 2 as idchild,CAST(NULL AS CHAR) as missing "
                    // FROM sysibm.sysdummy1";
            Query q1 = em.createNativeQuery(queryStr, EParent.class);
           
            List resultList = q1.getResultList();
            assertNotNull(resultList);
           
            List <EParent> pList = new ArrayList<EParent>();
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
    public void testPartialEmbeddableLoadByJPQLQuery() {
        EntityManager em = emf.createEntityManager();
       
        try {
            String queryStr = "SELECT id AS idparent, longVal AS idchild FROM EGENERIC";
            Query q1 = em.createNativeQuery(queryStr, EParent.class);
           
            List resultList = q1.getResultList();
            assertNotNull(resultList);
           
            List <EParent> pList = new ArrayList<EParent>();
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
  public void testSingleResultQuery() throws Exception {
    begin();
    EntityManager em = createEntityManager();

    String nativeQuery = "{ $and: [ { name : 'Portia' }, { author : 'Oscar Wilde' } ] }";
    OscarWildePoem poem = (OscarWildePoem) em.createNativeQuery( nativeQuery, OscarWildePoem.class ).getSingleResult();

    assertAreEquals( portia, poem );

    commit();
    close( em );
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
    String nativeQuery = "db.WILDE_POEM.find( "
        + "{ '$and' : [ { 'name' : 'Portia' }, { 'author' : 'Oscar Wilde' } ] }, "
        + "{ 'name' : 1 }"
        + " )";
    String result = (String) em.createNativeQuery( nativeQuery, "poemNameMapping" ).getSingleResult();

    assertThat( result ).isEqualTo( "Portia" );

    commit();
    close( em );
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
    String nativeQuery = "db.WILDE_POEM.find( "
        + "{ '$and' : [ { 'name' : 'Portia' }, { 'author' : 'Oscar Wilde' } ] }, "
        + "{ 'name' : 1, 'author' : 1 }"
        + " )";
    Object[] result = (Object[]) em.createNativeQuery( nativeQuery, "poemNameAuthorIdMapping" ).getSingleResult();

    assertThat( Arrays.asList( result ) ).containsExactly( "Portia", "Oscar Wilde", 1L );

    commit();
    close( em );
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.