Adding DROP script and property

Arun Gupta · Arun Gupta · commit 1a4d9415e33d · 2013-07-11T14:46:47.000-07:00
Former-commit-id: 1a2ffd198a24ff67e8a9b469bd29d83ed5cd890c
diff --git a/lab/solution/movieplex7/src/main/resources/META-INF/drop.sql b/lab/solution/movieplex7/src/main/resources/META-INF/drop.sql
@@ -0,0 +1,6 @@
+DROP TABLE SALES
+DROP TABLE POINTS
+DROP TABLE SHOW_TIMING
+DROP TABLE MOVIE
+DROP TABLE TIMESLOT
+DROP TABLE THEATER
diff --git a/lab/solution/movieplex7/src/main/resources/META-INF/persistence.xml b/lab/solution/movieplex7/src/main/resources/META-INF/persistence.xml
@@ -1,13 +1,14 @@
 <?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="movieplex7PU" transaction-type="JTA">
-        <jta-data-source>java:comp/DefaultDataSource</jta-data-source>
+        <!--<jta-data-source>java:comp/DefaultDataSource</jta-data-source>-->
         <properties>
             <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
             <property name="javax.persistence.schema-generation.create-source" value="script"/>
+            <property name="javax.persistence.schema-generation.drop-source" value="script"/>
             <property name="javax.persistence.schema-generation.create-script-source" value="META-INF/create.sql"/>
+            <property name="javax.persistence.schema-generation.drop-script-source" value="META-INF/drop.sql"/>
             <property name="javax.persistence.sql-load-script-source" value="META-INF/load.sql"/>
-            <property name="eclipselink.deploy-on-startup" value="true"/>
             <property name="eclipselink.logging.exceptions" value="false"/>
             <!--<property name="eclipselink.logging.level" value="FINE"/>-->
         </properties>
