then I am using Java jdk-19.0.2
To init the pool we are using
B4X:
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
B4X:
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
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.