Problem Note 70712: The error "No suitable driver" occurs in a SAS/ACCESS® Interface to Spark LIBNAME statement
 |  |  |  |
This issue affects SAS/ACCESS Interface to Spark on the SAS® Viya® platform (Stable 2024.03) when you use a CData JDBC driver.
The following error message might occur when specifying a SAS/ACCESS Interface to Spark LIBNAME or CASLIB statement:
ERROR: Error trying to establish connection: No suitable driver
This issue is caused by a Java security policy problem when SAS/ACCESS Interface to Spark attempts to find the default class name for a JDBC driver. This issue also affects SAS® Data Connector to Spark.
To circumvent this issue, specify the DRIVERCLASS= option with the appropriate Java class name. Here is an example:
libname dbricks SPARK platform=databricks
driverClass='cdata.jdbc.databricks.DatabricksDriver'
server="&MYDBRICKS" database=default port=443
user=token pwd="&MYPWD"
httpPath="&MYHTTPPATH"
properties='DefaultColumnSize=256;QueryPassthrough=true;Other=ConnectRetryWaitTime=500'
schema=default
bulkload=no;
driverClass='cdata.jdbc.databricks.DatabricksDriver'
server="&MYDBRICKS" database=default port=443
user=token pwd="&MYPWD"
httpPath="&MYHTTPPATH"
properties='DefaultColumnSize=256;QueryPassthrough=true;Other=ConnectRetryWaitTime=500'
schema=default
bulkload=no;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to JDBC (on SAS Viya) | Linux for x64 | Stable 2024.03 | Stable 2024.04 | Viya | Viya |
| SAS System | SAS Data Connector to SPARK | Linux for x64 | Stable 2024.03 | Stable 2024.04 | Viya | Viya |
A "No suitable driver" error message might occur when specifying a SAS/ACCESS® Interface to Spark LIBNAME statement without the driverClass option.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-06-25 15:12:54 |
| Date Created: | 2024-03-19 09:33:26 |