java.lang.ClassNotFoundException: java.sql.Driver Error Sql server database

[JosephWJMaxwell]

Good Morning Everyone,

I am currently trying to setup an HL7 listener to write messages to a sql server instance.
I have mirth connect setup with my sql server, it created the base tables and then I created a new table in the same database to store the new HL7 messages like so:

I have setup the new user to access the database and updated my mirth configuration class as well:

I believe my mirth connect server manager is also setup correctly:

And I have added the correct jdbc file for my version of java:

Here is my listener channel:

My issue is whenever I run the channel I get this error which is odd because mirth is able to connect to my database when I run the app but the channel can not:
`[2025-02-25 10:30:48.976] ERROR (com.mirth.connect.server.channel.ErrorTaskHandler:26): com.mirth.connect.donkey.server.DeployException: Failed to deploy channel HL7 Listener Database (ed3b25f7-7275-487b-903a-279114a1fd85).

at com.mirth.connect.donkey.server.channel.Channel.deploy(Channel.java:575)

at com.mirth.connect.donkey.server.channel.Channel.debugDeploy(Channel.java:471)

at com.mirth.connect.server.controllers.DonkeyEngineController$DeployTask.doDeploy(DonkeyEngineController.java:1987)

at com.mirth.connect.server.controllers.DonkeyEngineController$DeployTask.execute(DonkeyEngineController.java:1835)

at com.mirth.connect.server.channel.ChannelTask.call(ChannelTask.java:67)

at com.mirth.connect.server.channel.ChannelTask.call(ChannelTask.java:16)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

at java.base/java.lang.Thread.run(Thread.java:842)

Caused by: java.lang.NoClassDefFoundError: java/sql/Driver

at java.base/java.lang.ClassLoader.defineClass1(Native Method)

at java.base/java.lang.ClassLoader.defineClass(ClassLoader.java:1017)

at java.base/java.security.SecureClassLoader.defineClass(SecureClassLoader.java:150)

at java.base/java.net.URLClassLoader.defineClass(URLClassLoader.java:524)

at java.base/java.net.URLClassLoader$1.run(URLClassLoader.java:427)

at java.base/java.net.URLClassLoader$1.run(URLClassLoader.java:421)

at java.base/java.security.AccessController.doPrivileged(AccessController.java:712)

at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:420)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:592)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:525)

at com.mirth.connect.connectors.jdbc.CustomDriver.<init>(CustomDriver.java:40)

at com.mirth.connect.connectors.jdbc.DatabaseDispatcherQuery.initDriver(DatabaseDispatcherQuery.java:147)

at com.mirth.connect.connectors.jdbc.DatabaseDispatcherQuery.deploy(DatabaseDispatcherQuery.java:56)

at com.mirth.connect.connectors.jdbc.DatabaseDispatcher.onDeploy(DatabaseDispatcher.java:54)

at com.mirth.connect.donkey.server.channel.Connector.onDebugDeploy(Connector.java:51)

at com.mirth.connect.donkey.server.channel.Channel.deploy(Channel.java:557)

... 9 more

Caused by: java.lang.ClassNotFoundException: java.sql.Driver

at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:445)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:592)

at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:525)

... 25 more`

[pacmano1]

You should not add anything to custom lib, remove the file. Then try again. The SQL server driver is included already.

[JosephWJMaxwell]

Thank you