[CONF] OpenJPA > Using Criteria API in DayTrader

[confluence]

Using Criteria API in DayTrader Page edited by Dianne Richards Comment: Added more documentation Changes (3) ... h2. Build DayTrader You must have maven installed in order to build DayTrader. Maven can be downloaded from [http://maven.apache.org/download.html]. Unzip the file to a directory and run mvn.bat\|.sh in the bin subdirectory to install. Add the bin subdirectory to you system path. Maven needs a repository. Typically it is at the following: ... Install and start the Geronimo server Add jpa2 plugins from repository http://geronimo.apache.org/plugins/openjpa2. Add jpa2 plugins from repository [http://geronimo.apache.org/plugins/openjpa2]. One way to do this is the following: # Go to the Geronimo console at http://<host>:8080/console and logon # Select _plugins_ # Click on _Add Repository_ and add http://geronimo.apache.org/plugins/openjpa2 # Click on _Update Repository List_ # Make sure the new repository is selected. Then click on _Show Plugins in selected repository._ On that panel: ## Select _GeronimoPlugins, OpenJPA2::CAR 2.1.3-SNAPSHOT_ and _GeronimoPlugins, OpenJPA2::Deployer 2.1.3-SNAPSHOT_ ## Click on _Install_ # On the next screen, click on _Install_ Deploy the DayTrader application. This can be done through the console as follows: # Click on _Deploy New_ # For _Archive_, browse to DayTrader/branches/2.1.3/modules/ear/target/daytrader-ear-2.1.3.ear # For _Plan,_ browse to DayTrader/branches/2.1.3/plans/dayTrader-derby-plan.xml # Check _Start app after install_ Re-start the server. Make sure that the system module, org.apache.geronimo.configs/axis-deployer/2.1.5/car, is running. Run DayTrader: # Go to http://<host>:8080/daytrader/ # Click on the _Configuration_ tab and click on _(Re)-create DayTrader Database Tables and Indexes_ # Click on the _Configuration&nbsp;_ tab and click on _(Re)-populate DayTrader Database_ # Click on the _Trading & Portfolios_ tab and start trading Full Content Using Criteria API in DayTrader A current DayTrader project implementation in Apache Geronimo contains several JPQL queries. These can easily be converted to JPA Criteria API queries. A sample with this conversion can be created to run on the Apache Geronimo server. Downloading DayTrader You must have Subversion installed in order to download the DayTrader implementation.Subversion can be downloaded from http://subversion.apache.org/packages.html. Use the 2.1.3 version of DayTrader for this sample. Follow the following steps: Create a root directory for the download. For this example, we will use a directory called DayTrader. Create subdirectories branches/2.1.3 under the DayTrader directory cd to DayTrader Issue the following subversion command:      svn checkout https://svn.apache.org/repos/asf/geronimo/daytrader/branches/2.1.3 branches/2.1.3https://svn.apache.org/repos/asf/geronimo/daytrader/branches/2.1.3 Build DayTrader You must have maven installed in order to build DayTrader. Maven can be downloaded from http://maven.apache.org/download.html. Unzip the file to a directory and run mvn.bat|.sh in the bin subdirectory to install. Add the bin subdirectory to you system path. Maven needs a repository. Typically it is at the following: Windows - C:\Documents and Settings\<userid>\.m2\repository Linux/unix - ~/.m2/repository From the DayTrader/branches/2.1.3 directory, type "mvn clean install" to build the project. Setting up Eclipse First install eclipse by going to http:/www.eclipse.org and downloading a version of it. These instructions assume version 3.5. Unzip the downloaded file into a directory. You can start eclipse by running eclipse.exe in the eclipse directory. Next install subclipse, the Subversion Eclipse Plugin: In Eclipse, go to Help -> Install New software Click on Add button - Enter Subclipse for Name and http://subclipse.tigris.org/update_1.6.x for location Select the Subclipse Plugin and click Next -> Next Read and accept the license and click Finish Generate eclipse files for the DayTrader project. From the DayTrader/branches/2.1.3 directory, type "mvn eclipse:eclipse" Set the M2_REPO classpath variable in Eclipse: Go to Window -> Preferences -> Java -> Build Path -> Classpath Variables Add a new variable called M2_REPO, set to the maven repository directory mentioned above. Import DayTrader projects into Eclipse. From Eclipse, Click on File -> Import... Under the General folder, select Existing Projects into Workspace and click on Next. Enter the root directory of DayTrader/branches/2.1.3 Select all projects and click Finish Apply the DayTrader Patch The following patch can be applied using a system or downloaded patch utility. (For example, you can get a patch utility for Windows from http://gnuwin32.sourceforge.net/packages/patch.htm.) daytrader_geronimo.patch Download this patch and go to the DayTrader/branches.2.1.3 directory to apply it. For example, with the patch utility mentioned above, you can type: patch -p0 -i <path-to>/daytrader_geronimo.patch After you have applied the patch, you can see the changes from JPQL to the Criteria API in the java class org.apache.geronimo.samples.daytrader.ejb3.TradeSLSBBean. The changes are in the following 4 methods: getMarketSummary() getClosedOrders() getAllQuotes() getHoldings() (Note: If you view these changes in eclipse, and you have previously run "mvn eclipse:eclipse" to setup eclipse projects, you'll have to run this command again in order for this file to compile.) Run DayTrader on Geronimo This writeup assumes some familiarity with Apache Geronimo. The download and documentation can be found at http://geronimo.apache.org. Install and start the Geronimo server Add jpa2 plugins from repository http://geronimo.apache.org/plugins/openjpa2. One way to do this is the following: Go to the Geronimo console at http://<host>:8080/console and logon Select plugins Click on Add Repository and add http://geronimo.apache.org/plugins/openjpa2 Click on Update Repository List Make sure the new repository is selected. Then click on Show Plugins in selected repository. On that panel: Select GeronimoPlugins, OpenJPA2::CAR 2.1.3-SNAPSHOT and GeronimoPlugins, OpenJPA2::Deployer 2.1.3-SNAPSHOT Click on Install On the next screen, click on Install Deploy the DayTrader application. This can be done through the console as follows: Click on Deploy New For Archive, browse to DayTrader/branches/2.1.3/modules/ear/target/daytrader-ear-2.1.3.ear For Plan, browse to DayTrader/branches/2.1.3/plans/dayTrader-derby-plan.xml Check Start app after install Re-start the server. Make sure that the system module, org.apache.geronimo.configs/axis-deployer/2.1.5/car, is running. Run DayTrader: Go to http://<host>:8080/daytrader/ Click on the Configuration tab and click on (Re)-create DayTrader Database Tables and Indexes Click on the Configuration  tab and click on (Re)-populate DayTrader Database Click on the Trading & Portfolios tab and start trading Change Notification Preferences View Online | View Changes | Add Comment