Mercurial > lada > lada-server
annotate src/main/java/de/intevation/lada/util/data/DataTransaction.java @ 700:d74b5b1190ae
fixed delete probe service.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Fri, 10 Jul 2015 18:29:27 +0200 |
parents | 51784d74a85b |
children | f92c96efa976 |
rev | line source |
---|---|
457
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
1 /* Copyright (C) 2013 by Bundesamt fuer Strahlenschutz |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
2 * Software engineering by Intevation GmbH |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
3 * |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
4 * This file is Free Software under the GNU GPL (v>=3) |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
5 * and comes with ABSOLUTELY NO WARRANTY! Check out |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
6 * the documentation coming with IMIS-Labordaten-Application for details. |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
7 */ |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
8 package de.intevation.lada.util.data; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
9 |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
10 import javax.ejb.EJBTransactionRolledbackException; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
11 import javax.ejb.Stateless; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
12 import javax.ejb.TransactionAttribute; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
13 import javax.ejb.TransactionAttributeType; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
14 import javax.inject.Inject; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
15 import javax.persistence.EntityExistsException; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
16 import javax.persistence.EntityManager; |
700
d74b5b1190ae
fixed delete probe service.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
457
diff
changeset
|
17 import javax.persistence.PersistenceException; |
457
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
18 import javax.persistence.Query; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
19 import javax.persistence.TransactionRequiredException; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
20 |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
21 /** |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
22 * Abstract class implementing low level data operations. |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
23 * |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
24 * @author <a href="mailto:rrenkert@intevation.de">Raimund Renkert</a> |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
25 */ |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
26 @Stateless |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
27 public class DataTransaction |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
28 { |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
29 @Inject |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
30 protected EntityManagerProducer emp; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
31 |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
32 protected String jndiPath; |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
33 |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
34 /** |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
35 * Create object in the database. |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
36 * This operation can not be undone. |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
37 * |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
38 * @param object The object to create |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
39 * |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
40 * @throws EntityExistsException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
41 * @throws IllegalArgumentException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
42 * @throws EJBTransactionRolledbackException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
43 * @throws TransactionRequiredException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
44 */ |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
45 @TransactionAttribute(TransactionAttributeType.REQUIRED) |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
46 public void persistInDatabase(Object object, String dataSource) |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
47 throws EntityExistsException, |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
48 IllegalArgumentException, |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
49 EJBTransactionRolledbackException, |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
50 TransactionRequiredException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
51 { |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
52 emp.entityManager(dataSource).persist(object); |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
53 } |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
54 |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
55 /** |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
56 * Create object in the database. |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
57 * This operation can not be undone. |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
58 * |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
59 * @param object The object to create |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
60 * |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
61 * @throws EntityExistsException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
62 * @throws IllegalArgumentException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
63 * @throws EJBTransactionRolledbackException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
64 * @throws TransactionRequiredException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
65 */ |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
66 @TransactionAttribute(TransactionAttributeType.REQUIRED) |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
67 public void updateInDatabase(Object object, String dataSource) |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
68 throws EntityExistsException, |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
69 IllegalArgumentException, |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
70 EJBTransactionRolledbackException, |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
71 TransactionRequiredException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
72 { |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
73 emp.entityManager(dataSource).merge(object); |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
74 } |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
75 |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
76 /** |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
77 * Remove an object from the datebase. |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
78 * This operation can not be undone. |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
79 * |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
80 * @param object The object to remove |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
81 * |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
82 * @throws IllegalArgumentException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
83 * @throws TransactionRequiredException |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
84 */ |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
85 @TransactionAttribute(TransactionAttributeType.REQUIRED) |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
86 public void removeFromDatabase(Object object, String dataSource) |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
87 throws IllegalArgumentException, |
700
d74b5b1190ae
fixed delete probe service.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
457
diff
changeset
|
88 TransactionRequiredException, |
d74b5b1190ae
fixed delete probe service.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
457
diff
changeset
|
89 EJBTransactionRolledbackException |
457
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
90 { |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
91 EntityManager em = emp.entityManager(dataSource); |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
92 em.remove( |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
93 em.contains(object) ? |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
94 object : em.merge(object)); |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
95 } |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
96 |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
97 public Query queryFromString(String sql, String dataSource) { |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
98 EntityManager em = emp.entityManager(dataSource); |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
99 return em.createNativeQuery(sql); |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
100 } |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
101 |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
102 public EntityManager entityManager(String dataSource) { |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
103 return emp.entityManager(dataSource); |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
104 } |
51784d74a85b
Refactored data access. CDI is much cleaner now.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
diff
changeset
|
105 } |