Stored Procedures NOT executable using this Microsoft SQL Server JDBC Driver

dev support
1

Running:

  • CentOS 7.6.1810
  • Lucee 5.2.9.31
  • DSN Source is using - Microsoft SQL Server (JDBC4 - Vendor Microsoft)
    class: ‘com.microsoft.sqlserver.jdbc.SQLServerDriver’
    , bundleName: ‘mssqljdbc4’
    , bundleVersion: ‘6.0.7728.100’

I have the following enabled

  • Select
  • Insert
  • Update
  • Delete
  • Create
  • Drop
  • Revoke
  • Alter
  • Grant

I noticed there is no Stored Procedures option for me to use. On a separate CF server, I noticed I do have the option to use Stored Procedures. It makes me wonder if the JDBC driver I am using on this Lucee / CentOS box does not have the ability to execute stored procedures.

Anybody know how to solve this issue?

Any help is appreciated.

2

Got a stacktrace?

3

Lucee server doesn’t need a stored procedure option, Without the option lucee can work with Stored procedures as well. I don’t know why the ACF kept this option. I think lucee may build within MS SQL JDBC driver. If you facing any issue post it here.

5

I figured out the problem, even though my datasource was pointing at the correct database, I changed this

<CFSTOREDPROC PROCEDURE="ClientCallData_Parse_XML_v2" DATASOURCE="xxx" >

to this

<CFSTOREDPROC PROCEDURE="ClientProductionData..ClientCallData_Parse_XML_v2" DATASOURCE="xxx" >