Somewhere in the logs you should see a more detailed error message...
fake_instance_name -> this should be the mysql database name, not the Cloud SQL instance name
cloudSqlInstance -> please double check that this matches the "Instance connection name" shown on the instance overview page in Cloud Console
On Thu, Jul 21, 2016 at 2:14 PM Carl Andin Michel Sanon <ingscam@gmail.com> wrote:
another thing i see Vadims is even if i change the database instance name with another thats not exist in persitence xml, i still have the same exception, cannot open jdbc connection .see below
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://google/fake_instance_name?cloudSqlInstance=instance:us-east1:project&socketFactory=com.google.cloud.sql.mysql.SocketFactory;" />
On Thursday, July 14, 2016 at 10:02:31 AM UTC-4, Carl Andin Michel Sanon wrote:--Hi everyone,
i read everything in https://cloud.google.com/sql/docs/app-engine-connect also in https://developers.google.com/eclipse/docs/cloudsql-jpatools but i cannot connect to cloud SQL 2nd generation using hibernate+jpa on GAE. Please i want some additional explanation and some example to do it right.
i already have a web application running in GAE and connect to cloud sql 1rst generation, look at my persistence file using for the first generation below .
Now, what change to do in this persistence file to make it work with cloud sql 2nd generation please?
Best Regards.
<properties>
<property name="javax.persistence.jdbc.driver" value="com.google.appengine.api.rdbms.AppEngineDriver" />
<property name="javax.persistence.jdbc.url" value="jdbc:google:rdbms://myapps-web:apps/db" />
<property name="javax.persistence.validation.mode" value="NONE"/>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5InnoDBDialect" />
<property name="hibernate.connection.pool_size" value="0" />
<property name="hibernate.connection.useUnicode" value="true"/>
<property name="hibernate.connection.charSet" value="UTF-8"/>
<property name="hibernate.bytecode.provider" value="javassist"/>
<!-- <property name="hibernate.bytecode.use_reflection_optimizer" value="true"/> -->
<property name="hibernate.jdbc.use_streams_for_binary" value="true"/>
<property name="hibernate.cache.use_query_cache" value="false"/>
<property name="hibernate.cache.use_second_level_cache" value="false"/>
<!-- PROD -->
<property name="hibernate.show_sql" value="false"/>
<!-- <property name="hibernate.format_sql" value="false"/> -->
<!-- <property name="hibernate.generate_statistics" value="false"/> -->
<!-- <property name="hibernate.use_sql_comments" value="false"/> -->
</properties>
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/fa7ea515-1bfa-4007-bbfa-376693a4e5ba%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CABDU3p02ivtBE_cm3wdD-ZTuqjYDFQbeXPqgnZPOTOXXdWLmnA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment