Oracle Jdbc Driver in Behaviours plugin

[Mizan]

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 .

[JamieA · Accepted solution]

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.

[Mizan]

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

[dayuyang]

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

[ShamhoonJ]

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!

[JamieA]

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

[Mizan]

@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