Java.lang.IllegalStateException: Failed to load JDBC driver class [com.mysql.jdbc.GoogleDriver]

Question

I'm trying to connect to my database from Google Flexible to Google Cloud . The connection string and driver class are shown below:

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.GoogleDriver" />
    <property name="url" value="jdbc:google:mysql://mz-test:us-central1:mz-life-cloudsql-prod/mz_db" />
    <property name="username" value="root" />
    <property name="password" value="" />
</bean>

However, currently i am getting

org.springframework.beans.factory.BeanCreationException: 
    Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/classes/context/applicationContext-jooq.xml]: 
            Error setting property values; nested exception is org.springframework.beans.PropertyBatchUpdateException; 
            nested PropertyAccessExceptions (1) are:|PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; 
            nested exception is java.lang.IllegalStateException: Could not load JDBC driver class [com.mysql.jdbc.GoogleDriver]

The database I'm trying to connect to is a SQL Server Cloud Generation Cloud database .

Why am I getting this exception?

App Engine had this property <use-google-connector-j>. I have not seen this property for a flexible environment - at least on those pages that I have read so far. Is there anything I would need to add to the app.yaml file ?

---

, Flexible Environment, use-google-connector-j true yaml:

use-google-connector-j: true

, : https://code.google.com/p/googleappengine/issues/detail?id=11444

Answer 1

com.mysql.jdbc.GoogleDriver App Engine.

Java, App Engine Flexible Environment, mysql-socket-factory.

Maven :

<dependency>
    <groupId>com.google.cloud.sql</groupId>
    <artifactId>mysql-socket-factory</artifactId>
    <version>1.0.1</version>
</dependency>

/ com.mysql.jdbc.Driver.

jdbc:google:mysql://instance_name/db_name

to

jdbc:mysql://google/db_name?cloudSqlInstance=<instance_connection_name>&socketFactory=com.google.cloud.sql.mysql.SocketFactory

<instance_connection_name > Cloud SQL Google.

. XML , , & &.

. mysql (6 ). 5.1.39.