User Story #2684 (closed)
Devs should have a single place to make all JDBC calls.
Reported by: | jamoore | Owned by: | jamoore |
---|---|---|---|
Priority: | major | Milestone: | OMERO-Beta4.3 |
Component: | Services | Keywords: | n.a. |
Cc: | Story Points: | n.a. | |
Sprint: | n.a. | Importance: | n.a. |
Total Remaining Time: | 0.0d | Estimated Remaining Time: | n.a. |
Description
At the moment, JDBC calls are spread around the entire code base. These should be unified in a single interface (a DAO).
Change History (80)
comment:1 Changed 14 years ago by jmoore
- Milestone changed from OMERO-Beta4.2.1 to Unscheduled
comment:2 Changed 13 years ago by jmoore
- Milestone changed from Unscheduled to OMERO-Beta4.3
comment:4 Changed 13 years ago by jmoore
comment:5 Changed 13 years ago by jmoore
(In [8780/omero]) Removing JdbcTemplate usages from GeomTool (See #2684)
comment:6 Changed 13 years ago by jmoore
(In [8781/omero]) Refactoring strings out to Messages.java (See #2684)
comment:7 Changed 13 years ago by jmoore
(In [8784/omero]) Driver property and data source refactoring (See #2684)
comment:8 Changed 13 years ago by jmoore
(In [8786/omero]) Moving more methods to SqlAction, mostly tests (See #2684)
comment:9 Changed 13 years ago by jmoore
(In [8787/omero]) Moving delete using of session.connection to SqlAction (See #2684)
comment:10 Changed 13 years ago by jmoore
(In [8788/omero]) Changing EventHandler? to use SqlAction.deferConstraints (See #2684)
comment:11 Changed 13 years ago by jmoore
(In [8789/omero]) Adding SqlAction to SimpleWork before DeleteState (See #2684)
comment:12 Changed 13 years ago by jmoore
(In [8790/omero]) Prevent misuse of org.hibernate.Session (See #2985, #2684)
comment:13 Changed 13 years ago by jmoore
(In [8794/omero]) Improvements to SqlAction (See #2684)
comment:14 Changed 13 years ago by jmoore
(In [8795/omero]) Propagating SqlAction changes to Blitz (See #2684)
comment:15 Changed 13 years ago by jmoore
(In [8796/omero]) Propagating SqlAction fixes to TableIdGenerator? (See #2684)
comment:16 Changed 13 years ago by jmoore
(In [8797/omero]) More session hiding fixes (See #2684)
comment:17 Changed 13 years ago by jmoore
(In [8807/omero]) Fixing ScriptRepoHelper? use of createSQLQuery (See #2684)
comment:18 Changed 13 years ago by jmoore
(In [8808/omero]) Refactoring IAdmin.changePermissions' use of createSQLQuery (See #2684)
comment:19 Changed 13 years ago by jmoore
(In [8809/omero]) Fixing long/string persistent event log loader issue (See #2684)
comment:20 Changed 13 years ago by jmoore
(In [8810/omero]) Adding interfaces to our session wrapper (See #2684)
comment:21 Changed 13 years ago by jmoore
(In [8817/omero]) Using new context xml pattern for database types (See #2684)
With the new pattern, any one who would like to introduce there
own extension to datalayer.xml need only create a file of the
form:
ome/services/db-SOMETHING.xml
comment:22 Changed 13 years ago by jmoore
(In [8831/omero]) Initial work on removing all SimpleJdbcTemplate usages (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8778 05709c45-44f0-0310-885b-81a1db45b4a6
comment:23 Changed 13 years ago by jmoore
(In [8833/omero]) Removing JdbcTemplate usages from GeomTool (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8780 05709c45-44f0-0310-885b-81a1db45b4a6
comment:24 Changed 13 years ago by jmoore
(In [8834/omero]) Refactoring strings out to Messages.java (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8781 05709c45-44f0-0310-885b-81a1db45b4a6
comment:25 Changed 13 years ago by jmoore
(In [8837/omero]) Driver property and data source refactoring (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8784 05709c45-44f0-0310-885b-81a1db45b4a6
comment:26 Changed 13 years ago by jmoore
(In [8839/omero]) Moving more methods to SqlAction, mostly tests (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8786 05709c45-44f0-0310-885b-81a1db45b4a6
comment:27 Changed 13 years ago by jmoore
(In [8840/omero]) Moving delete using of session.connection to SqlAction (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8787 05709c45-44f0-0310-885b-81a1db45b4a6
comment:28 Changed 13 years ago by jmoore
(In [8841/omero]) Changing EventHandler? to use SqlAction.deferConstraints (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8788 05709c45-44f0-0310-885b-81a1db45b4a6
comment:29 Changed 13 years ago by jmoore
(In [8842/omero]) Adding SqlAction to SimpleWork before DeleteState (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8789 05709c45-44f0-0310-885b-81a1db45b4a6
comment:30 Changed 13 years ago by jmoore
(In [8843/omero]) Prevent misuse of org.hibernate.Session (See #2985, #2684)
original-svn-id: file:///home/svn/omero/trunk@8790 05709c45-44f0-0310-885b-81a1db45b4a6
comment:31 Changed 13 years ago by jmoore
(In [8847/omero]) Improvements to SqlAction (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8794 05709c45-44f0-0310-885b-81a1db45b4a6
comment:32 Changed 13 years ago by jmoore
(In [8848/omero]) Propagating SqlAction changes to Blitz (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8795 05709c45-44f0-0310-885b-81a1db45b4a6
comment:33 Changed 13 years ago by jmoore
(In [8849/omero]) Propagating SqlAction fixes to TableIdGenerator? (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8796 05709c45-44f0-0310-885b-81a1db45b4a6
comment:34 Changed 13 years ago by jmoore
(In [8850/omero]) More session hiding fixes (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8797 05709c45-44f0-0310-885b-81a1db45b4a6
comment:35 Changed 13 years ago by jmoore
(In [8860/omero]) Fixing ScriptRepoHelper? use of createSQLQuery (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8807 05709c45-44f0-0310-885b-81a1db45b4a6
comment:36 Changed 13 years ago by jmoore
(In [8861/omero]) Refactoring IAdmin.changePermissions' use of createSQLQuery (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8808 05709c45-44f0-0310-885b-81a1db45b4a6
comment:37 Changed 13 years ago by jmoore
(In [8862/omero]) Fixing long/string persistent event log loader issue (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8809 05709c45-44f0-0310-885b-81a1db45b4a6
comment:38 Changed 13 years ago by jmoore
(In [8863/omero]) Adding interfaces to our session wrapper (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8810 05709c45-44f0-0310-885b-81a1db45b4a6
comment:39 Changed 13 years ago by jmoore
(In [8869/omero]) Using new context xml pattern for database types (See #2684)
With the new pattern, any one who would like to introduce there
own extension to datalayer.xml need only create a file of the
form:
ome/services/db-SOMETHING.xml
original-svn-id: file:///home/svn/omero/trunk@8817 05709c45-44f0-0310-885b-81a1db45b4a6
comment:40 Changed 13 years ago by jmoore <josh@…>
- Resolution set to fixed
- Status changed from new to closed
(In [bf8e8214bfdc9ef2c9aa47b2386b7c80f136da7f/ome.git] on branch develop) Removed isolatedSqlAction; use PROPAGATION instead (Fix #2684, #3253, #3697)
comment:41 Changed 13 years ago by jmoore <josh@…>
(In [06e03246322567ce51e5cb22c5de090303597c5f/ome.git] on branch dev_4_1_custom) Initial work on removing all SimpleJdbcTemplate usages (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8778 05709c45-44f0-0310-885b-81a1db45b4a6
Significant reworking and merging needed. This commit is highly likely
non-functional. No changes were made to repo code due to the move from
blitz/ to tools/OmeroImporter
comment:42 Changed 13 years ago by jmoore <josh@…>
(In [d26bd69695d03e09ba6f5110ec5913ab21212e3a/ome.git] on branch dev_4_1_custom) Removing JdbcTemplate usages from GeomTool (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8780 05709c45-44f0-0310-885b-81a1db45b4a6
comment:43 Changed 13 years ago by jmoore <josh@…>
(In [e4721ce09ff551487701d2ac329aa0256249c931/ome.git] on branch dev_4_1_custom) Refactoring strings out to Messages.java (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8781 05709c45-44f0-0310-885b-81a1db45b4a6
comment:44 Changed 13 years ago by jmoore <josh@…>
(In [15e6923059ed801e4749b523d609a3bdb6726ed5/ome.git] on branch dev_4_1_custom) Driver property and data source refactoring (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8784 05709c45-44f0-0310-885b-81a1db45b4a6
comment:45 Changed 13 years ago by jmoore <josh@…>
(In [6ff13a5b55d9c7ddf90fbcd9f24a62caec575390/ome.git] on branch dev_4_1_custom) Moving more methods to SqlAction, mostly tests (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8786 05709c45-44f0-0310-885b-81a1db45b4a6
comment:46 Changed 13 years ago by jmoore <josh@…>
(In [3220ccc4ffdbe51ece2c3ac585b3ef4543a58e38/ome.git] on branch dev_4_1_custom) Moving delete using of session.connection to SqlAction (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8787 05709c45-44f0-0310-885b-81a1db45b4a6
comment:47 Changed 13 years ago by jmoore <josh@…>
(In [db05a647fc7774ed97438415fbed82eb64eb5188/ome.git] on branch dev_4_1_custom) Changing EventHandler? to use SqlAction.deferConstraints (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8788 05709c45-44f0-0310-885b-81a1db45b4a6
comment:48 Changed 13 years ago by jmoore <josh@…>
(In [4230117bf90c537ce1747ad5bba20217fe4054bb/ome.git] on branch dev_4_1_custom) Adding SqlAction to SimpleWork before DeleteState (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8789 05709c45-44f0-0310-885b-81a1db45b4a6
comment:49 Changed 13 years ago by jmoore <josh@…>
(In [2d5b9966445b9a77cd786e5733cb001e07231b1e/ome.git] on branch dev_4_1_custom) Prevent misuse of org.hibernate.Session (See #2985, #2684)
git-svn-id: file:///home/svn/omero/trunk@8790 05709c45-44f0-0310-885b-81a1db45b4a6
comment:50 Changed 13 years ago by jmoore <josh@…>
(In [306ec13dd6fc73a07c7e16a4e17ddbdaced440e9/ome.git] on branch dev_4_1_custom) Improvements to SqlAction (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8794 05709c45-44f0-0310-885b-81a1db45b4a6
comment:51 Changed 13 years ago by jmoore <josh@…>
(In [7a3bed86470f3c394c2b36269641b0a9cbf74268/ome.git] on branch dev_4_1_custom) Propagating SqlAction changes to Blitz (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8795 05709c45-44f0-0310-885b-81a1db45b4a6
comment:52 Changed 13 years ago by jmoore <josh@…>
(In [20f3f9a7ec6863d70834b163e6523471f79bf59f/ome.git] on branch dev_4_1_custom) Propagating SqlAction fixes to TableIdGenerator? (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8796 05709c45-44f0-0310-885b-81a1db45b4a6
comment:53 Changed 13 years ago by jmoore <josh@…>
(In [5e57d5e2fe5286499d2486da2b5474ffa12d3294/ome.git] on branch dev_4_1_custom) More session hiding fixes (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8797 05709c45-44f0-0310-885b-81a1db45b4a6
comment:54 Changed 13 years ago by jmoore <josh@…>
(In [7d91f687fe7bb26e5580793b90a222d7d94368d8/ome.git] on branch dev_4_1_custom) Fixing ScriptRepoHelper? use of createSQLQuery (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8807 05709c45-44f0-0310-885b-81a1db45b4a6
comment:55 Changed 13 years ago by jmoore <josh@…>
(In [3c14dad2e5bd8dd7ee95c25a1c39becef34375df/ome.git] on branch dev_4_1_custom) Refactoring IAdmin.changePermissions' use of createSQLQuery (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8808 05709c45-44f0-0310-885b-81a1db45b4a6
comment:56 Changed 13 years ago by jmoore <josh@…>
(In [b05e6035c60cffeb86bf45c2a47796919ede610f/ome.git] on branch dev_4_1_custom) Fixing long/string persistent event log loader issue (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8809 05709c45-44f0-0310-885b-81a1db45b4a6
comment:57 Changed 13 years ago by jmoore <josh@…>
(In [bc5b578dee40a8a590e76f52d821befd65060707/ome.git] on branch dev_4_1_custom) Adding interfaces to our session wrapper (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8810 05709c45-44f0-0310-885b-81a1db45b4a6
comment:58 Changed 13 years ago by jmoore <josh@…>
(In [fd807e12f4f81a94c502253abc1eae1c093ffa4e/ome.git] on branch dev_4_1_custom) Using new context xml pattern for database types (See #2684)
With the new pattern, any one who would like to introduce there
own extension to datalayer.xml need only create a file of the
form:
ome/services/db-SOMETHING.xml
git-svn-id: file:///home/svn/omero/trunk@8817 05709c45-44f0-0310-885b-81a1db45b4a6
comment:59 Changed 13 years ago by jmoore <josh@…>
(In [a7632310632e70b7ab440c71ec9f4bba1a543c6b/ome.git] on branch dev_4_1_custom) Removed isolatedSqlAction; use PROPAGATION instead (Fix #2684, #3253, #3697)
comment:60 Changed 13 years ago by jmoore <josh@…>
(In [7ac6cbd073399ce413d6ca629ceb2cf76f1953df/ome.git] on branch develop) Fixing ScriptRepoHelper.findInDb method after move to SqlAction (Fix #4379, See #2684)
During work on #2684, logic in findInDb which set the mimetype
was refactored out to SqlAction but what remained was a hard-
coded version with 'text/x-python' (ignoring the boolean).
See: [4ba6923cc95ed9c17d803e757db95fbdb40edbcb/ome.git], i.e. [r8807/omero]
comment:61 Changed 13 years ago by jmoore <josh@…>
(In [020a779fd872b865aa2b59476b680c4932ed7f56/ome.git] on branch dev_4_2) Fixing ScriptRepoHelper.findInDb method after move to SqlAction (Fix #4379, See #2684)
During work on #2684, logic in findInDb which set the mimetype
was refactored out to SqlAction but what remained was a hard-
coded version with 'text/x-python' (ignoring the boolean).
See: [4ba6923cc95ed9c17d803e757db95fbdb40edbcb/ome.git], i.e. [r8807/omero]
comment:62 Changed 13 years ago by jmoore <josh@…>
(In [d5818cd825a29d11f6fe2561605de173fc243af7/ome.git] on branch dev_4_2) Removed isolatedSqlAction; use PROPAGATION instead (Fix #2684, #3253, #3697)
comment:63 Changed 13 years ago by jmoore <josh@…>
(In [06e03246322567ce51e5cb22c5de090303597c5f/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Initial work on removing all SimpleJdbcTemplate usages (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8778 05709c45-44f0-0310-885b-81a1db45b4a6
Significant reworking and merging needed. This commit is highly likely
non-functional. No changes were made to repo code due to the move from
blitz/ to tools/OmeroImporter
comment:64 Changed 13 years ago by jmoore <josh@…>
(In [d26bd69695d03e09ba6f5110ec5913ab21212e3a/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Removing JdbcTemplate usages from GeomTool (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8780 05709c45-44f0-0310-885b-81a1db45b4a6
comment:65 Changed 13 years ago by jmoore <josh@…>
(In [e4721ce09ff551487701d2ac329aa0256249c931/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Refactoring strings out to Messages.java (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8781 05709c45-44f0-0310-885b-81a1db45b4a6
comment:66 Changed 13 years ago by jmoore <josh@…>
(In [15e6923059ed801e4749b523d609a3bdb6726ed5/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Driver property and data source refactoring (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8784 05709c45-44f0-0310-885b-81a1db45b4a6
comment:67 Changed 13 years ago by jmoore <josh@…>
(In [6ff13a5b55d9c7ddf90fbcd9f24a62caec575390/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Moving more methods to SqlAction, mostly tests (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8786 05709c45-44f0-0310-885b-81a1db45b4a6
comment:68 Changed 13 years ago by jmoore <josh@…>
(In [3220ccc4ffdbe51ece2c3ac585b3ef4543a58e38/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Moving delete using of session.connection to SqlAction (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8787 05709c45-44f0-0310-885b-81a1db45b4a6
comment:69 Changed 13 years ago by jmoore <josh@…>
(In [db05a647fc7774ed97438415fbed82eb64eb5188/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Changing EventHandler? to use SqlAction.deferConstraints (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8788 05709c45-44f0-0310-885b-81a1db45b4a6
comment:70 Changed 13 years ago by jmoore <josh@…>
(In [4230117bf90c537ce1747ad5bba20217fe4054bb/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Adding SqlAction to SimpleWork before DeleteState (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8789 05709c45-44f0-0310-885b-81a1db45b4a6
comment:71 Changed 13 years ago by jmoore <josh@…>
(In [2d5b9966445b9a77cd786e5733cb001e07231b1e/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Prevent misuse of org.hibernate.Session (See #2985, #2684)
git-svn-id: file:///home/svn/omero/trunk@8790 05709c45-44f0-0310-885b-81a1db45b4a6
comment:72 Changed 13 years ago by jmoore <josh@…>
(In [306ec13dd6fc73a07c7e16a4e17ddbdaced440e9/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Improvements to SqlAction (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8794 05709c45-44f0-0310-885b-81a1db45b4a6
comment:73 Changed 13 years ago by jmoore <josh@…>
(In [7a3bed86470f3c394c2b36269641b0a9cbf74268/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Propagating SqlAction changes to Blitz (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8795 05709c45-44f0-0310-885b-81a1db45b4a6
comment:74 Changed 13 years ago by jmoore <josh@…>
(In [20f3f9a7ec6863d70834b163e6523471f79bf59f/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Propagating SqlAction fixes to TableIdGenerator? (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8796 05709c45-44f0-0310-885b-81a1db45b4a6
comment:75 Changed 13 years ago by jmoore <josh@…>
(In [5e57d5e2fe5286499d2486da2b5474ffa12d3294/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) More session hiding fixes (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8797 05709c45-44f0-0310-885b-81a1db45b4a6
comment:76 Changed 13 years ago by jmoore <josh@…>
(In [7d91f687fe7bb26e5580793b90a222d7d94368d8/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Fixing ScriptRepoHelper? use of createSQLQuery (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8807 05709c45-44f0-0310-885b-81a1db45b4a6
comment:77 Changed 13 years ago by jmoore <josh@…>
(In [3c14dad2e5bd8dd7ee95c25a1c39becef34375df/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Refactoring IAdmin.changePermissions' use of createSQLQuery (See #2684)
original-svn-id: file:///home/svn/omero/trunk@8808 05709c45-44f0-0310-885b-81a1db45b4a6
comment:78 Changed 13 years ago by jmoore <josh@…>
(In [b05e6035c60cffeb86bf45c2a47796919ede610f/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Fixing long/string persistent event log loader issue (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8809 05709c45-44f0-0310-885b-81a1db45b4a6
comment:79 Changed 13 years ago by jmoore <josh@…>
(In [bc5b578dee40a8a590e76f52d821befd65060707/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Adding interfaces to our session wrapper (See #2684)
git-svn-id: file:///home/svn/omero/trunk@8810 05709c45-44f0-0310-885b-81a1db45b4a6
comment:80 Changed 13 years ago by jmoore <josh@…>
(In [fd807e12f4f81a94c502253abc1eae1c093ffa4e/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Using new context xml pattern for database types (See #2684)
With the new pattern, any one who would like to introduce there
own extension to datalayer.xml need only create a file of the
form:
ome/services/db-SOMETHING.xml
git-svn-id: file:///home/svn/omero/trunk@8817 05709c45-44f0-0310-885b-81a1db45b4a6
comment:81 Changed 13 years ago by jmoore <josh@…>
(In [a7632310632e70b7ab440c71ec9f4bba1a543c6b/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Removed isolatedSqlAction; use PROPAGATION instead (Fix #2684, #3253, #3697)
(In [8778/omero]) Initial work on removing all SimpleJdbcTemplate usages (See #2684)