1
resposta

Mysql

Tentei integrar o MySql mas me retornou muitos erros de criação de tabela .

Troquei o nome no JPAUtil e nos arquivos de conf.

<persistence-unit name="oficial"

transaction-type="RESOURCE_LOCAL">

<property name="javax.persistence.jdbc.driver"

value="com.mysql.jdbc.Driver" />

<property name="javax.persistence.jdbc.url"

value="jdbc:mysql://localhost:3306/loja" />

<property name="javax.persistence.jdbc.password"

value="1234567" />

#

<property name="hibernate.dialect"

value="org.hibernate.dialect.MySQLDialect" />

#

mysql

mysql-connector-java

8.0.28

1 resposta

Oi Victor,

Para utilizar o MySQL essas são as configurações corretas:

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.2"
    xmlns="http://xmlns.jcp.org/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_2.xsd">

    <persistence-unit name="loja" transaction-type="RESOURCE_LOCAL">
        <properties>
            <property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver"/>
            <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/loja"/>
            <property name="javax.persistence.jdbc.user" value="root"/>
            <property name="javax.persistence.jdbc.password" value="root"/>

            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL8Dialect"/>
            <property name="hibernate.show_sql" value="true"/>
            <property name="hibernate.hbm2ddl.auto" value="update"/>
        </properties>
    </persistence-unit>
</persistence>

Obs: o usuário/senha precisam ser de acordo com a sua instalação do MySQL

Bons estudos!