Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
729 questions
Issue with Azure mysql database for flexible server connection to azure app service. driver not found in sql server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 27%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
abhi
0
Reputation points
org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [loginServlet] in context with path [/myshuttledev] threw exception [Servlet execution threw an exception] with root causejava.lang.ExceptionInInitializerError: java.sql.SQLException: No suitable driver found for vrit10pmsql.mysql.database.azure.comat com.microsoft.example.DataAccess
{count} votes
-
Oury Ba-MSFT 16,901 Reputation points Microsoft Employee2024-05-21T02:34:15.1733333+00:00 @abhi Thank you for reaching out.
My understanding is that you are trying to connect to an azure Flexible server from an Azure app but getting the above error message.
Are you trying to access through private access connectivity or public access.
Are you following this tutorial https://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-webapp-server-vnet to achieve the scenario you describe above.
Regards,
Oury
-
abhi 0 Reputation points
2024-05-21T16:17:12.8633333+00:00 Hi Oury,
I am connecting through public access
-
Oury Ba-MSFT 16,901 Reputation points Microsoft Employee
2024-05-23T17:49:54.6166667+00:00 Thank you for getting back to me.
Azure Database for MySQL flexible server with Public access (allowed IP addresses), make sure that the firewall is configured to allow connections from your client. Refer to Create and manage Azure Database for MySQL flexible server firewall rules using the Azure portal.
Client firewall configuration: The firewall on your client must allow connections to your Azure Database for MySQL flexible server instance. IP addresses and ports of the server that you connect to must be allowed as well as application names such as MySQL in some firewalls.
Please let us know the result.
Are you connecting using managed identity.?
Regards,
Oury
-
Oury Ba-MSFT 16,901 Reputation points Microsoft Employee
2024-05-28T16:36:45.8366667+00:00 I wanted to check on the status of the above issue. Are you still unable to connect?
Regards,
Oury
Sign in to comment