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

This comment has been minimized.

Copy link

@frandevel frandevel commented Apr 5, 2014

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

@shadowofevans

This comment has been minimized.

Copy link

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

This comment has been minimized.

Copy link

@shadowofevans shadowofevans commented Apr 6, 2014

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

mysql mysql-connector-java 5.1.23
@khacsinhcs

This comment has been minimized.

Copy link

@khacsinhcs khacsinhcs commented Jan 8, 2015

Can I change transaction type to JTA?

@khacsinhcs

This comment has been minimized.

Copy link

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

This comment has been minimized.

Copy link

@TundeMichael TundeMichael commented Jan 12, 2015

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

@Harshaganta

This comment has been minimized.

Copy link

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

This comment has been minimized.

Copy link

@htkcodes htkcodes commented Nov 28, 2017

IT AINT FUCKING WORKING CUNTS

@cananeadouglas

This comment has been minimized.

Copy link

@cananeadouglas cananeadouglas commented Dec 5, 2017

very good. thanks

@vithu4

This comment has been minimized.

Copy link

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

This comment has been minimized.

Copy link

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