JPA/Hibernate works with Postgresql, but not with Mysql

Question

I am trying to replace PostgreSQL in my application with MySQL. I thought that it should be sufficient to replace the <properties> in persistence.xml file:

PostgreSQL:

<property name="hibernate.connection.url" value="jdbc:postgresql://localhost/postgres"/>
<property name="hibernate.connection.username" value=""/>
<property name="hibernate.connection.password" value=""/>
<property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/>
<property name="hibernate.show_sql" value="true"/>

MySQL:

<property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
<property name="hiberante.connection.url" value="jdbc:mysql://localhost:3306/GoOut2"/>
<property name="hibernate.connection.username" value=""/>
<property name="hibernate.connection.password" value=""/>
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
<property name="hibernate.hbm2ddl.auto" value="update"/>

But with this replacement, I amg getting

java.lang.UnsupportedOperationException: The application must supply JDBC connections

I am not sure what I am doing wrong, I just hoped that the replacement would be straightforward. In PostgreSQL, everything works correctly.

Persistence.xml: https://gist.github.com/2252443

applicationContext.xml: https://gist.github.com/2252463

exception: https://gist.github.com/2252487

Thanks!

EDIT: I remove username and password from the given code intentionally.

can you post the startup messages for the session factory as well? — araqnid
– araqnid, Commented Mar 31, 2012 at 8:16
can you connect from mysql workbench with the given credential information? — Sinisha Mihajlovski
– Sinisha Mihajlovski, Commented Mar 31, 2012 at 16:54

Pau Kiat Wee · Accepted Answer · 2012-04-01 02:18:35Z

6

You missing configuration hibernate dialect for PostgreSQL:

<property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>

EDIT:

You have miss spelling in configuration:

<property name="hiberante.connection.url" value="jdbc:mysql://localhost:3306/GoOut2"/>

should be

<property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/GoOut2"/>

Is hibernate, but not hiberante.

edited Apr 1, 2012 at 2:18

answered Mar 31, 2012 at 15:16

Pau Kiat Wee

9,50544 silver badges41 bronze badges

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

1 Comment

Vojtěch Over a year ago

I just forgot to add it to the example, but my problem is not PostgreSQL, byt MySQL.

Vishal Ranapariya · Accepted Answer · 2012-03-31 04:26:47Z

1

<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/demo</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">root</property>

answered Mar 31, 2012 at 4:26

Vishal Ranapariya

1,0868 silver badges8 bronze badges

Collectives™ on Stack Overflow

JPA/Hibernate works with Postgresql, but not with Mysql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related