search cancel

Cannot connect to MSSQL via JDBC from ca api layer7 gateway

book

Article ID: 188964

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7) CA API Gateway Enterprise Service Manager (Layer 7) STARTER PACK-7 CA Microgateway

Issue/Introduction

Initital setup of driver was below, 

Drvier: com.l7tech.jdbc.sqlserver.SQLServerDriver

JDBC URL : jdbc:sqlserver://SomesqlServer:1433;databaseName=abcd

Then User and PASSWORD

Error: Testing failed: invalid connection properties setting. No suitable driver

 

Environment

Release : 9.4

Component : API GATEWAY

Resolution

Driver: com.l7tech.jdbc.sqlserver.SQLServerDriver

JDBC URL : jdbc:l7tech:sqlserver://SomeSQLServer:1433;databaseName=abcd

So instead of
jdbc:sqlserver://
use
jdbc:l7tech:sqlserver://

Set the following properties on the node,
vi /opt/SecureSpan/Gateway/node/default/etc/conf/system.properties
** And add the following 2 properties.


com.l7tech.server.jdbcDriver=com.mysql.jdbc.Driver\ncom.l7tech.jdbc.mysql.MySQL
Driver\ncom.l7tech.jdbc.db2.DB2Driver\ncom.l7tech.jdbc.oracle.OracleDriver\ncom
.l7tech.jdbc.sqlserver.SQLServerDriver

com.l7tech.common.security.jceProviderEngineName=bc

*** The above system.properties must exist on all nodes of the cluster and once adding you must restart the ssg service.

And then use a SQL user like sa, not a windows user.
And testing is success.