I started learning about the google cloud platform and I have been able to create a project and an instance and then I created a db using a mysql dump file. Now, I have this application which was created using hibernate and it works when the db is pointing to my local mysql workbench, but when I change the url to this:
jdbc:google:mysql://${INSTANCE_CONNECTION_NAME}/${database}?user=${user}&password=${password}
it keeps giving this error:
[INFO] GCLOUD: javax.persistence.PersistenceException: Unable to build entity manager factory
[INFO] GCLOUD: at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:66)
[INFO] GCLOUD: Caused by: org.hibernate.HibernateException: Unable to make JDBC Connection [jdbc:google:mysql://${INSTANCE_CONNECTION_NAME}/${database}?user=${user}&password=${password}]
[INFO] GCLOUD: at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:60)
I have my persistence.xml file, web.xml file and appengine-web.xml file in the right places and when I try the api using postman, it takes a few seconds before returning the error, which makes me think it does hit the url but maybe the endpoint is refusing the connection? I'm not sure what I am doing wrong. I need a point in the right direction, if anyone can. My main goal is to set up the endpoints which can be queried to return data from the database.