Summary: Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to WordPress data into a Java-based ORM framework, Hibernate.You can use Hibernate to map object-oriented domain models to a traditional relational database. The tutorial below shows how to use the CData JDBC Driver for WordPress to generate an ORM of your WordPress repository with Hibernate.Though Eclipse is the IDE of choice for this article, the CData JDBC Driver for WordPress works in anyproduct that supports the Java Runtime Environment. In the Knowledge Base you will find tutorials to connect to WordPress data from IntelliJ IDEA and NetBeans.Install HibernateFollow the steps below to install the Hibernate plug-in in Eclipse. In Eclipse, navigate to Help -> Install New Software. Enter "http://download.jboss.org/jbosstools/neon/stable/updates/" in the Work With box. Enter "Hibernate" into the filter box. Select Hibernate Tools.Start A New ProjectFollow the steps below to add the driver JARs in a new project. Create a new project. Select Java Project as your project type and click Next. Enter a project name and click Finish. Right-click the project and click Properties. Click Java Build Path and then open the Libraries tab. Click Add External JARs to add the cdata.jdbc.wordpress.jar library, located in the lib subfolder of the installation directory.Add a Hibernate Configuration FileFollow the steps below to configure connection properties to WordPress data. Right-click on the new project and select New -> Hibernate -> Hibernate Configuration File (cfg.xml). Select src as the parent folder and click Next. Input the following values: Hibernate version:: 5.2 Database dialect: Derby Driver class: cdata.jdbc.wordpress.WordPressDriver Connection URL: A JDBC URL, starting with jdbc:wordpress: and followed by a semicolon-separated list of connection properties. To connect to WordPress, set the URL property and other authentication properties. WordPress supports Basic (User and Password) and OAuth2.0 authentication, though Basic is recommended for a testing environment only. To connect with OAuth you will need to register an app with WordPress.See the Getting Started guide in the CData driver documentation for more information.Built-in Connection String DesignerFor assistance in constructing the JDBC URL, use the connection string designer built into the WordPress JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.java -jar cdata.jdbc.wordpress.ja... You are listening to the topic about "Object-Relational Mapping (ORM) with WordPress Data Entities in Java", if you want to read the full article, please visit https://geniuswp.com or the link in the description.
