Unable to get data source: CustomerID SQL DataSource
“Please note that the information in this Knowledge Base article is provided "as is" and has been created only for SSO version 9.2 and CustomerID version 6.2.
These instructions have not undergone extensive testing or verification by our Engineering team. While this article offers valuable insights, it may not guarantee solution that work flawlessly with your specific Identity Server environment and configuration.
Please contact your Ubisecure partner and/or Ubisecure Support team to get more information what is the best approach to upgrade your specific environment.”
Problem
SSO diag log shows error in startup:
uas init ERROR Unable to get data source: CustomerID SQL DataSource: CustomerID SQL: com.ubisecure.ubilogin.directory.spi.DirectoryFactoryException: DataSource:
CustomerID SQL: java.sql.SQLException: Cannot create JDBC driver of class ‘' for connect URL 'jdbc:postgresql://idb.example.com:5432 /customeriddb’
Solution
One possible cause is that CustomerID SQL service URL is having extra space in the URL string like in the above example:
jdbc:postgresql://idb.example.com:5432 /customeriddb
Check the service URL from: SSO Management Console: Home -> Services -> CustomerID SQL