Database Values Plugin (jira-database-values-plugin) how to prepere Connection string

How to prepere Connection String to Connect Database Values Plugin with MS SQL. Please Help.

Here is documentation for this plugin:

https://bitbucket.org/wimdeblauwe/jdvp/wiki/Home#markdown-header-general

 

2 answers

0 vote

What connection string would you use in any other code?

Although the Atlassian docs do cover this for manual connections to MS-SQL, so you can use their examples - see https://confluence.atlassian.com/jira/connecting-jira-to-sql-server-2012-610763188.html and look near the bottom for "database connection fields" - that should give you a good guide

I want to connect with this Extention Nic. Have You tried this on extension ? I cant connect to MS SQL by this Extention.

Have you read the documentation I pointed to - it tells you how to set up a datasource

Yes I ws tried. But itdon't run wit this plugin. Have You Tried Nic this plugin ? I write like this: database.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver database.user=Login database.password=******** database.connection.url=jdbc:jtds:sqlserver://11.11.1111:1433/Database_Name

Yes, many times, and on different databases. "Itdon't run wit this plugin" just tells us that you've got something wrong. Try correcting the errors (e.g. do you *really* have a user called "Login"?) The doc I pointed to tells you how to work out and use the connection strings, and it works absolutely fine for me. Only used it last week, which is why I picked on it.

And How we could find out Nic that we connected database or not. Because we don't know that we connected database, or we have got a mistake with Query, or in HTML view. How find out that connection in right and plugin is connected.

I'm not sure what you're asking now - it seems to be for us to know what your database settings are and how you've configured them, but we can't tell you that, they're your systems! First question - how have you set up the add-on? Have you followed the instructions for creating the data source? Your original question was about formatting/building the connection string, and the doc I pointed to tells you how to take your raw settings and convert them to the string you need in there. But we can't tell you if they're right. The second question is how have you set up the field(s) you need?

But we cund find out nic by errors is we configured our Database right or wrong ? The Extensions haven't got error masages the connection is good or not ? AD.1. Yes I was fallow the instructions, but I have got still none Values. I can show after connection all my Query, but it hive back None Values: # Cache Timeout (= 15 minutes by default). The actual db is queried only once and then the results are kept in the cache for the given timeout. Uncomment the line below to change it. cache.timeout=1000 # The SQL Query that will be executed on the database sql.query=SELECT TOP 10 ContactId As ID, FirstName, LastName, "Krakow" as city, "Polska" as Country FROM ContactBase # Cache Timeout (= 15 minutes by default). The actual db is queried only once and then the results are kept in the cache for the given timeout. Uncomment the line below to change it. #cache.timeout=900000 # The column number (starting from 0) that contains the primary key of the returned data. primarykey.column.number=0 # The pattern that should be used to render the data in view mode. Use {column_number} as placeholders. You can use HTML, but make sure you close your tags properly! rendering.viewpattern={1} {2} from <a href="http://maps.google.com/maps?f=q&hl=nl&geocode=&q={3}, {4}">{3}, {4}</a> # The pattern that should be used to render the data in edit mode. Use {column_number} as placeholders. rendering.editpattern={2}, {1} # The pattern that should be used to render the data in searcher. Use {column_number} as placeholders. rendering.searchpattern={1} {2} ({0}) # This is used when sorting in the issue navigator. When not defined, the 'rendering.viewpattern' is used. rendering.sortpattern={1} {2} # Use 0 to have a combobox for editing, 1 to have AJAX-style input field, 2 for cascading select edit.type=0 # Use 0 to have a list for searching, 1 to have AJAX-style input field search.type=0 # The pattern that is used for the history and the activity view. If not specified, the 'rendering.viewpattern' is used. Note that you cannot use HTML. rendering.changelog.viewpattern={1} {2} # The pattern that is used for the pie chart, 2d filter statistics and single level group by. If not specified, the 'rendering.viewpattern' is used. Note that you cannot use HTML. rendering.statistics.viewpattern={1} {2}

If the connection is wrong, you should see errors in the log. If it's working, then the field will work.

Hello Nick. I find out a log error, abaut database name. Please help: at java.sql.DriverManager.getConnection(DriverManager.java:247) at java.sql.DriverManager.getConnection(DriverManager.java:689) java.sql.SQLException: No suitable driver found for jdbc:sqlserver:ServerName:DataBaseName 2015-12-09 15:59:31,876 http-bio-80-exec-19 ERROR MyLogini 959x32336x1 3s21vf 10.0.3.55 /secure/QuickCreateIssue.jspa [jira.plugin.databasevalues.DatabaseRowCache] No suitable driver found for jdbc:sqlserver:ServerName:DataBaseName

Nic would You know where is common\lib directory to put driver on it Please Help.

Ah, ok. The driver needs to be the plain .jar file, and placed in the *Tomcat* lib directory (I'm assuming you're using a roughly default JIRA install, not installed in a different app server). So, <jira install>/lib

Can You Nick look at my answer screen please?

Did you restart the Tomcat completely? Are there errors in the logs?

Oh, hang on, you should be using the jtds driver too - Microsoft's jdbc drivers are awful bug-ridden junk...

Yes I restarted Tomcat completely, and I have got errors on the log. On localization as on screen I put thetwo drivers: jtds-1.2.4.jar and was a jtds-1.3.1.jar. Maybe it's better to put in another localizations. Or Ishould Register this files on Jira ? I only put tchem in catalog.

That makes no sense. First, you need *one* version of the driver. If there's one already there, do NOT replace it with another, or have another version in there. I have no idea what you mean by "localization" - the locales have nothing to do with system drivers. Registering drivers in JIRA is nonsense, and I've got even less idea what you might mean by "catalog"

But the secound wos added on lib catalog or folder. So I must delete this ? Localisation I understand a lib catalog or folder. Idon't know why this don't work. If we tried to write It in Java with this driver it wos working.

If we tried with this driver programing by Java in Eclipse it was working.

I put there yesturday, but this not work:

 

Databasefield.png

 

 

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published yesterday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

60 views 0 3
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