I want to automatically insert data into my MySQL tables. Therefore I try to use the JPA property "javax.persistence.sql-load-script-source" in my persistence.xml:
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" 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">
<persistence-unit name="my-PU" transaction-type="JTA">
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<jta-data-source>jdbc/coding</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="eclipselink.ddl-generation" value="drop-and-create-tables" />
<property name="javax.persistence.ddl-drop-script-source" value="drop.sql" />
<property name="javax.persistence.sql-load-script-source" value="insert.sql"/>
</properties>
</persistence-unit>
</persistence>
The SQL scripts (drop.sql & insert.sql) are store in "src/main/resources" and include SQL commands. Unfortunately, these commands are not executed. Did I forget a property?
What version of EclipseLink are you using? These properties are part of JPA 2.1, so you must be using the EclipseLink 2.5 version (not yet released).
Enable logging on finest to see if any errors are occurring.