Task #56 (closed)
Opened 18 years ago
Closed 13 years ago
Code-generated db schema needs intially deferred constraints.
Reported by: | jamoore | Owned by: | jamoore |
---|---|---|---|
Priority: | critical | Milestone: | OMERO-Beta4.3 |
Component: | DSL | Version: | 3.0-M1 |
Keywords: | n.a. | Cc: | |
Resources: | n.a. | Referenced By: | n.a. |
References: | n.a. | Remaining Time: | 0.0d |
Sprint: | n.a. |
Description
The hibernate-generated schema file (currently ddl.sql) is missing INITIALLY DEFERRED on constraints. Google, Hibernate Wiki, Hibernate Forum, and Hibernate
documentation show no signs. Next is examining the source-code. This may be something we have to implement ourselves. In that case, a post-processing step
of the sort:
's/^alter\stable\s(\w+?)\sadd\sconstraint\s(\w+?)\sforeign\skey\s\((\w+)\)\sreferences\s(\w+?);/.../'
Originally: http://bugs.openmicroscopy.org.uk/show_bug.cgi?id=613
Change History (7)
comment:1 Changed 13 years ago by jmoore
- Milestone changed from Unscheduled to OMERO-Beta4.3
- Priority changed from minor to critical
- Remaining Time set to 0.5
- Sprint set to 2011-02-24 (6)
comment:2 Changed 13 years ago by jmoore
- Remaining Time changed from 0.5 to 0.25
- Sprint changed from 2011-02-24 (6) to 2011-02-10 (5)
- Status changed from new to accepted
comment:3 Changed 13 years ago by jmoore <josh@…>
(In [e674a54d9348019232e54d54bbd8b55eb12d794a/ome.git] on branch dev_4_1_custom) Adding "deferrable initially deferred" post-processing to ddl.sql (See #56)
comment:4 Changed 13 years ago by jmoore
- Remaining Time changed from 0.25 to 0.20
- Sprint 2011-02-10 (5) deleted
Previous commit has a working solution for this which is in production for other #73 databases. However, we will need to test it specifically for postgres. At the moment, "omero.db.defer" is set to "" so that these statements aren't generated. If "deferrable initially deferred" works, then the sql.deferConstraints() method might can be removed. Moving out of the current sprint.
comment:5 Changed 13 years ago by jmoore <josh@…>
(In [e674a54d9348019232e54d54bbd8b55eb12d794a/ome.git]on branches 4_1_custom, dev_4_1_custom, josh/4.1-web-backport) Adding "deferrable initially deferred" post-processing to ddl.sql (See #56)
comment:6 Changed 13 years ago by jmoore <josh@…>
(In [56818980d23e90273900ec3d9cd17c2a89336a96/ome.git] on branch develop) Adding "deferrable initially deferred" post-processing to ddl.sql (See #56)
comment:7 Changed 13 years ago by jmoore
- Remaining Time changed from 0.20 to 0
- Resolution set to fixed
- Status changed from accepted to closed
This has been added and can be considered closed as a part of #73
As a part of #73, it will now be a time to finally start tackling this.