Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
persistence.xml MySQL settings
<persistence 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"
version="2.0">
<persistence-unit name="org.hibernate.tutorial.jpa" transaction-type="RESOURCE_LOCAL">
<description>
Persistence unit for the JPA tutorial of the Hibernate Getting Started Guide
</description>
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<class>org.halyph.sessiondemo.Event</class>
<properties>
<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="hibernate.hbm2ddl.auto" value="create" />
</properties>
</persistence-unit>
</persistence>
@frandevel
Copy link

frandevel commented Apr 5, 2014

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

@shadowofevans
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.

@shadowofevans
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

@khacsinhcs
Copy link

khacsinhcs commented Jan 8, 2015

Can I change transaction type to JTA?

@khacsinhcs
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

@TundeMichael
Copy link

TundeMichael commented Jan 12, 2015

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

@Harshaganta
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

@htkcodes
Copy link

htkcodes commented Nov 28, 2017

IT AINT FUCKING WORKING CUNTS

@cananeadouglas
Copy link

cananeadouglas commented Dec 5, 2017

very good. thanks

@vithu4
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 ?

@kavianhabib
Copy link

kavianhabib commented Apr 27, 2020

org.hibernate.ejb.HibernatePersistence

change the above line to

org.hibernate.jpa.HibernatePersistenceProvider

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