0

I just began learning Mulesoft and want to put together a simple demo that uses sqljdbc to hit a SQL Server database with windows authentication.

Articles I referenced:

Connecting to MS SQL Server with MuleSoft

Using Database Connector with Microsoft SQL Server

Software details:

Mule Server 3.8.4 EE

Anypoint studio 6.2.4

Problem:

If I add the location of sqljdbc_auth.dll as native library location for sqljdbc42.jar, the project will not run.

Symptoms:

  • When I click run project there is no console output or error. I see the loading bar in the bottom right corner for about a second and then nothing.

  • If I remove the dll path from the native library location, the project will run. Of course, it errors when trying to hit the database.

  • The database connector passes connection test when the native library path is set. It fails when it is not set.

  • I am assuming x64 is the correct dll to use. My pc is x64, and the database connector fails connection test when I use the x86 dll.

  • This behavior is consistent for any project, regardless if it has a database connector or not. The same behaviors occur for a simple "hello world" type demo.

If anyone has any suggestions I would greatly appreciate it. If I can clarify anything or help by adding more details please let me know.

Vertical Sunlight
  • 57
  • 8
  • Screenshots: Message flow: https://i.stack.imgur.com/vt5Ej.png Adding dll path to native library: https://i.stack.imgur.com/LL126.png Successful connection test: https://i.stack.imgur.com/c4CHS.png – Vertical Sunlight May 04 '17 at 19:52

1 Answers1

1

I had same issue, logged ticket with Mulesoft and got a workaround.

First, you need to remove the reference to the sqljdbc_auth.dll. So remove that from the "Native library location" of the sqljjdbc42.jar.

Next, you need to add a reference to the auth DLL to the "Run configuration" for your project. To do that, do the following:

  1. Right-click your project, choose "Run As/Run Configurations..."
  2. On the "Arguments" tab, add the following parameter to the "VM arguments:"

-Djava.library.path="[path to your sqljsdb_auth.dll file]" (use quotes around the path if the path contains spaces)

  1. "Apply" the change and close out of the dialog and give it a go, see if that works for you.

This worked for me, my project builds and deploys, I can debug and otherwise run it with SQL Server integrated authentication. I don't know what the implications of adding this to the Run Configuration are, but it seems to be working OK for me. If you already have things in your build path argument then you'll have to figure out how to add multiple items, I don't know how to do that though.

  • This worked for me, thank you for looking into it and sharing. I don't know how Mulesoft's ticket system works, but is there a link to the ticket you submitted so I can monitor it for their response? – Vertical Sunlight May 23 '17 at 19:46
  • The support ticket was posted under our company support cases so I'm not sure if that's accessible to you. I'll check it though and post a link if I can. If I can't do that then I'll post an update once the Mulesoft folks come back with any additional news. –  May 24 '17 at 14:49
  • Yeah looks like you won't be able to access the case, is private to our company. I'm watching it though and I'll post an update once I know more. My guess is they'll fix it in a future update if they can, but no idea when that'll be at this point. –  May 24 '17 at 14:56