I was able to install and configure the Jira Database Values Plugin without significant issues. I set up the properties file to use a dropdown style input field, and was able to see all my database results as expected. However, if I switch to the AJAX style input field, no results are shown... it just appears to be a text input field.
For testing, I turned on debugging and opened a ticket. Here's what appeared in the log:
2013-06-03 08:05:11,992 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] Setting jql queries: {}
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] Got 0 substitutions in map
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] sql query after substitutions: select PartNum, CAST(PartDescription as varchar(255)) from Part where Company = 'ABC'
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] Got 0 substitutions in map
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] sql query after substitutions: select PartNum, CAST(PartDescription as varchar(255)) from Part where Company = 'ABC'
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] No project cache for InternalDefaultProjectKey
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] Got 0 substitutions in map
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] sql query after substitutions: select PartNum, CAST(PartDescription as varchar(255)) from Part where Company = 'ABC'
2013-06-03 08:05:12,149 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] SQL query: select PartNum, CAST(PartDescription as varchar(255)) from Part where Company = 'ABC'
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] Query returned 67843 rows
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] Showing first 5 records for debugging:
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=0, values={0=0000477026401, 1=PCB 96}]
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=1, values={0=0000688364000, 1=SSCRN: RETRO-FIT COMPUTER,REAR PANEL}]
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=2, values={0=0000879504000, 1=UTIL DIAG: SINGLE CHAMBER}]
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=3, values={0=030-070, 1=Keyboard holder}]
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=4, values={0=030-091, 1=Adaptor}]
