Open issues

When we remove a @Unique constraint, Active Objects is not able to drop the constraint
AO-3489
Join two Active objects tables on multiple fields
AO-3506
Entity with @Ignore/@Transient + default method
AO-3505
Create Oracle 18/19 tests for Active Objects
AO-3496
Bitbucket branch created via Jira but no commits appear
AO-3494
Removing non-null constraint in a column with a pre-existing default value breaks MSSQL upgrade task
AO-3493
After schema changes ActiveObjects yields exception "cached plan must not change result type" with PostgreSQL - JDBC driver 9.4
AO-697
Open AO database importer packages to other plugins
AO-689
Distinct query on an entity having an unlimited length text field results in exception on MS SQL Server
AO-687
TenantAwareActiveObjects blocks Jira during startup
AO-678
AcitveObjects generated queries with large IN clauses that result in SQL Server errors
AO-652
OneToMany relations are not being updated on same transaction
AO-598
Date fields are incorrectly preloaded on Oracle
AO-579
net.java.ao.db.SQLServerDatabaseProvider#setQueryResultSetProperties is not converting from zero-based to one-based
AO-385
ActiveObjects removes and refetches Enum values from the database
AO-382
Create SQL Server 2019 tests for Active Objects
AO-3500
Create PostgreSQL 12 tests for Active Objects
AO-3499
Create PostgreSQL 10/11 tests for Active Objects
AO-3497
Adding an ActiveObject table with a namespace, duplicates existing no-namespace AO tables
AO-3495
AO generates invalid SQL when GROUP BY query selects an aggregate column
AO-3490
MS SQL database for JIRA set to *SQL_Latin1_General_CP437_CI_AI' but fails Collation test - why?
AO-3478
Return long for ao.count method
AO-3477
Where clause column names on right hand side of conditional operator are not quoted for postgres
AO-3458
Two tests fail when run in a transaction
AO-3456
AO: Standard Case Insensitive Order
AO-3446
MySQL is blocking a thread and hanging the UPM installation
AO-3442
Support for specifying ASC/DESC for each element in a multicolumn index
AO-3431
Table name is not being quoted in "join/on" and "where"
AO-3428
NullPointerException on ao.create operation
AO-3413
Problems with deleting a table
AO-3411
Parameters order is not predictable leading to ORA-24816 when inserting a row into a table with Unlimited string column and another (limited) string column
AO-3395
Add coverage for Microsoft JDBC Driver 6.0.7507
AO-3387
Default ANSI quotes for MySQL table names
AO-3370
Active Objects runs out of connections when migrating enough times
AO-711
AO.create() fails on SQL Server when default schema is not configured and when generated primary key is overridden
AO-710
More JDBC driver tests
AO-707
SonarQube - Analyse and fix all Critical issues
AO-702
Deprecate ActiveObjects stream methods
AO-694
Provide AO table prefix for plugins
AO-642
Creating a table with any index and @Unique fails on Oracle with ORA-01408
AO-436
Distinct does not work with count for a field
AO-398
Describe available servlets in project's README.md
AO-3498
Fail during migrating CLOB type column with missing index in Oracle DB
AO-3465
Foreign key columns are not being preloaded by default
AO-3454
AO DatabaseUpdater causes failures on oracle
AO-3392
AO race condition leads to AO deadlock on DB migration
AO-3388
Fix Javadocs For JDK 8 Linting
AO-700
Clean up maven-dependency-tracker-plugin
AO-3509
issue 1 of 48

When we remove a @Unique constraint, Active Objects is not able to drop the constraint

Description

We removed @Unique constraints from some of our tables and some Exceptions were thrown in the log file.

We have several MSSQL cases with the following log.

 

and one Oracle SQL scenario with the error:

 

The only change in our plugin was removing the @Unique annotation.
Our plugin active objects dependency:

What can we do fix this issue?

Environment

None

Testing Notes

Add notes...

Status

Assignee

Unassigned

Reporter

Hugo Freixo

Labels

None

Add-on Type

Server

Team

None

CC

None

Risk factor

None

QA Kickoff Status

None

QA Demo Status

None

Components

Priority

Blocker
Configure