You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tomee.apache.org by db...@apache.org on 2012/03/11 00:30:30 UTC

svn commit: r1299304 - in /openejb/trunk/openejb/examples: ./ jpa-enumerated/ jpa-enumerated/src/ jpa-enumerated/src/main/ jpa-enumerated/src/main/java/ jpa-enumerated/src/main/java/org/ jpa-enumerated/src/main/java/org/superbiz/ jpa-enumerated/src/mai...

Author: dblevins
Date: Sat Mar 10 23:30:29 2012
New Revision: 1299304

URL: http://svn.apache.org/viewvc?rev=1299304&view=rev
Log:
TOMEE-151: Example: JPA @Enumerated

Added:
    openejb/trunk/openejb/examples/jpa-enumerated/
    openejb/trunk/openejb/examples/jpa-enumerated/README.md
    openejb/trunk/openejb/examples/jpa-enumerated/build.xml   (with props)
    openejb/trunk/openejb/examples/jpa-enumerated/pom.xml   (with props)
    openejb/trunk/openejb/examples/jpa-enumerated/src/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movie.java   (with props)
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movies.java   (with props)
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Rating.java   (with props)
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/resources/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/resources/META-INF/
    openejb/trunk/openejb/examples/jpa-enumerated/src/main/resources/META-INF/persistence.xml   (with props)
    openejb/trunk/openejb/examples/jpa-enumerated/src/test/
    openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/
    openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/
    openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/
    openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/jpa/
    openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/jpa/enums/
    openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/jpa/enums/MoviesTest.java   (with props)
Modified:
    openejb/trunk/openejb/examples/index.md
    openejb/trunk/openejb/examples/pom.xml

Modified: openejb/trunk/openejb/examples/index.md
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/index.md?rev=1299304&r1=1299303&r2=1299304&view=diff
==============================================================================
--- openejb/trunk/openejb/examples/index.md (original)
+++ openejb/trunk/openejb/examples/index.md Sat Mar 10 23:30:29 2012
@@ -37,6 +37,7 @@ All the examples show code, but some are
  - [injection-of-entitymanager](injection-of-entitymanager/README.html)
  - [jpa-eclipselink](jpa-eclipselink/README.html)
  - [jpa-hibernate](jpa-hibernate/README.html)
+ - [jpa-enumerated](jpa-enumerated/README.html) *
 }
 
 

Added: openejb/trunk/openejb/examples/jpa-enumerated/README.md
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/jpa-enumerated/README.md?rev=1299304&view=auto
==============================================================================
--- openejb/trunk/openejb/examples/jpa-enumerated/README.md (added)
+++ openejb/trunk/openejb/examples/jpa-enumerated/README.md Sat Mar 10 23:30:29 2012
@@ -0,0 +1,248 @@
+Title: JPA and Enums via @Enumerated
+
+It can sometimes be desirable to have a Java `enum` type to represent a particular column in a database. JPA supports converting database data to and from Java `enum` types via the `@javax.persistence.Enumerated` annotation.
+
+This example will show basic `@Enumerated` usage in a field of an `@Entity` as well as `enum`s as the parameter of a `Query`.  We'll also see that the actual database representation can be effectively `String` or `int`.
+
+## Enum
+
+For our example we will leverage the familiar `Movie` entity and add a new field to represent the MPAA.org rating of the movie.  This is defined via a simple `enum` that requires no JPA specific annotations.
+
+    public enum Rating {
+        UNRATED,
+        G,
+        PG,
+        PG13,
+        R,
+        NC17
+    }
+
+## @Enumerated
+
+In our `Movie` entity, we add a `rating` field of the enum type `Rating` and annotate it with `@Enumerated(EnumType.STRING)` to declare that its value should be converted from what is effectively a `String` in the database to the `Rating` type.
+
+    @Entity
+    public class Movie {
+
+        @Id
+        @GeneratedValue
+        private int id;
+        private String director;
+        private String title;
+        private int year;
+
+        @Enumerated(EnumType.STRING)
+        private Rating rating;
+
+        public Movie() {
+        }
+
+        public Movie(String director, String title, int year, Rating rating) {
+            this.director = director;
+            this.title = title;
+            this.year = year;
+            this.rating = rating;
+        }
+
+        public String getDirector() {
+            return director;
+        }
+
+        public void setDirector(String director) {
+            this.director = director;
+        }
+
+        public String getTitle() {
+            return title;
+        }
+
+        public void setTitle(String title) {
+            this.title = title;
+        }
+
+        public int getYear() {
+            return year;
+        }
+
+        public void setYear(int year) {
+            this.year = year;
+        }
+
+        public Rating getRating() {
+            return rating;
+        }
+
+        public void setRating(Rating rating) {
+            this.rating = rating;
+        }
+    }
+
+The above is enough and we are effectively done.  For the sake of completeness we'll show a sample `Query`
+
+## Enum in JPQL Query
+
+Note the `findByRating` method which creates a `Query` with a `rating` named parameter.  The key thing to notice is that the `rating` enum instance itself is passed into the
+ `query.setParameter` method, **not** `rating.name()` or `rating.ordinal()`.
+
+Regardless if you use `EnumType.STRING` or `EnumType.ORDINAL`, you still always pass the enum itself in calls to `query.setParameter`.
+
+    @Stateful
+    public class Movies {
+
+        @PersistenceContext(unitName = "movie-unit", type = PersistenceContextType.EXTENDED)
+        private EntityManager entityManager;
+
+        public void addMovie(Movie movie) {
+            entityManager.persist(movie);
+        }
+
+        public void deleteMovie(Movie movie) {
+            entityManager.remove(movie);
+        }
+
+        public List<Movie> findByRating(Rating rating) {
+            final Query query = entityManager.createQuery("SELECT m FROM Movie as m WHERE m.rating = :rating");
+            query.setParameter("rating", rating);
+            return query.getResultList();
+        }
+
+        public List<Movie> getMovies() throws Exception {
+            Query query = entityManager.createQuery("SELECT m from Movie as m");
+            return query.getResultList();
+        }
+
+    }
+
+## `EnumType.STRING` vs `EnumType.ORDINAL`
+
+It is a matter of style how you would like your `enum` data represented in the database.  Either `name()` or `ordinal()` are supported:
+
+ - `@Enumerated(EnumType.STRING) Rating rating` the value of `rating.name()` is written and read from the corresponding database column; e.g. `G`, `PG`, `PG13`
+ - `@Enumerated(EnumType.ORDINAL) Rating rating` the value of `rating.ordinal()` is written and read from the corresponding database column; e.g. `0`, `1`, `2`
+
+The default is `EnumType.ORDINAL`
+
+There are advantages and disadvantages to each.
+
+### Disadvantage of `EnumType.ORDINAL`
+
+A disadvantage of `EnumType.ORDINAL` is the effect of time and the desire to keep `enums` in a logical order.  With `EnumType.ORDINAL` any new enum elements must be added to the
+**end** of the list or you will accidentally change the meaning of all your records.
+
+Let's use our `Rating` enum and see how it would have had to evolve over time to keep up with changes in the MPAA.org ratings system.
+
+**1980**
+
+    public enum Rating {
+        G,
+        PG,
+        R,
+        UNRATED,
+    }
+
+**1984** PG-13 is added
+
+    public enum Rating {
+        G,
+        PG,
+        R,
+        UNRATED,
+        PG13
+    }
+
+**1990** NC-17 is added
+
+    public enum Rating {
+        G,
+        PG,
+        R,
+        UNRATED,
+        PG13,
+        NC17
+    }
+
+If `EnumType.STRING` was used, then the enum could be reordered at anytime could instead look as we have defined it originally with ratings starting at `G` and increasing in severity to `NC17` and eventually `UNRATED`.  With `EnumType.ORDINAL` the logical ordering would not have withstood the test of time as new values were added.
+
+If the order of the enum values is significant to your code, avoid `EnumType.ORDINAL`
+
+## Unit Testing the JPA @Enumerated
+
+    public class MoviesTest extends TestCase {
+
+        public void test() throws Exception {
+
+            final Properties p = new Properties();
+            p.put("movieDatabase", "new://Resource?type=DataSource");
+            p.put("movieDatabase.JdbcDriver", "org.hsqldb.jdbcDriver");
+            p.put("movieDatabase.JdbcUrl", "jdbc:hsqldb:mem:moviedb");
+
+            EJBContainer container = EJBContainer.createEJBContainer(p);
+            final Context context = container.getContext();
+
+            final Movies movies = (Movies) context.lookup("java:global/jpa-scratch/Movies");
+
+            movies.addMovie(new Movie("James Frawley", "The Muppet Movie", 1979, Rating.G));
+            movies.addMovie(new Movie("Jim Henson", "The Great Muppet Caper", 1981, Rating.G));
+            movies.addMovie(new Movie("Frank Oz", "The Muppets Take Manhattan", 1984, Rating.G));
+            movies.addMovie(new Movie("James Bobin", "The Muppets", 2011, Rating.PG));
+
+            assertEquals("List.size()", 4, movies.getMovies().size());
+
+            assertEquals("List.size()", 3, movies.findByRating(Rating.G).size());
+
+            assertEquals("List.size()", 1, movies.findByRating(Rating.PG).size());
+
+            assertEquals("List.size()", 0, movies.findByRating(Rating.R).size());
+
+            container.close();
+        }
+    }
+
+# Running
+
+To run the example via maven:
+
+    cd jpa-enumerated
+    mvn clean install
+
+Which will generate output similar to the following:
+    
+    -------------------------------------------------------
+     T E S T S
+    -------------------------------------------------------
+    Running org.superbiz.jpa.enums.MoviesTest
+    Apache OpenEJB 4.0.0-beta-2    build: 20120115-08:26
+    http://openejb.apache.org/
+    INFO - openejb.home = /Users/dblevins/openejb/examples/jpa-enumerated
+    INFO - openejb.base = /Users/dblevins/openejb/examples/jpa-enumerated
+    INFO - Using 'javax.ejb.embeddable.EJBContainer=true'
+    INFO - Configuring Service(id=Default Security Service, type=SecurityService, provider-id=Default Security Service)
+    INFO - Configuring Service(id=Default Transaction Manager, type=TransactionManager, provider-id=Default Transaction Manager)
+    INFO - Configuring Service(id=movieDatabase, type=Resource, provider-id=Default JDBC Database)
+    INFO - Found EjbModule in classpath: /Users/dblevins/openejb/examples/jpa-enumerated/target/classes
+    INFO - Beginning load: /Users/dblevins/openejb/examples/jpa-enumerated/target/classes
+    INFO - Configuring enterprise application: /Users/dblevins/openejb/examples/jpa-enumerated
+    INFO - Configuring Service(id=Default Stateful Container, type=Container, provider-id=Default Stateful Container)
+    INFO - Auto-creating a container for bean Movies: Container(type=STATEFUL, id=Default Stateful Container)
+    INFO - Configuring Service(id=Default Managed Container, type=Container, provider-id=Default Managed Container)
+    INFO - Auto-creating a container for bean org.superbiz.jpa.enums.MoviesTest: Container(type=MANAGED, id=Default Managed Container)
+    INFO - Configuring PersistenceUnit(name=movie-unit)
+    INFO - Auto-creating a Resource with id 'movieDatabaseNonJta' of type 'DataSource for 'movie-unit'.
+    INFO - Configuring Service(id=movieDatabaseNonJta, type=Resource, provider-id=movieDatabase)
+    INFO - Adjusting PersistenceUnit movie-unit <non-jta-data-source> to Resource ID 'movieDatabaseNonJta' from 'movieDatabaseUnmanaged'
+    INFO - Enterprise application "/Users/dblevins/openejb/examples/jpa-enumerated" loaded.
+    INFO - Assembling app: /Users/dblevins/openejb/examples/jpa-enumerated
+    INFO - PersistenceUnit(name=movie-unit, provider=org.apache.openjpa.persistence.PersistenceProviderImpl) - provider time 406ms
+    INFO - Jndi(name="java:global/jpa-enumerated/Movies!org.superbiz.jpa.enums.Movies")
+    INFO - Jndi(name="java:global/jpa-enumerated/Movies")
+    INFO - Created Ejb(deployment-id=Movies, ejb-name=Movies, container=Default Stateful Container)
+    INFO - Started Ejb(deployment-id=Movies, ejb-name=Movies, container=Default Stateful Container)
+    INFO - Deployed Application(path=/Users/dblevins/openejb/examples/jpa-enumerated)
+    INFO - Undeploying app: /Users/dblevins/openejb/examples/jpa-enumerated
+    INFO - Closing DataSource: movieDatabase
+    INFO - Closing DataSource: movieDatabaseNonJta
+    Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.831 sec
+
+    Results :
+
+    Tests run: 1, Failures: 0, Errors: 0, Skipped: 0

Added: openejb/trunk/openejb/examples/jpa-enumerated/build.xml
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/jpa-enumerated/build.xml?rev=1299304&view=auto
==============================================================================
--- openejb/trunk/openejb/examples/jpa-enumerated/build.xml (added)
+++ openejb/trunk/openejb/examples/jpa-enumerated/build.xml Sat Mar 10 23:30:29 2012
@@ -0,0 +1,119 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+       http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+-->
+
+<!-- $Rev: 1237516 $ $Date: 2012-01-29 18:48:17 -0600 (Sun, 29 Jan 2012) $ -->
+
+<project name="MyProject" default="dist" basedir="." xmlns:artifact="antlib:org.apache.maven.artifact.ant">
+
+  <!-- ===============================================================
+
+  HOW TO RUN
+
+    Download http://archive.apache.org/dist/maven/binaries/maven-ant-tasks-2.0.9.jar
+    Then execute ant as follows:
+
+    ant -lib maven-ant-tasks-2.0.9.jar
+
+  NOTE
+
+    You do NOT need maven-ant-tasks-2.0.9.jar to use OpenEJB for embedded EJB
+    testing with Ant.  It is simply used in this example to make the build.xml
+    a bit simpler.  As long as OpenEJB and it's required libraries are in the
+    <junit> classpath, the tests will run with OpenEJB embedded.
+
+  ================================================================= -->
+
+  <artifact:remoteRepository id="apache.snapshot.repository" url="http://repository.apache.org/snapshots/"/>
+  <artifact:remoteRepository id="m2.repository" url="http://repo1.maven.org/maven2/"/>
+
+  <!-- Build Classpath -->
+  <artifact:dependencies pathId="classpath.main">
+    <dependency groupId="org.apache.openejb" artifactId="javaee-api-embedded" version="6.0-3"/>
+  </artifact:dependencies>
+
+  <!-- Test Build Classpath -->
+  <artifact:dependencies pathId="classpath.test.build">
+    <dependency groupId="junit" artifactId="junit" version="4.3.1"/>
+  </artifact:dependencies>
+
+  <!-- Test Run Classpath -->
+  <artifact:dependencies pathId="classpath.test.run">
+    <remoteRepository refid="apache.snapshot.repository"/>
+    <remoteRepository refid="m2.repository"/>
+
+    <dependency groupId="org.apache.openejb" artifactId="openejb-core" version="4.0.0-beta-1"/>
+    <dependency groupId="junit" artifactId="junit" version="4.3.1"/>
+  </artifact:dependencies>
+
+  <!-- Properties -->
+
+  <property name="src.main.java" location="src/main/java"/>
+  <property name="src.main.resources" location="src/main/resources"/>
+  <property name="src.test.java" location="src/test/java"/>
+  <property name="build.main" location="target/classes"/>
+  <property name="build.test" location="target/test-classes"/>
+  <property name="test.reports" location="target/test-reports"/>
+  <property name="dist" location="target"/>
+
+
+  <target name="init">
+    <mkdir dir="${build.main}"/>
+    <mkdir dir="${build.test}"/>
+    <mkdir dir="${test.reports}"/>
+  </target>
+
+  <target name="compile" depends="init">
+
+    <javac srcdir="${src.main.java}" destdir="${build.main}">
+      <classpath refid="classpath.main"/>
+    </javac>
+    <copy todir="${build.main}">
+      <fileset dir="${src.main.resources}"/>
+    </copy>
+
+    <javac srcdir="${src.test.java}" destdir="${build.test}">
+      <classpath location="${build.main}"/>
+      <classpath refid="classpath.main"/>
+      <classpath refid="classpath.test.build"/>
+    </javac>
+  </target>
+
+  <target name="test" depends="compile">
+    <junit fork="yes" printsummary="yes">
+      <classpath location="${build.main}"/>
+      <classpath location="${build.test}"/>
+      <classpath refid="classpath.main"/>
+      <classpath refid="classpath.test.build"/>
+      <classpath refid="classpath.test.run"/>
+
+      <formatter type="plain"/>
+
+      <batchtest fork="yes" todir="${test.reports}">
+        <fileset dir="${src.test.java}">
+          <include name="**/*Test.java"/>
+        </fileset>
+      </batchtest>
+    </junit>
+  </target>
+
+  <target name="dist" depends="test">
+    <jar jarfile="${dist}/myproject-1.0.jar" basedir="${build.main}"/>
+  </target>
+
+</project>

Propchange: openejb/trunk/openejb/examples/jpa-enumerated/build.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Added: openejb/trunk/openejb/examples/jpa-enumerated/pom.xml
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/jpa-enumerated/pom.xml?rev=1299304&view=auto
==============================================================================
--- openejb/trunk/openejb/examples/jpa-enumerated/pom.xml (added)
+++ openejb/trunk/openejb/examples/jpa-enumerated/pom.xml Sat Mar 10 23:30:29 2012
@@ -0,0 +1,92 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+       http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+-->
+
+<!-- $Rev: 1237516 $ $Date: 2012-01-29 18:48:17 -0600 (Sun, 29 Jan 2012) $ -->
+
+<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
+  <modelVersion>4.0.0</modelVersion>
+  <groupId>org.superbiz</groupId>
+  <artifactId>jpa-enumerated</artifactId>
+  <packaging>jar</packaging>
+  <version>1.1-SNAPSHOT</version>
+  <name>OpenEJB :: Examples :: JPA @Enumerated</name>
+  <properties>
+    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
+  </properties>
+  <build>
+    <defaultGoal>install</defaultGoal>
+    <plugins>
+      <plugin>
+        <groupId>org.apache.maven.plugins</groupId>
+        <artifactId>maven-compiler-plugin</artifactId>
+        <version>2.3.2</version>
+        <configuration>
+          <source>1.6</source>
+          <target>1.6</target>
+        </configuration>
+      </plugin>
+    </plugins>
+  </build>
+  <repositories>
+    <repository>
+      <id>apache-m2-snapshot</id>
+      <name>Apache Snapshot Repository</name>
+      <url>http://repository.apache.org/snapshots</url>
+    </repository>
+  </repositories>
+  <dependencies>
+    <dependency>
+      <groupId>org.apache.openejb</groupId>
+      <artifactId>javaee-api</artifactId>
+      <version>6.0-3</version>
+      <scope>provided</scope>
+    </dependency>
+    <dependency>
+      <groupId>junit</groupId>
+      <artifactId>junit</artifactId>
+      <version>4.8.1</version>
+      <scope>test</scope>
+    </dependency>
+    <!--
+    The <scope>test</scope> guarantees that non of your runtime
+    code is dependent on any OpenEJB classes.
+    -->
+    <dependency>
+      <groupId>org.apache.openejb</groupId>
+      <artifactId>openejb-core</artifactId>
+      <version>4.0.0-beta-3-SNAPSHOT</version>
+      <scope>test</scope>
+    </dependency>
+  </dependencies>
+  <!--
+  This section allows you to configure where to publish libraries for sharing.
+  It is not required and may be deleted.  For more information see:
+  http://maven.apache.org/plugins/maven-deploy-plugin/
+  -->
+  <distributionManagement>
+    <repository>
+      <id>localhost</id>
+      <url>file://${basedir}/target/repo/</url>
+    </repository>
+    <snapshotRepository>
+      <id>localhost</id>
+      <url>file://${basedir}/target/snapshot-repo/</url>
+    </snapshotRepository>
+  </distributionManagement>
+</project>

Propchange: openejb/trunk/openejb/examples/jpa-enumerated/pom.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Added: openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movie.java
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movie.java?rev=1299304&view=auto
==============================================================================
--- openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movie.java (added)
+++ openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movie.java Sat Mar 10 23:30:29 2012
@@ -0,0 +1,79 @@
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+package org.superbiz.jpa.enums;
+
+import javax.persistence.Entity;
+import javax.persistence.EnumType;
+import javax.persistence.Enumerated;
+import javax.persistence.GeneratedValue;
+import javax.persistence.Id;
+
+@Entity
+public class Movie {
+
+    @Id
+    @GeneratedValue
+    private int id;
+    private String director;
+    private String title;
+    private int year;
+
+    @Enumerated(EnumType.STRING)
+    private Rating rating;
+
+    public Movie() {
+    }
+
+    public Movie(String director, String title, int year, Rating rating) {
+        this.director = director;
+        this.title = title;
+        this.year = year;
+        this.rating = rating;
+    }
+
+    public String getDirector() {
+        return director;
+    }
+
+    public void setDirector(String director) {
+        this.director = director;
+    }
+
+    public String getTitle() {
+        return title;
+    }
+
+    public void setTitle(String title) {
+        this.title = title;
+    }
+
+    public int getYear() {
+        return year;
+    }
+
+    public void setYear(int year) {
+        this.year = year;
+    }
+
+    public Rating getRating() {
+        return rating;
+    }
+
+    public void setRating(Rating rating) {
+        this.rating = rating;
+    }
+}

Propchange: openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movie.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movies.java
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movies.java?rev=1299304&view=auto
==============================================================================
--- openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movies.java (added)
+++ openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movies.java Sat Mar 10 23:30:29 2012
@@ -0,0 +1,54 @@
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+package org.superbiz.jpa.enums;
+
+//START SNIPPET: code
+
+import javax.ejb.Stateful;
+import javax.persistence.EntityManager;
+import javax.persistence.PersistenceContext;
+import javax.persistence.PersistenceContextType;
+import javax.persistence.Query;
+import java.util.List;
+
+@Stateful
+public class Movies {
+
+    @PersistenceContext(unitName = "movie-unit", type = PersistenceContextType.EXTENDED)
+    private EntityManager entityManager;
+
+    public void addMovie(Movie movie) {
+        entityManager.persist(movie);
+    }
+
+    public void deleteMovie(Movie movie) {
+        entityManager.remove(movie);
+    }
+
+    public List<Movie> findByRating(Rating rating) {
+        final Query query = entityManager.createQuery("SELECT m FROM Movie as m WHERE m.rating = :rating");
+        query.setParameter("rating", rating);
+        return query.getResultList();
+    }
+
+    public List<Movie> getMovies() throws Exception {
+        Query query = entityManager.createQuery("SELECT m from Movie as m");
+        return query.getResultList();
+    }
+
+}
+//END SNIPPET: code

Propchange: openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Movies.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Rating.java
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Rating.java?rev=1299304&view=auto
==============================================================================
--- openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Rating.java (added)
+++ openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Rating.java Sat Mar 10 23:30:29 2012
@@ -0,0 +1,27 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+package org.superbiz.jpa.enums;
+
+public enum Rating {
+
+    UNRATED,
+    G,
+    PG,
+    PG13,
+    R,
+    NC17
+}

Propchange: openejb/trunk/openejb/examples/jpa-enumerated/src/main/java/org/superbiz/jpa/enums/Rating.java
------------------------------------------------------------------------------
    svn:eol-style = native

Added: openejb/trunk/openejb/examples/jpa-enumerated/src/main/resources/META-INF/persistence.xml
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/jpa-enumerated/src/main/resources/META-INF/persistence.xml?rev=1299304&view=auto
==============================================================================
--- openejb/trunk/openejb/examples/jpa-enumerated/src/main/resources/META-INF/persistence.xml (added)
+++ openejb/trunk/openejb/examples/jpa-enumerated/src/main/resources/META-INF/persistence.xml Sat Mar 10 23:30:29 2012
@@ -0,0 +1,32 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+    Licensed to the Apache Software Foundation (ASF) under one or more
+    contributor license agreements.  See the NOTICE file distributed with
+    this work for additional information regarding copyright ownership.
+    The ASF licenses this file to You under the Apache License, Version 2.0
+    (the "License"); you may not use this file except in compliance with
+    the License.  You may obtain a copy of the License at
+
+       http://www.apache.org/licenses/LICENSE-2.0
+
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+-->
+<!-- START SNIPPET: code -->
+<persistence xmlns="http://java.sun.com/xml/ns/persistence" version="1.0">
+
+  <persistence-unit name="movie-unit">
+    <jta-data-source>movieDatabase</jta-data-source>
+    <non-jta-data-source>movieDatabaseUnmanaged</non-jta-data-source>
+    <class>org.superbiz.jpa.enums.Movie</class>
+
+    <properties>
+      <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>
+    </properties>
+  </persistence-unit>
+</persistence>
+    <!-- END SNIPPET: code -->

Propchange: openejb/trunk/openejb/examples/jpa-enumerated/src/main/resources/META-INF/persistence.xml
------------------------------------------------------------------------------
    svn:eol-style = native

Added: openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/jpa/enums/MoviesTest.java
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/jpa/enums/MoviesTest.java?rev=1299304&view=auto
==============================================================================
--- openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/jpa/enums/MoviesTest.java (added)
+++ openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/jpa/enums/MoviesTest.java Sat Mar 10 23:30:29 2012
@@ -0,0 +1,57 @@
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *  Unless required by applicable law or agreed to in writing, software
+ *  distributed under the License is distributed on an "AS IS" BASIS,
+ *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *  See the License for the specific language governing permissions and
+ *  limitations under the License.
+ */
+package org.superbiz.jpa.enums;
+
+import junit.framework.TestCase;
+import org.superbiz.jpa.enums.Movie;
+import org.superbiz.jpa.enums.Movies;
+import org.superbiz.jpa.enums.Rating;
+
+import javax.ejb.embeddable.EJBContainer;
+import javax.naming.Context;
+import java.util.Properties;
+
+public class MoviesTest extends TestCase {
+
+    public void test() throws Exception {
+
+        final Properties p = new Properties();
+        p.put("movieDatabase", "new://Resource?type=DataSource");
+        p.put("movieDatabase.JdbcDriver", "org.hsqldb.jdbcDriver");
+        p.put("movieDatabase.JdbcUrl", "jdbc:hsqldb:mem:moviedb");
+
+        EJBContainer container = EJBContainer.createEJBContainer(p);
+        final Context context = container.getContext();
+
+        final Movies movies = (Movies) context.lookup("java:global/jpa-enumerated/Movies");
+
+        movies.addMovie(new Movie("James Frawley", "The Muppet Movie", 1979, Rating.G));
+        movies.addMovie(new Movie("Jim Henson", "The Great Muppet Caper", 1981, Rating.G));
+        movies.addMovie(new Movie("Frank Oz", "The Muppets Take Manhattan", 1984, Rating.G));
+        movies.addMovie(new Movie("James Bobin", "The Muppets", 2011, Rating.PG));
+
+        assertEquals("List.size()", 4, movies.getMovies().size());
+
+        assertEquals("List.size()", 3, movies.findByRating(Rating.G).size());
+
+        assertEquals("List.size()", 1, movies.findByRating(Rating.PG).size());
+
+        assertEquals("List.size()", 0, movies.findByRating(Rating.R).size());
+
+        container.close();
+    }
+}

Propchange: openejb/trunk/openejb/examples/jpa-enumerated/src/test/java/org/superbiz/jpa/enums/MoviesTest.java
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: openejb/trunk/openejb/examples/pom.xml
URL: http://svn.apache.org/viewvc/openejb/trunk/openejb/examples/pom.xml?rev=1299304&r1=1299303&r2=1299304&view=diff
==============================================================================
--- openejb/trunk/openejb/examples/pom.xml (original)
+++ openejb/trunk/openejb/examples/pom.xml Sat Mar 10 23:30:29 2012
@@ -62,6 +62,7 @@
     <module>interceptors</module>
     <module>jpa-eclipselink</module>
     <module>jpa-hibernate</module>
+    <module>jpa-enumerated</module>
     <module>lookup-of-ejbs</module>
     <module>lookup-of-ejbs-with-descriptor</module>
     <module>mbean-auto-registration</module>