Rate this page:
This page contains some guidelines for best practices when developing a plugin that uses the Atlassian Active Objects (AO) plugin to store and retrieve data. The information takes the form of a quick reference sheet with links to pages containing further information.
Currently, the Atlassian Active Object framework does not support binary large objects (BLOBs). Plugins that work with BLOBs fail. Until there is full support, do not write AO plugins that manipulate BLOBs.
Specify table names in annotations
Use the annotation to specify your table names so that you can freely rename the entity interface. For example, . See Upgrading your plugin and handling data model updates.
Do not remove column names from Java code on upgrade
When upgrading your plugin to a new version, do not remove columns unless you are aware of the consequences. Active Objects will make the database match the entity interface in the Java code. It alters tables to match the current interface. Removing columns will result in data loss. For that reason, we recommend that you do not delete tables or columns, only add them. See Upgrading your plugin and handling data model updates.
If your plugin needs a different table structure after the upgrade, your upgrade task should:
Take care when renaming entities
The Active Objects framework does not know about renaming. So if you change the name of an entity, it will remove the other entity and create a new one. All the data in the entity will be lost. See Upgrading your plugin and handling data model updates.
When changing data type, migrate the data as part of the upgrade process
When migrating from one data type to another, the recommended approach is not to use an in-place type conversion. Instead, create a new column and migrate the data during the upgrade process. See Upgrading your plugin and handling data model updates.
Column names are case-sensitive
If you need to specify the raw column names in create or find operations, letter case is important. See Column names.
Column names should be in quotes
Active Objects doesn't automatically add quotes to column names in ORDER BY clauses. Depending on which database you are using, this may cause errors. For instance, this works on HSQLDB (the SDK default), but it does not work in PostgreSQL.
To avoid errors, we recommend that you always put column names within quotes in your ORDER BY statements, such as:
ORDER BY "COLUMN_NAME"
Use 'stream' rather than 'find' or 'get' methods for large amounts of data
When reading a large amount of data, do not use the 'find' of 'get' methods. Instead, use the 'stream' methods. See this blog post: ActiveObjects streaming API.
The 'find' and 'get' methods read everything into memory as editable AO objects, which is very memory intensive. The 'stream' methods return read-only objects, which are cheaper to create, and give them to you one-by-one.
Delete all related data in the right order
When deleting object graphs, or data from related tables, you will need to delete them in the right order. Make sure you delete the children before the parents. AO does not support cascading.
Use lazy initialisation with synchronisation
The Active Objects framework cannot be used during plugin startup. The easiest way to get around this is to perform any initialisation tasks only during the first HTTP request. As ActiveObjects service is not thread-safe during first call, it is also important to ensure other HTTP request threads are blocked while initialisation is being performed.
Operators must be space-delimited in WHERE clauses
When using an operator in a clause (such as the equals ("=") operator or the greater than (">") operator, spaces must be used to separate the operator from its operands. In other words, the following code is incorrect:
While this code is correct:
Query.select().where("FOO = 'bar'");
Column names in WHERE clauses must be in upper case
Mixed or lower-case column names in the clause will cause errors when running on PostgreSQL.
Boolean literals in WHERE clauses
Do not embed the boolean literal string or in a WHERE clause using Active Objects. This may cause incompatibilities with Microsoft SQL Server, such as the following error:
java.sql.SQLException: Invalid column name 'TRUE'.
Instead, use a substitution variable and supply the value or , like so:
Query.select().where("SOME_COLUMN IS ?", Boolean.TRUE);
See this question on Atlassian Answers for more detail.
Rate this page: