How do I deploy my app engine for java app with access to Google Cloud SQL?

[alexryan]

I'm coded up the sample app from chapter 11 "Using Google Cloud SQL with App Engine" in the book "Programming Google App Engine with Java".

It runs fine locally when talking to my local MySQL instance.

Reading and writing to MySQL locally no problem.

However, when I try to deploy it to app engine ...

from Eclipse Luna, using the latest version of the eclipse plugin ...

I edit the "App Engine Project Settings" ...

I enable the "Google Cloud SQL" ...

I select to "Use a Google Cloud SQL instance" ...

I enter the correct information in the popup ...

but then I get this really weird error ....

I am at a loss for how to fix this.

It seems to be referencing the MySQL driver.

I don't now why.

I have completely deleted that driver from my project and yet I am still getting this error.

The information in this "Configure Google Cloud SQL Instance" window is 100% correct (to the best of my knowledge).

And we have authorized this app engine app to access our Google Cloud SQL instance on console.cloud.google.com.

[arex]

My bad.

Got it working.

I was entering information in the wrong spot.

Turned out to be a bug in the code.

I had to change the user in the url to be root.

    if (SystemProperty.environment.value() == SystemProperty.Environment.Value.Production) {

      // This is App Engine

      Class.forName("com.mysql.jdbc.GoogleDriver");

      //url = "jdbc:google:mysql://" + instanceId + "/" + database + "?user=" + user;

      url = "jdbc:google:mysql://" + instanceId + "/" + database + "?user=root";

      conn = DriverManager.getConnection(url);

    } else {