I would recommend providing more details about your implementation and providing full errors logs. It will also be useful to know which documentation you used to set up your connection between Cloud SQL and JPA + Hibernate. This github <https://github.com/GoogleCloudPlatform/appengine-cloudsql-native-mysql-hibernate-jpa-demo-java> sample provide more details on how to connect to Cloud SQL with Hibernate.
Your issue seems to pertains to a configuration error and you would have better assistance from the community by posting in StackOverflow as Google Groups is intended for general discussion of the App Engine platform, not specific technical issues. You should post to StackOverflow <http://www.stackoverflow.com/> to have the developers community assist you. On Wednesday, October 24, 2018 at 3:53:10 PM UTC-4, BestBuy Holidays wrote: > > I am getting this error when I try to connect to google cloud sql from JPA > + Hibernate. The configuration is > > <?xml version="1.0" encoding="UTF-8"?> > > <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > > xsi:schemaLocation="http://java.sun.com/xml/ns/persistence > http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";> > > <persistence-unit name="ContactUsPU"> > > <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider> > > <properties> > > <property name="hibernate.dialect" value= > "org.hibernate.dialect.MySQL57InnoDBDialect" /> > > <property name="hibernate.hbm2ddl.auto" value="none" /> > > <property name="hibernate.connection.driver_class" value= > "com.mysql.jdbc.Driver" /> > > <!-- <property name="hibernate.connection.url" > value="jdbc:mysql://localhost/bbholidays" /> --> > > <property name="hibernate.connection.url" > > value= > "jdbc:mysql://google/bbh_database?cloudSqlInstance=bbhwebapp:asia-southeast1:bbh-db&socketFactory=com.google.cloud.sql.mysql.SocketFactory&useSSL=false" > /> > > <property name="hibernate.connection.username" value="xxxxx" /> > > <property name="hibernate.connection.password" value="xxxxx" /> > > <property name="hibernate.archive.autodetection" value="class" /> > > <property name="hibernate.show_sql" value="true" /> > > <property name="hibernate.format_sql" value="true" /> > > <property name="hibernate.use_sql_comments" value="true" /> > > <property name="hbm2ddl.auto" value="none" /> > > <property name="hibernate.connection.autocommit" value="true"/> > > </properties> > > </persistence-unit> > > </persistence> > > Org.hibernate.service.spi.ServiceException: Unable to create requested > service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] > > 1. > 1. at org.hibernate.service.internal. > AbstractServiceRegistryImpl.createService ( > AbstractServiceRegistryImpl.java:271) > 2. at org.hibernate.service.internal. > AbstractServiceRegistryImpl.initializeService ( > AbstractServiceRegistryImpl.java:233) > 3. at org.hibernate.service.internal. > AbstractServiceRegistryImpl.getService ( > AbstractServiceRegistryImpl.java:210) > 4. at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure > (JdbcServicesImpl.java:51) > 5. at org.hibernate.boot.registry.internal. > StandardServiceRegistryImpl.configureService ( > StandardServiceRegistryImpl.java:94) > 6. at org.hibernate.service.internal. > AbstractServiceRegistryImpl.initializeService ( > AbstractServiceRegistryImpl.java:242) > 7. at org.hibernate.service.internal. > AbstractServiceRegistryImpl.getService ( > AbstractServiceRegistryImpl.java:210) > 8. at org.hibernate.boot.model.process.spi. > MetadataBuildingProcess.handleTypes ( > MetadataBuildingProcess.java:352) > 9. at org.hibernate.boot.model.process.spi. > MetadataBuildingProcess.complete (MetadataBuildingProcess.java:111) > 10. at org.hibernate.jpa.boot.internal. > EntityManagerFactoryBuilderImpl.metadata ( > EntityManagerFactoryBuilderImpl.java:861) > 11. at org.hibernate.jpa.boot.internal. > EntityManagerFactoryBuilderImpl.build ( > EntityManagerFactoryBuilderImpl.java:888) > 12. at org.hibernate.jpa. > HibernatePersistenceProvider.createEntityManagerFactory ( > HibernatePersistenceProvider.java:58) > 13. at javax.persistence.Persistence.createEntityManagerFactory ( > Persistence.java:55) > 14. at javax.persistence.Persistence.createEntityManagerFactory ( > Persistence.java:39) > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/2aab0364-7e33-4bc9-8272-63f7d5edd0ef%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
