title: Inserting initial data in database play framework jpa
body: <p>I am using play 2.3 with jpa mysql. I have a admin in my database which should be created initially when creating database.I found <a href="https://stackoverflow.com/questions/ask">this</a> thread regarding it .So my <code>persistence.xml</code> looks like</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&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_1.xsd"
               version="2.1"&gt;
  
      &lt;persistence-unit name="defaultPersistenceUnit" transaction-type="RESOURCE_LOCAL"&gt;
          &lt;provider&gt;org.hibernate.jpa.HibernatePersistenceProvider&lt;/provider&gt;
          &lt;non-jta-data-source&gt;DefaultDS&lt;/non-jta-data-source&gt;
          &lt;properties&gt;
              &lt;property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/&gt;
              &lt;property name="hibernate.hbm2ddl.auto" value="create"/&gt;
              &lt;property name="javax.persistence.sql-load-script-source"
                        value="META-INF/sql/data.sql"/&gt;
          &lt;/properties&gt;
  
      &lt;/persistence-unit&gt;
  
  &lt;/persistence&gt;
  </code></pre>
  
  <p>then I created a sql file in <code>META-INF/sql/data.sql</code></p>
  
  <pre><code>INSERT INTO `roles` (`id`, `name`) VALUES(1, 'supersuperadmin')
  </code></pre>
  
  <p>but when I run my app it creates the database but it dint insert anything in<code>roles</code> table.</p>
  
  <p>I have also tried creating <code>evolutions/default/1.sql</code> or also <code>2.sql</code> file with same data as above but it showed nothing.</p>
  
  <p>so what I am doing wrong. How can I insert initial data in my database?</p>