Skip to main content
M
miguel.glez.mx
Participant
May 3, 2022
Answered

Sql server en Coldfusion 2021

  • May 3, 2022
  • 1 reply
  • 275 views

Tengo un problema con la configuración de Coldfusion 2021, ya configuré mis datasource de Microsoft Sql Server y la verificación de los mismos es EXITOSA, el problema viene cuando hago la modificación del "virtual directory", dentro del archivo server.xml ubicado en: C:\ColdFusion2021\Mi_Instancia\runtime\conf, mi Context queda de la siguiente manera: 

<Context path="/app" docBase="C:\ColdFusion2021\Mi_Instancia\wwwroot" WorkDir="C:\ColdFusion2021\Mi_Instancia\runtime\conf\Catalina\localhost\tmp"></Context>

Cabe señalar que esto me ha funcionado desde Coldfusion 2011 y Coldfusion 2018.

Cuando hago la modificación del Contexto de mi aplicación e intento ingresar me devuelve un error diciendome que no tengo instalado el paquete de Sql server.

Error:

El paquete de Sql Server si lo tengo instalado:

 

El error surge solamente después de hacer la modificación del Context en mi server.xml.

 

Espero alguien me pueda apoyar a encontrar una solución a esto.

 

Gracias.

    This topic has been closed for replies.
    Correct answer Charlie Arehart

    While I can't explain how the problem leads to the error about the module, I can say that there's a different way to create a virtual directory in tomcat (in that server.xml file). Instead of defining /app in the context element like you do, define it in a preresources element (within a differently defined context element). See a discussion and examples here:

     

    https://www.petefreitag.com/item/867.cfm

     

    As he notes, this is the way to do it in tomcat 8.5 and above, which cf 2021 and 2018 use or exceed. I know you say the old way worked for you in 2018. Maybe you really meant cf2016 (and FWIW, the Tomcat version cf uses has changed WITHIN cf versions when Adobe has offered "refreshed" installers). But let's not quibble over that, if this gets you going.

     

    Please do let us know if this works for you. 

    1 reply

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity ExpertCorrect answer
    Community Expert
    May 4, 2022

    While I can't explain how the problem leads to the error about the module, I can say that there's a different way to create a virtual directory in tomcat (in that server.xml file). Instead of defining /app in the context element like you do, define it in a preresources element (within a differently defined context element). See a discussion and examples here:

     

    https://www.petefreitag.com/item/867.cfm

     

    As he notes, this is the way to do it in tomcat 8.5 and above, which cf 2021 and 2018 use or exceed. I know you say the old way worked for you in 2018. Maybe you really meant cf2016 (and FWIW, the Tomcat version cf uses has changed WITHIN cf versions when Adobe has offered "refreshed" installers). But let's not quibble over that, if this gets you going.

     

    Please do let us know if this works for you. 

    /Charlie (troubleshooter, carehart. org)
    M
    miguel.glez.mxAuthor
    Participant
    May 4, 2022

    Muchas gracias Charlie,

    En efecto la solución fue poner mi alias en un PreResources, te comparto como quedó mi context:

    Te agradezco mucho tu ayuda.

    Saludos

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices