ActiveObjects and PostgreSQL - column names case sensitivity problems


I'm developing a JIRA plugin in which I use ActiveObjects (using version 0.19.7). I have entities which I want to find using ActiveObjects queries. E.g. like this:,"SOME_ATTRIBUTE=?", someAttributeValue);

I know that PostgreSQL handles column names case sensitively, I double checked that the database table has the physical column names in uppercase. Therefore I always use uppercase queries as in the example above.

Regardless of this, I always get the below exception:

Caused by: org.postgresql.util.PSQLException: ERROR: column "some_attribute" does not exist

Position: 55

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(

at org.postgresql.core.v3.QueryExecutorImpl.processResults(

at org.postgresql.core.v3.QueryExecutorImpl.execute(

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(



at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(

Any idea how to overcome this with PostgreSQL?

Thank you,


1 answer

1 accepted

This widget could not be displayed.

If you phrase you query with spaces before and after the equation mark (=), then AO uses the correct column name in queries. So the correct query is (nopte the spaces before and after the = character):,"SOME_ATTRIBUTE = ?", someAttributeValue);

Sad that I lost a few hours on this...

interesting! Thanks for sharing it..

I had similar problem with migration from local dev (mysql) to company dev environment (postgress). Exploding "QUERYCOLUMN=", with spaces solved this issue.

Thanks for tip.

Thanks for the answer, wasted a lot of time with this to.

We had the same issue,still not possible to do something like "lower(name) = ?" with PostgreSQL.

So I lost full day, but found solution.

My case is Postgresql 8, Jira 5.0.4. AO 0.18.2

In the following string column names should be in uppercase and also dont forget trailing spaces at the both sides of "=". If you want to use ORDER BY or other sql syntax you should escape them with quotes according to DB.

" PROJECT = ? AND MASTERISSTYPE = ? ORDER BY \"ID\"", projectId, masterIssueTypeId);

Also i found that 0.18.5 and 0.19.7 versions dont give a good result. At my own opinion developers have broken something you can see those links:

also you can try version 0.22 and write here about results

Hi Tibor, adding spaces for equation works fine. However I am facing the same problem while ordering. For instance, here is my query ending with order statement and getting the same error for "SORT_ORDER" column .order("myTable.SORT_ORDER")); Any idea, how I can achieve this problem? Thanks Tuncay

I think order("SORT_ORDER") is enough

The SQL has join statements so that I needed to use alias. I'm gonna try to use uppercase of alias name although I do not give it a chance.

Is it possible to somehow configure HSQLDB to work in the same way as postgres for this case? So that such errors are found on early stages during automated tests run.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

286 views 1 4
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you