NoSQL with JPA
Join the DZone community and get the full member experience.
Join For FreeEclipseLink, reference implementation of JPA, has JPA support for NoSQL databases (MongoDB and Oracle NoSQL) as of the version 2.4. In this tutorial we will discuss the use of MongoDB database with the JPA support of EclipseLink. The transaction previously done using the console and native java driver will be done in a web application with the help of EclipseLink.
Tools and technologies used in the sample application are as follows:
- MongoDB version 2.4.1
- MongoDB Java Driver version 2.11.1
- JSF version 2.2
- PrimeFaces version 3.5
- EclipseLink version 2.4
- Jetty 7.x Maven Plugin
- JDK version 1.7
- Maven 3.0.4
Project Dependencies
<dependency> <groupId>org.glassfish</groupId> <artifactId>javax.faces</artifactId> <version>2.2.0-SNAPSHOT</version> </dependency> <dependency> <groupId>org.primefaces</groupId> <artifactId>primefaces</artifactId> <version>3.5</version> </dependency> <dependency> <groupId>org.primefaces.themes</groupId> <artifactId>bootstrap</artifactId> <version>1.0.10</version> </dependency> <dependency> <groupId>org.eclipse.persistence</groupId> <artifactId>org.eclipse.persistence.jpa</artifactId> <version>2.4.0-SNAPSHOT</version> </dependency> <dependency> <groupId>org.eclipse.persistence</groupId> <artifactId>org.eclipse.persistence.nosql</artifactId> <version>2.4.0-SNAPSHOT</version> </dependency> <dependency> <groupId>jboss</groupId> <artifactId>jboss-j2ee</artifactId> <version>4.2.2.GA</version> </dependency> <dependency> <groupId>org.mongodb</groupId> <artifactId>mongo-java-driver</artifactId> <version>2.11.1</version> </dependency> <dependency> <groupId>commons-fileupload</groupId> <artifactId>commons-fileupload</artifactId> <version>1.3</version> </dependency>
@Entity @NoSql(dataFormat=DataFormatType.MAPPED) public class Article implements Serializable { public Article() { } @Id @GeneratedValue @Field(name="_id") private String id; @ElementCollection private List<Categories> categoryLists = new ArrayList<Categories>(); @Basic private String title; @Basic private String content; @Basic @Temporal(javax.persistence.TemporalType.DATE) private Date date; @Basic private String author; @ElementCollection private List<Tags> tagLists = new ArrayList<Tags>();
@Embeddable @NoSql(dataFormat=DataFormatType.MAPPED) public class Categories implements Serializable { @Basic private String category;
@Embeddable @NoSql(dataFormat=DataFormatType.MAPPED) public class Tags implements Serializable { @Basic private String tag;
<?xml version="1.0" encoding="UTF-8" ?> <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" version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"> <persistence-unit name="kodcuMongo" transaction-type="RESOURCE_LOCAL"> <class>com.kodcu.entity.Article</class> <class>com.com.kodcu.entity.Categories</class> <class>com.kodcu.entity.Tags</class> <properties> <property name="eclipselink.target-database" value="org.eclipse.persistence.nosql.adapters.mongo.MongoPlatform"/> <property name="eclipselink.nosql.connection-spec" value="org.eclipse.persistence.nosql.adapters.mongo.MongoConnectionSpec"/> <property name="eclipselink.nosql.property.mongo.port" value="27017"/> <property name="eclipselink.nosql.property.mongo.host" value="localhost"/> <property name="eclipselink.nosql.property.mongo.db" value="kodcu"/> <property name="eclipselink.logging.level" value="FINEST"/> </properties> </persistence-unit> </persistence>
<h:form id="articleForm"> <p:growl id="growl"/> <h:panelGrid columns="2" cellpadding="2" cellspacing="2"> <p:panel styleClass="registrationForm" header="Registration Form"> <h:panelGrid id="registrationPanelGrid" columns="2" cellpadding="2" cellspacing="2"> <h:outputLabel value="Category"/> <p:inputText value="#{myBean.categories}" styleClass="inputTextWidth"/> <h:outputLabel value="Title"/> <p:inputText value="#{myBean.article.title}" required="#{param['saveArticle']=='true'}" requiredMessage="The title field is required." styleClass="inputTextWidth"/> <h:outputLabel value="Content"/> <p:inputTextarea value="#{myBean.article.content}" required="#{param['saveArticle']=='true'}" requiredMessage="The content field is required." styleClass="inputTextAreaWidthHeight"/> <h:outputLabel value="Author"/> <p:inputText value="#{myBean.article.author}" required="#{param['saveArticle']=='true'}" requiredMessage="The author field is required." styleClass="inputTextWidth"/> <h:outputLabel value="Tags"/> <p:inputText value="#{myBean.tags}" styleClass="inputTextWidth" /> </h:panelGrid> </p:panel> <p:panel header="Article Directory" styleClass="articleDirectory"> <p:dataTable id="articleTable" var="article" value="#{myBean.articleList}" selectionMode="single" selection="#{myBean.selectArticle}" paginator="true" paginatorPosition="bottom" rows="5" rowKey="#{article.id}"> <p:ajax event="rowSelect" listener="#{myBean.articleSelect}" update=":articleForm:registrationPanelGrid :articleForm:removeArticle"/> <p:column width="200"> <f:facet name="header"> <h:outputLabel value="Title"/> </f:facet> <h:outputLabel value="#{article.title}"/> </p:column> <p:column width="350"> <f:facet name="header"> <h:outputLabel value="Content"/> </f:facet> <h:outputLabel value="#{article.content}"/> </p:column> <p:column width="200"> <f:facet name="header"> <h:outputLabel value="Author"/> </f:facet> <h:outputLabel value="#{article.author}"/> </p:column> <p:column width="40"> <f:facet name="header"> <h:outputLabel value="Date"/> </f:facet> <h:outputLabel value="#{article.date}"> <f:convertDateTime pattern="dd/MM/yyyy"/> </h:outputLabel> </p:column> </p:dataTable> </p:panel> <h:panelGroup> <p:commandButton id="newArticle" action="#{myBean.initArticle}" value="New" update="registrationPanelGrid articleTable removeArticle"/> <p:commandButton id="saveArticle" action="#{myBean.saveArticle}" value="Save" update="registrationPanelGrid articleTable growl"> <f:param name="saveArticle" value="true"/> </p:commandButton> <p:commandButton id="removeArticle" disabled="#{null == myBean.selectArticle}" action="#{myBean.removeArticle}" value="Remove" update="registrationPanelGrid articleTable @this"/> </h:panelGroup> </h:panelGrid> </h:form>
public void saveArticle() { em.getTransaction().begin(); if(null == article.getId()) em.persist(article); else em.merge(article); em.getTransaction().commit(); } public void removeArticle() { em.getTransaction().begin(); em.remove(selectArticle); em.getTransaction().commit(); }
Opinions expressed by DZone contributors are their own.
Comments