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 .
It's on the attachments page.
I'd consider waiting for the next release which will make things simpler, as I will drop support for everything but jira 5.1.
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!
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.
It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG