No suitable driver found exception in publish instance

[akhilraj]

Hi,

We are connecting AEM with SQL Data base.

Connectivity is fine in author instance and getting result.

Same we deployed to publish instance but getting below error.

Exception occurred in getting DB connection: No suitable driver found for
java.sql.SQLException: No suitable driver found for
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)

We are using same code and DB for publisher also. but connectivity is not happening. Any suggestions?

[Jörg_Hoh]

That means that there is a difference between author and publish, which prevents the SQL driver to be found. How did you deploy the SQL driver to AEM?