Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "EclipseLink/Examples/JPA/WebSphere7 Web Tutorial"

m (EclipseLink JPA Deployed on IBM WebSphere 7 using Eclipse WTP)
m (Replacing page with '[http://wiki.eclipse.org/EclipseLink/Examples/JPA/WebSphere_Web_Tutorial Original WebSphere 7 tutorial page for EclipseLink JPA]')
 
(42 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=EclipseLink JPA Deployed on IBM WebSphere 7 using Eclipse WTP=
+
[http://wiki.eclipse.org/EclipseLink/Examples/JPA/WebSphere_Web_Tutorial Original WebSphere 7 tutorial page for EclipseLink JPA]
* <font color="orange">This tutorial needs to be finished and/or expanded - as of 20100415 - I have approval to update this wiki via bug# bug# '''[http://bugs.eclipse.org/309201 309201]'''.</font>
+
 
+
<font color="red">Note: This tutorial' is under construction for the next week as of 20010415.</font>
+
 
+
If you want to get a small web application running quickly on WebSphere 7.0 you can use Eclipse to create the EAR and [[EclipseLink/Examples/JPA/WebSphere7_Web_Tutorial#Remote_Debugging_EclipseLink_in_WebSphere_7.0_from_Eclipse_3.4|attach to a running WebSphere instance in debug mode on port 7781]].
+
 
+
This basic example details how to use Eclipse to run/debug a minimum J2EE web application servlet using EclipseLink JPA as the persistence provider.  The goal of this example is to detail the minimum steps required to run EclipseLink inside the [http://www.ibm.com/developerworks/downloads/ws/was/?S_TACT=105AGX28&S_CMP=DLMAIN&S_CMP=rnav IBM WebSphere Application Server 7.0] server using the Eclipse IDE.  At this point no presentation/controller layer such as JSF, Spring or Struts will be used beyond a basic HttpServlet so we can concentrate on the the integration layer JPA setup.
+
 
+
The [http://wiki.eclipse.org/Dali DALI] project can be used to generate Entities from a schema with sequences already populated.
+
 
+
Tables can be populated by persisting an instance of the mode in an SE JPA persistence unit with DDL generation turned on.
+
 
+
'''The recommended configuration for running EclipseLink as the JPA provider on WebSphere 7 are the following [http://wiki.eclipse.org/EclipseLink/Examples/JPA/WebSphere7_Web_Tutorial#Container_Managed_and_Application_Managed_Scenarios container managed scenarios] below.'''
+
 
+
==Development Environment==
+
===Software===
+
*''' http://www.eclipse.org/downloads/download.php?file=/technology/epp/downloads/release/galileo/SR2/eclipse-jee-galileo-SR2-win32.zip Eclipse IDE for Java EE 3.5 Galileo SR 2] (April 2010 +) IBM J9 JRE 1.6.0 build 2.4 20080816_22093.
+
===OS===
+
*I am running this on both a 32-bit P630 2Gb machine and a Corei7 64-bit Windows7 12Gb machine - Note: '''installing the 32 bit version of WebSphere 7 on a 64-bit OS will require a full reboot of the server before you can start the container'''.
+
*Note: Developing/Debugging an enterprise application works excellent if you use IBM Rational Developer as the Eclipse based IDE where 7.0 server support currently exists.  However if you wish to debug from an unenhanced standard Eclipse 3.5 EE IDE you must run through some hoops and export your EAR manually, deploy/update it in the admin console and attach to the debuggable process manually.  In other application servers such as WebLogic, OC4J, Glassfish, Tomcat and even WebSphere 6.0 this process is handled automatically for you via an eclipse plugin.
+
 
+
==Prerequisites==
+
===<font color="green">Install Eclipse EE</font>===
+
*I installed a clean version of Eclipse Galileo 3.5 SR2 EE Edition (32-bit) (April 2010) on a Window 7 64-bit install where the default JRE was the 64-Bit server version of the SUN JVM.  I therefore needed to override the default ''java.exe'' by specifying the following shortcut override
+
<source lang="java">
+
C:\eclipse35-32bit-home\eclipse.exe -vm c:/jdk1.6.0_32-bit/bin/java.exe
+
</source>
+
*Default [[EclipseLink/Development/Testing/Prereq#Recommended_eclipse.ini_settings_for_EclipseLink|eclipse.ini]] settings must be modified as referenced.
+
 
+
===<font color="green">Install a Database</font>===
+
*We will be using a remote '''Oracle 11''' instance as well as a ''local'' '''[[EclipseLink/Examples/JPA/Derby|Derby 10.5.3.0]]''' instance or the embedded '''Derby''' instance that comes with WebSphere.
+
 
+
===<font color="green">Install WebSphere 7.0</font>===
+
*I installed the commercial '''7.0.0.0''' version of IBM WebSphere 7 and then the '''7.0.0.5''' '''fixpack in 7.0.0-WS-WAS-WinX32-FP0000005.pak''' using the ''7.0.0.5-WS-UPDI-WinIA32.zip'' installer.
+
*[[Image:Ibm_websphere_fixpack_7001_result.JPG]]
+
 
+
===Install WebSphere Eclipse 3.4 Server Plugin - unusable===
+
We will first see if the WebSphere 6.0 or 6.1 plugin works with WebSphere 7.0 - it fails on missing jar files that are not present in 7.0.
+
The WebSphere 6.1 Eclipse WTP server plugin is not shipped by default with Eclipse (WebSphere 6.0 for JEE 1.4 is).
+
*'''Note: The WebSphere 6.1 plugin for Eclipse WTP is currently being developed - see the following [http://bugs.eclipse.org/160220 Eclipse WTP enhancement request 160220 in progress].
+
*We are not blocked from using Eclipse WTP to manage the WebSphere 6.1 server, but without this plugin we will need to attach manually to port 7781 of a running WebSphere server that was started in debug mode outside of the Eclipse IDE - we will use this alternate debug approach.
+
*<font color="red">If you try to stub out the 73 jars required by the WebSphere 6.0 plugin to make it work with a WebSphere 7.0 server - you will get the following exception '''starting''' WebSphere from Eclipse.</font> - ''so don't do it''
+
 
+
<source lang="java">com.ibm.ws.exception.ConfigurationError: java.lang.Exception: Cannot find BundleContext for service com.ibm.ws.runtime.config.ConfigServiceImpl
+
at com.ibm.ws.runtime.WsServerImpl.bootConfigService(WsServerImpl.java:335)
+
at com.ibm.ws.runtime.WsServerImpl.start(WsServerImpl.java:171)
+
</source>
+
 
+
==WebSphere Configuration Changes==
+
*WebSphere configuration modifications can be done on the admin console .
+
**http://localhost:9060/ibm/console/
+
**Which redirects to
+
***https://localhost:9043/ibm/console/login.do?action=secure
+
***or if a secure login was not selected
+
***http://localhost:9060/ibm/console/unsecureLogon.jsp
+
 
+
==JNDI Datasource Setup==
+
 
+
===Global Scoped Datasource Setup===
+
*We will ''for now'' use the already configured JNDI name '''"DefaultDatasource"'''.
+
*Note the check box '''"Use this data source in container managed persistence (CMP)"''' that allows us to use this TX datasource for all our container managed deployments below.
+
[[Image:DefaultDatasource_derby_on_websphere7.JPG]]
+
 
+
==Downloading EclipseLink Libraries==
+
===Download EclipseLink using HTTP - recommended===
+
*Proceed to the following URL and download the latest eclipselink.zip which contains everything you need.
+
**http://www.eclipse.org/eclipselink/downloads/index.php
+
***'''Click on the "EclipseLink Installer Zip''' link which resolves to http://www.eclipse.org/downloads/download.php?file=/rt/eclipselink/releases/n.n.n/eclipselink-n.n.n.zip
+
*Expand the zip file and get the following 2 files
+
**eclipselink-*\eclipselink\jlib\eclipselink.jar
+
**eclipselink-*\eclipselink\jlib\jpa\javax.persistence_*.jar
+
===Download EclipseLink using Maven===
+
See the repository on http://www.eclipse.org/eclipselink/downloads/index.php
+
===Download EclipseLink using SVN - developers only===
+
*Get the following ''<font color="blue">eclipselink.jar</font>'' and ''<font color="blue">javax.persistence*.jar</font>'' from http://www.eclipselink.org ready for your EclipseLink shared library.
+
**The following page details four different ways to either obtain the binary jars or download the source and build them yourself with an anon account.
+
**http://wiki.eclipse.org/EclipseLink/Source
+
 
+
=Container Managed and Application Managed Scenarios=
+
*The following table summarizes the type of test, server modifications and results for verious container managed and application managed EntityManager deployments on the IBM WebSphere 7 server.
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! UC# DI#
+
! Test Example-Description
+
! Container-Managed vs Application-Managed
+
! Injected-EMF vs Persistence bootstrap
+
! JTA, non-JTA, RESOURCE _LOCAL Datasource
+
! Entities, PU in utility JAR
+
! Entities, PU in EJB JAR
+
! Entities, PU in WAR
+
! '''WAS console <font color="red">parent-last</font> Classloader override'''
+
! Server modifications?
+
! '''persistence.xml 2.0 XSD Schema'''
+
! '''Weaving entities'''
+
! '''Runs JPA2 Impl (shipped with EclipseLink 1.2 only)'''
+
! '''Runs JPA2 Impl (shipped with EclipseLink 2.0 only) - IE: CriteriaBuilder'''
+
|- bgcolor="#efefcc"
+
|| [[EclipseLink/Examples/JPA/WebSphere7_Web_Tutorial#EclipseLink_library_in_Server.2Flib|#1]]
+
|<font color="green">Container-Managed PU in EAR(EJB,WAR)</font> - working with server mod
+
||container ||injected @PersistenceContext EM on SLSB 
+
|| JTA (derby XA)
+
|| || PU in EJB||
+
|| || eclipselink.jar in %server%/lib
+
|| <font color="red">1.0 only</font>|| <font color="green">'''Weaved as 1.0'''</font>
+
|| ? || ?
+
|- bgcolor="#efefcc"
+
|| [[EclipseLink/Examples/JPA/WebSphere7_Web_Tutorial#Container_Managed_EclipseLink_library_in_EAR|#2]]
+
|<font color="green">Container-Managed PU in EAR(EJB,WAR)</font> - with eclipselink.jar in EAR
+
||container ||injected @PersistenceContext EM on SLSB 
+
|| JTA (derby XA)
+
|| || PU in EJB||
+
|| || none
+
|| <font color="red">1.0 only</font> || <font color="green">'''Weaved as 1.0'''</font>
+
|| ? || ?
+
|- bgcolor="#efefef"
+
|| [[EclipseLink/Examples/JPA/WebSphere7_Web_Tutorial#.40PersistenceUnit_EMF_injection_on_WAR_Servlet|#3]]
+
|<font color="green">Application-Managed PU in EAR(WAR)</font> - working with no server mods
+
||application ||injected @PersistenceUnit on Servlet 
+
|| RESOURCE_LOCAL (derby network XA)
+
|| || || PU in WAR
+
|| || eclipselink.jar, JPA persistence jar in EAR
+
|| <font color="red">1.0 only</font>||<font color="green">'''Weaved as 1.0'''</font>
+
|| ? || ?
+
|-
+
|}
+
 
+
==Configuration==
+
*URL
+
**http://192.168.0.165:9080/enterprise/FrontController?action=demo&rnd=4343434359
+
*<font color="red">'''This section is currently undergoing review and minor editing as more deployment scenarios are tested today (20100419)'''</font>
+
*The following section details investigations on what configurations work when using the '''EclipseLink''' JPA provider on the '''IBM WebSphere 7''' Application Server.  The test deployments are configured around ''<font color="green">container managed</font>'' EARs that require server modification such as creating a global shared library or placing the eclipselink.jar library directly in the '''%SERVER%/lib''', and ''<font color="blue">application managed</font>'' EARs that do not require any server modification as they ship the required libraries as part of the EAR.
+
 
+
==Container Managed==
+
===EAR configuration===
+
*standard @EJB statless session bean injected on Servlet client, the EJB bean is @PersistenceContext injected with a container managed EntityManager using a transactional datasource (in this case derby)
+
*Server startup logs
+
<pre>WebSphere Platform 7.0.0.5 [BASE 7.0.0.5 cf050926.18] running with process name beowulf5Node01Cell\beowulf5Node01\server1 and process id 2928
+
Host Operating System is Windows XP, version 5.1 build 2600 Service Pack 3
+
Java version = 1.6.0, Java Compiler = j9jit24, Java VM name = IBM J9 VM
+
</pre>
+
===EclipseLink library as Global Shared Library===
+
*Here a developer with access to the servers' console would add a global scope library that references an external '''eclipselink.jar'''.
+
*This works the same as the option below.
+
===<font color="green">'''EclipseLink library in Server/lib</font>'''===
+
*Placing the eclipselink.jar library directly on the server in the '''%SERVER%/lib''' directory and restarting the server will allow container managed deployments of EclipseLink applications following the JPA 1.0 specification to inject and function correctly.
+
====Predeploy, deploy and runtime logs====
+
<source lang="java">
+
[4/16/10 10:26:39:484 EDT] 0000000a SystemOut    O [EL Finest]: 2010-04-16 10:26:39.343--ServerSession(112920251)--Thread(Thread[server.startup : 1,5,main])--Begin predeploying Persistence Unit example; session jar:file:/C:/opt/was7001/AppServer/profiles/AppSrv01/installedApps/beowulf5Node01Cell/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR.ear/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar!/_example; state Initial; factoryCount 0
+
[4/16/10 10:26:40:218 EDT] 0000000a SystemOut    O [EL Finer]: 2010-04-16 10:26:40.218--ServerSession(112920251)--Thread(Thread[server.startup : 1,5,main])--Class [org.eclipse.persistence.example.jpa.server.business.Cell] registered to be processed by weaver.
+
[4/16/10 10:26:40:312 EDT] 0000000a SystemOut    O [EL Finest]: 2010-04-16 10:26:40.312--ServerSession(1551588475)--Thread(Thread[server.startup : 1,5,main])--End predeploying Persistence Unit exampleAM; session jar:file:/C:/opt/was7001/AppServer/profiles/AppSrv01/installedApps/beowulf5Node01Cell/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR.ear/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar!/_exampleAM; state Predeployed; factoryCount 1
+
[4/16/10 10:26:44:078 EDT] 0000000a EJBContainerI I  WSVR0057I: EJB jar started: org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar
+
[4/16/10 10:27:23:781 EDT] 00000012 SystemOut    O [EL Finest]: 2010-04-16 10:27:23.781--ServerSession(112920251)--Thread(Thread[WebContainer : 1,5,main])--Begin weaver class transformer processing class [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/16/10 10:27:23:843 EDT] 00000012 SystemOut    O [EL Finest]: 2010-04-16 10:27:23.843--ServerSession(112920251)--Thread(Thread[WebContainer : 1,5,main])--Weaved persistence (PersistenceEntity) [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/16/10 10:27:23:843 EDT] 00000012 SystemOut    O [EL Finest]: 2010-04-16 10:27:23.843--ServerSession(112920251)--Thread(Thread[WebContainer : 1,5,main])--Weaved fetch groups (FetchGroupTracker) [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/16/10 10:27:23:843 EDT] 00000012 SystemOut    O [EL Finest]: 2010-04-16 10:27:23.843--ServerSession(112920251)--Thread(Thread[WebContainer : 1,5,main])--End weaver class transformer processing class [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/16/10 10:27:26:953 EDT] 00000012 SystemOut    O [EL Config]: 2010-04-16 10:27:26.953--ServerSession(112920251)--Connection(292491631)--Thread(Thread[WebContainer : 1,5,main])--Connected: jdbc:derby:C:\opt\was7001\AppServer\profiles\AppSrv01/installedApps/beowulf5Node01Cell/DefaultApplication.ear/DefaultDB
+
[4/16/10 10:27:27:312 EDT] 00000012 SystemOut    O [EL Finest]: 2010-04-16 10:27:27.312--UnitOfWork(67175425)--Thread(Thread[WebContainer : 1,5,main])--PERSIST operation called on: org.eclipse.persistence.example.jpa.server.business.Cell@562176386( id: null state: null left: null right: null parent: HashSet@562700682 references: HashSet@562700682).
+
[4/16/10 10:27:27:359 EDT] 00000012 SystemOut    O [EL Fine]: 2010-04-16 10:27:27.359--ClientSession(488447261)--Connection(18219286)--Thread(Thread[WebContainer : 1,5,main])--INSERT INTO EL_CELL (STATE, TSEQ, ACELLATTRIBUTE_ID, RIGHT_ID) VALUES (?, ?, ?, ?)
+
</source>
+
===<font color="green">Container Managed EclipseLink library in EAR</font>===
+
*This is an interesting use case where the eclipselink JPA library is included locally in the EAR ''(requiring no server modifications)'' but the persistence unit itself is container managed by '''@PersistenceUnit''' injection on a ''stateless session bean''.
+
====Injected EntityManager on the SSB====
+
*We get a <font color="green">'''JPATxEntityManager@14001400'''</font> entityManager instance injected from the WebSphere container - this looks like a proxy wrapper for our EntityManagerImpl.
+
 
+
<source lang="java">
+
[4/19/10 12:07:22:106 EDT] 00000028 SystemOut    O [EL Example]: enterprise: ApplicationService query: select object(e) from Cell e on
+
EM: JPATxEntityManager@14001400[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example,
+
org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
</source>
+
 
+
====Insertion Testing====
+
*The following screen captures highlight our results of doing ''entity insertion'' on this custom container managed persistence unit detailed below.
+
*after read of 5 existing entities and insertion of an additional 5...
+
[[Image:Browser_cap_jpa1_persistenceContext_injected_em_on_slsb_jta_derby.JPG]]
+
*inserting another 5 in a 2nd transaction using a different injected entityManager but the same JPAtxEntityManager proxy.
+
[[Image:Browser_cap_jpa1_persistenceContext_injected_em_on_slsb_jta_derby_after_2nd_insert.JPG]]
+
 
+
====Configuration====
+
=====Console Overrides=====
+
*None - I did not override the '''Class Loader Order''' - it is still set to ''Classes loaded with parent class loader first''.
+
=====EclipseLink library in EAR=====
+
*org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR
+
**EarContent
+
***APP-INF
+
****lib
+
*****'''<font color="red">eclipselink.jar</font> - note there is no eclipselink.jar on the server.
+
 
+
======MANIFEST.MF======
+
<source lang="java">
+
Manifest-Version: 1.0
+
Class-Path: APP-INF/lib/eclipselink.jar
+
eclipselink.jar
+
</source>
+
=====Stateless Session Bean=====
+
@Local
+
@Stateless
+
public class ApplicationService implements ApplicationServiceLocal {
+
@PersistenceContext(unitName="example", type=PersistenceContextType.TRANSACTION)
+
private EntityManager entityManager;
+
...
+
// with no transaction or entityManager application management - all callbacks handled by the container
+
    public boolean insertObjects(List<Cell> classes) {
+
...
+
                    entityManager.persist(classes.get(i));
+
 
+
=====Servlet client=====
+
<source lang="java">
+
public class FrontController extends HttpServlet implements Servlet {
+
    @EJB(beanName="ApplicationService")
+
public ApplicationServiceLocal applicationService;
+
</source>
+
=====persistence.xml in ejb.jar=====
+
<source lang="xml">
+
<persistence-unit name="example" transaction-type="JTA">
+
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
+
        <jta-data-source>derbyXA</jta-data-source> <!-- custom local TX 10.5.3.0 derby -->
+
        <class>org.eclipse.persistence.example.jpa.server.business.Cell</class>
+
        <class>org.eclipse.persistence.example.jpa.server.business.CellAttribute</class>       
+
        <properties>
+
            <property name="eclipselink.target-server" value="WebSphere_7"/>
+
            <property name="eclipselink.target-database" value="Derby"/>           
+
            <property name="eclipselink.weaving" value="true"/>           
+
            <!--property name="eclipselink.ddl-generation" value="drop-and-create-tables"/>
+
            <property name="eclipselink.ddl-generation.output-mode" value="database"/>                       
+
            <property name="eclipselink.logging.level" value="FINEST"/-->
+
        </properties>     
+
    </persistence-unit>
+
</source>
+
 
+
====Logs====
+
<source lang="java">
+
[4/19/10 12:56:51:468 EDT] 0000001a ApplicationMg A  WSVR0204I: Application: org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR  Application build level: Unknown
+
[4/19/10 12:56:51:858 EDT] 0000001a SystemOut    O [EL Finest]: 2010-04-19 12:56:51.838--ServerSession(104924737)--Thread(Thread[WebContainer : 6,5,main])--Begin predeploying Persistence Unit example; session jar:file:/C:/opt/was7b/AppServer/profiles/AppSrv01/installedApps/xps435Node01Cell/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR.ear/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar!/_example; state Initial; factoryCount 0
+
[4/19/10 12:56:52:448 EDT] 0000001a SystemOut    O [EL Finest]: 2010-04-19 12:56:52.448--ServerSession(104924737)--Thread(Thread[WebContainer : 6,5,main])--End predeploying Persistence Unit example; session jar:file:/C:/opt/was7b/AppServer/profiles/AppSrv01/installedApps/xps435Node01Cell/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR.ear/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar!/_example; state Predeployed; factoryCount 1
+
[4/19/10 12:56:52:458 EDT] 0000001a EJBContainerI I  WSVR0037I: Starting EJB jar: org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar
+
[4/19/10 12:56:52:458 EDT] 0000001a EJBContainerI I  CNTR0167I: The server is binding the org.eclipse.persistence.example.jpa.server.business.ApplicationServiceLocal interface of the ApplicationService enterprise bean in the org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar module of the org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR application.  The binding location is: ejblocal:org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar/ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationServiceLocal
+
[4/19/10 12:56:52:478 EDT] 0000001a EJBContainerI I  WSVR0057I: EJB jar started: org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar
+
[4/19/10 12:56:52:488 EDT] 0000001a webapp        I com.ibm.ws.webcontainer.webapp.WebGroupImpl WebGroup SRVE0169I: Loading Web Module: enterprise.
+
[4/19/10 12:56:52:508 EDT] 0000001a WASSessionCor I SessionContextRegistry getSessionContext SESN0176I: Will create a new session context for application key default_hostenterprise
+
[4/19/10 12:56:52:528 EDT] 0000001a webcontainer  I com.ibm.ws.wswebcontainer.VirtualHost addWebApplication SRVE0250I: Web Module enterprise has been bound to default_host[*:9080,*:80,*:9443,*:5060,*:5061,*:443].
+
[4/19/10 12:56:52:528 EDT] 0000001a ApplicationMg A  WSVR0221I: Application started: org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR
+
[4/19/10 12:56:52:528 EDT] 0000001a CompositionUn A  WSVR0191I: Composition unit WebSphere:cuname=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR in BLA WebSphere:blaname=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR started.
+
 
+
>action
+
http://127.0.0.1:9080/enterprise/FrontController?action=demo&rnd=.04393939419
+
[4/19/10 12:57:42:028 EDT] 00000019 servlet      I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR] [/enterprise] [FrontController]: Initialization successful.
+
[4/19/10 12:57:42:028 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.028--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--Begin weaver class transformer processing class [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/19/10 12:57:42:078 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.078--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--Weaved persistence (PersistenceEntity) [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/19/10 12:57:42:078 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.078--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--Weaved fetch groups (FetchGroupTracker) [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/19/10 12:57:42:078 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.078--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--End weaver class transformer processing class [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/19/10 12:57:42:078 EDT] 00000019 SystemOut    O [EL Example]: enterprise: ApplicationService.insertObjects() em: JPATxEntityManager@6acf6acf[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example, org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
[4/19/10 12:57:42:078 EDT] 00000019 SystemOut    O [EL Example]: enterprise: ApplicationService persisting: org.eclipse.persistence.example.jpa.server.business.Cell@1706321332( id: null state: null left: null right: null parent: HashSet@1706845628 references: HashSet@1706845628) on EM: JPATxEntityManager@6acf6acf[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example, org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
[4/19/10 12:57:42:088 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.078--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--Begin deploying Persistence Unit example; session jar:file:/C:/opt/was7b/AppServer/profiles/AppSrv01/installedApps/xps435Node01Cell/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR.ear/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar!/_example; state Predeployed; factoryCount 1
+
[4/19/10 12:57:42:158 EDT] 00000019 SystemOut    O [EL Info]: 2010-04-19 12:57:42.158--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--EclipseLink, version: Eclipse Persistence Services - 2.1.0.qualifier
+
[4/19/10 12:57:42:168 EDT] 00000019 SystemOut    O [EL Config]: 2010-04-19 12:57:42.168--ServerSession(104924737)--Connection(1708484053)--Thread(Thread[WebContainer : 5,5,main])--connecting(DatabaseLogin(
+
platform=>DerbyPlatform
+
user name=> ""
+
connector=>JNDIConnector datasource name=>null
+
))
+
[4/19/10 12:57:42:418 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.418--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--End deploying Persistence Unit example; session jar:file:/C:/opt/was7b/AppServer/profiles/AppSrv01/installedApps/xps435Node01Cell/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR.ear/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar!/_example; state Deployed; factoryCount 1
+
[4/19/10 12:57:42:468 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:42.468--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--client acquired
+
[4/19/10 12:57:42:468 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:42.468--UnitOfWork(1076117540)--Thread(Thread[WebContainer : 5,5,main])--TX binding to tx mgr, status=STATUS_ACTIVE
+
[4/19/10 12:57:42:468 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.468--UnitOfWork(1076117540)--Thread(Thread[WebContainer : 5,5,main])--PERSIST operation called on: org.eclipse.persistence.example.jpa.server.business.Cell@1706321332( id: null state: null left: null right: null parent: HashSet@1706845628 references: HashSet@1706845628).
+
[4/19/10 12:57:42:468 EDT] 00000019 SystemOut    O [EL Example]: enterprise: ApplicationService persisting: org.eclipse.persistence.example.jpa.server.business.Cell@1706845628( id: null state: null left: null right: null parent: HashSet@826618180 references: HashSet@826618180) on EM: JPATxEntityManager@6acf6acf[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example, org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
[4/19/10 12:57:42:468 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:42.468--UnitOfWork(1076117540)--Thread(Thread[WebContainer : 5,5,main])--begin unit of work commit
+
[4/19/10 12:57:42:478 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:42.478--ClientSession(1595039506)--Thread(Thread[WebContainer : 5,5,main])--TX beginTransaction, status=STATUS_ACTIVE
+
[4/19/10 12:57:42:478 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.478--UnitOfWork(1076117540)--Thread(Thread[WebContainer : 5,5,main])--Execute query InsertObjectQuery(org.eclipse.persistence.example.jpa.server.business.Cell@1708418516( id: null state: null left: null right: null parent: HashSet@1707894220 references: HashSet@1707894220))
+
[4/19/10 12:57:42:488 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.488--ClientSession(1595039506)--Thread(Thread[WebContainer : 5,5,main])--reconnecting to external connection pool
+
[4/19/10 12:57:42:498 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:42.498--UnitOfWork(1076117540)--Thread(Thread[WebContainer : 5,5,main])--Execute query DataModifyQuery()
+
[4/19/10 12:57:42:508 EDT] 00000019 SystemOut    O [EL Fine]: 2010-04-19 12:57:42.508--ClientSession(1595039506)--Connection(1358319862)--Thread(Thread[WebContainer : 5,5,main])--INSERT INTO EL_CELL_EL_CELL (references_ID, peers_ID) VALUES (?, ?)
+
bind => [9, 6]
+
[4/19/10 12:57:42:528 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:42.528--UnitOfWork(1076117540)--Thread(Thread[WebContainer : 5,5,main])--TX afterCompletion callback, status=COMMITTED
+
[4/19/10 12:57:42:538 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:42.538--UnitOfWork(1076117540)--Thread(Thread[WebContainer : 5,5,main])--end unit of work commit
+
[4/19/10 12:57:42:538 EDT] 00000019 SystemOut    O [EL Example]: enterprise: ApplicationService query: select object(e) from Cell e on EM: JPATxEntityManager@6acf6acf[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example, org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
[4/19/10 12:57:43:008 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:43.008--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--client acquired
+
[4/19/10 12:57:43:018 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:43.018--UnitOfWork(393484148)--Thread(Thread[WebContainer : 5,5,main])--TX binding to tx mgr, status=STATUS_ACTIVE
+
[4/19/10 12:57:43:018 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:43.018--UnitOfWork(393484148)--Thread(Thread[WebContainer : 5,5,main])--Execute query ReadAllQuery(referenceClass=Cell sql="SELECT ID, STATE, TSEQ, RIGHT_ID, ACELLATTRIBUTE_ID FROM EL_CELL")
+
[4/19/10 12:57:43:058 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:57:43.058--UnitOfWork(393484148)--Thread(Thread[WebContainer : 5,5,main])--Register the existing object org.eclipse.persistence.example.jpa.server.business.Cell@1081950333( id: 2 state: null left: null right: null parent: HashSet@85329174 references: HashSet@85329174)
+
[4/19/10 12:57:43:078 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:43.078--UnitOfWork(393484148)--Thread(Thread[WebContainer : 5,5,main])--TX beforeCompletion callback, status=STATUS_ACTIVE
+
[4/19/10 12:57:43:078 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:43.078--UnitOfWork(393484148)--Thread(Thread[WebContainer : 5,5,main])--begin unit of work commit
+
[4/19/10 12:57:43:088 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:43.088--UnitOfWork(393484148)--Thread(Thread[WebContainer : 5,5,main])--initialize identitymaps
+
[4/19/10 12:57:43:088 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:43.088--UnitOfWork(393484148)--Thread(Thread[WebContainer : 5,5,main])--TX afterCompletion callback, status=COMMITTED
+
[4/19/10 12:57:43:088 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:57:43.088--UnitOfWork(393484148)--Thread(Thread[WebContainer : 5,5,main])--end unit of work commit
+
[4/19/10 12:57:43:088 EDT] 00000019 SystemOut    O [EL Example]: enterprise: Object: org.eclipse.persistence.example.jpa.server.business.Cell@1366970746( id: 1 state: null left: null right: null parent: HashSet@-379786916 references: HashSet@-379786916)
+
 
+
 
+
>2nd insert
+
http://127.0.0.1:9080/enterprise/FrontController?action=demo&rnd=.04393939420
+
[4/19/10 12:58:37:468 EDT] 00000019 SystemOut    O [EL Example]: enterprise: ApplicationService.insertObjects() em: JPATxEntityManager@6acf6acf[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example, org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
[4/19/10 12:58:37:468 EDT] 00000019 SystemOut    O [EL Example]: enterprise: ApplicationService persisting: org.eclipse.persistence.example.jpa.server.business.Cell@1281379424( id: null state: null left: null right: null parent: HashSet@1281903720 references: HashSet@1281903720) on EM: JPATxEntityManager@6acf6acf[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example, org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
[4/19/10 12:58:37:468 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:58:37.468--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--client acquired
+
[4/19/10 12:58:37:468 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:58:37.468--UnitOfWork(1285901477)--Thread(Thread[WebContainer : 5,5,main])--TX binding to tx mgr, status=STATUS_ACTIVE
+
[4/19/10 12:58:37:478 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:58:37.468--UnitOfWork(1285901477)--Thread(Thread[WebContainer : 5,5,main])--PERSIST operation called on: org.eclipse.persistence.example.jpa.server.business.Cell@1281379424( id: null state: null left: null right: null parent: HashSet@1281903720 references: HashSet@1281903720).
+
[4/19/10 12:58:37:478 EDT] 00000019 SystemOut    O [EL Example]: enterprise: ApplicationService persisting: org.eclipse.persistence.example.jpa.server.business.Cell@1281903720( id: null state: null left: null right: null parent: HashSet@-448207544 references: HashSet@-448207544) on EM: JPATxEntityManager@6acf6acf[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example, org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
[4/19/10 12:58:37:608 EDT] 00000019 SystemOut    O [EL Example]: enterprise: ApplicationService query: select object(e) from Cell e on EM: JPATxEntityManager@6acf6acf[PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example, org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#ApplicationService#org.eclipse.persistence.example.jpa.server.business.ApplicationService/entityManager]
+
[4/19/10 12:58:37:608 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:58:37.608--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--client acquired
+
[4/19/10 12:58:37:608 EDT] 00000019 SystemOut    O [EL Finer]: 2010-04-19 12:58:37.608--UnitOfWork(374150733)--Thread(Thread[WebContainer : 5,5,main])--TX binding to tx mgr, status=STATUS_ACTIVE
+
[4/19/10 12:58:37:608 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:58:37.608--UnitOfWork(374150733)--Thread(Thread[WebContainer : 5,5,main])--Execute query ReadAllQuery(referenceClass=Cell sql="SELECT ID, STATE, TSEQ, RIGHT_ID, ACELLATTRIBUTE_ID FROM EL_CELL")
+
[4/19/10 12:58:37:608 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:58:37.608--ServerSession(104924737)--Thread(Thread[WebContainer : 5,5,main])--reconnecting to external connection pool
+
[4/19/10 12:58:37:608 EDT] 00000019 SystemOut    O [EL Fine]: 2010-04-19 12:58:37.608--ServerSession(104924737)--Connection(57672560)--Thread(Thread[WebContainer : 5,5,main])--SELECT ID, STATE, TSEQ, RIGHT_ID, ACELLATTRIBUTE_ID FROM EL_CELL
+
[4/19/10 12:58:37:608 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 12:58:37.608--UnitOfWork(374150733)--Thread(Thread[WebContainer : 5,5,main])--Register the existing object org.eclipse.persistence.example.jpa.server.business.Cell@1081950333( id: 2 state: null left: null right: null parent: HashSet@85329174 references: HashSet@85329174)
+
 
+
</source>
+
 
+
===<font color="red">''No EclipseLink library on the Server or the EAR''</font>===
+
*This is not a valid configuration because the EclipseLink JPA provider library is not shipped by default with WebSphere.
+
*You will see the following exception if you attempt to use the '''org.eclipse.persistence.jpa.PersistenceProvider''' in this case.  This forms a good base case failure test upon which the other valid scenarios can be verified against.
+
**javax.ejb.EJBException: Injection failure; nested exception is: java.lang.IllegalStateException: EntityManagerFactory has not been created for PU : PuId=org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR#org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEJB.jar#example
+
 
+
==Application Managed==
+
*The primary use case that requires an appplication managed entityManager is one where the application developer does not have access to the server to create global or local scope '''Shared Libraries'''.  In this case all library configuration and classloader scope changes must be done inside the EAR itself.
+
*For either the developer that has access to the deployment workflow on the WAS console - We can modify the classloader to load the '''parent last''' using the following [http://publib.boulder.ibm.com/infocenter/wasinfo/v7r0/topic/com.ibm.websphere.zseries.doc/info/zseries/ae/trun_classload_entapp.html procedure from DeveloperWorks].
+
*See '''Enterprise Applications > org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR > Class loader''' in...
+
[[Image:Was_console_modify_application_classloader_parent_last.JPG]]
+
 
+
===EAR configuration===
+
*standard Persistence static bootstrap EMF on the servlet or @PersistenceUnit injection on the servlet with a non-JTA datasource or direct JDBC connection (in this case derby)
+
===Eclipselink library in EAR===
+
====Static Persistence bootstrap EMF creation in WAR Servlet====
+
====<font color="red">''Static Persistence bootstrap EMF creation in EJB Session Bean</font>''====
+
*placing the eclipselink.jar in the EAR and attempting to use the SE Persistence bootstrap class to create an EMF on a '''Stateless Session Bean - in the EJB.jar''' - ''(on the EJB container instead of the WEB container)'' does not work because the classloader position of the eclipselink.jar is not visible to the '''JPA 1.0 persistence library''' that ships with the server higher up.
+
*You see the following warnings
+
<source lang="java">
+
[4/16/10 11:23:09:218 EDT] 0000001d SystemErr    R WARNING: Unable to load persistence provider "org.eclipse.persistence.jpa.PersistenceProvider" due to "java.lang.ClassNotFoundException: org.eclipse.persistence.jpa.PersistenceProvider"
+
[4/16/10 11:23:09:218 EDT] 0000001d SystemErr    R WARNING: Found unrecognized persistence provider "org.eclipse.persistence.jpa.PersistenceProvider" in place of OpenJPA provider.  This provider's properties will not be used.
+
</source>
+
*You will get a '''null''' ''EntityManagerFactory'' when attempting
+
<source lang="java">EntityManagerFactory emf = Persistence.createEntityManagerFactory("example");</source>
+
====@PersistenceUnit EMF injection on WAR Servlet====
+
*This is the recommended application managed way of getting an EMF.
+
=====<font color="green">'''JPA 1.0 persistence.xml'''</font>=====
+
*Both '''Persistence''' boostrap and '''@PersistenceUnit''' injection work well on an application managed EclipseLink JPA 1.0 client like a servlet in the WAR in an EAR on WebSphere 7.0.
+
======WebContent/META-INF/MANIFEST.MF======
+
*Manifest entry on the WAR must reference the libraries in the EAR project
+
**Class-Path: APP-INF/lib/eclipselink.jar
+
*** APP-INF/lib/javax.persistence_2.0.0.v201002051058.jar
+
======Servlet client======
+
*Injection of EMF on servlet
+
<source lang="java">
+
public class FrontController extends HttpServlet implements Servlet {
+
    @PersistenceUnit(unitName="example-am1")
+
    private EntityManagerFactory emf;
+
</source>
+
======Persistence.xml 1.0 version======
+
<source lang="xml">
+
<persistence 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_1_0.xsd" version="1.0">
+
<!-- persistence 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 persistence_2_0.xsd" version="2.0"-->
+
    <persistence-unit name="example-am1" transaction-type="JTA">
+
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
+
        <!-- shared-cache-mode>NONE</shared-cache-mode--> <!-- JPA 2.0 PFD only -->
+
        <jta-data-source>DefaultDatasource</jta-data-source>
+
        <class>org.eclipse.persistence.example.jpa.server.business.Cell</class>
+
        <class>org.eclipse.persistence.example.jpa.server.business.CellAttribute</class>
+
        <properties>
+
            <property name="eclipselink.target-server" value="WebSphere_7"/>
+
            <property name="eclipselink.logging.level" value="FINEST"/>
+
        </properties>     
+
    </persistence-unit>
+
</persistence>
+
</source>
+
 
+
*Or the RESOURCE_LOCAL version
+
<source lang="xml">
+
<persistence 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_1_0.xsd" version="1.0">
+
    <persistence-unit name="example-am1" transaction-type="RESOURCE_LOCAL">   
+
        <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
+
        <class>org.eclipse.persistence.example.jpa.server.business.Cell</class>
+
        <class>org.eclipse.persistence.example.jpa.server.business.CellAttribute</class>
+
        <properties>
+
            <property name="eclipselink.target-server" value="WebSphere_7"/>
+
            <property name="eclipselink.weaving" value="true"/>           
+
            <property name="javax.persistence.jdbc.driver" value="org.apache.derby.jdbc.ClientDriver"/>
+
            <property name="eclipselink.target-database" value="Derby"/>           
+
            <property name="javax.persistence.jdbc.url" value="jdbc:derby://127.0.0.1:1527/websphere;create=true"/>
+
            <property name="javax.persistence.jdbc.user" value="APP"/>
+
            <property name="javax.persistence.jdbc.password" value="APP"/>
+
            <!--property name="eclipselink.ddl-generation" value="drop-and-create-tables"/-->
+
            <!--property name="eclipselink.ddl-generation.output-mode" value="database"/-->
+
            <property name="eclipselink.logging.level" value="FINEST"/>
+
        </properties>     
+
    </persistence-unit>
+
</persistence>
+
</source>
+
 
+
======Console logs======
+
*The following logs show evidence of '''Weaving''' ''(bytecode instrumentation for change tracking and cache performance)'', '''EntityManagerFactory''' and '''EntityManager''' ''EclipseLink'' JPA provider instances and their usage.
+
<source lang="java">
+
[4/16/10 16:21:55:359 EDT] 0000001a SystemOut    O [EL Finest]: 2010-04-16 16:21:55.359--ServerSession(439228974)--Thread(Thread[WebContainer : 4,5,main])--Begin predeploying Persistence Unit example-am1; session file:/C:/opt/was7001/AppServer/profiles/AppSrv01/installedApps/beowulf5Node01Cell/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR.ear/org.eclipse.persistence.example.jpa.server.websphere.EnterpriseWeb.war/_example-am1; state Initial; factoryCount 0
+
 
+
[4/16/10 16:23:51:640 EDT] 0000001d SystemOut    O [EL Finest]: 2010-04-16 16:23:51.64--ServerSession(1268927394)--Thread(Thread[WebContainer : 7,5,main])--Begin weaver class transformer processing class [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/16/10 16:23:51:718 EDT] 0000001d SystemOut    O [EL Finest]: 2010-04-16 16:23:51.718--ServerSession(1268927394)--Thread(Thread[WebContainer : 7,5,main])--Weaved persistence (PersistenceEntity) [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/16/10 16:23:51:718 EDT] 0000001d SystemOut    O [EL Finest]: 2010-04-16 16:23:51.718--ServerSession(1268927394)--Thread(Thread[WebContainer : 7,5,main])--Weaved fetch groups (FetchGroupTracker) [org.eclipse.persistence.example.jpa.server.business.Cell].
+
[4/16/10 16:23:53:515 EDT] 0000001d SystemOut    O Injected @PersistenceUnit: org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl@5dc85dc8
+
[4/16/10 17:03:28:312 EDT] 00000019 SystemOut    O EntityManager from Injected @PersistenceUnit: org.eclipse.persistence.internal.jpa.EntityManagerImpl@4cfc4cfc
+
[4/16/10 16:23:53:421 EDT] 0000001d SystemOut    O [EL Finer]: 2010-04-16 16:23:53.421--ServerSession(439228974)--Thread(Thread[WebContainer : 7,5,main])--Canonical Metamodel class [org.eclipse.persistence.example.jpa.server.business.Cell_] not found during initialization.
+
[4/16/10 16:23:53:500 EDT] 0000001d SystemOut    O [EL Finer]: 2010-04-16 16:23:53.5--ServerSession(439228974)--Thread(Thread[WebContainer : 7,5,main])--client acquired
+
[4/16/10 16:23:53:515 EDT] 0000001d SystemOut    O [EL Finest]: 2010-04-16 16:23:53.515--UnitOfWork(758525238)--Thread(Thread[WebContainer : 7,5,main])--PERSIST operation called on: org.eclipse.persistence.example.jpa.server.business.Cell@165349851( id: null state: null left: null right: null parent: HashSet@165874147 references: HashSet@165874147).
+
[4/16/10 16:23:53:859 EDT] 0000001d SystemOut    O [EL Finest]: 2010-04-16 16:23:53.859--UnitOfWork(859058996)--Thread(Thread[WebContainer : 7,5,main])--Execute query ReadAllQuery(referenceClass=Cell sql="SELECT ID, STATE, TSEQ, RIGHT_ID, ACELLATTRIBUTE_ID FROM EL_CELL")
+
...
+
[4/19/10 9:33:35:213 EDT] 0000001a SystemOut    O [EL Finest]: 2010-04-19 09:33:35.213--ServerSession(1893232856)--Thread(Thread[WebContainer : 6,5,main])--Execute query ReadObjectQuery(name="left" referenceClass=Cell sql="SELECT ID, STATE, TSEQ, RIGHT_ID, ACELLATTRIBUTE_ID FROM EL_CELL WHERE (RIGHT_ID = ?)")
+
[4/19/10 9:33:35:213 EDT] 0000001a SystemOut    O [EL Fine]: 2010-04-19 09:33:35.213--ServerSession(1893232856)--Connection(1950839879)--Thread(Thread[WebContainer : 6,5,main])--SELECT ID, STATE, TSEQ, RIGHT_ID, ACELLATTRIBUTE_ID FROM EL_CELL WHERE (RIGHT_ID = ?)
+
bind => [1]
+
[4/19/10 9:33:35:243 EDT] 0000001a SystemOut    O [EL Finest]: 2010-04-19 09:33:35.243--ServerSession(1893232856)--Thread(Thread[WebContainer : 6,5,main])--Execute query ReadAllQuery(name="references" referenceClass=Cell sql="SELECT t1.ID, t1.STATE, t1.TSEQ, t1.RIGHT_ID, t1.ACELLATTRIBUTE_ID FROM EL_CELL_EL_CELL t0, EL_CELL t1 WHERE ((t0.peers_ID = ?) AND (t1.ID = t0.references_ID))")
+
[4/19/10 9:33:35:243 EDT] 0000001a SystemOut    O [EL Fine]: 2010-04-19 09:33:35.243--ServerSession(1893232856)--Connection(1950839879)--Thread(Thread[WebContainer : 6,5,main])--SELECT t1.ID, t1.STATE, t1.TSEQ, t1.RIGHT_ID, t1.ACELLATTRIBUTE_ID FROM EL_CELL_EL_CELL t0, EL_CELL t1 WHERE ((t0.peers_ID = ?) AND (t1.ID = t0.references_ID))
+
bind => [1]
+
[4/19/10 9:33:35:293 EDT] 0000001a SystemOut    O [EL Finest]: 2010-04-19 09:33:35.293--UnitOfWork(273879123)--Thread(Thread[WebContainer : 6,5,main])--Register the existing object org.eclipse.persistence.example.jpa.server.business.Cell@579084932( id: 4 state: null left: null right: null parent: HashSet@1550867568 references: HashSet@1550867568)
+
 
+
</source>
+
 
+
======Browser Output======
+
*The following screen capture illustrates the fact that 5 entities were read from in this case a Derby 10.5.3.0 database using a RESOURCE_LOCAL @PersistenceUnit injected EMF on a Servlet client as part of the WAR in an EAR that contains the eclipselink.jar library embedded - essentially an SE application.
+
[[Image:Browser_cap_jpa1_persistenceUnit_injected_emf_resource_local.JPG]]
+
*After insertion of 5 new entities...
+
[[Image:Browser_cap_jpa1_persistenceUnit_injected_emf_resource_local_After_insert.JPG]]
+
<source lang="java">
+
[4/19/10 11:06:40:990 EDT] 00000019 SystemOut    O [EL Finest]: 2010-04-19 11:06:40.99--UnitOfWork(1284721811)--Thread(Thread[WebContainer : 5,5,main])--Execute query DataModifyQuery(sql="INSERT INTO EL_CELL_EL_CELL (references_ID, peers_ID) VALUES (?, ?)")
+
[4/19/10 11:06:40:990 EDT] 00000019 SystemOut    O [EL Fine]: 2010-04-19 11:06:40.99--ClientSession(1751476325)--Connection(593306461)--Thread(Thread[WebContainer : 5,5,main])--INSERT INTO EL_CELL_EL_CELL (references_ID, peers_ID) VALUES (?, ?)
+
bind => [10, 7]
+
</source>
+
 
+
=====<font color="red">JPA 2.0 persistence.xml</font>=====
+
*Application Managed EAR's that define a JPA 2.0 schema reference in their '''persistence.xml''' will not deploy. 
+
<source lang="xml">
+
  <persistence 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 persistence_2_0.xsd" version="2.0">
+
</source>
+
*The following XML parsing error occurs on the server.
+
<source lang="java">
+
[4/16/10 15:45:50:093 EDT] 00000016 SystemErr    R com.ibm.ws.exception.RuntimeWarning: com.ibm.ws.metadata.MetaDataException: CWWJP0040E: The persistence.xml in application org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR, module org.eclipse.persistence.example.jpa.server.websphere.EnterpriseWeb.war, has a syntax error at line number: 20, column number: 209.
+
[4/16/10 15:45:50:093 EDT] 00000016 SystemErr    R at com.ibm.ws.jpa.management.JPAApplInfo.processModulePUs(JPAApplInfo.java:185)
+
[4/16/10 15:45:49:250 EDT] 00000016 JPAPxmlInfo  E  CWWJP0040E: Incorrect syntax or error detected in the persistence.xml file in application: org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR, module: org.eclipse.persistence.example.jpa.server.websphere.EnterpriseWeb.war, at line number: 20, column number: 209. The following associated error message occurred: javax.xml.bind.UnmarshalException
+
- with linked exception:
+
[org.xml.sax.SAXParseException: cvc-complex-type.3.1: Value '2.0' of attribute 'version' of element 'persistence' is not valid with respect to the corresponding attribute use. Attribute 'version' has a fixed value of '1.0'.]
+
at javax.xml.bind.helpers.AbstractUnmarshallerImpl.createUnmarshalException(AbstractUnmarshallerImpl.java:326)
+
Caused by: org.xml.sax.SAXParseException: cvc-complex-type.3.1: Value '2.0' of attribute 'version' of element 'persistence' is not valid with respect to the corresponding attribute use. Attribute 'version' has a fixed value of '1.0'.
+
at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
+
</source>
+
[[Image:App_managed_jpa2_ear_fails_to_deploy_on_websphere_7.JPG]]
+
*Also, if we try using JPA 2.0 API via a persistence.xml that is defined as JPA 1.0 so it passed deployment - we will still get an expected runtime exception when we try to use JPA 2.0 commands.
+
<source lang="java">
+
[4/16/10 16:08:47:578 EDT] 0000001b servlet      E com.ibm.ws.webcontainer.servlet.ServletWrapper service SRVE0068E: Uncaught exception created in one of the service methods of the servlet FrontController in application org.eclipse.persistence.example.jpa.server.websphere.EnterpriseEAR. Exception created : java.lang.NoSuchMethodError: javax/persistence/EntityManager.getMetamodel()Ljavax/persistence/metamodel/Metamodel;
+
at org.eclipse.persistence.example.jpa.server.business.ApplicationManagedService.getMetamodel(ApplicationManagedService.java:139)
+
</source>
+
 
+
==Persistence JAR location==
+
*Where does the standard library '''plugins/com.ibm.ws.jpa.jar''' and '''runtimes/com.ibm.ws.jpa.thinclient_7.0.0.jar''' fit in? Is this a JPA spec jar or an '''OpenJPA''' implementation?
+
 
+
==JDBC JAR location==
+
*If you are using a JDBC provider other than the 3 provided by WebSphere, you must defined all of the '''JDBC Providers''', the '''Data sources''' and the secondary '''JAAS-J2C authentication data''' sections in the admin console for your new datasource.
+
[[Image:Was_console_oracle_datasource1.JPG]]
+
 
+
=EAR Deployment and testing=
+
==Publish EAR==
+
*On WebSphere we use the standard stop|update|start commands on the ''Applications | Application Types | WebSphere enterprise applications''' console page in our case accessed via http://xps435:9060/ibm/console/login.do
+
==Perform CRUD operations: JPQL insert and query==
+
*We perform standard ''Create/Read/Update/Delete'' commands.
+
===Browser Output===
+
*See browser output results in the [[EclipseLink/Examples/JPA/WebSphere7_Web_Tutorial#Container_Managed_and_Application_Managed_Scenarios|Container Managed and Application Managed Scenarios]] above.
+
 
+
==Remote Debugging EclipseLink in WebSphere 7.0 from Eclipse 3.4==
+
The following procedure details how to attach to a debug version of IBM WebSphere 7.0 with the Eclipse 3.4 IDE.
+
 
+
Note: we will not be modifying startServer.bat.  The java process in that script is only for server startup - if you need to debug this part of the server.
+
===Modify console setup to start server in debug mode===
+
*Login to the console using your admin login or a default username like ''system''
+
**http://mobrien-pc2.st-mdc.ca.oracle.com:9064/ibm/console/login.do
+
*Navigate to Servers | Server Types | WebSphere Application servers | server1
+
*Navigate on the right down to Additional Properties | Debugging service
+
*Enable JDWP by ckecking the checkbox ''Enable service at server startup"
+
**The default properties below will be OK unmodified
+
***JVM debug port = 7781
+
***JVM debug arguments = -agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=7781
+
*Optionally you can add server packages if you have the source for WebSphere
+
*We will be debugging client test code and EclipseLink API in the Eclipse IDE
+
 
+
[[Image:Websphere7_console_debug_screen.JPG]]
+
 
+
===Start the WebSphere Server===
+
Either run bin/startServer.bat or the following server ant test target in our suite.
+
<pre>
+
<trunk>jpa\eclipselink.jpa.test>ant server-start
+
</pre>
+
 
+
===Attach Eclipse 3.4 to the debug port on WebSphere 7===
+
*Right-click your test code
+
*Debug as | Debug Configurations
+
*select Remote Java Application
+
*create a new config by hitting the top-left ''new launch configuration'' icon
+
*type a name for your config and modify only the port to read 7781
+
*''apply'' changes
+
*click debug
+
 
+
[[Image:Eclipse34_remote_debug_websphere7_screen.JPG]]
+
 
+
You should see the a stack trace ready for any breakpoints in your code that are hit - or suspend an orb thread to break into the code.
+
<pre>
+
</pre>
+
 
+
===Deploy and Run EAR application===
+
Depending on your breakpoints you will see a stacktrace hit in the Eclipse IDE similar to the following.
+
<pre>
+
VirtualAttributeTestSuite [Remote Java Application]
+
IBM J9 VM[localhost:7781]
+
Thread [P=833989:O=0:CT] (Running)
+
Daemon Thread [Signal Dispatcher] (Running)
+
...
+
Daemon Thread [Thread-52] (Running)
+
Daemon Thread [ORB.thread.pool : 0] (Running)
+
Daemon Thread [ORB.thread.pool : 1] (Suspended (breakpoint at line 302 in ConcurrencyManager))
+
ConcurrencyManager.isAcquired() line: 302
+
ClientSession(AbstractSession).isInTransaction() line: 2405
+
ClientSession(AbstractSession).beginTransaction() line: 538
+
SequencingManager$Preallocation_Transaction_NoAccessor_State.getNextValue(Sequence, AbstractSession) line: 455
+
SequencingManager.getNextValue(AbstractSession, Class) line: 905
+
ClientSessionSequencing.getNextValue(Class) line: 70
+
ObjectBuilder.assignSequenceNumber(Object, AbstractSession) line: 277
+
RepeatableWriteUnitOfWork(UnitOfWorkImpl).assignSequenceNumber(Object, ClassDescriptor) line: 402
+
RepeatableWriteUnitOfWork(UnitOfWorkImpl).registerNotRegisteredNewObjectForPersist(Object, ClassDescriptor) line: 3952
+
RepeatableWriteUnitOfWork.registerNotRegisteredNewObjectForPersist(Object, ClassDescriptor) line: 359
+
RepeatableWriteUnitOfWork(UnitOfWorkImpl).registerNewObjectForPersist(Object, Map) line: 3899
+
EntityManagerImpl.persist(Object) line: 254
+
JPATxEmInvocation(JPAExEmInvocation).persist(Object) line: 336
+
JPATxEntityManager(JPAEntityManager).persist(Object) line: 123
+
VirtualAttributeTestSuite.testInsertVirtualAttribute() line: 63
+
NativeMethodAccessorImpl.invoke0(Method, Object, Object[]) line: not available [native method]
+
NativeMethodAccessorImpl.invoke(Object, Object[]) line: 45
+
DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: 37
+
Method.invoke(Object, Object...) line: 599
+
VirtualAttributeTestSuite(TestCase).runTest() line: 154
+
VirtualAttributeTestSuite(TestCase).runBare() line: 127
+
VirtualAttributeTestSuite(JUnitTestCase).runBareServer() line: 391
+
TestRunnerBean.runTest(String, String, Properties) line: 87
+
EJSRemote0SLTestRunner_ed643271.runTest(String, String, Properties) line: not available
+
_EJSRemote0SLTestRunner_ed643271_Tie.runTest(InputStream, ResponseHandler) line: not available
+
_EJSRemote0SLTestRunner_ed643271_Tie._invoke(String, InputStream, ResponseHandler) line: not available
+
WSExtendedServerDelegate(ServerDelegate).dispatchInvokeHandler(InterceptorManager, ServerRequestInfoImpl, String, Object, ServerRequestReader) line: 622
+
WSExtendedServerDelegate(ServerDelegate).dispatch(ServerRequest) line: 475
+
ORB(ORB).process(ServerRequest) line: 504
+
ORB.process(ServerRequest) line: 1571
+
Connection.respondTo(RequestHandler, IIOPReader) line: 2771
+
Connection.doWork(RequestHandler, IIOPReader) line: 2640
+
WorkUnitImpl.doWork() line: 63
+
PooledThread.run() line: 118
+
ThreadPool$Worker.run() line: 1527
+
Daemon Thread [AIO Timer Thread 1] (Running)
+
Daemon Thread [WebContainer : 0] (Running)
+
...
+
        Daemon Thread [RT=7:P=833989:O=0:WSTCPTransportConnection[addr=10.156.52.98,port=1553,local=9104]] (Running)
+
</pre>
+
 
+
=Migration to the EclipseLink JPA provider on WebSphere 7=
+
*The steps below detail what needs to be done to migrate an existing JPA enterprise application to use a JPA provider other than the shipped '''OpenJPA''' - like the '''org.eclipse.persistence.jpa.PersistenceProvider''' provider.
+
==Update persistence.xml==
+
*Change the provider tag to <source lang="xml"><provider>org.eclipse.persistence.jpa.PersistenceProvider</provider></source>
+
==References==
+
*See [[EclipseLink/UserGuide/Developing_JPA_Projects_%28ELUG%29|Developing JPA Projects]] in the EclipseLink User's Guide.
+
**http://www.ibm.com/developerworks/eclipse/downloads/ganymede/
+
*http://www.ibm.com/developerworks/eclipse/downloads/ganymede/dev.html
+
*[http://publib.boulder.ibm.com/infocenter/wasinfo/v7r0/index.jsp?topic=/com.ibm.websphere.zseries.doc/info/zseries/ae/tejb_configpp.html WebSphere Application Server 7: Using third-party persistence providers]
+
 
+
==History==
+
*20090115: Originated on build EclipseLink 1.1 M6 - Michael O'Brien
+
*20100415: Updating for eclipselink.jar placement for container managed and application managed scenarios in EclipseLink enhancement # [http://bugs.eclipse.org/309201 309201]
+

Latest revision as of 12:32, 5 October 2010

Original WebSphere 7 tutorial page for EclipseLink JPA

Back to the top