Oracle Jdbc Driver in Behaviours plugin

Hi All / Jamie ,

I need to use Behaviours for Jira 5.1 ... i tested it by disabling inline edits and it works fine in my case . one of my script requires to connect to an oracle database .. I was not able to find the source code of the compatible plugin so that i can add the jdbc jar and build the plugin .

Can you please provide me the source code or a Jar with oracle driver .

Thank you .

1 answer

1 accepted

It's on the attachments page.

https://studio.plugins.atlassian.com/wiki/download/attachments/2261853/Behaviours-jira-0.5.0-src.zip

I'd consider waiting for the next release which will make things simpler, as I will drop support for everything but jira 5.1.

Thanks alot Jamie , i need the plugin as we might upgrade our Jira next week . I will update the plugin when the next release is available .

Thank you once again

Hi Jamie,

Behaviours plugin is great and very useful for us! Glad to hear that you will make it support JIRA 5.1

Just want to know:

  • Will it support inline mode behaviour control?
  • When will you release it?

Thank you

Hi Guys,

Was the oracle jdbc driver connection fixed in behaviors -plugin, we are running JIRA 5.1, please see my code (may be my code is incorrect)

import com.atlassian.jira.ComponentManager
import groovy.sql.Sql

FormField formField = getFieldById(fieldChanged)
FormField AssetField = getFieldById("customfield_12103")

String currentassetid=AssetField.getFormValue()

def currUser = ComponentManager.getInstance().getJiraAuthenticationContext().getUser()
String currUserName = currUser.getName()

db = Sql.newInstance(
            'jdbc:oracle:thin:@//serverA:1521/SYMPH',
            'USER', 'PASSWORD', 'oracle.jdbc.driver.OracleDriver')

 String sqlString = "select aradmin.DJAST_CLASSAPPLICATION_SOX_APP.APPROVER_LOGIN from aradmin.DJAST_CLASSAPPLICATION_SOX_APP where aradmin.DJAST_CLASSAPPLICATION_SOX_APP.ASSET_ENTRY_ID='$currentassetid' AND aradmin.DJAST_CLASSAPPLICATION_SOX_APP.APPROVER_LOGIN='$currUserName' AND aradmin.DJAST_CLASSAPPLICATION_SOX_APP.APPROVAL_TYPE = 1"
String row = db.firstRow(sqlString) 

formField.setFormValue(row)

The field is not getting set, I removed the SQL connection and set the field with local value it works. Please help!

You need to add some logging. There may well be an exception in the logs.

@Jamie

Does the plugin version 0.5.6 which is the latest currently has oracle drivers ?

I was not able to find the source code for this plugin. Can you please provide me the source code so that I can add a dependency fro oracle drivers and rebuild the plugin.

Thanks

Mizan

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Agile

How Scrum works? It starts with training and education

To answer “How scrum works,” most of the teams I've worked with first addressed the question: “where to start?”  That question applies to both implementation and improvements on the Scrum framew...

167 views 3 5
Read article

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