mysql - EclipseLink 可以创建 persistence.xml 中指定的数据库吗？

Question

我正在完成《Beginning Java EE 7》中的练习，但我正在尝试调整它们以使用 MySQL 而不是 Derby。对于chapter 4 JPA exercise ，我将 persistence.xml 更改为:

<?xml version="1.0" encoding="UTF-8"?>
<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_1.xsd"
             version="2.1">

  <persistence-unit name="chapter04PU" transaction-type="RESOURCE_LOCAL">
    <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
    <class>org.agoncal.book.javaee7.chapter04.Book</class>
    <properties>
      <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
      <property name="javax.persistence.schema-generation.scripts.action" value="drop-and-create"/>
      <property name="javax.persistence.schema-generation.scripts.create-target" value="chapter04Create.ddl"/>
      <property name="javax.persistence.schema-generation.scripts.drop-target" value="chapter04Drop.ddl"/>
      <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
      <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/chapter04DB"/>
      <property name="javax.persistence.jdbc.user" value="USER"/>
      <property name="javax.persistence.jdbc.password" value="PASS"/>
      <property name="javax.persistence.sql-load-script-source" value="insert.sql"/>
      <property name="eclipselink.logging.level" value="INFO"/>
      <property name="eclipselink.ddl-generation" value="create-or-extend-tables"/>
    </properties>
  </persistence-unit>

  <persistence-unit name="chapter04TestPU" transaction-type="RESOURCE_LOCAL">
    <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
    <class>org.agoncal.book.javaee7.chapter04.Book</class>
    <properties>
      <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
      <property name="javax.persistence.schema-generation.scripts.action" value="drop-and-create"/>
      <property name="javax.persistence.schema-generation.scripts.create-target" value="create.sql"/>
      <property name="javax.persistence.schema-generation.scripts.drop-target" value="drop.sql"/>
      <property name="javax.persistence.jdbc.driver" value="org.apache.derby.jdbc.EmbeddedDriver"/>
      <property name="javax.persistence.jdbc.url" value="jdbc:derby:memory:chapter0`enter code here`4DB;create=true"/>
      <property name="javax.persistence.sql-load-script-source" value="insert.sql"/>
      <property name="eclipselink.logging.level" value="INFO"/>
    </properties>
  </persistence-unit>

</persistence>

一切都构建得很好，如果我转到数据库服务器并创建数据库，则 jar 运行正常。但我试图让 EclipseLink 在运行时创建数据库(正如书中暗示 Derby 会做的那样)，如果当我运行 jar 时数据库不存在，我会收到此错误:

Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'chapter04DB'

如何让 EclipseLink 在运行时创建 MySQL 数据库？

Answer 1

不能，因为自动创建数据库是 Derby 功能，而不是自动创建模式，后者可以由 EclipseLink 使用以下命令执行

<property name="eclipselink.ddl-generation" value="create-or-extend-tables"/>