Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
persistence.xml MySQL settings
<persistence xmlns=""
<persistence-unit name="org.hibernate.tutorial.jpa" transaction-type="RESOURCE_LOCAL">
Persistence unit for the JPA tutorial of the Hibernate Getting Started Guide
<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/jpatestdb" />
<property name="javax.persistence.jdbc.user" value="root" />
<property name="javax.persistence.jdbc.password" value="root" />
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
<property name="hibernate.show_sql" value="true" />
<property name="" value="create" />
Copy link

frandevel commented Apr 5, 2014

Where do you have to place the MySQL Driver Jar to work?

Copy link

shadowofevans commented Apr 5, 2014

Great question. I'm trying to work through this now as I believe it is the root cause of a namespace error I'm having. If you are using Maven you will probably need to put it there; otherwise, in your classpath.

Copy link

shadowofevans commented Apr 6, 2014

BTW... If you are using maven add this to your pom:

mysql mysql-connector-java 5.1.23

Copy link

khacsinhcs commented Jan 8, 2015

Can I change transaction type to JTA?

Copy link

khacsinhcs commented Jan 8, 2015

My web project is run on Glassfish server and using j2ee 7. But I couldn't connect to mySql server.

I config persistence.xml file like yours, it don't connect to mySql db but connect to derby

Copy link

TundeMichael commented Jan 12, 2015

@khacsinhcs you're probably using Netbeans. That problem is common to netbeans.

Copy link

Harshaganta commented Sep 25, 2017

mine is throwing an exception error like this "Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]"
what to do
i cannot able to connect to mysql database

Copy link

htkcodes commented Nov 28, 2017


Copy link

cananeadouglas commented Dec 5, 2017

very good. thanks

Copy link

vithu4 commented Dec 19, 2017

if im using mysql in xampp do i need to put org.hibernate.dialect.MySQL5Dialec in the application properties of spring boot prj ?

Copy link

kavianhabib commented Apr 27, 2020


change the above line to


Copy link

bittap commented Sep 2, 2022

I executed that persistence.xml and then the Hibernate show me this message

23:50:44.846 [main] WARN org.hibernate.orm.connections.pooling - HHH10001002: Using Hibernate built-in connection pool (not for production use!)
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

Therefore, I recommend to change this to the under line

<property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver" />


<property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment