JIRA upgrade - NPE on a plugin

[ladis salvador]

My company still using on production JIRA 3.13. I have a separate testing instance. I have upgraded sucessully on my testing instance from 3.13 to 4.2.1.. but i've observed many errors mostly related with the 3rd party plugin(we have 3 to 4 of those on our JIRA.)..During the upgrade i recompiled the plugins against 4.2.1... .. Time later i tried to perform a new upgrade from 4.2.1 to 4.3.4.. Once again one of the plugins is complainin is not picking up values from the Oracle database (that particular plugins connects to the database). its getting a a 'java.NullPointerException'.... and my tips is looking for a class on Oracle... my questions is is that class part of the 'UCP' or just part of the 'ojdbc'..

what's exactly the ucp jar does??

java clas the connects to oracle

"public class DBQueryHandler {

static String className = "oracle.jdbc.pool.OracleDataSource";
static String urlname = "jdbc:oracle:thin:@localhost:1521:XE";
static String userName = "jirax";
static String password = "jirax";



static Statement stmt;

UniversalConnectionPoolManager mgr;
PoolDataSource pds;

"

here 's the log:

Caused by: java.lang.NullPointerException
at com.oxxxx.jira.plugins.CIS.DBQueryHandler.returnResultsAsArray(DBQueryHandler.java:219)
at com.oxxxx.jira.plugins.CIS.CISFactory.getInstance(CISFactory.java:96)
at com.oxxxx.jira.plugins.CIS.CISFactory.getChildren(CISFactory.java:421)
at com.oxxxx.jira.plugins.CIS.CISFactory.getAllChildren(CISFactory.java:362)
at com.oxxxx.jira.plugins.CIS.CISFactory.getAllChildren(CISFactory.java:369)
at com.oxxxx.jira.plugins.CIS.CISfield.getValueFromIssue(CISfield.java:82)
at com.atlassian.jira.issue.fields.CustomFieldImpl.getValue(CustomFieldImpl.java:317)
at com.atlassian.jira.issue.fields.screen.StandardFieldScreenRendererFactory.getCustomFieldRenderLayoutItem(StandardFieldScreenRendererFactory.java:145)
at com.atlassian.jira.issue.fields.screen.StandardFieldScreenRendererFactory.createFieldScreenRenderer(StandardFieldScreenRendererFactory.java:106)
at com.atlassian.jira.issue.fields.screen.StandardFieldScreenRendererFactory.createFieldScreenRenderer(StandardFieldScreenRendererFactory.java:75)
at com.atlassian.jira.issue.fields.screen.StandardFieldScreenRendererFactory.createFieldScreenRenderer(StandardFieldScreenRendererFactory.java:52)
at com.atlassian.jira.issue.fields.screen.FieldScreenRendererFactoryImpl.getFieldScreenRenderer(FieldScreenRendererFactoryImpl.java:59)
at com.atlassian.jira.issue.fields.screen.FieldScreenRendererFactoryImpl.getFieldScreenRenderer(FieldScreenRendererFactoryImpl.java:42)
at com.atlassian.jira.issue.fields.screen.FieldScreenRendererFactoryImpl.getFieldScreenRenderer(FieldScreenRendererFactoryImpl.java:65)
at com.atlassian.jira.web.action.issue.AbstractCommentableIssue.getFieldScreenRendererWithAllFields(AbstractCommentableIssue.java:200)
at com.atlassian.jira.web.action.issue.AbstractCommentableIssue.getFieldScreenRendererLayoutItemForField(AbstractCommentableIssue.java:188)
at com.atlassian.jira.web.action.issue.ViewIssue.getCommentBoxHTML(ViewIssue.java:1167)

thanks

[MatthewC]

It sounds like you may not have copied the jar from your old install of Jira to the new one? The Oracle drivers won't be included with Jira by default and you have to manually install them by copying them into the lib directory at the tomcat level. UCP is another jar that sits along side the ojdbc jar)

http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+Oracle

UCP: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/ucp-085009.html