Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

PSQLException: ERROR: column "qualifier" does not exist

Dear Atlassian Answers,

we are currently developing a plugin which utilized the JIRA intern Database and creates new tables/ columns etc.

When querying a column we get the following error:

Caused by: org.postgresql.util.PSQLException: ERROR: column "qualifier" does not exist
  Position: 91
	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.executeQuery(
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(
	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(
	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.find(
	... 279 more

The reason for this is that the columns in JIRA are always saved in upper case letters ("QUALIFIER") while the query itself utilized lower case letters. Is there any workaround which helps in this case?

Best regards,


2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

we use something like 
ActiveObjectImporterConfiguration importerConfiguration = ao.create(ActiveObjectImporterConfiguration.class);

which does not allow us to change the select/ create query. It always uses the lowercase variant.

We know that H2 and MySQL is not case sensitive, but our plugin also has to work for Postgres databases

That's odd, are you certain that it's a create() that triggers the exception?

It is actually the find who triggers the exception, you are right (we need to find the object first, eventually delete it and recreate it as an update mechanism, ao does not provide update functionality otherwise)

We fixed the problem now though, the reason where Missing Quotes in the following line:

        .where("QUALIFIER=? AND IDENTIFIER=?",c...

which needed to be changed to

        .where("\"QUALIFIER\"=? AND \"IDENTIFIER\"=?",c....

Furthermore we applied


fields to our application

Still a little strange, I wasn't required to apply quotes so far including when testing with postgres. Anyhow, glad you fixed it!

I'm guessing the query worked fine with the H2 DB and now that you're testing in an environment with a postgres DB - is that correct? That's because the latter is case sensitive in that regard while H2 is not and neither is MySQL by the way.

Use uppercase in your SQL query and you should be fine!

AUG Leaders

Atlassian Community Events