Stored Procedures NOT executable using this Microsoft SQL Server JDBC Driver


  • CentOS 7.6.1810
  • Lucee
  • DSN Source is using - Microsoft SQL Server (JDBC4 - Vendor Microsoft)
    class: ‘’
    , 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.

Got a stacktrace?

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.

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


to this

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