title: JPA persistence.xml I want it to connect to MariaDB but it always connects to hsqldb
body: <p>I have a java webapp,</p>
  
  <p><code>persistence.xml</code></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
  &lt;persistence 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"
           version="2.2"&gt;
  
  &lt;persistence-unit name="my-persistence-unit"&gt;
      &lt;provider&gt;org.hibernate.jpa.HibernatePersistenceProvider&lt;/provider&gt;
      &lt;exclude-unlisted-classes&gt;false&lt;/exclude-unlisted-classes&gt;
      &lt;properties&gt;
  
          &lt;property name="javax.persistence.jdbc.driver" value="org.mariadb.jdbc.Driver"/&gt;
          &lt;property name="javax.persistence.jdbc.url" value="jdbc:mariadb://localhost:3306/qltb"/&gt;
          &lt;property name="javax.persistence.jdbc.user" value="root"/&gt;
          &lt;property name="javax.persistence.jdbc.password" value="my_passwowrd"/&gt;
  
          &lt;property name="hibernate.archive.autodetection" value="class"/&gt;
          &lt;property name="hibernate.dialect" value="org.hibernate.dialect.MariaDB103Dialect"/&gt;
          &lt;property name="hibernate.show_sql" value="true"/&gt;
          &lt;property name="hibernate.format_sql" value="true"/&gt;
          &lt;property name="hibernate.hbm2ddl.auto" value="update"/&gt;
          &lt;property name="hbm2ddl.auto" value="update"/&gt;
      &lt;/properties&gt;
  &lt;/persistence-unit&gt;
  </code></pre>
  
  <p></p>
  
  <p>I create a simple <code>Bottle</code> <code>@Entity</code> class, which contains only an id and a String property.</p>
  
  <p>When I run this webapp, I see in the log that it was processing <code>my-persistence-unit</code> but an exception was thrown:</p>
  
  <pre><code>org.hibernate.jpa.internal.util.LogHelper.logPersistenceUnitInformation HHH000204: Processing PersistenceUnitInfo [
  name: my-persistence-unit
  ...]
  
  ... // Some lines are skipped
  
  
  org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "
  create table Bottle (
     id bigint not null,
      color varchar(255),
      primary key (id)
  ) engine=InnoDB" via JDBC Statement
  
  .... // Some lines are skipped
  Caused by: org.hsqldb.HsqlException: unexpected token: ENGINE : line: 6
  at org.hsqldb.error.Error.parseError(Unknown Source)
  at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
  at org.hsqldb.ParserCommand.compilePart(Unknown Source)
  at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
  at org.hsqldb.Session.executeDirectStatement(Unknown Source)
  at org.hsqldb.Session.execute(Unknown Source)
  </code></pre>
  
  <p>Why JPA is connecting to hsqldb instead of MariaDB as declared in persistence.xml?</p>
  
  <p>Additional information: I am using TomEE 8.0.0 M1</p>