Heroku keeps on using Postgres instead of MySQL

Question

I have a Java application that uses Hibernate. It's configured to write to a MySQL db. I can say that I configured it correctly because when I run it on my local machine (on Tomcat and Jetty), tables are created in my local db.

However, when I deploy it to Heroku, the tables are not created. Heroku logs:

Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'po
stgres://zzz:[email protected]
mazonaws.com:5432/zzz'

Logs

Why is Heroku connecting to this db instead of using my configurations?

Additional info: App is deployed. It's just that the db tables are not created.

Jon Mountjoy · Accepted Answer · 2012-08-30 13:19:53Z

1

It looks like you're trying to establish a MySQL connection to a Postgres database. Either use a Postgres driver instead, or use a MySQL database.

Look here for MySQL databases: https://addons.heroku.com

PS. I'm guessing you used the default Heroku Postgres database - which populates DATABASE_URL with a Heroku Postgres Starter Tier database.

answered Aug 30, 2012 at 13:19

Jon Mountjoy

4,55024 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Carlo Ledesma Over a year ago

Hi @Jon, to be sure, I did 'heroku pg' and it showed app has no heroku-postgresql databases. I wonder if this is a bug in Heroku's celadon cedar stack.

Jon Mountjoy Over a year ago

If you don't have a free postgres database, then you don't have one. That's not a bug. If you want one, execute heroku addons:add heroku-postgresql:dev

Carlo Ledesma Over a year ago

Jon, thanks for the reply. What I meant was related to my original question. If I don't even have a postgre db in my add ons, yet I can see a postgre error in the heroku logs, it must be a heroku bug, particularly in the celadon cedar stack

Abbas · Accepted Answer · 2013-02-25 15:04:03Z

0

You need to point the DATABASE_URL variable to mysql database.

heroku config:set DATABASE_URL=mysql://xxxxxx

answered Feb 25, 2013 at 15:04

Abbas

971 silver badge11 bronze badges

Collectives™ on Stack Overflow

Heroku keeps on using Postgres instead of MySQL

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related