Do I have to close the connection that I got via new DefaultOfBizConnectionFactory().getConnection()?

[Nabil Sayegh]

Hi,

my calculated custom field needs to query the database and therefore gets a database connection via DefaultOfBizConnectionFactory().getConnection(). Do I have to close that connection explicitly and the end of my plugin's method?

[Nabil Sayegh · Accepted solution]

If I close the Connection explicitly, I get the following errors, so I assume you must not close the connection:

java.lang.IllegalStateException: The OpTimer has been re-used.  end() can only be called once!
	at com.atlassian.instrumentation.operations.SimpleOpTimer.end(SimpleOpTimer.java:142)
	at com.atlassian.instrumentation.operations.SimpleOpTimer.end(SimpleOpTimer.java:99)
	at com.atlassian.instrumentation.operations.SimpleOpTimer.end(SimpleOpTimer.java:117)
	at com.atlassian.jira.ofbiz.InstrumentedSQLInterceptor.onConnectionReplaced(InstrumentedSQLInterceptor.java:38)
	at com.atlassian.jira.ofbiz.ChainedSQLInterceptor.onConnectionReplaced(ChainedSQLInterceptor.java:75)
	at org.ofbiz.core.entity.jdbc.interceptors.connection.ConnectionTracker$ConnectionWithSQLInterceptorImpl.close(ConnectionTracker.java:96)
	at com.example.jira.customfields.SprintField.close(SprintField.java:106)
...

Closing the ResultSet and Statement should be done nevertheless.

[reyes hernandez]

We have the same problem. Do you finally find the correct way to do it?

[Nabil Sayegh]

IIRC, we only closed the ResultSet and the Statement.