Context Navigation

Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

User Story #3884 (closed)

Opened 9 years ago

Closed 9 years ago

Cross-db validation & transformations

Reported by:	jamoore	Owned by:	jamoore
Priority:	critical	Milestone:	OMERO-Beta4.3
Component:	ORM	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

Some databases cannot handle of a particular format, or make assumptions about data that others do not. Each of these assumptions or special cases will need to be handled in a single location, both for JDBC as well as Hibernate code paths.

References

Referenced by:

← Requirement (#73): Enable multi-database support
References:
→ Task (#3885): Non-nullable string fields may need to have a space inserted. ( Owner: jamoore Remaining Time: 0 ) → Task (#3886): Database entity name length limits ( Owner: jamoore Remaining Time: 0 ) → Task (#56): Code-generated db schema needs intially deferred constraints. ( Owner: jamoore Remaining Time: 0 ) → Task (#4052): Build2 for testing DBs ( Owner: jamoore Remaining Time: 0 ) → Task (#3977): Bug: some dbs returns different array types ( Owner: jamoore Remaining Time: 0 ) → Task (#3961): Bug: select ... in (:ids) possibly limited ( Remaining Time: 0 ) → Task (#3971): Bug: "select distinct" fails when array columns present for some DBS (2 - loadRoi) ( Owner: jamoore ) → Task (#3973): Bug: "select distinct" fails when array columns present for some DBS ( Owner: jamoore Remaining Time: 0 ) → Task (#3968): BUG:Feedback 3161 Opening Dataset with too many ids in set ( Owner: jamoore ) → Task (#3969): BUG:Feedback 3160 tagging images ( Owner: jamoore Remaining Time: 0 ) → Task (#3970): BUG:Feedback 3158 import plate sends too many ids ( Owner: jamoore )

Change History (2)

comment:1 Changed 9 years ago by agilo

Status changed from new to accepted

Updated status, related task in progress

comment:2 Changed 9 years ago by jmoore

Resolution set to fixed
Status changed from accepted to closed

Many initial corners cases have been found. These include:

relation name lengths
quoting of restricted or keywords
deferrable handling
allowed delimiters

More will certainly be found but these can be classified as "bugs".

Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

Download in other formats: