B4J Question MSSQL DRIVER Issue

[Peter Lewis]

Hi, I have the following additional jar

#AdditionalJar:mssql-jdbc-12.8.2.jre11
#AdditionalJar: HikariCP-5.0.1

then I am using Java jdk-19.0.2
To init the pool we are using

Public pool As HikariCP
pool.Initialize("com.microsoft.sqlserver.jdbc.SQLServerDriver",$"jdbc:sqlserver://${host}:${port};databaseName=${database}"$,user,password)

with the following code starting sql

Dim sql As SQL = pool.GetConnection

The error code I am getting is as follows

java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=com.microsoft.sqlserver.jdbc.SQLServerDriver

The .jar file is in the additional files folder and I cannot see what I have done wrong.

Thank you

 

[Bladimir Silva Toro]

Hi, try using the JTDS driver; I think it works much better with any Microsoft SQL Server database.

Download Link: https://sourceforge.net/projects/jtds/files/

 

[virpalacios]

Hi Peter, please keep us informed, I had a bad issue with new SQLServer version, it has some encription built in, try first as Bladimis says,

Good Luck

Best Regards

 

[Peter Lewis]

Hi, try using the JTDS driver; I think it works much better with any Microsoft SQL Server database.

Download Link: https://sourceforge.net/projects/jtds/files/

Does it work with HikariCP ?

 

[Bladimir Silva Toro]

Does it work with HikariCP ?

To useHikariCP con jTDS This involves configuring the HikariCP connection pool to use the jTDS JDBC driver (for SQL Server/Sybase) in your Java application

It should work; you just need to test it and see if it works correctly.

 

[Peter Lewis]

Hi, try using the JTDS driver; I think it works much better with any Microsoft SQL Server database.

Download Link: https://sourceforge.net/projects/jtds/files/

I went to download the driver and found it is over 12 years old. I am trying to develop with latest drivers.