Package javax.persistence

Examples of javax.persistence.EntityManager.createNativeQuery()

110
111
112
113
114
115
116
117
118
119
120
     */
    protected void deleteAllData() {
        EntityManager em = emf.createEntityManager();
        em.getTransaction().begin();

        em.createNativeQuery("delete from Supplier_Part").executeUpdate();
        em.createQuery("delete from PartBase s").executeUpdate();
        em.createQuery("delete from Supplier s").executeUpdate();
        em.createQuery("delete from Usage u").executeUpdate();
        em.createQuery("delete from Part p").executeUpdate();

View Full Code Here
235
236
237
238
239
240
241
242
243
244
245
        em.getTransaction().begin();

        String insert1 =
            "insert into Part(partno,parttype,name,cost,mass)" +
            " values(13,'PartBase','breakes',1000.0,100.0)";
        em.createNativeQuery(insert1).executeUpdate();
        String insert2 =
            "insert into Supplier_Part(suppliers_sid,supplies_partno)" +
            " values(1,13)";
        em.createNativeQuery(insert2).executeUpdate();
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
            " values(13,'PartBase','breakes',1000.0,100.0)";
        em.createNativeQuery(insert1).executeUpdate();
        String insert2 =
            "insert into Supplier_Part(suppliers_sid,supplies_partno)" +
            " values(1,13)";
        em.createNativeQuery(insert2).executeUpdate();

        em.getTransaction().commit();
        em.close();

        em = emf.createEntityManager();
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
        em = emf.createEntityManager();
        em.getTransaction().begin();

        String sql = "select partno from Part where cost > 120 ";
        Query nativeq = em.createNativeQuery(sql);
        int nativelistSize = nativeq.getResultList().size();

        em.getTransaction().commit();
        em.close();
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
    }
   
    public void testNativeSQL() {
        EntityManager em = emf.createEntityManager();
        em.getTransaction().begin();
        int count = em.createNativeQuery("INSERT INTO Address (id, city,"
          + " country, streetAd, zipcode) VALUES (?,?,?,?,?)")
          .setParameter(1, System.currentTimeMillis()%10000)
          .setParameter(2, "Some City")
          .setParameter(3, "Some Country")
          .setParameter(4, "Some Street")
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
    }
   
    public int setSequence(long sequence) {
        int result = 0;
        EntityManager em = emf.createEntityManager();
        Query query = em.createNativeQuery("update SEQUENCE set SEQ_COUNT = ?1");
        query.setParameter(1, sequence);
        em.getTransaction().begin();
        try {
            result = query.executeUpdate();
            em.getTransaction().commit();
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
    }
   
    public int setSequence(long sequence) {
        int result = 0;
        EntityManager em = emf.createEntityManager();
        Query query = em.createNativeQuery("update SEQUENCE set SEQ_COUNT = ?1");
        query.setParameter(1, sequence);
        em.getTransaction().begin();
        try {
            result = query.executeUpdate();
            em.getTransaction().commit();
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    }
   
    private void setH2LockTimeout() {
        EntityManager manager = entityManagerFactory.createEntityManager();
        manager.getTransaction().begin();
        manager.createNativeQuery("SET DEFAULT_LOCK_TIMEOUT " + locktimeout).executeUpdate();
        manager.getTransaction().commit();
        manager.close();
    }
   
    @After
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
    public void clear() throws LocomotivePersistenceException {
        logger.debug("clear()");
        EntityManager em = HibernatePersistence.getEntityManager();
        try {
            em.createNativeQuery("TRUNCATE TABLE locomotive").executeUpdate();
            // em.createNativeQuery("TRUNCATE TABLE locomotive_type")
            // .executeUpdate();
            em.createNativeQuery("TRUNCATE TABLE locomotive_group")
                    .executeUpdate();
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        EntityManager em = HibernatePersistence.getEntityManager();
        try {
            em.createNativeQuery("TRUNCATE TABLE locomotive").executeUpdate();
            // em.createNativeQuery("TRUNCATE TABLE locomotive_type")
            // .executeUpdate();
            em.createNativeQuery("TRUNCATE TABLE locomotive_group")
                    .executeUpdate();

            super.clear();

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