org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

2,078 views
Skip to first unread message

BestBuy Holidays

unread,
Oct 24, 2018, 3:53:10 PM10/24/18
to Google App Engine
Below is the exception the program throws when I tried to connect to GCS from GAE.

The hibernate settings are 

<?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://google/yyyyyy?cloudSqlInstance=bbhwebapp:asia-southeast1:bbh-db&amp;socketFactory=com.google.cloud.sql.mysql.SocketFactory&amp;useSSL=false"/>

<property name="hibernate.connection.username" value="xxxx" />

<property name="hibernate.connection.password" value="xxx" />

<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. 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)
  1. My 

Mohammad I (Cloud Platform Support)

unread,
Oct 26, 2018, 6:13:17 PM10/26/18
to Google App Engine

Hello,


Please review the following docs on how to connect to Cloud SQL instance from application running on App Engine Standard environment or App Engine Flexible environment as they elaborate about the process.


This link of GitHub contains the example program that shows how to use Hibernate on App Engine when connecting to Cloud SQL. Just for your information, please use Google App Engine Standard Environment if you are using for Hibernate version 4.2.0 or earlier and Google App Engine Flexible Environment with later versions of Hibernate in order to avoid the issue described here.


Please kindly note that this forum is meant for general discussion of the App Engine platform, not specific technical issues. If you believe that what you've encountered is platform specific issue you can report this by creating an issue in the Issue Tracker and Google Cloud Support team member will assist you to resolve your issue.  If your issue is not a platform issue but rather a problem with how you've configured your code, although you're not sure what it may be specifically, you should post to StackOverflow and community of developers will assist you.
Reply all
Reply to author
Forward
0 new messages