title: Play Siena failing to connect to MySQL on GAE
body: <p>I am using play framework 1.2.7, gae module 1.6.0 and siena module 2.0.7 (also tested 2.0.6). This is a simple project that should run in play deployed on App Engine and connect to a MySQL database in Google Cloud SQL. My project runs fine locally but fails to connect to the database in production. Looking at the logs it looks like it is using the postgresql driver instead of the mysql one.</p>
  
  <p>Application.conf</p>
  
  <pre><code># db=mem
  db.url=jdbc:google:mysql://PROJECT_ID:sienatest/sienatest
  db.driver=com.mysql.jdbc.GoogleDriver
  db.user=root
  db.pass=root
  </code></pre>
  
  <p>This is the crash stack trace</p>
  
  <pre><code>play.Logger niceThrowable: Cannot connected to the database : null
  java.lang.NullPointerException
      at com.google.appengine.runtime.Request.process-a3b6145d1dbbd04d(Request.java)
      at java.util.Hashtable.put(Hashtable.java:432)
      at java.util.Properties.setProperty(Properties.java:161)
      at org.postgresql.Driver.loadDefaultProperties(Driver.java:121)
      at org.postgresql.Driver.access$000(Driver.java:47)
      at org.postgresql.Driver$1.run(Driver.java:88)
      at java.security.AccessController.doPrivileged(AccessController.java:63)
      at org.postgresql.Driver.getDefaultProperties(Driver.java:85)
      at org.postgresql.Driver.connect(Driver.java:231)
      at java.sql.DriverManager.getConnection(DriverManager.java:571)
      at java.sql.DriverManager.getConnection(DriverManager.java:215)
      at play.modules.siena.GoogleSqlDBPlugin.onApplicationStart(GoogleSqlDBPlugin.java:103)
      at play.plugins.PluginCollection.onApplicationStart(PluginCollection.java:525)
      at play.Play.start(Play.java:533)
      at play.Play.init(Play.java:305)
  </code></pre>
  
  <p>What is going on here? I am specifying the correct driver and url schema and it's using postgresql driver. Google Cloud SQL API access is enabled, the app is allowed to connect to the mysql instance, I am not using db=mem, ... I am stuck and can't figure out how to move forward! :-((</p>
  
  <p><strong>UPDATE:</strong> I thought I found the solution, but that was not the case. If I keep the <code>%prod</code>. prefix and create a war normally (or just don't define any DB properties), then the application will use <code>Google DataStore</code> instead of the <code>Cloud SQL</code>. If I create the war file adding <code>--%prod</code> at the end (or just delete the <code>%prod</code>. prefix in the application.conf), then it will keep failing to connect to the database showing the same initial error.</p>
  
  <p>Any ideas please?</p>