How to resolve the hibernate connection issue

[BestBuy Holidays]

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&amp;socketFactory=com.google.cloud.sql.mysql.SocketFactory&amp;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)

[sami...@google.com]

According to this thread in stackoverflow, this issue occurs when Hibernate is not able to connect to the database.

As the thread suggests, you can start with verifying if the database present at the server is being referred to the configuration file. Also please check if the username and password for connecting to the database is correct.

Please note that Google Group is intended for Google Cloud general product discussion purposes only, not for troubleshooting issues. If you think this issue could be caused by a possible bug you can report it in Public Issue Tracker. Issue Tracker is a tool used internally at Google to track bugs and feature requests during product development. So this way we would be able to get a deeper understanding of your issue.