Below is the error when I tried to connect to google cloud sql using JPA + Hibernate
<?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/f6673afe-25e1-4982-9066-6bceba7952a9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
